How to Build a Live Dividend Stock Portfolio with Microsoft Excel | Tutorial 📈

Today we look at how to build a live, updating dividend stock portfolio using Microsoft Excel. Excel has many helpful features that make building and tracking a portfolio of stocks very easy and useful. But there's a few snags when it comes to dividend shares. Here are are some helpful tips and tricks so you can use Excel to build the best live updating dividend portfolio you possibly can.

[bigo]

--__-- than is not a live dividend update if you have to come back every 3 months and update it manually

[lizacapinpin]

Thank you for sharing this video. Great help! Just what I needed to know. More power! God bless

[Kayn_.]

Mate, sorry but that’s not really a live updating one isn’t? Every time you buy and sell you have to update. Everytime the dividend updates you have to update.

[johnnybanana]

Thanks so much for this useful video! It helped me use excel to build a dividend portfolio of my own! Thanks Rainbow!

[epauloconnor]

Do you have a dividend schedule spreadsheet to take payouts?

[theunisholthuis]

This is a great help man, thank you for taking the effort! :)

[jackturner]

Would there be a way of creating an excel chart to see what dividend payout you will get each month, as in incorporating when you receive the dividends into the data you showed in this video, thanks

[patricklonski]

Problem with your example is that "the Yield" is not portfiolio's owner's dividend yield. One's yield is the Expected Payout/Your Purchase Price Per Share not the constantly changing share price. Rookie mistake.

[kgba]

hi how do i add vanguard LifeStrategy 80% Equity A ACC into my excel spreadsheet please :)

[Calventius]

Thanks, I was using Google sheets but the company symbols stop working

[captainoblivionthicc]

I wish everybody here a happy investment career and good luck 💪

[edwardmcdonald]

I don't even see a stock date button under my data section of the spread sheet