Using spreadsheet to analyze the stock investment benefit simulation (V2.1) sequel

Stock Exchange and Market Analysis

Technical Analysis (5) sequel

Set the annual reporting rate target, use spreadsheet to analyze the stock investment benefit simulation – V2.1 (Keyword: investment and financial management, stock technical analysis, spreadsheet, benefit) Then, post office deposit interest rate, EPS, dividends, dividends, net profit, reporting rate, conservative, healthy, short-term speculation)

Summary: Compare the reporting rate of bidding before and after the opening and closing prices

For the previous investment financial notes - stock technical analysis (5), we make a paper simulation based on the stock price-to-earnings ratio and the post office deposit rate, and hang in or buy the target at the target price before the opening day. The price hangs out (set one). This sequel is changed to the target price at the buy price before the close of the day or the target price at the sell price (set 2). Compare the investment profit and loss status of the two. The simulation analysis of Juyang and Sinosteel:
​
​
It can be seen from the above table that the method of setting the second stock selection can reduce the loss, but the relative profit is slightly inferior. This is because the buying and selling timing is determined by the difference between the buying and selling target price and the closing price of the day, rather than the opening of the day. The price, the risk will be more timely, but relatively, the trading point is also less likely to touch the lowest price of the day.
Template5_2 and template6_2 are for the reference calculation of the above two stocks by the method of setting two. If you have any questions, please feel free to discuss them, or if you have any mistakes, please feel free to correct them. Thank you for sharing your experience. Thank you!
Next time, we will use the above P/E ratio and the change in the annual deposit rate of the post office as the main axis, supplemented by other technical indicators, in an attempt to identify a stock picking strategy with lower risk or better profit . In addition, the author analyzes stocks. The various indicators (moving average, RSI, deviation rate, KD value, William indicator, MACD and Bollinger channel, etc.) produced the EXCEL spreadsheet for readers' reference, and further produced K-line diagrams and other technical indicators. On the same chart, interested readers can refer to Ref.1. Stay tuned.
Reference (Ref):
1 . Finance notes - Stock Analysis