How to Calculate the Relative Strength Index (RSI) in Excel

[@AMARDIPNIMBALKAR]

very nicely explain the concept.thank you

[@yogihex]

Phenomenal video! This explanation is better than Seeking Alpha's

[@russkiy81]

Great explanation! Do you know by any chance how to calculate for excel 3-period RSI of 1-period ROC?

[@gupteparag]

Thanks for sharing 👍

[@bernabegm8345]

Thanks I will follow you

[@ajaymehta1843]

thanks very useful

[@beisatonlineshopping5713]

Thank you for this great tutorial, the calculation shown in the video is for "RSI exponential" right ? . normal RS = AVG Gain/AVG Loss) , am i right ?

[@h2e]

Yes, and I believe that's normally what most sites us. Since it's a momentum indicator, exponential is probably most appropriate.

[@tee-gamer8281]

Thank you. On Point

[@atulkadbe4082]

Great

[@rickb5271]

Your "Average Gain" and "Average Loss" take care of 0 values when in opposite Gain/Loss, are you sure it's the way?
Example for "Average Loss" it would be (4.01+3.42+1.92+1.16+0.74)/5 = 2.25. Not 0.80 ?

[@nth.education]

I have the very same question, super confused, I also believe one should not take 0 values as a count in denominator. That way it would be actual average gain (as we only average when gain happened). I understood it correctly, right ?

[@Alejandro-db2xj]

great! can you teach us how to test a sistem using RSI in excel?? thanks!

[@741980abhi]

Thank you very Much 👍🙏 can u please explain how to find weekly and monthly Rsi in Google or Excel .

[@kvs9290]

this works for the last date if you feed around a year long data

[@kvs9290]

I tried this for a 3 months data, it didn't return exactly the same value !

[@h2e]

If you only download 3 months of data it won't be the same. It includes some trailing history in the average. I'd suggest using an entire year worth of data, then you should see that variance shrink