How to Get the Dividend Payment History of an ETF

ETF Dividend Payment History

Looking for the dividend payment history of an ETF? You've come to the right place! In this blog post, we will show you how to get this information in a few easy steps. We will also provide some tips on how to use this information to make smart investment decisions!

What is a dividend payment history, and why is it important to know it?

A dividend payment history is the record of past dividends that an ETF (Exchange Traded Fund) has paid. This information can be helpful in making investment decisions, as it allows investors to measure their expected returns and compare them to other similar investments.

To get the dividend payment history of an ETF, you'll need to use a financial data provider. There are several services available to obtain this data (more on that below). Once you have the data, you will be able to see how much money the ETF has paid in dividends over time.

The best way to use this information is to compare the dividend payment history of a particular ETF with other similar investments. Look for trends in the data, such as how often the ETF pays dividends or how much it typically pays. You can also use this information to determine if an ETF is an excellent long-term investment.

How to get the dividend payment history of an ETF

There are many ways to get the dividend payment history of an ETF. Typically, investors navigate to a website like Yahoo Finance and copy-paste it into the spreadsheet where they perform their analysis. Unfortunately, this is time-consuming and ineffective for analyzing multiple ETFs at once and investing in the best ones.

Therefore we recommend Wisesheets, an Excel and Google Sheets add-on that lets you retrieve dividend data for stocks and ETFs on your spreadsheet.

Getting the dividend history of an ETF is very simple all you need to do is enter the formula like this:

=WISEPRICE("ticker", "dividend").

For example, to retrieve VOO's dividend payment history, you can do =WISEPRICE("VOO", "dividend")

dividend payment history of an ETF 

This will return an array like this with the historical dividend payments of the ETF, including the ex-date, dividend, adjusted dividend, payment date, and declaration date.

How to get the dividend yield of an ETF?

Instead of getting all of the dividend payments at once using Wisesheets, you can get individual dividend metrics. One of the key metrics is the dividend yield which you can retrieve using the formula =WISE("ticker", "dividend yield", "ttm")

For example, to get the dividend yield of VOO, you can enter =WISE("VOO", "dividend yield", "ttm")

etf dividend yield excel

This will return the ETFs dividend yield based on the past 12 payments and the current price.

A key benefit is that you can calculate this metric for a list of companies like this:

etfs dividend yield

This allows you to spot attractive ETF investment opportunities faster.

How to get dividend ETF dividend payments for a particular year?

If you are looking for the sum of the dividend payments made by an ETF over a specific period of time, like 2022, you can do this in a super simple way. You can use the formula =WISE("ticker", "dividend", year)

For example, to get the ETF dividend payments of VOO in 2021, you can do =WISE("VOO", "dividend", 2021)

etf dividend payments excel/google sheets

This will return the ETF dividend payments for the specified period saving you time and energy.

Once again you can perform this for many ETFs to compare ETFs faster and easier.

How to get dividend payment information for ETFs over a particular period?

One last thing that is value to get is ETF dividend payments over a particular period. To do this you can use the formula =WISEPRICE("ticker", "dividend", ,"start_date", end_date")

For example, to get ETF dividend payments of VOO from Jan 1st, 2021, to Dec 31, 2021, you can use =WISEPRICE("VOO", "dividend",,"01/01/2021", "12/31/2021")

Hoe to get etf dividend payments on spreadsheet

This will return ETFs' dividend payments over the specified period. This way, you can easily compare ETF performance over a specific time and make better investment decisions.

The benefits of having this information before you invest in an ETF

Some of the main advantages of having all the dividend information you need for ETFs are the following:

  • You can compare ETFs faster and easier
  • Get an understanding of ETF dividend history
  • Spot attractive ETF investment opportunities faster
  • Predict ETF performance better over a period of time.

By having the ETF dividend data you need on your spreadsheet, you can make more informed decisions and invest in ETFs that meet your particular investment criteria.

Examples of how to use this information to your advantage

The ETF dividend data you can get from Wisesheets allows you to make more informed decisions on ETFs. For example, you could use the ETF dividend payment history over a period of time to compare ETFs and decide which one is the most attractive investment opportunity.

You could also use ETF dividend yields and price data to determine ETF performance over time and compare ETFs to make the best investment decision.

Finally, you could use ETF dividend payments in combination with other ETF metrics like price momentum or volatility to spot ETFs that are outperforming the market.

ETF data on Excel & Google Sheets

FAQs about dividend payment histories for ETFs

Q: How often do ETFs typically pay dividends?

A: ETFs usually pay dividends quarterly. However, some ETFs may have different dividend schedules and payout frequencies.

Q: Where can I find ETF dividend payment information?

A: You can find ETF dividend payment information on Wisesheets. Our ETF dividend data allows you to quickly get ETF dividend payment information for ETFs in your portfolio.

Q: How can I use ETF dividend payment history to my advantage?

A: You can use ETF dividend payment information combined with other ETF metrics like price momentum or volatility to spot ETFs that are outperforming the market and make more informed investment decisions.


ETF dividend payment histories can provide valuable insight into ETF performance over time, making it easier to spot attractive ETF investing opportunities. With Wisesheets, you can get etf dividend payment history and use it to your advantage when making ETF investing decisions. The ETF dividend payment information you get from Wisesheets allows you to make better ETF investing decisions and take advantage of ETF opportunities faster.

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts