Registered User Joined: 10/7/2004 Posts: 8
|
Is it possible to change the date of a watchlist so that column values will calculate as of that date?
For example, I have indicator values as of today. I would like these values as of a week or a month ago (some other date). For simple formulas, I know how to do this but for complex formulas is it either impossible or too onerous.
Suppose I wanted my values as of March 23, 2011 for example. The data are all in the system. Why not have a way to extract it in column format per a watchlist as of that date?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you know the number of bars ago for the desired date, you could create your formula as a Custom PCF Indicator or Custom PCF % True Indicator. Then you could add a 1-Period Simple Moving Average with the Offset set to the number of bars ago of interest. Clicking on the offset moving average and selecting Add Column to WatchList would then allow you to display the value of the indicator Offset bars ago as a WatchList Column.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|