Using spreadsheet to produce MA-osc indicators (Moving Average Oscillator)

Stock Exchange and Market Analysis

Technical Analysis (12)

In the candlestick chart of individual stocks , the moving averages of different days are usually drawn as reference for stock trading , while the Moving Average Oscillator (MA-osc) is the difference between the moving averages of different days ( which can also be expressed by the ratio ) represents the range of movement between moving averages , and reflects the degree of stock price deviation. It can be further used as a reference for short-term entry and exit . Let us follow the math formula of MA-osc imported into Excel spreadsheet :
OSC-MA _t : a first t moving average daily amount of rocking , The m difference day moving average is simply subtracted by the n-day moving average. The detail following formula is shown as:
MA-osc _t = MAn _t - MAm _t
  MAn _t : of t Day n -day moving average (Ref.l)
  MAm _t : of t Day m day moving average
Usually, the value of n is smaller than the value of m . Since MA-osc is often used as an indicator for short-term entry and exit , the two moving averages are often composed of a weekly line and a half-moon line . Since Taiwan implements two days off per week , the n and m values ​​are each taken to be 5 with 10 Ri , and to 5-10MA-osc on behalf of the moving average amount of swing . Finally, for the convenience of the reader utilize MA-osc indicators , the author still continue to produce an analysis sample by using Makalot as template in Excel format samples for analysis Reader's reference :

template12.xlsx

In addition to this sample " historical stock price " provides spreadsheet 5-10MA-osc reference index outside , and the second spreadsheet provides the candlestick in FIG. 5 Day and 10 moving average day , turnover the amount and MA-osc trend line for the reader . observed 5-10MA-osc of the charts , can be found in the so-called golden cross and death cross is the 5-10MA-osc from negative to positive and from positive to negative point in time , and In the negative axis it began to reverse upwards, the opportunity to rebound the stock price was prompted earlier. Similarly, when the positive axis began to reverse downward, it also reminded the stock price of the stock . As the spreadsheet was just formed , if there are any mistakes, please Do not correct me . Thank you !
In addition , the author made EXCEL spreadsheet for various indicators (moving average , RSI, BIAS, stochastic KD line, William indicator , MACD, CDP and Bollinger band) for stock analysis, and further produced candlestick chart, figure charts and other technical indicators on the same chart , interested readers can refer to Ref.2.
Reference (Ref):
1. Investment and financial notes - Stock technical analysis (2): How to use Excel to produce individual stock technical indicators - moving average and deviation rate
2. Investment Financial Notes - Stock Technical Analysis