Support Board
Date/Time: Tue, 26 Nov 2024 17:34:25 +0000
Spreadsheet formula cross Daily OHLC
View Count: 349
| [2023-10-16 19:33:02] |
| Hopeman - Posts: 166 |
|
Hello, I am using the Daily OHLC Y study and I want to make an input formula that crosses this level, the problem is that every time there is a new HH the study is updated, do you know if there is any formula to configure this? value and being able to create a Crossover formula that at least lasts until the next bar I think this would be enough, thank you |
| [2023-10-16 19:38:06] |
| John - SC Support - Posts: 36300 |
|
We are not sure exactly what it is that you are wanting, but we think the thing that may help you the most is the Input for "Graph High and Low Historically" for the "Daily OHLC" study. When this is set to "Yes", then the highest high as it was at each bar is kept and only updates for the new bars when a new Higher High exists. If you need more help let us know what exactly you want to accomplish and we will help you the best we can. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-10-24 16:55:37] |
| Hopeman - Posts: 166 |
|
Hello, I am thinking that using a formula from the spreadshet I can generate a breakout of the "Daily OHLC".. The indicator works well. The problem is that it is updated every time a candle goes up. I would be interested in keeping it over time or being able to set it to create that breakout. Kind regards Date Time Of Last Edit: 2023-10-24 16:57:11
|
| [2023-10-24 20:17:32] |
| John - SC Support - Posts: 36300 |
|
If you want to have the previous highest high data available instead of the current one, then you can add a Spreadsheet Study and enter the following in cell K3: =IF(ID1.SG1@3 <> ID1.SG2@4, ID1.SG2@4, K4) Where ID1 is the ID of the Daily OHLC study. This will shift the data such that the previous value is available at the current bar and so on going backwards in time. This also assumes that you have the Input for the Daily OHLC of "Graph High and Low Historically" is set to "Yes". You can then use this to determine your breakout. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-11-01 15:28:57] |
| Hopeman - Posts: 166 |
|
Thank you very much, It was a great help to me. I wanted to take advantage of this post to ask you a question, although I don't know if it is possible, I would like to know if it is possible to know when there is a percentage balance in a volume profile Volume by price, thank you. Best regards |
| [2023-11-01 17:31:24] |
| John - SC Support - Posts: 36300 |
|
Sorry, but we are not understanding - what do you mean by a "percentage balance"?
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: