Login Page - Create Account

Support Board


Date/Time: Thu, 27 Feb 2025 09:05:58 +0000



Is this custom study possible with spreadsheets?

View Count: 405

[2021-07-01 14:10:02]
myke - Posts: 23
I need to use values from two different charts to make a study.

Chart 1 values: daily high & daily low

Chart 2 value: daily close

Study: SUM(Chart1DailyHigh, Chart1DailyLow, Chart2DailyClose)/3
[2021-07-01 15:55:26]
John - SC Support - Posts: 38222
First, take a look at the Pivot Points study as it almost sounds like Pivot Points Formula Type 0 is what you are looking for. Refer to the following:
Pivot Points


But, since you are referencing the Close from a different chart, the Pivot Points may not be what you want. In which case you would need to use the Study/Price Overlay to overlay one of the items from one chart to another, then use the Spreadsheet to do what you want. Refer to the following for the Study/Price Overlay:
Study/Price Overlay Study

And refer to the following for the start of the information on the Spreadsheet study:
Overview of Spreadsheet Studies
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