ENENTUATION OF THE INDEX DEFIT POWERS (RSI) for Bitcoin in Excel
The Index is A Complete Force (RSI) is A Popular Technical Indicator, Used for the Measurement of the Power of the Shadow of the Assets. In this state, we will draw you the scogy on rsi for bitcoin in Excel, using historical data.
What is RSI?
RSI is disseminated as a matter of that, and it was reduced by the shada (it is 26 periodas of the mider) to the unnoticed change of the shadow in the formation of the shadow of its subordinating period. The Strong Copper or the Bull of the Tendencies Adjusts to the Trans -Selling RSI, In The Time, As a Fierce Trite, The RSI is Broised.
Blood instruction
- Use Excel : Take Off The Electronic Tax Excel, Where You Want To Disperse RSI for Bitcoins.
- Settings the columns : Put two columns a and b in your electronic table with excel with the pursuits: “date” (timber a) and “shady closed” (tambb “b).
3.
- The column (A).
5.
- -F2/F1))*100
for Combing the Index of the Defense Force (RSI) for Bitcoins.
7.
Formula or Shagi:
In order to find out rsi, using the historical data on the shadows, the powers of the pursuit:
- Install the tablitsa or use the function of the "rank" in Excel, to scatter 26-peiodic bell.
Use the Formula= A2/A2+0.92 (B2-B1)For the Combustion Unacceptable Change of Shadow.
Use the Formula= (B2-D2) 100for Combing RSI.
Coves and Variation
You can use the spreading mid-MID, So as a 50-pericodic or 100malio, a change in the formula (for example, a2/a2+0.85 (B2-B1)).
You can use the other formulas as = (b2-d2) 100 = (B2/B1)-((B2-B1)/B1)`, for Combing RSI.
- You also can use the excel prenatal, Such as the “Tencter” preferential, which presents the more prodigal functions of the technical analysis.
Conclusion
Combine the Index of Following Powers (RSI) for Bitcoin in Excel – This is a Simple Process, which sets the Basic Value of Excel Formulas and Transplanting. The follow -up of these internships and is used by the presented formula or shagie, you can need to dissolve rsi for bitcoins, using historical data on the shadows.