Relative Strength Index (RSI) Excel Template
Вставка
- Опубліковано 12 вер 2024
- Excel for Stock Market - Day 20
Download Relative Strength Index (RSI) Technical Indicator Excel template to create RSI indicator for any stock. Just type in a ticker symbol and see the RSI and signal events generate automatically. Customize for different time periods and time intervals.
Link to download this template (for free)
indzara.com/20...
Other videos in this series:
STOCK LOOKUP - • Stock Lookup Excel Tem...
STOCK PRICE CHART - • Stock Price Chart Exce...
FOREX CURRENCY CHART - • Forex Currency Chart E...
CANDLESTICK CHART - • Candlestick Chart Exce...
STOCKS WATCH LIST - • Stocks Watch list Exce...
US STOCK MARKET TRACKER - • US Stock Market Tracke...
INDIA STOCK MARKET TRACKER - • India Stock Market Tra...
LONDON STOCK EXCHANGE TRACKER - • London Stock Exchange ...
FOREX MARKET TRACKER - • Forex Market Tracker E...
SIMPLE MOVING AVERAGE - • Simple Moving Average ...
WEIGHTED MOVING AVERAGE - • Weighted Moving Averag...
EXPONENTIAL MOVING AVERAGE - • Exponential Moving Ave...
EXPONENTIAL MOVING AVERAGE CROSSOVER - • Exponential Moving Ave...
MOVING AVERAGE ENVELOPE - • Moving Average Envelop...
BOLLINGER BANDS - • Bollinger Bands Excel ...
DONCHIAN CHANNELS - • Donchian Channels Exce...
MOMENTUM AND RATE OF CHANGE - • Momentum And Rate Of C...
AWESOME OSCILLATOR - • Awesome Oscillator Exc...
MACD - • MACD Excel Template
RSI - • Relative Strength Inde...
ATR - • Average True Range (AT...
WILLIAMS %R - • Williams %R Excel Temp...
STOCHASTIC INDICATOR - • Stochastic Indicator E...
ON BALANCE VOLUME INDICATOR - • On Balance Volume Exce...
KELTNER CHANNELS INDICATOR - • Keltner Channels Excel...
US MARKET INDUSTRY ANALYZER - • US Stock Market - Indu...
INDIA MARKET INDUSTRY ANALYZER - • India Stock Market - I...
TWO STOCKS COMPARISON - • Two Stocks Comparison ...
US MARKET STOCK SCREENER - • US Market Stock Screen...
STOCK PORTFOLIO TRACKER - • Stock Portfolio Tracke...
All the templates in this series will be available for you to download on indzara.com. Please visit
www.indzara.co...
The Excel for Stock Market Playlist Link
• Excel for Stock Market...
Microsoft 365 Subscription Plans for PC and Web:
www.microsoft....
Excel for the web:
www.microsoft....
#excelforStockMarket #excel #indzara
NEW: 25 Technical Indicators in Excel: ua-cam.com/video/PamlAR61Ba0/v-deo.html
indzara.com/product/technical-analysis-pro-excel-template/
All templates: indzara.com/stock-market-templates/
Thanks & Best wishes.
You describe well about the formula of Simple moving average On cell F14(Avg.Gain) and on cell G14(Avg.Loss). In excel Simple average is "average" formula. But technically skipped about the average formulas of Cell F15 and Cell G15 (Which most people fail to understand). No one can understand why you use different types of average formula on Cell F15 and Cell G15 if you not describe well. You must have to say that, The formula of RSI is based on Exponential Moving Average. This is why on Cell F15 and Cell G15 we need to input the formula of Exponential Moving Average. Many may have a question that why the formula of "Exponential Moving Average" not input on the Cell F14 and Cell G14 directly. The answer is, No one can calculate "Exponential Moving Average" on the very first day. On the very first day "Exponential Moving Average" is unknown to all. This is why to calculate "Exponential Moving Average" we use simple moving average for the first time only.
Yes, you are correct. Thank you very much for your valuable feedback and input shared. We have noted it down and we will update the description in the next version of the template.
Ty sir, the only video I found explaining the smoothing of RSI
You are welcome.
Best wishes.
Excellent Video. One of the best I have everseen. Yet to use it. /👏👏👌🏻👌🏻
Thank you for sharing your valuable feedback.
Best wishes.
By the way, the RSI formula has a mistake. it is missing a division. There should be a division between 100 and (1+RS). It should be RSI=100-100/(1+RS), not RSI=100-100(1+RS).
Thank you for highlighting the same.
We have used RSI=100-100/(1+RS) inside our template calculation but due to typo error on the concept explanation it is incorrect.
We will update the same in our video and concept description as soon as possible.
Best wishes.
Super video! Thanks for it
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
Thanks a lot. Excellent. It doesn't mark the green buy dot and the red sell dot, what could it be? Greetings from Argentina.
You are welcome. Thank you for sharing your valuable feedback.
We regret the inconvenience caused.
Can you share your copy of the template with the ticker symbol that you are using to us at the below link to check further:
support.indzara.com/support/tickets/new
Best wishes.
Sir, instead of typing stock names every time, can v create a list of stocks and then in front each stock names show the rsi values ? For example creating a list of nifty 50, nifty next 50 nitty 250 etc. Please help
Yes, we can use a Macro to automatically change the ticker symbol from the list in the template to get the RSI value and update it in the symbols table. We have done the same in our premium version of the technical indicator template that provides 25 technical indicator values along with RSI. Following is the link to the template for quick reference:
indzara.com/product/stock-market-excel-templates/stock-screener-excel-template/
Best wishes.
Is this RSI based on simple moving average or exponential moving average ?
Thank you for showing interest in our template.
If you select the source as closed, then the RSI is based on simple moving average.
Best wishes.
@@indzara You already used the formula of exponential average on Cell F15 and Cell G15. So, how could you say that, RSI is based on simple moving average. You wrote the formula in cell F15 and G15 . And don't you know which formula you wrote in cell F15 and G15 ?
Why is this RSI not the same as the RSI of Tradingview? Any ideas?
Can you please send us screenshot to support@indzara.com?
I tested against Tradingview when developing this template.
Best wishes.
Yes the RSI calculation never matches with tradingview mostly
Indzara previously indicated that its calculation is based in SMA, and Tradingview use RMA as basis. Somebody knows how to make this calculate using RMS?.
I want to apply 2 indicators in one chart. How can it be done in RSI chart template?
Best Regards
Thank you for showing interest in our template.
We have technical analysis pro template which has 25 indicators in one template. Following is the link to the same for quick reference:
indzara.com/product/stock-market-excel-templates/technical-analysis-pro-excel-template/
Best wishes.
sir ji nice video... could you guide me how to calculate.. weekly and monthly basis ema, rsi, and another indicator... please make one video on this
Thank you for showing interest in our template.
Currently, we do not have tutorial video explaining the calculation of weekly and monthly basis EMA, RSI, and another indicator. We will update you once we create the same.
Best wishes.
I am from Pakistan. How can I use this template in PSX, i.e. Pakistan Stock Exchange.
Thank you for showing interest in our template.
Currently, all tickets symbols are not yet available in Microsoft stock data base. We use Microsoft Stock Data type in Excel to get the stock data. I tested some PSX ticker symbols taken from google but I am unable to get the data from the Microsoft Stock database.
Best wishes.
Hello Indzara, Do you know how to calculate RSI using RMA instead SMA?. Because Tradingview, Coinmarketcap, Binance, etc. use RMA to make this kind of calculation. Thanks in advance by any reply.
Thanks for your message. I use the SMA only for the first day. After that I am using RMA. My numbers matched with Tradingview. Please share details if you see otherwise.
Thanks & Best wishes.
I use an alternative software for excel which is Kingsoft's WPS Office. Do you know I could use your macro with Kingsoft's WPS Office?
Thank you, Elliot
We do not use Macro in any of our template to ensure the template is easy for the customer's to use and edit if they require. We have also not tested our template with WPS office.
Best wishes.
How to make the RSI in terms of Indian stock market, please give me a detailed steps in the commet
Thank you for showing interest in our template.
You can change the ticker symbol in cell B2 to view the required Indian Stock ticker symbol.
Best wishes.
I have downloaded the template and key in the stock, but it shows that the value in the row of the specific day in the help sheet showing N/A. Please kindly advise how to solve it?
Thank you for showing interest in our template.
Currently, the template works only with Microsoft Excel 365 subscription. If you have Microsoft Excel 365 subscription ans till unable to use the template, requesting to share the sheet to support@indzara.com along with the screenshot of the issue to check further.
Best wishes.
I don't think your template (RSI) I have checked so far works for penny stock. Just tried this symbol on your excel and it is not showing correct RSI
Else Nutrition Holdings Inc. (XTSE:BABY)
Please share some sample data at the below link with some screenshots highlighting the difference to check further.
support.indzara.com/support/tickets/new
Best wishes.
RSI calculated values are not matching with Trading view
We have build the template with reference from the Trading View.
Please share some sample data showing the difference at the below link to check further:
support.indzara.com/support/tickets/new
Best wishes.
Sir how to calculate weekly and monthly RSI in Google Sheets for NSE
Thank you for reaching out to us.
The concept of how to calculate the RSI is available in our Excel template on the sheet named Concept. You can download the Excel template from the below link:
indzara.com/free-excel-template-for-rsi-technical-indicator/
To get the google finance data, you will need to use Google Finance function in Google Sheets as shown below:
=GOOGLEFINANCE("NASDAQ:TSLA","all","01-Jan-2024",21)
Then you can apply the concept shown in the Excel sheet on Google Sheets. Note: The concept is defined for 14 days, instead, you will need to use 5 days for a week and 22 or 21 days for a month.
Best wishes.
@@indzara thanks sir , I got through with Weekly data but can you please make monthly RSI calculation video for NSE STOCKS .
We are glad that you got the weekly interval RSI. Since Monthly interval is not available in Google Finance, you will need to calculate the Open, Close, Low and High for the monthly data.
For dates you can use the below function to get months:
=ARRAYFORMULA(DATE(2023,SEQUENCE(24),1))
The above formula returns 24 months. You can change the year and number of months required.
To get the close value from the daily/weekly finance data, you can use the below formula:
=IFERROR(INDEX(F:F,ARRAYFORMULA(SMALL(IF(($B:$B>=I6)*(B:B
@@indzara thanks a lot sir for ur help, will try it out , new to this formulas etc ,but will try out,thanks a lot again sir.
You are welcome.
Sure, try out the above mentioned formulas and let us know your feedback. If you are facing any issues, please do reach out to us at the below link to assist further:
support.indzara.com/support/tickets/new
Best wishes.
I just installed free template from your website, changed stock symbol to GDNP.V (good natured Products Inc. (XTSX:GDNP)), I don't think your template is giving correct RSI..
Please share some sample data at the below link with some screenshots highlighting the difference to check further.
support.indzara.com/support/tickets/new
Best wishes.
Sir can you send excel with formula
I can pay you
Plssss
Thank you for showing interest in our template.
You can download the Excel template for free of cost from the below link:
indzara.com/free-excel-template-for-rsi-technical-indicator/
We also take customization projects for a fee. You can write to us at the below link for free estimation:
support.indzara.com/support/tickets/new
Best wishes.
Sir how to connect you
Thank you for reaching out to us.
You can write to us at the below link and we will get back to you within 1 business days:
support.indzara.com/support/tickets/new
Best wishes.
sir ur sheet not fetch the present day data ,in stock watch how to fix it
Thank you for showing interest in our template.
Requesting to refresh the data by clicking Data ribbon -> Refresh all to get the updated stock data.
Best wishes.
@@indzara done but shows same ,thank for your reply
@@sevaantivi8163 I am unable to replicate the issue in my end.
The template requires Excel 365 version and if you have Excel 365 version and still facing the issue, requesting to share your copy of the template to support@indzara.com to check further.
Best wishes.