Excel Google Finance: Best Ways To Get Stock Data - Wisesheets Blog (2024)

If you want to get data in Excel like Google Finance, then we are here to guide you step by step. We will also provide some helpful tips on how to use this data to make informed investment decisions.

Is Google Finance Available in Excel?

Unfortunately, Google Finance is not available in Excel. However, you can use different alternatives to get the same data available through other methods explained in this guide.

The Best Ways to Get Data in Excel

One way to get data in Excel is to use a third-party service such as Yahoo Finance or Bloomberg. With them, you copy-paste the data. Another way is to use an API (Application Programming Interface) to get the data directly from a data provider. However, the best way by far is to combine the built-in Excel Stocks function and Wisesheets to get all the stock data you need without coding or wasting time copy-pasting the data.

Historical Stock Data in Excel

There are different types of data you can get in Excel. Here are the best ways to get stock data for each type.

Historical financials and key metrics (Wisesheets)

There are two ways to access historical financials and key metrics using Wisesheets. The first is to go to 'Financials' in Wisesheets, enter the ticker (e.g. NFLX), select Annual data or Quarter data, and then click on 'Get Data'.

You will then see the income statement, balance sheet, cash flow statement, key metrics, and growth metrics in different tabs of your Excel spreadsheet going back up to 19 years.

If you are looking to get only specific line items from the statement dump output, you can simply enter them in the WISE function and get them instantly.

The syntax of the function is simple:

=WISE(ticker, parameter/s, period, [quarter]).

As you can see, all you have to do is enter the ticker, the parameter/s you want to get, like "revenue", the period like 2023, "LY" (latest fiscal year), "LQ" (latest fiscal quarter), and quarter (only if you are looking for quarterly data).

Historical stock price data (STOCKHISTORY function)

If you want to get historical stock data in Excel, the best method is to use the built-in STOCKHISTORY function. The function syntax works as follows: =STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5]).

The function arguments definition can be seen here:

The list of properties available includes:

Altogether to get Apple's close stock price ending on January 1st, 2023, until January 30th, 2023, you would need to enter the following command.

=STOCKHISTORY(“AAPL”, "01/01/2023", "01/30/2023",0,1,0,1).

Historical revenue breakdowns (Wisesheets)

Using the WISE function, you can also access historical revenue breakdown based on revenue segments and geographic segments.

For example, to get Apple's segment revenue breakdown from 2021 until 2023. All you need to do is enter the following function call:

=WISE("aapl", "segment revenues", {2023, 2022, 2021})

You can do the same for geographic segments. The only difference is that you need to substitute "segment revenues" for "geographic revenues."

If you want to access this data every quarter, you must enter "LQ" (latest fiscal quarter), "LQ-1" (previous fiscal quarter), "LQ-2", etc., as the function's period.

Historical dividend stock data (Wisesheets)

There are two ways to access historical stock and ETF dividend data in Excel. The first is to use the WISE function. We just discussed it above.

The function has to look like this:

=WISE("ticker", "dividend", period).

The key thing to remember is that you can only enter "LQ" and a range of LQ values as the period/s. So, for example, if you only enter "LQ" as the period, this will return the latest quarterly dividend paid by the company. However, if you enter something like:

