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 |

Exact Date in PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
sirengr
Posted : Friday, May 29, 2009 6:51:27 PM
Registered User
Joined: 10/15/2006
Posts: 2

How do you specify an "exact date" in a PCF?  For example, if I wanted to know the High for a stock since Jan 3, 2009, what would the PCF be?  (I saw this in a discussion years ago, but could not find it.)
Thanks.

Bruce_L
Posted : Monday, June 1, 2009 7:58:47 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The only way I know of to specify an exact date in a PCF is to specify a date for the Bars Ago parameter. This would mean it is possible to find the High on January 5, 2009 (January 3rd was not a trading day):

H'01/05/09'

But there would not be a simple automated way to find the high since January 5, 2009 because you would need to know the number of trading days. The Bars Ago portion of MAXH in TeleChart's Personal Criteria Formula Language specified the last date, not the first date, of the Maximum High Period.

PCF Formula Descriptions
Days Ago parameter

There are two distinct ways to use historical data with Personal Criteria Formulas.

Any criteria can be used to scan X number of days back by adding '.XX' where XX is equal to the number of market days past to calculate for. An example of this is (AVGC21.21), which is a 21 day moving average 21 of close, 21 days ago. This use of historical data always refers to the market day XX number of days ago (in this case, 21). If you wish to use a specific date’s data, use the option detailed below.

The other method of using historical data is by specifying a precise date in history to use. For example, (AVGC21.'11/13/08') will provide a 21 day moving average of close for November 13, 2008 (the period should be used in cases where the first method requires a period and not used when the first method does not use a period). Always confirm that the date you wish to use using this parameter was a market day.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MauiTrader
Posted : Friday, June 3, 2011 12:04:33 PM
Registered User
Joined: 10/7/2004
Posts: 37
Bruce,I there any way of specifying the open date of today for all short term timeframe PCF's? I know I can use '6/3/11' for today but tomorrow I would have to change my PCF. I'm looking for a way to calculate the change for any timeframe less than daily without having to select the PCF each time.I realize this may be coming in the Version 11.1 but I have not kept up with all potential enhancements.Thanksmauitrader
Bruce_L
Posted : Friday, June 3, 2011 12:14:39 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I do not know of a way to do so currently.

-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.