Login Page - Create Account

Support Board


Date/Time: Tue, 26 Aug 2025 10:20:27 +0000



Post From: How to show value of a study only when bar has closed?

[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