Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Date specific PCFs Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kenjanson
Posted : Thursday, February 13, 2014 4:19:39 PM
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.

Bruce_L
Posted : Thursday, February 13, 2014 4:35:49 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.