Calculate RSI using Excel (Momentum Indicator) - Step by Step
Вставка
- Опубліковано 12 вер 2024
- 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.
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
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.
Nice catch, Vatsal.
The formula should be (F17*13 + D17)/14. I'll mark this in the description.
Thank you!
@@jothiprakashanandan Pleasure. Came out just for curiosity and help. That's still how the last 3-4 candles RSI matched with our excel calculation. 🤔
Analysing the same. Need to find how QC was perfect.
@@jothiprakashanandan Sir average loss mein bhi yahi sem process karna padega vahan bhi formula change hoga
sir it will refresh automatically
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 🙏🙏
Yes, definitely. I'll even create this as a video soon. Would be great to calculate entry and exit prices well.
Sir..thank you for such simple explanation
You are most welcome
Thank you sir, plz make dashboard videos based on plotly dash
Thanks, Ramesh. Great idea. Can do!
@@jothiprakashanandan plz do a detailed series on that
Sir
In mcx commodity (silver and crude) can we use these formula
सर जी नमस्कार स्टॉक का मनी फ्लो कैसे निकालते है ?
Can you please elaborate a bit?
How to fetch options chain tick by tick data live market
Where this 13 came from, i didn't understand
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.
Razz023 has exploded well. Thanks.