Google Finance does not work natively in Excel. The GOOGLEFINANCE function is built for Google Sheets, not Microsoft Excel.

To get stock data in Excel, users need alternatives such as Excel’s Stocks data type, the STOCKHISTORY function, Power Query, APIs, or an Excel add-in like Wisesheets.

This guide explains the best ways to get Google Finance-style stock data in Excel, including live prices, historical prices, financial metrics, dividends, and portfolio tracking.

Can You Use Google Finance in Excel?

No, you cannot use Google Finance directly in Excel.

The GOOGLEFINANCE function only works in Google Sheets. It is not available as a native Microsoft Excel formula, so you cannot enter a formula like =GOOGLEFINANCE("AAPL","price") in Excel and expect it to work.

For a deeper breakdown of how the formula works in Sheets, read our guide to the GOOGLEFINANCE function.

That said, Excel users still have several ways to pull stock data into their spreadsheets. Depending on what you need, you can use Excel’s Stocks data type, the STOCKHISTORY function, Power Query, stock market APIs, or an Excel add-in like Wisesheets.

Here’s the quick answer:

Question	Answer
Does GOOGLEFINANCE work in Excel?	No. It only works in Google Sheets.
Can Excel pull stock prices?	Yes, through Stocks data type, STOCKHISTORY, APIs, Power Query, or add-ins.
Best built-in Excel option?	STOCKHISTORY for historical prices.
Best no-code alternative?	Wisesheets for live prices, financials, dividends, and metrics.

So if you are trying to recreate a Google Finance-style workflow in Excel, the best option depends on the type of stock data you want. For simple stock tracking, Excel’s built-in tools may be enough. For historical price analysis, STOCKHISTORY is useful.

But if you want live prices, financial statements, key metrics, dividends, and portfolio data in one place, an add-in like Wisesheets gives you a more complete setup inside Excel.

Why Google Finance Does Not Work in Excel

Google Finance does not work in Excel because the GOOGLEFINANCE function is built specifically for Google Sheets. It is part of Google’s spreadsheet ecosystem.

If you still use Sheets for some stock tracking workflows, our guide to Google Finance in Google Sheets explains how the function works there.

That means Excel cannot run formulas like =GOOGLEFINANCE("AAPL","price") natively. If you enter that formula in Excel, it will not pull stock data the way it does in Google Sheets.

Microsoft Excel does have its own stock data features, such as the Stocks data type and the STOCKHISTORY function. However, these are Excel-specific tools instead of direct versions of Google Finance.

So the issue is not that Excel cannot work with stock data at all – it can. However, it does not support the actual GOOGLEFINANCE formula, which is why users need a different method to bring stock prices, historical data, and financial information into their spreadsheets.

Best Google Finance Alternatives for Excel

Google Finance is not available in Excel, but Excel users still have several ways to pull stock data into their spreadsheets. The right option depends on whether you need simple stock prices, historical prices, financial statements, dividends, or a more complete investment research setup.

Method	Works in Excel?	Live Prices	Historical Data	Fundamentals	Best For
GOOGLEFINANCE	No	Yes, in Sheets	Limited	Limited	Google Sheets users
Excel Stocks Data Type	Yes	Yes	Limited	Limited	Basic stock tracking
STOCKHISTORY	Yes	No live prices	Yes	No	Historical price analysis
Power Query	Yes	Depends on source	Yes	Depends on source	Custom data imports
APIs	Yes	Yes	Yes	Depends on provider	Developers and technical users
Wisesheets	Yes	Yes	Yes	Yes	Investors using Excel

Excel’s Stocks data type may suffice for basic stock tracking. For historical price analysis, STOCKHISTORY is a useful built-in option. If you're seeking a more technical workflow, Power Query and APIs can help import stock data from external sources.

But if you want a no-code way to pull live prices, historical data, financial statements, key metrics, and dividends into Excel, Wisesheets is the most complete option on this list.

Google Finance Formula Equivalents in Excel

Excel does not have a perfect one-to-one replacement for the GOOGLEFINANCE function. You cannot simply copy a Google Sheets formula into Excel and expect it to work.

However, you can recreate many common Google Finance workflows in Excel using built-in Excel tools or an add-in like Wisesheets. The best replacement depends on the type of stock data you want to pull.

For users looking specifically for a formula-based workflow, our guide to the Excel stock quote formula covers more ways to bring quote data into Excel.

Below are a few common Google Finance formula equivalents for Excel:

