Stock Analysis

With Barchart for Excel, you can use various studies and analysis tools to help you spot trends in stock price movements over time.

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 an 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.

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.

Check out our User Guide to see all of the available studies you can use to analyze stocks in Barchart for Excel.