To keep track

Credits: ChatGPT :)

​

Here's a step-by-step guide to create a portfolio tracker that includes dividend information:

1. Create a new Excel spreadsheet and set up columns for the following information:

• Stock ticker symbol
• Number of shares
• Purchase price per share
• Purchase date
• Current price per share
• Market value
• Total gain/loss
• Dividend yield
• Total dividends received

Enter the stock information for each of your holdings in the appropriate columns.

​

Use the following formula to calculate the market value of each holding:

• Market value = Number of shares * Current price per share

Use the following formula to calculate the total gain or loss for each holding:

• Total gain/loss = Market value - (Number of shares * Purchase price per share)

Enter the dividend yield for each holding in the appropriate column. You can usually find this information on the company's investor relations website or from financial websites such as Yahoo Finance.

​

Use the following formula to calculate the total dividends received for each holding:

• Total dividends received = Number of shares * Dividend yield

Add a formula to calculate the total market value of your entire portfolio by summing up the market value of each holding:

• =SUM(Market value column)

Add a formula to calculate the overall gain or loss of your portfolio by summing up the total gain/loss of each holding:

• =SUM(Total gain/loss column)

Add a formula to calculate the total dividends received from your entire portfolio by summing up the total dividends received from each holding:

• =SUM(Total dividends received column)

Use conditional formatting to highlight the cells in the Total gain/loss column that indicate a gain or a loss in a different color.

​

You can also add charts or graphs to visually represent the performance of your portfolio over time, including the total dividends received.

​

This portfolio tracker should give you a comprehensive view of your investments, including the market value of your holdings, the gain or loss on each holding, and the dividends received from each stock. You can further customize the tracker to fit your specific needs.

I dont have a spreadsheet, but here's how I would do it. Excel workbook with 2 sheets: Share purchases, and dividend history.

​

The table in 'Share purchases' are ordered by dates and basically capture important info you would want to retain about your purchase. like date bought, how many shares, transaction fee, price at which it was filled, remarks (to indicate why you made that purchase).

​

The dividend history will just be a table showing date, stock, dividend amount, remarks. Can also include added metrics like annualized yield, or a separate table grouped by year and company detailing for e.g. 2023, company xyz, how much dividends in total did you receive, your cost basis, total cost (+ fees), and thus your div yield (expressed as a % of cost).