Support Board

Date/Time: Fri, 19 Apr 2024 04:43:55 +0000

Post From: Automated Trading

[2019-01-02 18:19:59] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3973
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