Login Page - Create Account

Support Board


Date/Time: Thu, 06 Feb 2025 07:16:17 +0000



percent change previous days RTH last (close) to current intraday last price

View Count: 895

[2020-04-17 13:33:21]
User731787 - Posts: 5
Is there an existing study that shows the percent price change for the current intraday last price to the PREVIOUS days (RTH) (close) last price. If not, using the spreadsheet formula study (C-C[-1])/C[-1]*100, any suggestions on how I hold the C[-1] constant at previous days RTH (close) last?
[2020-04-17 14:48:51]
Sawtooth - Posts: 4169
any suggestions on how I hold the C[-1] constant at previous days RTH (close) last?
This is what I use on a 5 min chart:
=IF(AND(MROUND(BARTIME[-1],1/86400)<TIMEVALUE("16:14:00"),MROUND(BARTIME,1/86400)>=TIMEVALUE("16:15:00")),C[-1],ID1.SG1[-1])
where ID1 is the Spreadsheet Formula study.

This assumes chart bars are timebased. It returns a persistent price at the close of the 16:10 bar.
Date Time Of Last Edit: 2020-04-17 16:22:25
[2020-04-17 18:40:41]
Sierra Chart Engineering - Posts: 104368
Also take a look at this study:
Percent Change Since Previous Close
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to 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:

Login

Login Page - Create Account