Goal	Google Sheets Formula	Best Excel Replacement
Live price	=GOOGLEFINANCE("AAPL","price")	=WISEPRICE("AAPL","Price") using Wisesheets
Historical price	=GOOGLEFINANCE("AAPL","close",DATE(2024,1,1),TODAY())	=STOCKHISTORY("AAPL",DATE(2024,1,1),TODAY()) using Excel
Financial metrics	Limited	=WISE("AAPL","PE Ratio",2024) using Wisesheets
Dividends	Limited/manual	=WISE("AAPL","Dividend","LQ") using Wisesheets

For basic historical prices, Excel’s STOCKHISTORY function can be a good built-in option. But if you need live prices, financial metrics, dividends, and deeper stock analysis, Wisesheets gives you formulas that work directly in Excel.

Try Wisesheets to bring live prices, financials, dividends, and key metrics into Excel without copy-pasting data from multiple websites.

Option 1: Use Excel’s Stocks Data Type

One built-in way to get stock data in Excel is to use the Stocks data type. This feature lets you convert company names or ticker symbols into linked stock data that Excel can recognize.

For example, you can enter a ticker like Apple or Microsoft, convert it into the Stocks data type, and then add fields such as price, market cap, exchange, previous close, and other basic company information.

This can be useful if you want to create a simple watchlist or portfolio tracker without installing an add-in or connecting to an external API. It works well for basic stock tracking, especially if you only need high-level market data inside your spreadsheet.

However, the Stocks data type is not the same as Google Finance, nor is it as flexible as formula-based tools. If you want to pull detailed financial statements, advanced metrics, dividend data, or build more customized stock analysis models, you may need another option.

Option 2: Use the STOCKHISTORY Function

The STOCKHISTORY function is one of the best options if you want a built-in Excel formula for historical stock prices.

STOCKHISTORY lets you pull historical price data directly into Excel for a specific stock, date range, and interval. You can use it to get daily, weekly, or monthly price history, depending on how you want to analyze the data.

For example, this formula pulls Apple’s historical stock prices from January 1, 2024, to today:

=STOCKHISTORY("AAPL",DATE(2024,1,1),TODAY())

This can be useful for building charts, analyzing price trends, calculating returns, or comparing how different stocks performed over time.

For a full walkthrough, read our guide on how to use the STOCKHISTORY function in Excel.

However, STOCKHISTORY is not a complete replacement for Google Finance, since it is mainly useful just for historical price data. If you need live prices, financial statements, key metrics, dividends, or more detailed company analysis, you will need another method alongside it.

Option 3: Use Wisesheets for Live Prices, Financials, and Dividends

If you want more than basic stock data in Excel, Wisesheets is one of the most complete no-code alternatives to Google Finance.

Wisesheets works directly inside Excel and Google Sheets, so you can pull stock data into the spreadsheet you already use. Instead of copying numbers from Google Finance, Yahoo Finance, financial statements, or other websites, you can use Wisesheets formulas to bring the data directly into your workbook.

For example, you can pull Apple’s latest stock price with:

=WISEPRICE("AAPL","Price")

You can also pull financial metrics, such as Apple’s P/E ratio:

=WISE("AAPL","PE Ratio",2024)

Or dividend data, such as the latest quarterly dividend:

=WISE("AAPL","Dividend","LQ")

This makes Wisesheets useful for building stock screeners, portfolio trackers, dividend trackers, financial models, and custom investment research spreadsheets. You can pull live prices, historical prices, financial statements, key metrics, and dividends without switching between multiple websites.

If you want more than basic stock prices, try Wisesheets to bring live prices, financial statements, key metrics, dividends, and historical data directly into Excel.

Option 4: Use Power Query or Stock Market APIs

If you want more control over how stock data enters your spreadsheet, you can use Power Query or stock market APIs.

Power Query lets you import data into Excel from web pages, files, databases, and other external sources. With a reliable data source, you can use it to bring stock information into your workbook and refresh it when needed.

Stock market APIs can also provide live prices, historical prices, and other market data, though they usually require more setup. You may need an API key, some technical knowledge, and a process for cleaning or organizing the imported data inside Excel.

If you want to compare API-based routes, our guide to Google Finance API alternatives covers both code and no-code options.

These methods can work well for developers, analysts, or advanced Excel users who want a custom workflow. But for non-technical users, a built-in Excel function like STOCKHISTORY or an Excel add-in like Wisesheets may be easier to use and maintain.

Which Google Finance Alternative Should You Use?

The best Google Finance alternative for Excel depends on what you are trying to achieve. Some users only need basic stock prices, while others need historical prices, dividends, financial statements, or a more complete stock analysis workflow.

