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

[@gupteparag]

Thanks for sharing 👍

[@ajaymehta1843]

thanks very useful

[@atulkadbe4082]

Great

[@tee-gamer8281]

Thank you. On Point

[@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.

[@bernabegm8345]

Thanks I will follow you

[@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 ?

[@kvs9290]

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

[@741980abhi]

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

[@Alejandro-db2xj]

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

[@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