=SUM(WISE("aapl", "dividend", {"lq", "lq-1", "lq-2", "lq-3}"))

This will return the sum of the last 4 dividend payments made by the company or ETF.

The second way to get historical dividend payment data is quite simple. Using the WISEPRICE function, all you have to do is enter something like =WISEPRICE("ticker", "dividend").

Real-time stock data in Excel

The three best ways of getting real-time stock data in your Excel spreadsheet are to use Excel stocks, and Wisesheets or combine the two of them together.

Excel stock tables

To access real-time stock data in Excel, start by creating a table that lists the stocks you're interested in. Once you have your list, go to the Data tab in the Excel ribbon. Select your stock list, and then click on the "Stocks" button to fetch the real-time data.

Within a few seconds Excel will recognize if these are valid symbols and mark them by the stock icon. From here, a floating table with a plus button will become visible for you to click on and select the data you would like to get.

The supported data includes:

After you have added the data, on the Data part of the Excel ribbon, you will see a refresh button to click if you would like the data to be updated.

Wisesheets (live price data)

Using Wisesheets, to get real-time stock data on your spreadsheet is quite straightforward. After you install the Excel add-on, all you have to do is use the WISEPRICE function.

The syntax of the function works as follows:

=WISEPRICE(ticker/s, parameter/s).

The available parameters include the following:

• Symbol
• Name
• Price
• Changes Percentage
• Change
• Day Low
• Day High
• Year High
• Year Low
• Market Cap
• Price Avg 50
• Price Avg 200
• Volume
• Avg Volume
• Exchange
• Open
• Previous Close
• EPS
• PE
• Shares Outstanding
• Earnings Announcement
• Timestamp

Altogether you can build a stock list like this one, reference all of the tickers inside the WISEPRICE function as well as the parameters, and get all the stock data you need in one function.

You can also refresh the data at any moment by clicking on the WISPRICE menu of the Wisesheets add-in and then click on the refresh data button.

Wisesheets (key metrics)

Another type of accessible data only available through Wisesheets is key metrics. For this, you have to use the WISE function.

The function's syntax works as follows: =WISE(ticker, parameter/s, period, [quarter]).

The list of real-time parameters includes:

• Date
• Revenue Per Share
• Net Income Per Share
• Operating Cash Flow Per Share
• Free Cash Flow Per Share
• Cash Per Share
• Book Value Per Share
• Tangible Book Value Per Share
• Shareholders Equity Per Share
• Interest Debt Per Share
• Market Cap
• Enterprise Value
• PE Ratio
• Price To Sales Ratio
• POCF Ratio
• PFCF Ratio
• PB Ratio
• PTB Ratio
• EV To Sales
• Enterprise Value Over EBITDA
• EV To Operating Cash Flow
• EV To Free Cash Flow
• Earnings Yield
• Free Cash Flow Yield
• Debt To Equity

Generally, for the period you enter a specific year like 2023, that will return the key metrics based on fiscal year financial results. However, you can enter "TTM", to get the real-time value of the particular metric you are looking for.

You can see here that you can access the real-time dividend yield of a particular company or ETF as well as the price to sales based on the latest financial results and stock price.

Excel Google Finance Stock Investment Templates

Below are some of the most helpful stock investment templates you can build using Excel and Wisesheets.

Discounted Cashflow (DCF)

DCF is one of the most comprehensive spreadsheet templates you can use. It allows you to compare companies of a similar type by important key metrics. Then it enables you toproject future cash flowsby entering any assumptions you like on the financial statements based on your research. It also combines historical stock data with real-time information. This is used to calculate the company's intrinsic value per share.

Stock tracker

This is another useful template for tracking your investments. It includes all the important information you need to know about a company as well as its share price. You can also easily see how much each stock has increased or decreased in value over time.

Stock screener

On a single pageview, using the WISE and WISEPRICE functions, you can compare hundreds of companies

From this template, you can quickly identify companies worth looking into on a deeper level.

Tips for Getting Stock Data in Excel

Here are some simple tips for getting stock data in Excel:

• When looking up international stocks, use the correct ticker symbols. Check the lists for Excel stocks and Wisesheets to find the right symbols.
• Use cell references to pull multiple data points with the WISE and WISEPRICE functions at once.

Conclusion

To sum up, you can't use Excel in Google Finance. So, Wisesheets and Excel Stocks are the best tools for getting real-time and historical stock data in your spreadsheets. You can use the WISE and WISEPRICE functions to find stock data for any company or ETF.

Additionally, there are many helpful templates you can create with Excel and Wisesheets. This will greatly help you in your stock analysis and investment decisions.