Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 18:39:21 +0000



Quick question about Time formula

View Count: 802

[2019-08-06 21:35:31]
JDMontero - Posts: 34
Hi.

Need to backtest a strategy that involves a formula that triggers a condition that happens on all days before 2011.

-Is that IF(TODAY()<DATEVALUE("01/01/2011"), trigger, nothing) ?? This way it isn't working...

or

-IF(TODAY()<(Integer that represents 1st Jan 2011), trigger, nothing) ?

Please advise. Thanks.
[2019-08-07 09:18:00]
Sierra Chart Engineering - Posts: 104368
You definitely cannot use TODAY in a formula during back testing. You have to work with the chart bar date-times themselves which are in column A.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account