Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 00:53:27 +0000
[Programming Help] - Chart recalculation setting
View Count: 706
| [2019-07-28 18:53:22] |
| User968625 - Posts: 256 |
|
Hello, 1- I have a study that uses the excel sheet study to draw 10 mins, open range band. It works and it uses the first 10 mins IB so after the first 10 mins the line is finalized (through the first 10 mins it keeps plotting). It works really well however many time I need to force the chart to recalculate to display the bands. is there a way to force the chart to recalculate at a certain time to make sure it displays? any other way? 2- Also,I use the high/low of a period to display the band. again it works well but it displays the band across the whole chart. I just want to have it displayed over the first 30 mins bars. is there a way for that as well. Thanks Date Time Of Last Edit: 2019-07-28 19:00:18
|
| [2019-07-29 01:24:28] |
| Sawtooth - Posts: 3980 |
|
is there a way to force the chart to recalculate at a certain time to make sure it displays?
1. Use the Chart Recalculation - Periodic study. (FYI, this study does not recalculate when using Replay Chart.)I just want to have it displayed over the first 30 mins bars.
2. On the spreadsheet study, use a formula to filter when the line is displayed, like this:=IF(AND(TODAY()=INT(A3),S3>0),S3,0) where S3 is the formula that draws the upper band. This will limit its display to the current day. Repeat this for the lower band. Since you are using a spreadsheet study to draw the bands, you could combine the formulas into one column per side. |
| [2019-07-29 10:48:36] |
| User968625 - Posts: 256 |
|
Thank you. I added the study. I looked for something like this but it is not on the technical study reference page. as for the code, not sure how/where to add this code. I will look for how to implement it. thank you again
|
To post a message in this thread, you need to log in with your Sierra Chart account: