Support Board
Date/Time: Tue, 21 Jan 2025 04:12:12 +0000
Compare bar times
View Count: 1038
[2018-07-29 00:59:11] |
chart_warrior - Posts: 96 |
One of my conditions needs to happen only when low of day happens before high of day. How can I say "if high of day time is > low of day time"? Only function I know is BARTIME but I don't know how to reference bar time of a specific condition like high of day. Thanks! |
[2018-07-29 19:05:37] |
Sawtooth - Posts: 4157 |
You would need use a spreadsheet study to create persistent variables of the LOD and HOD times. This cannot be done with a Simple Alert formula. |
[2018-07-30 03:28:24] |
chart_warrior - Posts: 96 |
So how would you do it in a spreadsheet?
|
[2018-07-30 14:34:21] |
Sawtooth - Posts: 4157 |
It's not as easy as a simple formula example. More detail are needed: - What are you using to find the LOD and HOD? - Do you want a signal at each new LOD since the last HOD? - The day's opening bar will have a LOD and a HOD. Which one should be used? - When should the formula start looking for a new LOD? |
[2018-07-30 17:45:07] |
Sierra Chart Engineering - Posts: 104368 |
The particular time of the high of the day and the low of the day can be determined with the Daily OHLC Single Point study: Daily OHLC - Single Point But still you will need a way to reference those particular points. 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 |
[2018-08-01 17:36:52] |
chart_warrior - Posts: 96 |
It's not just about HOD or LOD. I was trying to see how often something happens, this can be anything to be honest but in my particular case instead of doing it in Excel I just wanted to quickly extract it from Sierra with LOD time being before HOD. I guess it's faster to just filter/sort in Excel unfortunately. |
To post a message in this thread, you need to log in with your Sierra Chart account: