Profile: calm2bw-subscribe
 About User Name: calm2bw-subscribe Groups: Gold User, Member, Platinum User, TeleChart Rank: Registered User Real Name: Location Occupation: Interests: Gender: Gender:
 Statistics Joined: Wednesday, February 01, 2012 Last Visit: Wednesday, September 23, 2020 9:19:41 AM Number of Posts: 14[0.00% of all post / 0.00 posts per day]
 Avatar
 Last 10 Posts Topic: Measuring ROC from a low point on a monthly chart to current Posted: Tuesday, August 16, 2016 5:36:48 PM 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: ABS(C Â  Â  = MINC21) * 0 - Â NOT(C Â  Â = MINC21) * ( ABS(C1 Â  Â = MINC21.1) Â * (((C-MINC21.1 Â )/MINC21.1 Â )*100) Â - NOT(C1 Â = MINC21.1 Â ) * ( ABS(C2 Â  Â = MINC21.2) Â * (((C-MINC21.2 Â )/MINC21.2 Â )*100) Â - NOT(C2 Â = MINC21.2 Â ) * ( ABS(C3 Â  Â = MINC21.3) Â * (((C-MINC21.3 Â )/MINC21.3 Â )*100) Â - NOT(C3 Â = MINC21.3 Â ) * ( ABS(C4 Â  Â = MINC21.4) Â * (((C-MINC21.4 Â )/MINC21.4 Â )*100) Â - NOT(C4 Â = MINC21.4 Â ) * ( ABS(C5 Â  Â = MINC21.5) Â * (((C-MINC21.5 Â )/MINC21.5 Â )*100) Â - NOT(C5 Â = MINC21.5 Â ) * ( ABS(C6 Â  Â = MINC21.6) Â * (((C-MINC21.6 Â )/MINC21.6 Â )*100) Â - NOT(C6 Â = MINC21.6 Â ) * ( ABS(C7 Â  Â = MINC21.7) Â * (((C-MINC21.7 Â )/MINC21.7 Â )*100) Â - NOT(C7 Â = MINC21.7 Â ) * ( ABS(C8 Â  Â = MINC21.8) Â * (((C-MINC21.8 Â )/MINC21.8 Â )*100) Â - NOT(C8 Â = MINC21.8 Â ) * ( ABS(C9 Â  Â = MINC21.9) Â * (((C-MINC21.9 Â )/MINC21.9 Â )*100) Â - NOT(C9 Â = MINC21.9 Â ) * (Â  ABS(C10 Â  = MINC21.10) * (((C-MINC21.10 )/MINC21.10 )*100) - NOT(C10 Â = MINC21.10 ) * ( . . . ABS(C251=MINC21.251)*(((C-MINC21.251)/MINC.251)*100) - NOT(C251 = MINC21.251)Â  )))))))))) Â  DLTR does not give me a Rate of Change for 104 bars, but ROST will with 199 bars. Â  I have verified this with the cursor drag method, and the command-C so I know what rate of change should be returning. Â Again it works on my easy scan of 913 stocks about half and not on the other half. Â I have looked at the PCF and not seen any point where a typo may have occured. Â It works on symbols with less bars and more bars. Â I Â am suspecting there is some kind of data error. Can anyone help with this? Topic: Custom Date Sort Across Different Time Frames Posted: Monday, June 10, 2013 11:56:11 AM 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...... Topic: Custom Date Sort Across Different Time Frames Posted: Monday, June 10, 2013 11:52:27 AM 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? Topic: Custom Date Sort Across Different Time Frames Posted: Monday, June 10, 2013 1:10:00 AM 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 Daily: Weekly: Monthly: Topic: Custom Date Sort strange performance numbers on Morninstar Industry Groups Posted: Monday, June 10, 2013 12:32:03 AM 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.... Topic: Custom Date Sort strange performance numbers on Morninstar Industry Groups Posted: Friday, June 07, 2013 11:30:51 PM 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. Â