The latest update to Apple’s Numbers app includes a new STOCK function that allows a spreadsheet to retrieve stock information from the internet.

Update: In the Numbers for Mac 4.2 update, Apple changed the STOCK and CURRENCY functions to return data from the previous market day’s close.

Using this feature, I’ve created a spreadsheet template for tracking a dividend income portfolio. You may download and use this template for free. This spreadsheet helps with the planning, management and maintenance of your portfolio.

Template preview

After you have entered your positions (e.g. ticker symbol, number of shares and buy price), the spreadsheet automatically retrieves the latest stock information and performs the following calulations:

  1. The amount invested in each equity.
  2. The current market price and value of your equities.
  3. The gain/loss for each position.
  4. The annual dividend and current dividend yield for each position.
  5. The annual dividend income for each position.
  6. The dividend yield based on the amount you paid.
  7. The total amount invested, value, and gain/loss for the portfolio.
  8. The total annual dividend income for the portfolio.

Download Template

Get started investing

If you want to get started investing, sign up for Robinhood and get a free share of stock (valued from $3-$150) when you fund your account.

Robinhood is a stock brokerage that allows customers to buy and sell U.S. listed stocks and ETFs with $0 commission.

Sign up for Robinhood