Support Board
Date/Time: Fri, 31 Jan 2025 09:03:20 +0000
Post From: Automated Trading
[2019-01-02 18:19:59] |
Sawtooth - Posts: 4164 |
Is it possible to trigger an order at a certain time?
Yes, if you are using the Spreadsheet System for Trading study. You would need to use the FRACTIME and NOW() functions and compare it to a time value window, like in these examples: =AND(FRACTIME(NOW())>=TIMEVALUE("09:30:00"),FRACTIME(NOW())<TIMEVALUE("09:30:02")) =AND(FRACTIME(NOW())>=$J$75,FRACTIME(NOW())<$J$75+2/86400) You may need to make the time window wider than 2 seconds. J75 is the chart's Session Start Time. 2/86400 is equal to 2 seconds of Serial Date Time Value. These formulas would go in row 3 of columns K or M. Other entry conditions could be included. These are the available spreadsheet functions: Spreadsheet Functions |