Support Board
Date/Time: Mon, 09 Feb 2026 23:51:17 +0000
spreadsheet formula question using Time after
View Count: 11
| [2026-02-09 21:10:03] |
| User873130 - Posts: 53 |
|
I have a spreadsheet formula but would like the lines to start after 09:45 How do I implement this formula so it starts the drawing after 9:45? ID5.SG9+20 assuming ID5.SG9 is the Initial balance study input High my best attempt but didn't work =AND(FRACTIME(BARTIME)>TIME(09,35,00), ID5.SG9+20) |
| [2026-02-09 21:14:45] |
| John - SC Support - Posts: 44538 |
|
You have the right idea, but you need to consider that the AND() function is only going to give a True/False result. So what you are asking is to return a true answer when the Bartime is greater than 09:35:00 and ID5.SG9 + 20 is non-zero. To get what you want, you need to give the result of what you want to display. For this, you would need to use the IF() statement. So your formula would be the following: =IF(FRACTIME(BARTIME) > TIME(09, 35, 00), ID5.SG9 + 20, 0) Note that this will give you a line from the first bar after 09:35:00 and continue until midnight. The value of the line will be ID5.SG9 + 20. If you want to limit the times, then you would need to use an AND() and include an end time, like the following: =IF(AND(FRACTIME(BARTIME) > TIME(09, 35, 00), FRACTIME(BARTIME) < TIME(16, 00, 00)), ID5.SG9 + 20, 0) For the most reliable, advanced, and zero cost futures order routing, use 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: