Can Google Finance show dividend yield in Google Sheets?

For regular stocks, not in the clean way most investors want.

You can use GOOGLEFINANCE to pull stock prices, market cap, PE ratio, EPS, volume, and other basic market data. But Google Finance does not give you a simple, dependable stock dividend yield attribute that works like the standard price formula.

So if you want dividend yield in Google Sheets, you usually have two practical options:

1. Use Wisesheets to pull dividend yield and dividend payments directly into Google Sheets or Excel.
2. Pull the current stock price with Google Finance and calculate dividend yield manually.

Goal	Google Sheets / Google Finance	Wisesheets
Current dividend yield	Limited/manual	=WISE("AAPL","dividend yield","ttm")
Dividend payments	Not straightforward	=WISEPRICE("AAPL","Dividend")
Annual dividend	Manual calculation	=WISE("AAPL","Dividend",2023)
Latest dividend	Manual lookup	=WISE("AAPL","Dividend","LQ")

So if you only need a rough dividend yield for one stock, you can calculate it manually.

But if you are building a dividend tracker, watchlist, income sheet, or stock research spreadsheet, Wisesheets is the much cleaner option.

Can You Get Dividend Yield from Google Finance?

The short answer is: not reliably for regular stocks.

Google Finance is useful for pulling basic market data into Google Sheets. For example, you can use it to get the current stock price:

=GOOGLEFINANCE("NASDAQ:AAPL","price")

You can also pull other stock-related fields such as market cap, PE ratio, EPS, volume, 52-week high, 52-week low, and daily price changes.

For a deeper breakdown of supported attributes and examples, read this guide to the GOOGLEFINANCE function.

But dividend yield is different. For stock investors, dividend yield depends on two moving parts:

• the company’s annual dividend per share
• the current stock price

Google Finance can help with the stock price side. But it does not give you a simple and reliable stock dividend yield field that works the way most users expect.

That is why many investors end up either:

• manually entering annual dividend amounts
• copying dividend data from websites
• using complicated import formulas
• switching to a spreadsheet add-on like Wisesheets

How to Calculate Dividend Yield Manually in Google Sheets

The dividend yield formula is simple:

Dividend Yield = Annual Dividend Per Share / Current Stock Price

To show it as a percentage:

Dividend Yield = (Annual Dividend Per Share / Current Stock Price) * 100

For example, if a stock pays $2.00 per share in annual dividends and trades at $50, the dividend yield is:

$2.00 / $50 = 0.04

That means the dividend yield is 4%.

In Google Sheets, you can calculate it like this:

=B2/C2

Where:

• B2 contains the annual dividend per share
• C2 contains the current stock price

If you want the current stock price from Google Finance, you can use:

You can also follow this guide on how to get stock prices in Google Sheets if you want a fuller walkthrough.

=GOOGLEFINANCE("NASDAQ:AAPL","price")

Then enter the annual dividend manually in another cell.

For example:

Ticker	Annual Dividend	Current Price	Dividend Yield
AAPL	1.04	=GOOGLEFINANCE("NASDAQ:AAPL","price")	=B2/C2

You can format the dividend yield cell as a percentage.

This works fine for a small sheet, but can become rather annoying when you are tracking several stocks – because every annual dividend number has to be found, entered, checked, and updated manually.

Why Google Finance Is Limited for Dividend Tracking

Google Finance can pull basic stock data, but it was not designed to handle full dividend tracking.

The main problem is that dividend data changes over time.

Companies can:

• increase dividends
• reduce dividends
• pause dividends
• pay special dividends
• change payment schedules
• adjust dividends after splits or corporate actions

A proper dividend tracking spreadsheet needs more than just a current stock price.

You may also want:

• current dividend yield
• latest dividend payment
• annual dividend paid
• historical dividend payments
• adjusted dividends
• ex-dividend dates
• payment dates
• declaration dates
• dividend growth

Google Finance does not give you that full dividend workflow inside Sheets.

So while it can help with the price part of the calculation, it leaves most of the dividend work to you.

How to Get Dividend Yield Directly in Google Sheets with Wisesheets

If you want to pull dividend yield directly into your spreadsheet, use the Wisesheets function:

=WISE("AAPL","dividend yield","ttm")

This returns Apple’s current trailing twelve-month dividend yield directly in Google Sheets or Excel.

To understand the period behind this formula, see this guide on dividend TTM.

You can replace AAPL with any supported ticker.

For example:

=WISE("MSFT","dividend yield","ttm")

Or use a cell reference:

=WISE(A2,"dividend yield","ttm")

This is especially useful if you are tracking multiple dividend stocks in one sheet.

For example:

Instead of searching each dividend yield manually, you can build a live dividend watchlist directly inside your spreadsheet.

How to Get Dividend Payments in Google Sheets

Dividend yield tells you the return based on the current stock price, but you need dividend payments to learn what the company actually paid.

To get historical dividend payments with Wisesheets, use:

=WISEPRICE("AAPL","Dividend")

This pulls a dividend history table directly into your spreadsheet.

You can use this data to review:

• past dividend payments
• dividend payment dates
• ex-dividend dates
• declaration dates
• adjusted dividends
• dividend trends over time

This is helpful because dividend yield alone can be misleading:

A stock can have a high dividend yield because the dividend is strong, but it can also have a high dividend yield because the stock price has fallen sharply.

Looking at dividend payment history gives you more context.

How to Get Annual Dividend Data

If you want the total dividend paid in a specific year, use:

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

This returns Apple’s dividend data for 2023.

You can also replace the year with another period depending on what you want to analyze.

For example:

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

This makes it easier to compare how a company’s dividend has changed year by year.

You can use annual dividend data to answer questions like:

• Has the company increased its dividend over time?
• Has the dividend stayed flat?
• Did the company reduce or suspend payments?
• Is the current dividend yield backed by a strong dividend history?

You can also calculate the dividend growth rate to see whether the company’s payouts are increasing over time.

How to Get the Latest Dividend Payment

If you only want the most recent dividend payment, use:

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

In this formula, LQ refers to the latest quarter or latest available dividend period.

You can also use previous periods, such as:

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

or:

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

This helps when you want to build a compact dividend dashboard instead of showing the full dividend history table.

For example, your sheet could show:

Ticker	Current Yield	Latest Dividend	Annual Dividend
AAPL	=WISE(A2,"dividend yield","ttm")	=WISE(A2,"Dividend","LQ")	=WISE(A2,"Dividend",2023)

[Screenshot: A compact Google Sheets dividend dashboard showing ticker, current dividend yield, latest dividend, and annual dividend]

Google Finance vs Wisesheets for Dividend Data

Here is the practical comparison:

Feature	Google Finance / Google Sheets	Wisesheets
Current stock price	Yes	Yes
Current dividend yield	Manual/limited	Yes
Annual dividend	Manual	Yes
Latest dividend payment	Manual lookup	Yes
Historical dividend payments	Not straightforward	Yes
Payment dates	Not straightforward	Yes
Declaration dates	Not straightforward	Yes
Dividend tracker workflow	Manual setup	Easier to automate
Works in Google Sheets	Yes	Yes
Works in Excel	No, Google Finance is Sheets-only	Yes

If you only need to check a stock’s current price, Google Finance is enough.

But if you want to track dividend income, dividend yield, dividend growth, and dividend history, Wisesheets is the better fit.

Build a Dividend Tracker Instead of Manually Checking Dividend Yield

The main challenge is not just getting one dividend yield number, but keeping your dividend data updated.

If you own or track several dividend stocks, you probably want to know:

• how much dividend income you are expected to receive
• which stocks have the highest current yield
• whether a company’s dividend is growing
• when dividends were paid
• when dividends were declared
• whether a dividend looks sustainable
• how your portfolio income changes over time

