Using spreadsheet to produce FI indicators (Force Index) - stock exchange & technical analysis

Stock Exchange and Market Analysis

Technical Analysis (18)

Force Index FI (Force Index) is one kind of oscillators and proposed by the technical analysis of financial transactions Dr. Alexander Elder and used to measure each short rally and each decline in long chewy between the two indicators of growth and decline. The trend line is calculated by multiplying the volume and today rise/fall directly. Based on FI calculation formula , it can be seen this indicator implies the direction of price changes , the magnitude and the amount of energy ( volume ), is a fairly technical indicators have reference value . If closed up today , the FI is positive , if it is to fall into a negative , may by This is to observe the trend of price changes , and when the price change is increased or the volume is enlarged, the amplitude of the FI swing is increased , which means that the trend is full of strength .

Force Index itself represents the kinetic energy of the plate potential of the stock , due to the negative reversal may occur at any time in the next day , it is often represented on the bar graph technology charts , in order to avoid when using this index change caused by severe distortion , and therefore combined with the trend of the average line as a reference out . the most commonly used are FI itself 2 Day (FI-2EMA) and 13 is Day (FI-13EMA) exponentially smoothed moving average ( equation refer to Ref.l). two who after smoothing effect can be a basis for short-term and medium to long term investment . Finally, let us according to FI import mathematical formulas Excel spreadsheet :
The FI _t : a first t closing price of the day of the first t -1 spread is multiplied by the closing price of t daily Day
  FI_t = ( C_t - C_t-1 ) * V_t
  C _t , C _{t. 1-} = second t and t -1 day's closing price
  V _t = volume on the tth day
FI-2EMA _t : 2 Day FI exponentially smoothed moving average of day t(equation refer to Ref.l)
FI-13EMA _t : 13 day FI exponentially smoothed moving average of day t(equation refer to Ref.l)
  13EMA _t :13 day price exponentially smoothed moving average of day t(equation refer to Ref.l)

FI-2EMA _{t is} mainly used for short-term operations after the establishment of the long-short market . In the bullish trend established by the 13EMA uptrend , when FI-2EMA is in a negative value and reverses upwards, it is a buy signal . Conversely , if 13EMA the downward trend established trend in short , when the FI-2EMA in a positive and reversal sell signal when it is down . for long-term investors , FI-13EMA with 13EMA used will be a pair of very useful Judging tool . When 13EMA is on the bullish uptrend , while FI-13EMA is in the positive region, the high point is getting lower and lower , causing mutual deviation , indicating that the buying momentum is weak , once the FI-13EMA falls closer Zero point. The selling point emerges , the momentum may reverse downward at any time . Conversely, when 13EMA is in the downward trend of the bears , and FI-13EMA is in the negative region, the low point is higher and higher , causing mutual deviation , indicating selling pressure. light is , once the FI-13EMA rise approaching 0:00 , buy surfaced , plate potential may be turned up at any time . the above, although a general rule out of stock , but due to the different properties of the stock , preferably at least one year or more shares have observed the subject matter The trend graph is then appropriately corrected according to the technical indicators . Finally, in order to facilitate the reader to use the FI index , the author still uses the model of Juyang (template) to continue to produce the analysis sample in Excel format for readers' reference :

template18.xlsx

This sample except the " historical stock " provides spreadsheet FI reference index outside , also be accompanied 13EMA, FI-2EMA and FI-13EMA index data , and second spreadsheet  provided in the candlestick figure, volume , FI histogram , 13EMA, FI-2EMA and FI-13EMA 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 WMA (Weighted Moving Averages) and EMA (Exponential smoothing Moving Averages) indicators
2. Investment Financial Notes - Stock Technical Analysis