Excel for Stock Market – Day 04
Build your own #candlestick charts in Excel for stock market. Type in a ticker symbol to view instantly the price history in a candlestick chart. View customizable time periods (3 mths, 6 mths, 1 year, 5 years) and customizable intervals (daily, weekly, monthly).
Link to download this template (for free) from #indzara
0:00 Introduction
0:59 How to use this template?
3:13 The Concept of Candlestick
7:51 Formulas used
Other videos in this series:
STOCK LOOKUP –
STOCK PRICE CHART –
FOREX CURRENCY CHART –
CANDLESTICK CHART –
STOCKS WATCH LIST –
US STOCK MARKET TRACKER –
INDIA STOCK MARKET TRACKER –
LONDON STOCK EXCHANGE TRACKER –
FOREX MARKET TRACKER –
SIMPLE MOVING AVERAGE –
WEIGHTED MOVING AVERAGE –
EXPONENTIAL MOVING AVERAGE –
EXPONENTIAL MOVING AVERAGE CROSSOVER –
MOVING AVERAGE ENVELOPE –
BOLLINGER BANDS –
DONCHIAN CHANNELS –
MOMENTUM AND RATE OF CHANGE –
AWESOME OSCILLATOR –
MACD –
RSI –
ATR –
WILLIAMS %R –
STOCHASTIC INDICATOR –
ON BALANCE VOLUME INDICATOR –
KELTNER CHANNELS INDICATOR –
US MARKET INDUSTRY ANALYZER –
INDIA MARKET INDUSTRY ANALYZER –
TWO STOCKS COMPARISON –
US MARKET STOCK SCREENER –
STOCK PORTFOLIO TRACKER –
All the templates in this series will be available for you to download on indzara.com. Please visit
The Excel for Stock Market Playlist Link
Microsoft 365 Subscription Plans for PC and Web:
Excel for the web:
#excelforStockMarket #excel #stockmarket
Will this work for indian stocks
Yes, it should. Please test and let me know your experience.
Thanks for your support.
Best wishes.
@Indzara Excel Templates ok will check. On the currency video not sure how you look at it but normally the number required is decimal plus 4 digits after the decimal. I see only 2 digits after the decimal. Maybe you can make it a standard in the sheet.
Study
Bullish Sandwich
Bullish Equal low
Bearish EQUAL HIGH
VERY COMMON IN NIFTY
Thanks for your suggestion.
We will look into it.
This is a masterpiece, is there any way to pull in the Indian dataset to this template? That would help me a lot!
Thank you for showing interest in our template.
Yes, you can change the ticker symbol in cell B2 to check the Candlestick Chart for the required Indian stock.
Best wishes.
Great template sir. Cant thank you enough. Have a nice day sir
Thank you for sharing your valuable feedback and you are welcome.
Best wishes.
Cannot change the time offset sir. Think cell is protected
You can unprotect the sheet using the password indzara.
Best wishes.
I tried and test the template exactly by typing the XNAS:MSFT . However no data was pulled out. Any help what could go wrong? Appreciate so much this template.
Thank you for showing interest in our template.
I have double checked and I am able to enter the ticker symbol XNAS:MSFT. Hence, requesting to double confirm whether you have installed Excel version is 365 subscription.
If you have Excel 365 subscription installed and still you are unable to get the stock data, requesting to share some screenshot of your Excel version and your concern to support@indzara.com to check further.
Best wishes.
Loving your videos, helping a lot. Can you help me to know if I want to create buttons and can display the chart based on selection, like candlestick chart, MAC-D, and so on based on selection
Thank you for showing interest in our template.
If you want to change a chart type by clicking a button? This can be done using Macros. We take customization project for a fee. Requesting to share your requirement to support@indzara.com for estimation.
Best wishes.
I can’t change the chart type to candlestick. Please help.
Requesting to share your sheet with some screenshot highlighting your concern to support@indzara.com to check further.
Best wishes.