How to Get Real-Time Stock Data in Excel

Manually updating your stock portfolio in a spreadsheet can feel like a chore you never get to the bottom of. You look up a ticker, type in the price, and by the time you've finished the third one, the first one is already out of date. This guide will show you how to pull live and near real-time stock data directly into Excel, transforming your static tracker into a dynamic financial dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Easiest Method: Excel's Built-In 'Stocks' Data Type

If you have a Microsoft 365 subscription, the simplest way to get stock data is by using a feature called 'Stocks'. This powerful tool converts a simple piece of text - like a ticker symbol or a company name - into a data-rich entity connected to a massive online database.

Think of it as adding a "smart" layer to your text. Instead of just seeing "AAPL," Excel recognizes it as Apple Inc. and can instantly pull related financial information.

How to Use the Stocks Data Type

Getting started is incredibly straightforward. Here's how to do it in four easy steps:

1. Create Your List: In a column, type the ticker symbols, company names, or fund names you want to track. For best results, use the official ticker symbol (e.g., GOOG, TSLA, AMZN, NFLX).
2. Select Your Data: Highlight the cells containing your list of stocks.
3. Convert to Stocks Data Type: Go to the Data tab on the Excel ribbon. In the 'Data Types' section, click on Stocks.
4. Add Your Info: Excel will automatically convert your text. You'll see a small 'building' icon next to each one, confirming the connection. Now, with your cells still selected, a small button with a plus sign will appear. Click it to open a dropdown menu of all the available data fields you can add, such as 'Price', 'Change', 'Market Cap', '52-week high', and dozens more. Simply click on a field to add it as a new column.

You can keep adding as many data points as you need. This method is incredibly fast for building a watchlist or a basic portfolio summary without any complex formulas.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What to Know About Excel's Stock Data Refresh Rate

While the 'Stocks' data type is a fantastic feature, it's important to understand its main limitation: the data is not truly real-time. The prices you see are typically delayed, often by 15-20 minutes, depending on the stock exchange. Refinitiv provides the data, and delays are standard for free services to comply with exchange rules.

To refresh the data, you can go to the Data tab and click Refresh All. This will pull the latest available information for all your connected data types.

For most personal investors and trackers, this slight delay is perfectly fine. However, if you're a day trader or require millisecond-level accuracy, this built-in feature won't replace a dedicated trading terminal.

• Pro: Extremely easy to use, no formulas required.
• Pro: Access to a wide range of fundamental data (P/E ratio, market cap, etc.).
• Con: Requires a Microsoft 365 subscription.
• Con: Data is delayed, not truly real-time.

For More Control: Using Power Query to Get Web Data

If you need more advanced data, want to pull from a specific web source, or don't have a Microsoft 365 subscription, Power Query is your best friend. Power Query (also known as 'Get & Transform Data') is Excel's engine for connecting to, cleaning, and shaping data from a huge variety of sources, including websites.

You can use it to pull stock information directly from financial websites like Yahoo Finance. Let's walk through an example of grabbing the current market price for a specific stock.

Step-by-Step with Power Query

1. Find Your Data Source URL: Head over to a financial website like Yahoo Finance and search for the stock you want. For this example, let's find the page for Apple (AAPL). Copy the full URL from your browser's address bar.
2. Open the 'From Web' Connector: In Excel, go to the Data tab. In the 'Get & Transform Data' group, click From Web.
3. Enter the URL: A dialog box will appear. Paste the URL you copied into the box and click OK.
4. Select the Data Table: The Navigator window will open. Power Query analyzes the webpage and presents you with a list of all the HTML tables it found. Click through the tables on the left pane until you find the one containing the data you need (like the summary table with the stock price, previous close, and other metrics). Select it and click Load.

Excel will place the data from the website directly into a new worksheet as a formatted table. The best part? This connection is live. You can refresh it at any time to pull the most current data from the webpage.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Set Up Automatic Data Refresh

Manually clicking "Refresh" is fine, but you can also automate it. To make your data update on a timer:

1. Right-click anywhere within the data table Power Query created.
2. Navigate to Table > Edit Query or simply find the query in the 'Queries & Connections' pane, right-click it, and choose Properties.
3. In the 'Query Properties' dialog box, find the 'Refresh control' section.
4. Check the box for Refresh every and set your desired interval in minutes (the minimum allowed here is usually 1 minute).
5. Click OK.

Now, Excel will automatically refresh your connection at the interval you chose, making your sheet a nearly-real-time dashboard.

The Pro Option: Dedicated Financial Data Add-Ins

For financial professionals, serious traders, or analysts who need robust, real-time data within Excel, the ultimate solution is often a third-party add-in. These are specialized tools built by financial data companies that plug directly into Excel.

Popular options include:

• MarketXLS: A widely used add-in specifically for stock market data, offering templates for tracking, options analysis, and more.
• Refinitiv Workspace / Eikon: The successor to the famous Thomson Reuters Eikon terminal, it provides a comprehensive Excel add-in for deep financial analysis, often used in corporate finance settings.
• YCharts Excel Add-in: Excellent for creating compelling charts and comparing securities based on thousands of different metrics.

These tools often come with a subscription fee but offer true real-time streaming data, historical data sets spanning decades, and powerful proprietary functions, far exceeding what's available through Excel's native features.

Putting It All Together: Build a Simple Portfolio Tracker

Let's use the 'Stocks' data type to create a simple, dynamic portfolio tracker from scratch.

Step 1: Set Up Your Holdings Table

Create a small table with your core investment details. This is the information you'll input manually. Include columns for:

• Ticker: The stock symbol.
• Shares Owned: The number of shares you hold.
• Purchase Price: The average price you paid per share.

Step 2: Pull in Live Data

First, convert your range into an official Excel Table by pressing Ctrl + T. Then, select the 'Ticker' column and convert it using the Data > Stocks feature as described earlier.

Now, add smart columns using the 'Add Column' icon:

• Company Name: Just to see the full name.
• Price: This will be the current (delayed) market price.
• Change: The dollar change from the previous day's close.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Add Your Own Calculated Columns

This is where you bring it all together. Since you created an Excel Table, you can add formulas that automatically apply to the entire column. Add the following columns:

• Market Value: =[Shares Owned]*[Price]
• Cost Basis: =[Shares Owned]*[Purchase Price]
• Total P/L ($): =[Market Value]-[Cost Basis]

And just like that, you have a self-calculating tracker. Every time you hit 'Refresh All,' the price, market value, and total profit/loss will update automatically.

Final Thoughts

By using Excel's built-in Stocks data type, tapping into Power Query for web data, or leveraging third-party add-ins, you can turn a basic spreadsheet into a powerful and dynamic financial tracking tool. You've moved beyond static data entry into a world of live reports that help you make more informed decisions about your investments.

The challenge with Excel often comes from the manual setup and wrestling with different data formats, especially when you want to combine data from multiple places. What if you wanted to see how your portfolio correlates with your company's sales data from Shopify or your marketing spend on Facebook Ads? That's when you typically hit a wall, reverting to time-consuming manual exports. This is exactly why we built Graphed. We automate the complexities of connecting data sources so you can get insights using simple language. Instead of building web queries or dealing with table properties, you can ask, "Build me a dashboard showing my Shopify revenue next to my portfolio value this month." We handle the direct connections to your platforms to give you automated, live dashboards and answers in seconds, not hours.