2024 India Stock Market Tracker in Excel – LIVE Updates
You can use this template to track the Indian Stock market performance.
Requirements
Microsoft has introduced a new feature in Excel called Data types. One of the data types is ‘Stocks’. That’s what we will be using for these templates. This feature is available in Microsoft 365 Subscription Plans for PC and Web
For all the templates in this ‘Excel for Stock Market’ series, please visit indzara.com/stock-market-templates
Download
Video Demo
Template features
This template can be used to view the India. stock market performance.
- Automatically shows the major indices – NIFTY 50 and SENSEX
- 1648 stocks are tracked for performance – 18 are currently not available
- New stocks can be added easily
- View the top gainers (stocks which increased in price, ranked by Change %)
- View the top decliners (stocks which decreased in price, ranked by Change %)
- View the most actives (stocks which traded most in volume, ranked by Volume)
- See more details on the top gainers, top decliners and most actives
The foundation of this template is the Stocks Data type and StockHistory function.
Indices
Two of the most used indices in the Indian stock market are NIFTY 50 and SENSEX.
Dashboard shows the indices’ current price, change in price and change %.
You can also see that of the 1690 stocks that make up the indices, how many gained in price and how many declined in price.
In the above screenshot, 917 gained and 676 declined. 18 stocks are not mapped.
On the top right you can see the maximum of the last trade time of all the stocks.
The default time that Microsoft provides is UTC, we convert that to Indian Standard Time via the offset of 5.5 hours.
Visit https://savvytime.com/converter/utc to view offset
Top Gainers
The dashboard shows the Top gainers of the day.
In the Gainers sheet, you can see more details about the top gainers. You can also see top 20 stocks that gained.
Top Decliners
The dashboard also shows the top decliners of the day.
You can see more details of these stocks and also top 20 stocks that declined in price, in the DECLINERS sheet.
Top Active Stocks
Finally, the dashboard also shows the top 10 stocks that are active (by trading volume) on the day.
To see top 20 stocks that were active and also see more details such as 52 week price range, please see the ACTIVES sheet.
Please read more on Stocks Data Type.
Please read more on StockHistory function and how we use to extract the price history of a stock or currency.
Here is the link to the article from Microsoft which shows which exchanges are available and the delay in data refresh for each.
How to refresh?
To refresh the price and other information, just use the regular Excel refresh in the Data ribbon.
How to add more stocks?
Please unhide the hidden DATA sheet and add stock symbols to that table. They will automatically be added for tracking in the dashboard.
-
Simple Moving Average Stock Screener Google Sheet Template$25 -
Stock Screener Excel Template$97
-
Simple Moving Average Stock Screener Excel Template$25
-
Product on saleTechnical Analysis Pro Excel Template (25 Technical Indicators)Original price was: $97.$67Current price is: $67.
Feedback
Please share your experience. I expect this to be different with different exchanges and countries. Is it working for you? Is it working differently? I would love to hear from you.
17 Comments
I want to add another stocks in actives sheets and but i dono that datas is fatching from NSE or some other plateform please help me out if not from NSE then how to fatch from NSE
Thank you for showing interest in our template.
We use Microsoft stock datatype to get stock data from Microsoft server. To add another stock ticker symbol or remove unwanted ticker symbols, please follow below steps:
1. Right-click any sheet name (For example: Sheet name ACTIVES)
2. Select Unhide
3. Select DATA sheet and click Unhide.
In DATA sheet you can add new ticker symbols or remove unwanted ticker symbols as per your requirement.
Best wishes.
Great post! I’m really interested in keeping track of the India stock market, and this Excel tracker looks like a fantastic tool to help me do just that. I love how easy it is to use and how it provides real-time updates. Can’t wait to try it out!
Thank you for showing interest in our template and sharing your valuable feedback.
Best wishes.
Can I use this template for live intra day trading?
How to get live stock prices with out any time delay (if I do not want to use Microsoft feed) – your recommendation
In other words I want to use your template for live intra-day trading with out using microsoft equity price feed
Pl let me know if it is possible
If it is possible may be i can pay for that program
Thank you for showing interest in our template.
Currently, we take data from Microsoft server using Stock Data type in Microsoft Excel 365. The intra day trading is not yet available in Microsoft stock datatype.
We take customization projects for a fee. If you have a source to get data and its credentials to connect to the source, then we can use power query to pull the data from the preferred source make the template to update the dashboard from your source. Please write to us at the below link with the source details for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
I am unable to fetch the help sheet and data sheet. how to fetch those sheets?
Thank you for showing interest in our template.
You need to right-click any of the sheet name at the bottom of the template and select unhide to unhide the data and help sheet.
Best wishes.
this sheet is protected so couldnot add more stocks, kinldy let me know the password to personalise the sheet and more lines in gainers
Thank you for showing interest in our template.
The password to unprotect the sheet is indzara.
Best wishes.
Data not getting refreshed even after pressing refresh all multiple times. Please help
can we fetch the top 20 gainers and losers from file
Thank you for showing interest in our template.
Yes, the template will provide you top 20 gainers and decliners.
Best wishes.
I am unable to use this file n Indian Stock MArket Tracker.
1) Do I first need to link with any website? If yes, how to do that?
Thanks for using the template.
Please let us know if you are using it in Excel online (free) or the Microsoft 365 subscription plan. If so, it should work.
thanks & best wishes.
Hi trying this template on Excel Online, Couldn’t see the stock data Tab . How to unhide that
Following are the steps to unhide the data tab:
1. Right-click any of the tab name and select unhide.
2. Select Data and click Ok.
Best wishes.