How to Create a Dividend Stock Portfolio in Excel in Under 10 Minutes

A dividend stock is a great option if you're looking to diversify your overall investment portfolio and reduce risk, whilst making your money work for you. Most stocks will pay out their dividends quarterly, with some raising the payout amount over time.

While there are a variety of ways to keep track of your dividend stock, in this post, we'll focus on Excel. Specifically, we're going to focus on utilizing Intrinio's free Excel Add-In, which allows you to pull in a variety of dividend records such as the amount of latest dividend, the dividend yield, dividend payout ratio, and more.

Read More

How Can I see a Company’s Dividend?

Most users are familiar with the dividend yield of a stock and many investors like to keep an eye on this important metric. Usually when an investor sees a yield, they are looking at the trailing dividend yield, which is usually the way an Intrinio user will want to see the data.

Intrinio uses the tag trailing_dividend_yield for this datapoint, however there are many more ways to think about and calculate a firm's dividend. There are many types of dividend tags and many ways to get data about dividends and some companies report dividends in different ways as well.

This diversity of dividend options makes it important to explore the different ways you can access dividends. The following lists show the numerous ways dividends can be pulled from Intrino data.

Tags:

"trailing_dividend_yield"

"dividend" - The amount of the latest dividend

Read More