Support Board
Date/Time: Tue, 10 Feb 2026 01:42:44 +0000
Post From: spreadsheet formula question using Time after
| [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 |