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 ?
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 ?
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
Yeah - in testing, I found that I needed a minimum of 6 months of trailing before my answers would match various brokerages out to 2 decimal points. (Of course, more than 6 months is better.) This is the nature of indicators that rely on a history of previous calculations. They need to be "warmed up", so to speak, with lots of historical data. Exponential moving averages have the exact same issue.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Thanks for the video, I create the same excel sheet and try to analyze the RSI. appreciate your video.
Phenomenal video! This explanation is better than Seeking Alpha's
Thanks for sharing 👍
thanks very useful
very nicely explain the concept.thank you
Thanks I will follow you
Great
Great explanation! Do you know by any chance how to calculate for excel 3-period RSI of 1-period ROC?
Thank you. On Point
this works for the last date if you feed around a year long data
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 ?
Yes, and I believe that's normally what most sites us. Since it's a momentum indicator, exponential is probably most appropriate.
great! can you teach us how to test a sistem using RSI in excel?? thanks!
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 ?
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 ?
Thank you very Much 👍🙏 can u please explain how to find weekly and monthly Rsi in Google or Excel .
I tried this for a 3 months data, it didn't return exactly the same value !
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
Yeah - in testing, I found that I needed a minimum of 6 months of trailing before my answers would match various brokerages out to 2 decimal points. (Of course, more than 6 months is better.) This is the nature of indicators that rely on a history of previous calculations. They need to be "warmed up", so to speak, with lots of historical data. Exponential moving averages have the exact same issue.
thanks very useful