If you're an investor, you know that dividend yield is an important metric to track. But how do you get stock dividend data on Google Sheets? In this guide, we will show you how to do just that! We'll walk you through the steps of setting up a Google Sheets spreadsheet and importing the stock dividend data you need into it. So whether you're just starting out in investing or are a seasoned pro, this guide is for you!
How to get dividend yield and dividend payment data in Google Sheets
Analyzing dividend stock data on your Google Sheets spreadsheet is very helpful because you can track your dividend stocks, find new attractive stocks and see how your dividend-paying stocks perform over time. This is valuable information when making investment decisions.
Unfortunately, there is no native way to access stock dividend data using Google Finance, so you either have to scrape it from a website like Yahoo Finance using complex import HTML formulas or get it from Wisesheets in a simple function call. We will go over the second method in detail so you can get the dividend data you need to make better stock investments.
Dividend yield and dividend payment amount on Google Finance?
Since there is no way to get dividend stock data on google sheets using the Google Finance function, the best way is to use a Google Sheets add-on called Wisesheets.
The great thing about this add-on is that getting historical and real-time dividend data on Google Sheets is very easy.
Real-time dividend yield
If you are looking to get the real-time dividend yield of any stock listed across 50+ covered exchanges, you can do so very simply by entering the function =WISE("ticker", "dividend yield", "ttm").
For example, if you want to get Apple's current dividend yield, you can do so by entering =WISE("AAPL", "dividend yield", "ttm")
As you can see, the function returns the latest dividend yield based on the last dividend payment and current stock price. You can refresh this number by changing the ticker, pressing enter, and returning the ticker to the original value.
Historical dividend yield on Google Sheets
Are you looking for the dividend yield of a particular stock for different years or quarters? You can do so by entering the function in the following way =WISE("ticker", "dividend yield", year) or =WISE("ticker", "dividend yield", year, quarter).
For example, to get Apple's dividend yield for the 2020 quarter 2 report, all you have to do is enter =WISE("AAPL", "dividend yield", 2020, "q2")
This will return the dividend yield based on Apple's closing price when the financial statements were released.
Historical dividend payments on Google Sheets
All historical dividend payments
Getting all historical dividend payment information on Google Sheets is even easier. All you have to do is enter in any cell of your spreadsheet =WISEPRICE("ticker", "dividend").
For example, to get Microsoft's past dividend payments, you can simply do =WISEPRICE("MSFT", "dividend")
As you can see, this returns the ex-date, dividend payment, payment date, and declaration date with data going back to the 1980s. This allows you to perform any calculations you like, such as dividend growth, dividend yield at different periods, and overall dividend trend if you decide to graph it.
Yearly dividend payments
Different stocks and ETFs may have different payment periods like quarterly, monthly, etc. The good news is that you can easily get the sum of the dividend payments made in a particular year or years. You can do this by entering this on any cell of your spreadsheet =WISE("ticker", "dividend", year/s).
For example, to get the sum of the dividend payments made by Apple in 2021, all you need to enter is =WISE("aapl", "dividend", 2021).
This makes it easy for you to track the dividend payments you have received in the past from the companies you have invested in or analyze dividend payments faster.
Free dividend discount model template
To help you get started, we've created a free dividend discount model template that you can use on your own Excel or Google Sheets spreadsheet. This template includes the dividend discount model formula and allows you to input a company's data to find its intrinsic value.
You can access the free template by clicking here.
With this template, you can change the ticker and automatically get the company's history of dividend payments and historical dividend growth. This allows you to easily change the required rate of return to assess how much you should pay for a particular dividend stock. At this time, it enables you to screen for dividend stocks where the dividend yield is higher than the required rate of return.
Altogether this represents a powerful tool to give you an edge when looking at many dividend stocks and save you countless hours of time getting the data and making calculations.
For more information on the template, check out this article that goes in-depth on the template and dividend discount model.
*Note in order to take advantage of this template, you need a Wisesheets account to get the dividend data on your spreadsheet. You can get your free account here.
What is a dividend yield, and how is it calculated
A dividend yield is a ratio that shows how much a company pays out in dividends each year relative to its share price.
For example, if a company has a share price of $100 and it pays out $0.50 in dividends per share each quarter, its dividend yield would be 0.50/100 = 0.005 or 0.50%.
The dividend yield can be a valuable metric to compare different stocks, especially when you are trying to income from your investments. This is because a higher dividend yield usually means a higher return on investment (ROI), all else being equal.
However, it is essential to remember that the dividend yield is just one metric, and you should never invest in a stock solely based on its dividend yield.
When analyzing a stock, you should always look at the company's fundamentals, such as its earnings, cash flow, balance sheet, and valuation.
Why dividends are important to investors
Dividends are important to investors for a few reasons.
First, dividends provide a source of income that can be reinvested back into the stock or used to pay expenses. This can be especially important for retirees who depend on their investment income to cover their living expenses.
Second, dividend-paying stocks tend to outperform non-dividend-paying stocks over the long run. This is because dividend payments force companies to be more disciplined with their cash flow and use it more efficiently.
Lastly, dividends can act as a cushion during market downturns. When the stock market crashes, dividend payments can provide a source of income that can help investors weather the storm.
To sum it up, dividends are important to investors because they provide a source of income, force companies to be more efficient with their cash flow, and act as a cushion during market downturns.
How to find the best dividend stocks using Google Sheets
The best strategy for finding high-quality dividend stocks on Google Sheets is to use the various methods of getting dividend data on your spreadsheet using Wisesheets to screen these stocks in the following ways.
The first way is to find companies with a higher dividend yield than the discount rate. This means that the company's dividend payments are expected to exceed the required rate of return and thus be profitable dividend investments. In simple terms, if you want to achieve a 5% return and the yield is 6%, then you know that this investment meets the criteria.
The second way is to find companies whose stock price is trading below the present value of its future dividend payments. This means that the company is undervalued based on its expected future dividend payments and therefore represents an attractive buying opportunity where you can buy a stock worth $1 dollar for $0.80 as an example.
Once you have found some companies that look attractive, you will need to do some further research to determine if they are indeed suitable investments. This research should include an analysis of the company's financial statements, competitive position, and management team. Check out this article for more information.
Now you know some tangible ways to find high-quality dividend stocks using Google Sheets and Wisesheets.
The pros and cons of investing in high-yield dividend stocks
Pros:
The biggest pro of high-yield dividend stocks is that they offer the potential for higher returns. This is because you are being compensated for the extra risk you are taking.
Another pro is that these stocks can provide a source of income during retirement. This is especially true if you reinvest your dividends back into the stock.
Lastly, high-yield dividend stocks tend to be more resilient during market downturns. Again, this is because investors are looking for stocks that offer a stable source of income.
Cons:
High-yield dividend stocks tend to be more volatile than the market as a whole. This means that they are riskier investments but also have the potential for higher returns.
Another thing to consider is that high-yield dividend stocks are often mature companies with slower growth rates. This can make them less exciting to investors who are looking for high-growth stocks.
Examples of high-yield dividend stocks
Now that you know the pros and cons of high-yield dividend stocks, here are a few examples of companies that fit this description (at the time of writing).
– AT&T (T) 5.31%
– Verizon (VZ) 5.04%
– ExxonMobil (XOM) 3.55%
– Pfizer (PFE) 3.01%
– Johnson & Johnson (JNJ) 2.56%
These are just a few examples of high-yield dividend stocks. There are many other companies out there that offer attractive dividend yields. The key is to do your research and only invest in companies you understand and believe to be high-quality businesses.
Conclusion
In conclusion, getting dividend data on google sheets using google finance is not possible. However, you can get this information using the Wisesheets add-on, which provides real-time and historical dividend data for stocks across 50+ exchanges. This guide showed you how easy it is to get this valuable information that can help you make better investment decisions, as well as why getting this information matters and how to use it to make smarter dividend stock investments.
I hope this guide was helpful. If you have any questions, please leave a comment below.
Happy investing!
10 Responses
WISE function does not work any more
Hi Ricky, could you email us at info@wisesheets.io we are happy to help with any issues.
I thought the same thing .. but then I realized I had to buy the product :s
You can use it for free forever, but it is limited to Apple, Amazon, and Tesla.
I truly wanted to write a comment to be able to thank you for all the amazing recommendations you are placing at this site. My time-consuming internet search has now been recognized with reliable suggestions to write about with my companions. I 'd mention that many of us website visitors are undoubtedly blessed to be in a magnificent network with so many lovely individuals with interesting plans. I feel really blessed to have come across your entire webpage and look forward to tons of more enjoyable minutes reading here. Thanks once again for a lot of things.
Does not work
Hi Graham, we tested it and everything seems to be working well. Could you email us at info@wisesheets.io with the error you are facing we are happy to help.
What’s Happening i'm new to this, I stumbled upon this I've discovered It absolutely useful and it has aided me out loads. I hope to give a contribution & assist different users like its aided me. Great job.
wise sheets requests access to your google drive .. all files, read write edit … wtf?
We totally understand your concern.
We wish that we could change the permissions required, but unfortunately, Google controls the platform, and there is no way around it.
The reason why we ask for those permissions is for our templates functionality, where you can access templates made by the community and be able to upload your own. We need those permissions to enable the sharing of the spreadsheets across users.
This is the only reason, we cannot delete or see your spreadsheets or files in any other way. We have a disclaimer on our website that includes more details: https://www.wisesheets.io/pages/disclaimer.html
You can also use Wisesheets on Excel, where these permissions are not required since the storing and sharing of templates are technologically different. One more option is to create a separate google account to use Wisesheets.