Below is the updated dividend portfolio spreadsheet of my current holdings.  This spreadsheet contains my entire dividend stock portfolio and excludes any mutual funds I've yet to sell. All the fields are calculated in real-time so the total value and yields will change throughout the day.  The columns with the blue headings are the only fields that require manual input.  The rest of the portfolio spreadsheet will auto calculate with current information. Feel free to make a copy of the spreadsheet from the link below to use and manipulate the dividend portfolio spreadsheet as you'd like.  More narrative about the dividend stock