Calculate RSI using Excel (Momentum Indicator) - Step by Step

[@pushpendrasharma7172]

Thank you for putting in the effort to make this video. Super helpful. However I would like to call out that you made a mistake at the 6 minute, 30 second mark. Instead of taking the average of first 14 values and pasting it in the 15th row, you should paste it in the 14th row. To be specific, AVERAGE(D3:D16) should go to to F16 (you have assigned it to F17). You eventually get it back on track when you compute F18. It would be great of you can edit the video at the 6 minute 30 second mark and repost it as it will save a lot of people from making this mistake in their code/calculations. Thanks again for your contribution to the community.

[@arunnagarajramaraj8631]

I did the calculation of RSI as per your steps. But the values are not matching with Trading view. Need to understand this difference. Arun

[@vatsal715]

Sir, You used (F17*13+D18)/14 formula for EMA, didn't we missed the D17 cell data point of Gain/Loss? Neither it is taken whilst calculating formula in F17 nor in F18.

[@jothiprakashanandan]

Nice catch, Vatsal. The formula should be (F17*13 + D17)/14. I'll mark this in the description. Thank you!

[@vatsal715]

@@jothiprakashanandan Pleasure. Came out just for curiosity and help. That's still how the last 3-4 candles RSI matched with our excel calculation. 🤔

[@jothiprakashanandan]

Analysing the same. Need to find how QC was perfect.

[@vikas036]

​@@jothiprakashanandan Sir average loss mein bhi yahi sem process karna padega vahan bhi formula change hoga

[@sahil-dx7hz]

sir it will refresh automatically

[@jeetendradhawde6232]

Sir..thank you for such simple explanation

[@jothiprakashanandan]

You are most welcome

[@amaxrai6340]

Sirji, I have a question, can this sheet be used to calculate future price based on future RSI number ? for example current RSI = 32 , wht will be the price is RSI = 60 . Thanks 🙏🙏

[@jothiprakashanandan]

Yes, definitely. I'll even create this as a video soon. Would be great to calculate entry and exit prices well.

[@krishnagopal7890]

Sir In mcx commodity (silver and crude) can we use these formula

[@alndr4u]

Thank you sir, plz make dashboard videos based on plotly dash

[@jothiprakashanandan]

Thanks, Ramesh. Great idea. Can do!

[@alndr4u]

@@jothiprakashanandan plz do a detailed series on that

[@dineshjoshi8238]

How to fetch options chain tick by tick data live market

[@govindprasadgupta9250]

सर जी नमस्कार स्टॉक का मनी फ्लो कैसे निकालते है ?

[@jothiprakashanandan]

Can you please elaborate a bit?

[@user-nb7bz7pp2l]

Where this 13 came from, i didn't understand

[@razz023]

since we are taking an average of 14 days, there should be 14 values in the numerator (#13 + #1). Since we are looking at the EMA, where we give more weightage to the most recent value which is the values of that #1 i.e. current gain or loss value while giving less weightage to the previous 13 values, of whose we take an SMA and multiply it by 13. That's where 13 comes from. In short, a little value to the history (pervious price gains or losses of whom we have taken and sma) + more weight/value to the current parameter (here it's current price gain or loss). Hope, you get the point.

[@jothiprakashanandan]

Razz023 has exploded well. Thanks.