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.
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 🙏🙏
Hi, Thanks for sharing the video, I had a question that is troubling me a bit. I read the same theory on RSI from investopedia and was wondering about the calculation of Avg Gain and Avg loss you made for the first cell. When we are calculating average gain, shouldn't we consider only the days where we had positive movement in the denominator ? E.g. if out of 14 trading days 5 days were gain, then average gain would be SUM(gain)/5 and not by 14, Any thoughts here ? Would love to know if I am thinking anything incorrect here, Thanks :)
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.
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.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
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.
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.
Hi, Thanks for sharing the video, I had a question that is troubling me a bit. I read the same theory on RSI from investopedia and was wondering about the calculation of Avg Gain and Avg loss you made for the first cell.
When we are calculating average gain, shouldn't we consider only the days where we had positive movement in the denominator ? E.g. if out of 14 trading days 5 days were gain, then average gain would be SUM(gain)/5 and not by 14, Any thoughts here ? Would love to know if I am thinking anything incorrect here, Thanks :)
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
In mcx commodity (silver and crude) can we use these formula
how i can change the different stock name in this sheet......
Thank You
Sir..thank you for such simple explanation
You are most welcome
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
सर जी नमस्कार स्टॉक का मनी फ्लो कैसे निकालते है ?
Can you please elaborate a bit?
Why MS Excel hasn't provided RSI function? It'd be a lot easier if they do.
sir it will refresh automatically
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
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.