Python & ChatGPT for Stock Market Analysis - www.udemy.com/... RSI is a momentum indicator that helps you understand if a stock is overbought or oversold. In this video, you will learn how to calculate RSI using Excel.
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.
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.
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 🙏🙏
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.
