Daily, Weekly & Monthly RSI
RSI or Relative Strength Index is one of the parameters to know whether the stock is good to buy or not, or if the stock is good to sell. Now I have created a Video earlier where I talked about how we can find the RSI of a stock. The formula to calculate Relative Strength Index is RSI = 100 – [100 / {1 + (Average of Upward Price Change / Average of Downward Price Change}].
Now using this formula we can actually calculate the Daily, Weekly and Monthly RSI. The only thing is that for daily we take daily close Price, weekly we have to take weekly close Price and for monthly we take monthly close Price. And then using the above formula we calculate the Daily, Weekly and Monthly RSI.
In the above video, I have shown how we can calculate the RSI of Nifty 500 stocks. I have also created 4 sheets, 1 for Daily RSI Caculation, 1 for Weekly and 1 for Monthly. I have also created a combined sheet but the problem is since there are a lot of calculation involved it takes a lot of memory and cpu and that's why I have created separate sheet for every calculation.
This was also a request from some of the comments added in the first video. So after 6 months I have created the video creating the RSI of all the three. Now you might ask what is use of getting RSI of weekly and monthly. Now if someone wants to know whether the more time period the stock is in overbought zone or overbought zone then its the best way to know using the Weekly and Monthly RSI. And that's why I have created these sheets so that it is helpful for people to get the values.
Posted Using INLEO
This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.
Do you know that you can earn a passive income by delegating to @indiaunited. We share more than 100 % of the curation rewards with the delegators in the form of IUC tokens. HP delegators and IUC token holders also get upto 20% additional vote weight.
Here are some handy links for delegations: 100HP, 250HP, 500HP, 1000HP.
100% of the rewards from this comment goes to the curator for their manual curation efforts. Please encourage the curator @bhattg by upvoting this comment and support the community by voting the posts made by @indiaunited..
This post received an extra 20.00% vote for delegating HP / holding IUC tokens.
This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.
Do you know that you can earn a passive income by delegating your Leo power to @india-leo account? We share 100 % of the curation rewards with the delegators.
100% of the rewards from this comment goes to the curator for their manual curation efforts. Please encourage the curator @bhattg by upvoting this comment and support the community by voting the posts made by @indiaunited.