Support Board
Date/Time: Thu, 27 Feb 2025 07:09:52 +0000
Post From: Spreadsheet study MEAN. how do i use this in indicators under the MA type?
| [2021-06-16 13:40:56] |
| John - SC Support - Posts: 38222 |
|
If we are understanding you correctly, you have developed your own Moving Average in a Spreadsheet and you want to use that as the Moving Average option in the CCI study. What you are wanting to do is not supported, nor would it be something that could be done, as you are wanting to tie a Spreadsheet cell to an input for a study. But, you can certainly get the result you want, by adding the CCI study and setting the Length to a value of 1 (that will essentially not give you a moving average). Then use the Spreadsheet Study that has your Moving Average in it to use your Moving Average on the CCI study. Keep in mind that the values from studies that are added to the chart are displayed in the Spreadsheet study after the calculation columns (typically starting at column AA). Refer to the following: Using the Spreadsheet Study: Order of Study Data Outputted to Spreadsheet For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |