Put the Index withdrawal (RSI) for bitcoins in Excel
The adhesive index of the resistance (RSI) is published by the popular technical indicator, used for the measurement of the power of the activa. In this state, we will draw you the scogy on RSI for Bitcoin in Excel, using historical shadows.
What is RSI?
RSI is disseminated by the part of the interde, the crop of the shadow (with its 26 -summer ones, the mass media) to the unacceptable modification of the shadows by the formation of the permanent persecution. Strong tendencies or Bychya attaches to the erected reading, in that time, as a strong growth, he brings to the overload of Rs.
Instruction Shag by Shago
- 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 the electronic Tablit Excel with the following cakes: “Date” (timber a) and “shada closed” (tambourine b).
3.
- (A).
5.
6.
7.
Formula or Shagi:
In order to disperse RSI, using this historical shadows, the pursuits of the follow -ups:
- Put the Tablitsa of the rest or use the function of the “rank” in Excel to scatter the wear in 26 perid.
Use the formula = A2/A2+0.92 (B2-B1) to disperse the unacceptable change of shadow.
Use the formula= (B2-D2) 100for combing RSI.
COVES AND VARIATION
You can use the spreading mobiles, so as 50 periods or 100 periods, changes in the formula (for example,= A2/A2+0.85 (B2-B1)).
You can use the other formulas as= (B2-D2) 100
- You also can use the Excel supplement, such as the supplement of the “start -up”, which impells the more prodigal functions of the technical analysis.
conclusion
Combine the Index of Following Soprotte (RSI) for Bitcoin in Excel – this is a simple process that sets the bases of the Excel formulas and the second -hand. The follow -up of these stages and use of the imposed formula or the shagov, you can need to dissolve RSI for bitcoins, using these historical shadows.
