Registered User Joined: 12/21/2004 Posts: 35
|
I'd like PCFs two Pcf formulas please.
Percen change from 12/31/13 and Percent change from 2014 low.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
An Indicator Formula for a price percent change since December 31, 2013 can be written as:
100 * (C / C'12/31/2013' - 1)
There is no way to create an Indicator Formula for the percent change from the 2014 low in TC2000 version 7 which will automatically work for any date (at least until after 2014 is over). The structure of the MINL indicator in the Personal Criteria Formula Language does allow you to substitute a date for the bars ago parameter, but this would be the date of the last bar in the period being covered by the MINL indicator.
So for example, the following formula would return the value of the 252-bar low ending on December 31, 2013 (which would just so happen to be the lowest low of 2013):
MINL252.'12/31/2013'
So the price percent change since the low of 2013 could be written as:
100 * (C / MINL252.'12/31/2013' - 1)
But the lowest low of the 2014 so far would be:
MINL30
Or:
MINL30.0
Or (with a date):
MINL30.'02/13/2014'
Note that tomorrow you would need to increment both the number of bars and the date (although leaving off the bars ago parameter or date will produce the same results):
MINL31.'02/13/2014'
Now once we get to end of the year and know the number of bars in the year, we could create an Indicator Formula for the lowest low in 2014 which no longer needs to change like we did for 2013, but we can't do so until that point.
Now interestingly enough in TC2000 version 12.4, we can create an Indicator Formula for this because we can set the time frame of the Indicator Formula to yearly (all PCFs in TC2000 version 7 are daily and the yearly time frame in TC2000 version 7 is not based on calendar years in any case).
100 * (C / L - 1)
All the formula does is return how much the close is above the low for the current bar as a percentage of the low of that bar. The key is just that the time frame of the bar is 1 year and that the 1 year bar in TC2000 version 12.4 is for calender years.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|