Investors are always on the lookout for different ways to analyze the performance of stocks in their portfolio. One critical element they often look out for is the dividend yield. The dividend yield is a financial ratio that shows how much a company pays out in dividends each year relative to its stock price. In today’s guide, we’ll learn how to get dividend yield in Google Sheets.
What You’ll Need
To get started, you’ll need the following:
- A Google account
- A Google Sheets document
Steps to Calculate Dividend Yield in Google Sheets
Google Sheets provides a =GOOGLEFINANCE function which fetches current or historical securities information from Google Finance. Let’s see how to use this function to calculate the dividend yield:
Step 1: Open Your Google Sheets
Open Google Sheets and prepare your sheet by setting up columns names like ‘Ticker’, ‘Dividends’ and ‘Dividend Yield’.
Step 2: Enter the Ticker Symbol
In the ‘Ticker’ column, you can enter the ticker symbol of the stock for which you want to find the dividend yield.
Step 3: Fetch Dividend Data
To get the dividend data for a particular stock, use the =GOOGLEFINANCE function. The syntax of the function should look like this:
=GOOGLEFINANCE("symbol", "dividend")
Step 4: Fetch Current Price Data
Similarly, to get the current price for all the stocks use the same =GOOGLEFINANCE function with ‘price’ attribute. The syntax of the function should look like this:
=GOOGLEFINANCE("symbol", "price")
Step 5: Calculate Dividend Yield
Next, calculate the dividend yield by dividing the dividend per share by the price per share and multiply the result by 100 to get the yield percentage. Ensure to replace “A2” and “B2” with the correct cell references where your dividend and price data are present:
=(B2/A2)*100
Step 6: Refresh to Update
Finally, remember that stock prices and dividend values can fluctuate daily. To keep your data updated, refresh your Google Sheets regularly. Google Sheets updates the GOOGLEFINANCE function every few minutes for the most up-to-date information.
Conclusion
With Google Sheets, you can track and analyze dividend yield data easily. Its integration with Google Finance ensures you have the most accurate and up-to-date information at your fingertips. Now that you know how to get the dividend yield in Google Sheets, you can make more informed decisions about your investments. Happy investing!