Use Case	Best Option
Basic stock prices in Excel	Excel Stocks data type
Historical price analysis	STOCKHISTORY
Live prices plus fundamentals	Wisesheets
Dividend tracking	Wisesheets
Full financial statements	Wisesheets
Custom developer workflow	APIs
Importing web data into Excel	Power Query
Google Sheets workflow	GOOGLEFINANCE

For the majority of Excel users, the choice will come down to STOCKHISTORY, Wisesheets, or a mix of both. STOCKHISTORY works well if you mainly need historical price data, while Wisesheets is better if you want live prices, financial metrics, dividends, and financial statements in the same spreadsheet.

If you are comfortable working with APIs or Power Query, you can also build a more custom setup. But a built-in Excel tool or a spreadsheet add-in will usually be the easier option for most investors who want to work directly inside Excel without too much setup.

How to Build a Google Finance-Style Stock Tracker in Excel

Once you have chosen your Excel stock data tools, you can build a simple Google Finance-style stock tracker inside your spreadsheet.

Start by creating a table with the stocks you want to track. Add one ticker per row, such as AAPL, MSFT, TSLA, or any other company in your portfolio or watchlist.

Then add columns for the main data points you want to monitor. A basic tracker might include:

Column	What It Tracks
Ticker	Stock symbol
Company Name	Name of the company
Current Price	Latest stock price
Historical Price	Past stock price for a selected date or period
P/E Ratio	Valuation metric
Dividend	Latest dividend data
Shares Owned	Number of shares in your portfolio
Portfolio Value	Current price multiplied by shares owned

You can use STOCKHISTORY to pull historical stock prices into Excel. For example, you can use it to track how a stock performed over a specific date range or create price charts over time.

For live prices, financial metrics, dividends, and financial statement data, you can use Wisesheets formulas such as WISEPRICE and WISE. This lets you add more detailed investment data to the same spreadsheet without copy-pasting from multiple websites.

Once the data is in place, calculate your portfolio value by multiplying the current price by the number of shares you own. From there, you can track performance over time, compare stocks, review dividend income, or build a more detailed investment dashboard.

You can also follow our full guide to build a stock portfolio tracker in Excel if you want a more detailed setup.

Frequently Asked Questions (FAQs) About Google Finance in Excel

Can I use GOOGLEFINANCE in Excel?

No. GOOGLEFINANCE only works in Google Sheets. Excel does not support the formula natively.

What is the Excel equivalent of GOOGLEFINANCE?

There is no exact built-in equivalent of GOOGLEFINANCE in Excel. Depending on the data you need, you can use Excel’s Stocks data type, the STOCKHISTORY function, Power Query, APIs, or an add-in like Wisesheets.

Can Excel pull live stock prices?

Yes. Excel can pull live stock prices through the Stocks data type, Power Query, APIs, or add-ins like Wisesheets. The best option depends on how much data you need and how much setup you are comfortable with.

Is STOCKHISTORY the same as GOOGLEFINANCE?

No. STOCKHISTORY is not the same as GOOGLEFINANCE. STOCKHISTORY is an Excel function mainly used for historical price data, while GOOGLEFINANCE is a Google Sheets function used for stock and securities data inside Google Sheets.

What is the best Google Finance alternative for Excel?

The best alternative depends on your use case. For historical prices, STOCKHISTORY is a good built-in Excel option. For live prices, financial metrics, dividends, financial statements, and stock analysis workflows, Wisesheets is a more complete option.

Can I use Wisesheets instead of Google Finance?

Yes. Wisesheets can be used as a Google Finance alternative for Excel and Google Sheets. It lets you pull stock prices, financial statements, key metrics, dividends, and historical data directly into your spreadsheet.

Final Verdict: The Best Way to Get Google Finance-Style Data in Excel

Google Finance does not work natively in Excel, but that does not mean Excel users are stuck without stock data.

If you only need basic stock information, Excel’s Stocks data type can help you create a simple watchlist or portfolio tracker. If you need historical prices, the STOCKHISTORY function is a useful built-in option. For more technical workflows, Power Query and stock market APIs can also bring external data into Excel, although they require more setup and maintenance.

But if you want a more complete Google Finance-style workflow inside Excel, Wisesheets is the better option. It lets you pull live prices, historical prices, financial statements, key metrics, and dividends directly into your spreadsheet.

Start using Wisesheets to build a complete stock tracker in Excel without copy-pasting data from Google Finance, Yahoo Finance, or multiple financial websites.