Login Page - Create Account

Support Board


Date/Time: Fri, 19 Dec 2025 15:35:03 +0000



Post From: Daily % Calculation

[2025-11-01 17:33:15]
Sawtooth - Posts: 4300
The Daily Change % is calculated on the settlement Closed prices of an Historical Day bar created from *.dly data, not on a 1 Day chart created from Intraday *.scid data.

You will need to do your own Daily Change % calculation based on your Intraday 1-0-0 bar that is based on your own Session Times.

Try this:
1. Add the Spreadsheet Formula study
- Use a formula like this in its Formula field:
=ROUND((C-C[-1])/C*100,1)
- Hide this study.

2. Add the Text Display for Study study
- Reference the Spreadsheet Formula study's ID#.SG#
- Enter the Prefix Text and Suffix Text as needed.

See attached pic.
The left chart is a 1 Day chart starting at Globex open, the right chart is an Historical Day chart.
Note the DChg % of the Historical Day chart is positive, but the 1 Day chart is negative.
imageDChg% comparison.png / V - Attached On 2025-11-01 17:33:04 UTC - Size: 34.77 KB - 30 views