A dividend stock is a great option if you’re looking to diversify your overall investment portfolio and reduce risk while 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.
Stock Valuation – The Art and the Science
Warren Buffett is one of the most famous investors of our time and is a stock valuation pro. He learned most of what he knows from Benjamin Graham – the KING of Value Investing.
“Long ago, Ben Graham taught me that price is what you pay, and value is what you get. Whether we’re talking about socks or stocks, I like buying quality merchandise when it is marked down.” – Warren Buffett
Stock valuation involves analyzing a company from many different angles to determine an intrinsic value. This intrinsic value will either be above or below the current stock price. If the value you arrive at is above the stock price – buy it! It’s cheap. If the value is below the stock price- sell it! It’s expensive.
Not everyone is a fan of value investing; it’s more of a long term approach. Hundreds of thousands of traders around the world pay little attention to the value of a stock, instead raking in big bucks betting on fluctuations in the price of the stock. Day trading, however, is incredibly risky and very few make money at it in the long run. To make an informed investment decision it’s wise to analyze the value of the stock before buying.
Stock valuation is as much an art as it is a science. Running a discounted cash flow is somewhat of a science. Deciding which assumptions to put into that model – that is an art. Looking back over historical earnings and performance is a science. Modeling future sales based on industry knowledge and macroeconomic forecasts – that is an art.
There are lots of tools publicly available to assist you in performing stock valuation. We’ve developed two free tools that take care of the science for you, allowing you to focus fully on the art.
Financial analysts and fintech developers everywhere are realizing they have choices when it comes to sourcing financial data. Intrinio’s financial data API strives to increase those choices by offering a wide variety of data types that are affordable, easy to access, and high quality.
Traditional data providers have enjoyed monopolies on this data for decades, making financial data APIs expensive or limiting access. This article shows how Intrinio is changing things. Keep reading for examples of the data types Intrinio offers, how they can be accessed, and how much they cost.
This article shows how to get started if you are not familiar with Intrinio. You can create a free account and start accessing data feeds right away such as: US Fundamentals and Stock Prices and US Global & Economic data feeds with a free trial or subscription.