Support Board
Date/Time: Tue, 26 Aug 2025 08:50:49 +0000
How to show value of a study only when bar has closed?
View Count: 100
| [2025-07-23 09:09:37] |
| neevaksama - Posts: 53 |
|
I have 2 simple Spreadsheet Formula studies with - Formula = C + or - some study - Number of Bars To Calculate = 1 - Chart Region = 1 - Enabled Value Label for the study I want the values on price scale of the Main Price Graph to show only of the last completed bar but the value is updating in real time. Eg: If the Spreadsheet Formula formula outputs 1,2,3 throughout the lifetime of the bar, I only want to see it being updated to 3 on the price scale (assuming 3 is the latest value) Any ideas to achieve a "Show values only upon bar close" sorta functionality? PS: Just to add, I only want to see the value on the price scale, I do not need to see the Spreadsheet Formula chart itself which more or less is achieved when I did Number of Bars To Calculate = 1 Date Time Of Last Edit: 2025-07-23 09:21:10
|
| [2025-07-23 15:07:04] |
| John - SC Support - Posts: 41464 |
|
Show value on Bar Closed implies that you want to see the value of the previous bar and not of the current bar. The easiest way to do this would be to change your formula so that it references the information for one bar back from the current bar. So your formula would look like the following: =C[-1] + ID1.SG1[-1] Refer to the following: Study/Chart Alerts And Scanning: Referencing Data Other Than on the Last Bar/Column In the Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-07-23 18:12:52] |
| neevaksama - Posts: 53 |
|
Perfect!
|
To post a message in this thread, you need to log in with your Sierra Chart account: