Support Board
Date/Time: Tue, 04 Nov 2025 15:19:55 +0000
Is this custom study possible with spreadsheets?
View Count: 499
|   [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: 42753 | 
| 
                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:
