Studies

Add Historical Study Data

Historical study data on over 90 technical indicators is accessible via the Chart and History icons. For Historical data, after a symbol is selected and placed into the insert pane you will see a Apply Study button.

Click on the Apply Study button and a menu will display with all the available indicators.

Click on an indicator and you can then edit the parameters including period and source (OHLC).

Once the study is customized, hit apply and select other indicators or click away from the indicator drop down menu. The study will appear in the insert panel below the symbol.

Add as many studies as required from the list, select your fields and historical options, and then click insert and the corresponding data will display in the spreadsheet.

Charts

For Charts, the same steps will provide historical indicator data directly to the chart. Once a symbol is selected, click the Apply Study button and make the required indicator selection and update the parameters. Once a study is applied, you can edit the study by clicking the Edit Study button.

Once finished applying studies, you update your Historical preferences and then click insert to view the chart.

Much like Time Series, all of the underlying and historical study data will display below the chart as well.

Available Studies

Moving Average	Moving Average Envelope	Moving Average Envelope Exponential	Moving Average Envelope Smoothed	Moving Average Exponential
Rate Of Change	Triple Exponential	Moving Average Exponential 2X	Moving Average Exponential 3X	Moving Average High/Low
Moving Average Smoothed	Moving Average Triangular	Moving Average Weighted	Volume Moving Average	MACD Oscillator
MACD Oscillator Exponential	Percentage Price Oscillator	Percentage Volume Oscillator	Average Directional Index	Modified Average Directional Index
Moving Standard Deviation (required for Bollinger studies)	Bollinger Bands	Bollinger Width	Bollinger Bands %B	Typical Price (required for CCI)
Commodity Channel Index	Parabolic Time/Price	Percent Change	Stochastic, Fast	Stochastic, Slow
Average True Range	Adjusted Average True Range	Change Over Average True Range	Relative Strength Index	Relative Strength Index Modified
Stochastic RSI	Percent R	Historical Volatility	Alligator	Aroon Up/Down
Aroon Oscillator	Awesome Oscillator	Close Location Value	Chaikin Money Flow	Chaikin Accumulation Distribution
Accumulation/Distribution Williams	Chaikin Oscillator	Chaikin Volatility	Chande Momentum Oscillator	Coppock Curve
Detrended Price Oscillator	Donchian Channel	Donchian Width	Ease Of Movement	Elder Ray Bull
Elder Ray Bear	Force Index	Highest High Lowest Low	Hull Moving Average	Ichimoku Clouds
Keltner Channel	Keltner Channel Exponential	Keltner Bands	Mass Index	McGinley Dynamic
Momentum	Money Flow Index	Moving Linear Regression	On Balance Volume	Oscillator
Volume Oscillator	Price Performance	Pivot Points Bands	Plot Line	Price Volume Trend
Stochastic Momentum Index	Supertrend	True Strength Index	Turtle Channel	Turtle Channel Retracement
Volatility Stop	Negative Volume Index	Positive Volume Index	Volume	Open Interest
VWAP	Weighted Close	Welles Wilder Volatility	Linear Regression Channel	Wilder Accumulative Swing Index
Retracement ATR High	Retracement ATR Low	Guppy Multiple Moving Average

Barchart for Excel

Studies

Add Historical Study Data

Charts

Available Studies

Related pages