Gold Customer
Joined: 3/11/2005 Posts: 8
|
Can you tell me how to write a scan for a specific date, such as 10/11/13, using a stochastic, such as 12.5, with a value <20? I've tried STOC12.5'10/11/13'<20 but that didn't work.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If the syntax requires a . when writing it was a numeric parameter, it still requires a . when using a date for that parameter. So you would want to write your Condition Formula as:
STOC12.5.'10/11/2013' < 20
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 3/11/2005 Posts: 8
|
OK, thank you for that, but why is the value one day behind the date? For example, I entered the PCF, C'10/09/13', but the close for 10/08 is shown in the sort value column.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is an issue in TC2000 version 7 related to the Thanksgiving holiday. Anything after the Thanksgiving holiday is using the correct dates when referenced in PCFs but everything before the Thanksgiving holiday is off by one day.
The issue does not affect TC2000 version 12.4 and I do not know what is causing it in TC2000 version 7 (but both data and development are looking into the issue and attempting to fix it). It could be a bug in the TC2000 version 7 code or it could be a fake bar in the TC2000 version 7 for Thanksgiving which is corrected on the charts but is still affecting Personal Criteria Formula with date references.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|