Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 12:49:40 +0000
Compare bar times
View Count: 950
| [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: 3993 |
|
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: 3993 |
|
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] |
| |
|
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: