Using spreadsheet to show candlestick charts, moving average, RSI, BIAS, MACD, stochastic KD and Bollinger band Simultaneously

Stock Exchange and Market Analysis

Technical Analysis (9)

According to the historical data of individual stocks, the various technical indicators are drawn into commonly used candlestick charts, moving averages, trading volume, RSI, BIAS, MACD, stochastic KD line and Bollinger band. Line graph, and displayed on the same screen at the same time (as shown below).
​
At present, we have introduced the calculation methods of moving average, RSI, BIAS, MACD, stochastic KD line and Bollinger band with EXCEL in the previous articles (Stock technical analysis 2-4, please refer to Ref.1~3). For the convenience of analysis, today we will use the Excel chart to draw these indicators together with the candlestick chart of the stock on the same spreadsheet for the reader's reference:
Template9_1.xls
The candlestick chart on this spreadsheet covers the stock price of Juyang from 2003/01/22 to 2014/01/20, so the horizontal axis (timeline) range is quite long. When the file is opened, the screen only displays the chart of the most recent date. Since EXCEL provides at most two main coordinate axes and sub-coordinate axes for each chart, the spreadsheet "strand chart" is constructed in a multi-graph manner, in which the candlestick chart, the Bollinger band and the moving average are produced in the same chart. And the main/second coordinate axis is indicated. As for other technical indicators, it is displayed in individual charts. Since the technical indicators are directly stacked on the candlestick chart, the candlestick chart will overlap with these indicators in some periods, as long as the readers will have The overlapping technical indicator maps can be clicked and then moved vertically downwards. In addition, there are two lines on the candlestick diagram to provide readers with the pressure line and support line analysis. The end points of the lines can be changed in length and angle, or they can be copied to create additional lines for other analysis purposes.
As for the analysis of the stock chart of other stocks, just return to the "historical stock price" spreadsheet, and copy the relevant information of individual stocks (such as the column A~J in the spreadsheet) to the corresponding field by Ref.4 method. so you can show charts updated in the "stock chart" spreadsheet. Since these charts is the author foray, if left error, please also feel free to correct me, let sorted out more accurate information helpful. Thank you! in addition, The author has produced EXCEL spreadsheets for readers' reference for various indicators of stock analysis (moving average, RSI, BIAS, stochastic KD line, William indicator, MACD and Bollinger band, etc.) For interested readers, please refer to Ref.5. Stay tuned.
Reference (Ref):

1. Stock Technical Analysis (2) - How to use Excel to produce individual stock technical indicators - moving average and deviation rate
2. Stock Technical Analysis (3) - How to use Excel to produce individual stock technical indicators - RSI, William indicator and KD value
3. Stock technical analysis (4) - how to use Excel to produce individual stock technical indicators - MACD
4. Stock technical analysis (1) - Stock technical analysis ( 1): Taiwan stock index and individual stock historical data query
5. Investment Financial Notes - Stock Technical Analysis