Support Board
Date/Time: Wed, 19 Nov 2025 03:58:53 +0000
Need spreadsheet formula to determine chart's time frame value
View Count: 1080
| [2016-05-27 04:24:17] |
| rc7rader - Posts: 144 |
|
Hi, I'm trying to include the chart's time frame value in a spreadsheet formula. For example, I have 3 charts - 5-minute chart, 15-minute chart, and 60-minute chart. I want to restrict an alert only to the 5-minute chart and ignore signals on 15-minute and 60-minute charts. Anyone knows the spreadsheet formula to get the time frame value? Thanks. |
| [2016-05-27 05:05:51] |
| Sawtooth - Posts: 4288 |
|
Cell J36 has the Seconds Per Bar. You could reference this cell in your formulas requiring it to be 300 seconds.
|
| [2016-05-27 05:07:12] |
| |
|
You can use this Spreadsheet cell: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#CellJ36 Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-05-27 05:17:13] |
| rc7rader - Posts: 144 |
|
Thanks so much. I don't know how I missed that.
|
To post a message in this thread, you need to log in with your Sierra Chart account: