2023 US Stock Market Tracker in Excel – LIVE Updates

You can use this template to track the U.S. Stock market performance.

US Stock Market Tracker template


Video Demo

Template features

This template can be used to view the U.S. stock market performance.

The foundation of this template is the Stocks Data type and StockHistory function.


Three of the most used indices are DOW 30, S&P500 and NASDAQ 100, in the US stock market.

Dashboard shows the indices’ current price, change in price and change %.

US Stock Market Indices

You can also see that of the 529 stocks that make up the indices, how many gained in price and how many declined in price. In the above screenshot, 474 gained and 55 declined.

On the top right you can see the maximum of the last trade time of all 529 stocks.

UTC Offset time

The default time that Microsoft provides is UTC, we convert that to pacific time via the offset of -7 hours. If you are in a different time zone, please enter the corresponding offset.

Visit to view offset

Top Gainers in U.S. Market

The dashboard shows the Top gainers of the day.

Top Gainers – Stocks that gained on 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 Gainers

Top Decliners in U.S. Market

The dashboard also shows the top decliners of the day.

Top 10 Decliners

You can see more details of these stocks and also top 20 stocks that declined in price, in the DECLINERS sheet.

Top 20 Decliners

Top Active Stocks in U.S. Market

Finally, the dashboard also shows the top 10 stocks that are active (by trading volume) on the day.

Top 10 Actively traded Stocks

To see top 20 stocks that were active and also see more details such as 52 week price range, please see the ACTIVES sheet.

Top 20 Actively traded Stocks

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.

Refresh stocks data

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.


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


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.

Related Templates

Exit mobile version