Worden Discussion Forum
I tried chating with support but was unable to get a reasonable answer, so I'm posting it here:
I have a chart where I indicate a low points and High points. In this case, I am looking at a 21 period low on a monthly time frame. It works well for most, but it doesnt work for about half of the stocks in my easyscan. I created a PCF that looks back until it finds the most recent 21 bar low and measures the rate of change from there to the current month. I'll use symbol "DLTR" which has 104 bars from its 21 period low (C=MINC21.104) to the current month, as an example of what doesnt work. "ROST" has 199 bars from its monthly 21p low to current, and this works correctly, giving me the correct Rate of change. The PCF logic is long so I'll shorten it here:
Or allow us to tweak the dates by manually overriding the dates, that way we do not have to flip around in time frames, just give us the % chg for those time periods, and number of days......
Thank you, after watching the "Finding Top Performers with Custom Date Sort" and "Seasonality Analysis with Custom Date Sort". that reducing your timeframe down to a weekly or monthly timeframe to do a > 2 year study could produce skewed results. Could I request that they actually show the correct dates I am selecting in the custom date sort dialog? Also if they could include the number of days between the two dates?
Im seeing some varying % Change when using it under different timeframes. For instance, if you look up AAPL on a daily chart, from 1/2/13 through 6/7/13, it will produce
How is the % Change that appears in the Custom Date Sort dialog box calculated? For a daily time frame it almost makes sense. if you change to a weekly then monthly specifying the same date range, it shows different results:
AAPL Close 1/2/13 - 549.03
APPL Close 6/7/13 - 441.81
Daily Weekly Monthly
-19.53 -16.17 -3.00
Again using the exact same date range. Daily is what I expect, but the weekly and monthly % chg, does not produce the same result, even though the custom date sort box shows the same date range.
I'm wondering how they are calculated?
Here's some screen shots
Nevermind, I see now the totals of the Morninstar Industry Groups, are not a summation of the % chg of the individual stocks wihin them. There is something else I noticed about Custom Date Sort and the timeframes its performed on, but I will post that separately....
In trying to measure the performance during a period of time using the custom date sort, I'm seeing some strange results, where the numbers don't add up. I'm attaching a screen shot.