Support Board
Date/Time: Tue, 04 Nov 2025 02:30:27 +0000
Post From: How to Reference Time in Spreadsheet for Trading
| [2020-10-17 19:09:36] |
| User440656 - Posts: 14 |
|
I would like to back test a system that buys the ES mini five minutes before the close of regular trading hours and then sells in the after hours trading session. Specifically, the system buys at 12:55 Pacific time and exits the next time the market is open at 20:00 Pacific time. For the buy entry in my spreadsheet I have if(A4==12:55:00,1,0) and for the buy exit I have if(A4==20:00:00,1,0). However, column A includes a date and time, so I do not think that is correct. What should I use for the buy entry and buy exit? I have attached my spreadsheet. Thank you. |
Private File |