Doing that manually in Google Sheets can be time-consuming and difficult to maintain. That is why using a dedicated dividend tracker spreadsheet is usually a more efficient and organized approach.

If you want a faster starting point, use the free dividend tracker spreadsheet from Wisesheets. It is built for Excel and Google Sheets and helps you track dividend yield, dividend payments, income projections, and dividend history without building everything from scratch.

How to Use Dividend Yield in Your Stock Research

Dividend yield is useful, but it should not be the only number you look at.

A high yield can be attractive, especially if you are investing for income. But sometimes a high yield can also be a warning sign.

For example, if a company’s share price falls sharply while the dividend stays the same, the dividend yield rises. That may make the stock look attractive at first glance, but the falling price could reflect deeper business problems.

Before relying on dividend yield, check:

• dividend payment history
• dividend growth
• payout ratio
• earnings stability
• free cash flow
• debt levels
• revenue trends
• balance sheet strength

A good dividend stock has a dividend that looks consistent, supported, and sustainable.

Once you know what to look for, you can use a dividend stock screener to find more dividend-paying companies that match your criteria.

Frequently Asked Questions About Google Finance Dividend Yield

Can Google Finance show dividend yield?

Not reliably for regular stocks. Google Finance can pull basic market data into Google Sheets, including stock prices, but it does not give most users a clean stock dividend yield formula. You usually need to calculate dividend yield manually or use a tool like Wisesheets.

---

What is the Google Sheets formula for dividend yield?

Use this formula:

=Annual Dividend Per Share / Current Stock Price

For example, if the annual dividend is in cell B2 and the current stock price is in cell C2, use:

=B2/C2

Then format the result as a percentage.

---

Can I use GOOGLEFINANCE to calculate dividend yield?

You can use GOOGLEFINANCE to pull the current stock price:

=GOOGLEFINANCE("NASDAQ:AAPL","price")

But you still need the annual dividend per share. Once you have that number, divide the annual dividend by the current price.

---

What is the Wisesheets formula for dividend yield?

Use:

=WISE("AAPL","dividend yield","ttm")

This pulls the current trailing twelve-month dividend yield directly into your spreadsheet.

---

How do I get dividend payments in Google Sheets?

With Wisesheets, use:

=WISEPRICE("AAPL","Dividend")

This pulls historical dividend payment data into your spreadsheet.

---

How do I get the latest dividend payment?

Use:

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

This returns the latest dividend payment data for the selected ticker.

Can I track dividend yield in Excel too?

Yes. Wisesheets works in both Google Sheets and Excel, so you can use the same dividend formulas in either spreadsheet tool.

---

Google Finance Helps, but It Doesn't Finish the Job

Google Finance works well when you need simple stock data in Google Sheets, like pulling in current prices quickly.

But dividend tracking needs more than price data. If you only want to calculate dividend yield for one stock, you can do it manually by dividing annual dividend per share by the current stock price.

But manual work becomes a problem once you start tracking multiple dividend stocks. You need dividend yield, latest payments, annual dividend totals, payment history, and updates over time.

Wisesheets becomes more practical when you need to automatically pull dividend yield, payment amounts, and historical dividend data directly into your spreadsheet without manual updates.

Instead of searching for dividend data, entering it manually, and fixing your sheet every time something changes, you can pull the data directly into Google Sheets or Excel with formulas like:

=WISE("AAPL","dividend yield","ttm")

and:

=WISEPRICE("AAPL","Dividend")

So use Google Finance for what it does well – basic stock price data.

Use Wisesheets when you want to build a real dividend tracking system inside your spreadsheet.

To make that easier, start with the free Wisesheets dividend tracker spreadsheet. It gives you a ready-made setup for tracking dividend yield, dividend payments, dividend history, and portfolio income in Excel or Google Sheets.

And if you want to pull dividend yield and dividend payments directly into your own spreadsheets, try Wisesheets for free and use the formulas in this guide to start tracking your dividend data automatically.