Using spreadsheet to produce BR indicators (buy and sell willingness indicator)

Stock Exchange and Market Analysis

Technical Analysis (17)

Sale willingness index (BR) is used to measure the test indicators of the strength of the will of the sale. It is the ratio of the n-day difference summation between the highest price and the closing price to the n-day difference summation between the opening price  of the previous day and the lowest price of the day . Since the closing price is usually the final result of the investor’s reaction in the ups and downs of the stock market at that time , it is determined with emotion . so BR, implicit in n days of market trading will of sentiment indicators, are used as a reference anti-market operations . therefore BR is usually the trading momentum indicators AR (Ref.1) in order to increase the accuracy of forecasting index resistance . In addition, BR encountered ex-entitlement , need to adjust the previous day's closing price , while AR is no problem of adjustment.
Basically, the difference between the highest price of the day and the closing price of the previous day represents the energy of the long stocks to increase the stock price after a night of calm thinking , and the difference between the previous day's closing price and the lowest price of the day shows the empty share price. of strength . so when BR at 70% to 150% of the time between , said the two sides are in the consolidation see-saw stage . If the BR Chaoguo 150% represents a buying active , stock prices strong rise , to 400% or more , then entered the overbought area , to begin pullback of attention may at any time . Conversely, if BR is less than 70% indicates a low popularity , the stock retreated vulnerable . to 50% or less , then entered the oversold zone , can keep an eye opportunistic approach point in time . As the BRSwing amplitude values than the AR big values , a single indicator can easily lead to miscarriage of justice , it is usually choose to work with AR use . When the AR and BR value at the same time to reach a relatively high point , when the shareholding should wait profit appearances , the opposite , when two were significantly lower humble , you can buy ready to start looking approach . Finally, let us according to BR import mathematical formulas Excel spreadsheet :
DH _t : a first t highest price first date t -1 closing price of the spread
  DH_t = H_t - C_t-1
  C _t-1 = second t -1 closing price of the day
  H _t = the highest price on the tth day
DL _t : the difference between the closing price of the t-1 day and the lowest price of the t- day
DL_t = C_t-1 - L_t
  L _t = the lowest price on the tth day
BR _nt : n- day trading intention indicator on the day of t
  BR_nt = ( DH_t + DH_t-1 + … + DH_t-n+1 ) / ( DL_t + DL_t-1 + … + DL_t-n+1 )
Wishes index trading BR 's n value generally 26 is the optimum value , equivalent to the strength of each month share price momentum . Although the foregoing general rule is out of stock , but because of the different properties of individual stocks , the best still have to observe the subject of at least one year The above stock price trend chart is moderately corrected according to the technical indicators . Finally, in order to facilitate the reader to use the BR index , the author still uses the model of Juyang (template) to continue to produce the analysis sample in Excel format for readers' reference :

template17.xlsx

In addition to this sample " historical stock price " provides spreadsheet BR reference index outside , also be accompanied AR index data , and second spreadsheet provides the candlestick graph , daily AR and BR Trend line chart for readers' reference . If you find any mistakes, please correct me . Thank you !
In addition , the author made 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 charts and other technical indicators on the same chart , interested readers can refer to Ref.2.
Reference (Ref):
1. Using spreadsheet to produce AR indicators (buy and sell momentum)
2. Investment Financial Notes - Stock Technical Analysis