Putting the Index is a fixing force (RSI) for bitcoins in Excel
The index is a complete force (RSI) is a popular technical indicator, with which the power of the activation of activation is measured. In this state, we will make you a trash on the scales of RSI for bitcoins in Excel, using historical data on the shadows.
What is RSI?
RSI is disseminated as the one, in a great time, the shadow (from the medium scolving 26 occupying) to the last change of the shadow with the shadows of the false people. Strong tendencies or bull tendencies are provided to the non -barrier reading of RSI, in that time, as a strong tendencies, to the exit tendencies to the overbought reading of the RSI.
Blood Instruction
- Use Excel : Take Tablitsa Excel, where do you want to unite RSI for bitcoins.
- Squeeze the columns : Put two columns A and B in your pittle Excel with the picker: “Date” (timber A) and “Close the shada” (Tolobets B).
3.
- “The column (a).
5.
- F2/F1))*100
Describe the Index Define Powers (RSI) for Bitcoins.
7.
Formula or Shagi:
Follow the pursuit of the step, to dispel RSI, using the historical data:
- Install the tablitsa or use the function of the "rank" in Excel, in order to disperse the mid 26 period.
Use the formula= A2/A2+0.92 (B2-B1).
Use the formula = (B2-D2) 100 for combing RSI.
COVES AND VARIATION
You can use the spreading primary values, so as 50 periods or 100 perids, changes in the formula (for example, `= A2/A2+0.85 (b2-b1).
- You can use the other formulas, for example,
- You also can use the exposure to Excel, for example, B. “Started” -e -in, which will immerse the more prodigal functions for technical analysis.
Diplom
Combine the Index of Following Power (RSI) for Bitcoin in Excel – this is a simple process that sets the bases of Excel formulas and the subtractor. If you will fill these shagies and use the indicative formula or Shagi, you can distort the RSI for bitcoins, using historical data on the shadows.
