I am attempting to determine a formula so that I can understand sets of internet data which is only available in time ranges of 90 days or less. If I want to obtain this data for say, 2 years, I have to download the data in 8 sets of 90 days each.
But.. I have discovered that if I obtain data for one period, say 1/1/17 through 4/1/17, the numbers (beginning with the 1st day) for specific dates will be different from the numbers on the same date if I am obtaining data for an overlapping period (say 2/1/17 through 5/15/17).
The attached worksheet (zipped) demonstrates this. Note that the numbers vary from 0 to 100. I believe this is based on a "relative strength indicator" which attributes a strength to each number in the data set.
The formula might be something like: 100 - 100/1 + (average increase/average decrease)
I'm not a mathematician, and I'd appreciate any insights which might help me decipher the formula so that I can make better sense of this data for periods of longer than 90 days.
Thanks!View attachment data differences.zip
But.. I have discovered that if I obtain data for one period, say 1/1/17 through 4/1/17, the numbers (beginning with the 1st day) for specific dates will be different from the numbers on the same date if I am obtaining data for an overlapping period (say 2/1/17 through 5/15/17).
The attached worksheet (zipped) demonstrates this. Note that the numbers vary from 0 to 100. I believe this is based on a "relative strength indicator" which attributes a strength to each number in the data set.
The formula might be something like: 100 - 100/1 + (average increase/average decrease)
I'm not a mathematician, and I'd appreciate any insights which might help me decipher the formula so that I can make better sense of this data for periods of longer than 90 days.
Thanks!View attachment data differences.zip
