| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/26/2006
Posts: 2
|
To Bruce L.
Thanks for your quick reply. Please let me know if I can somehow use Telechart 2007 to determine numerical values for a PCF on particular stocks in particular days during the past two years. I would like to add more variables to my database.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
If you add the PCF formula Bruce gave you as a custom indicator plotted in the top window, you can then use the Pointer to find out it's value on any given date.
Press the period (.) key twice so you get the data box displayed along with the Pointer.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
One option is to use Custom Indicators instead of Personal Criteria Formulas along with Indicator Sorting. Custom Percent True Indicators can be used for Boolean formulas (returning True or False) and Custom Indicators can be used for formulas returning values.
Visually Backtesting Specific Symbols
Plotting Custom Indicators with Examples
Sorting price and indicators by their Actual Value
Another option is to re-write your PCFs. 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./31/97') will provide a 21 day moving average of close for December 31, 1997 (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). In this particular case, December 31 is the last trading day of that specific year. This will not always be the case. Always confirm that the date you wish to use using this parameter was a market day.
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
Using EasyScan to find stocks that meet your own criteria
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |