Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 07:41:48 +0000



Is there a ID # for Open, High, Low, Close?

View Count: 773

[2020-01-06 05:44:17]
sourdubber - Posts: 52
Is there a way to use Open, High, Low, Close in the Spreadsheet Formula? Here's the formula I want to create:

i = MovingAverage(Close + StdDev, length);

where StdDev is the standard deviation. There is a study for standard deviation, so I can get the ID for that but I don't know how I could combine it with "Close". When I used "Close + ID3.SG1" or "E3 + ID3.SG1" (spreadsheet cell) as the input, it did not work. Please advise.
[2020-01-06 05:53:49]
sourdubber - Posts: 52
Please disregard. I found the answer: C+ID3.SG1
[2020-01-06 18:01:38]
John - SC Support - Posts: 31159
For reference, here is where you will find the Main Price Graph identifiers that can be used in Alerts or the Spreadsheet Formula study:
Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables
For the most reliable, advanced, and zero cost futures order routing, use 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