Support Board
Date/Time: Mon, 13 Jan 2025 02:03:50 +0000
Omit Rollover days spreadsheet Trading
View Count: 583
| [2017-03-28 19:52:28] |
| JamesP - Posts: 89 |
|
What is the best way to not trade rollover days (ES) when auto trading through spreadsheets.
|
| [2017-03-28 20:16:56] |
| |
|
You really would have to know those specific dates and create a formula to use in this particular cell to prevent automated trading: https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#DisableAutoTrading 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 |
| [2017-03-28 21:02:25] |
| JamesP - Posts: 89 |
|
So for example If I wanted to disable for this past rollover(ES) which was March 9 2017, = DATE( 2017, March, 5 ) would give me a fn to disable for Thursday's in the month of March? I've used disable autotrading for specific time periods but I'm not sure how to get the formula to disable for just March 9th 2017. Thanks.
|
| [2017-03-28 23:00:31] |
| Sawtooth - Posts: 4149 |
|
Use a formula like this in J28: =INT(A3)=DATEVALUE("3/9/2017") |
To post a message in this thread, you need to log in with your Sierra Chart account: