Stock Exchange and Market Analysis
Technical Analysis (9)
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 (investment financial notes - 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 on the same spreadsheet for the reader's reference:
Template9_1.xls
The Candlestick chart on this spreadsheet covers the stock price of MAKALOT 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 coordinate axes (main and sub-coordinate axes) for each chart, The main 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 second coordinate axis is indicated for trading volume. As for other technical indicators, it is displayed in additional charts. Since some 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 click the overlapping technical indicator maps and then move them vertically downwards to see more clearly. In addition, there are two straight lines on the Candlestick diagram to provide readers with the Resistance 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. In this way, the updated chart can be displayed in the modified spreadsheet. Since these line drawings are the first test of the author, please correct me if you have any mistakes, so that the information compiled can be more accurate and useful. Thank you! 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
