The Best Dividend Portfolio Tracker! | DIY Investor Tool Kit 6.0 Update |

[@Dividendology]

Link to download my spreadsheets: www.patreon.com/dividendology Join my free newsletter! dividendology.substack.com/ Get a huge discount + 7 day free trial to Seeking Alpha: seekingalpha.me/Dividendology

[@ladapavlik869]

How can i add EU stocks in spreadsheet?

[@CanuckDividends]

As others have asked, will your spreadsheet be US stocks or will we be able to enter in CDN stocks as well? It looks great, just haven't found one as complete as yours

[@danmurray4594]

Nice. Will the stocks page aggregate? For instance I buy 10 shrs of Stock STK at $50/shr. Then some time later, I buy 30 shrs at $55. Will the charts show a total of 40 Shrs and an average/aggregate share cost of $53.75?

[@Dividendology]

You simply need to update the total amount of shares you own and the average purchase price! Just list this once.

[@YODAddyLIVE]

@@Dividendology first and foremost the spreadsheet is amazing and I'm grateful to you for putting in the work. That being said I had the same question as @danmurray4594 (thanks for asking). Hopefully this is something that can be added in the next update. I'll be joining the Patreon group later this week so be happy to be your tester as well. Again, a huge thanks and prosperous 2024.

[@wanderlust4591]

Thanks for the update. I would request on the stock tab where you have the cash position to also add a money market account as there’s really no where to plug those interest payments in.

[@llew-AZ]

Does your spreadsheet take into account enhanced equity dividend trust 's of instance BCX, BDJ, BST?

[@chibbu1965]

Just bought the membership and went to the Stock Tab. There are a bunch of cells that have the following #NAME?. Can you please help me? Why it is not doing it correctly? Thanks

[@Dividendology]

You just have to use the Tickerdata add on and click ‘refresh’! Here’s a quick tutorial: kzbin.info/www/bejne/lZzXeoNsYrSSm6Msi=8vhhVnxpvX4a_c23

[@gilhodges7260]

I am having trouble with data filtering in from Tickerdata once you input the ticker symbol in the stock tab. It is giving an error say unknown function. Price, Market value, dollar gain, growth, etc is not being pulled in. Thank you!

[@Dividendology]

About to roll out an update, but you can also email [e-mail] ! :)

[@sulthoniikhsanulfadhillah1718]

Is it only for US Stocks?

[@maccomputers]

Any update on Canadian markets being supported? Would love to support!

[@Dividendology]

Hopefully in less than a month. Finished product is very close.

[@TonyMocca]

Crypto table is not working correctly. I enter a symbol (for example BTC) but output N/A in tables.

[@scooter741]

Does the spreadsheet cover UK stocks?

[@NxtrdayAdventures]

Been looking forward to this update! Any new guidance on where to get Industry data pulled into the spreadsheet?

[@Dividendology]

My spreadsheet pulls it automatically!

[@whoiswho22]

Is it able to track now also different currencies, when I buy e.g. British American Tabaco in London or tencent in Hongkong at their home market

[@Dividend_Info]

Your spreadsheet is amazing

[@PNWPawsPathsPad]

I’ve only entered 8 stocks in my portfolio but two of the stocks have wrong references and the total return is not calculated accurately.

[@Dividendology]

Everything seems to be working properly on my end. You may have entered some of the data incorrectly. I’d suggest watching the tutorial video all the way through as that should explain how to use it.

[@davidwperkins]

Besides rolling it for the new year, are there any other changes/updates/improvements?

[@blktauna]

So I do daily buys for dollar cost avg. For this sheet, and I doing rows each day? This will get big pretty fast.

[@Dividendology]

Nope! You simply update the total amount of shares you own and the average purchase price.

[@cashdinero0]

Does the excel sheet also covers stocks on the european exchanges?

[@barryroyds-gl8wc]

it all error for me and can i delete what all reddy fillied in

[@Dividendology]

Make sure you download the Tickerdata add on!

[@barryroyds-gl8wc]

@@Dividendology i did i have log in

[@lizacapinpin7904]

Thank you for your update. Amazing! New learnings too for my dividend portfolio. Keep it up. God bless.

[@bhavneshparikh8283]

Can be available Indian market stock ETF sip mutual fund etc?

[@xz1144]

Would u provide a tutorial on how to track SGX and KLSE stocks on google sheets

[@maneugeni]

It would be great if you could design it to also track individual bonds, which I also use to build a solid income portfolio with dividend stocks, CEFs , ETFs and some mutual funds.

[@TonyMocca]

Hi, big thanks for this tracker portfolio. Very useful thing.

[@careyloh]

Does this work if we buy stocks in other market eg SGX

[@texgallop458]

I have brought the pantheon gold and the tickerdata and still can’t figure how to make them work

[@Dividendology]

check out the tickerdata youtube channel! There are some tutorials here: kzbin.info/www/bejne/lZzXeoNsYrSSm6M

[@anthonyboone9629]

not working for me... in canada and all im seeing is #name? for price, market value etc... please help

[@Dividendology]

Have you joined Tickerdata at Tickerdata.com ? That will allow the sheet to work for Canadian stocks!

[@anthonyboone9629]

@@Dividendology yes, but it still has no information on some of my tickers. All of my positions in brookfield, Air canada, NWH.UN, and TNT.UN

[@joemadden]

I downloaded it but it just gives me errors. I have a tickerdata account.

[@Dividendology]

Working on an update right now! Email [e-mail] with any questions! :)

[@the_freedom_movement]

My sheet is not populating and no one is responding to my messages

[@Dividendology]

Not sure who you are messaging, but feel free to email [e-mail] and we can help you!

[@bartoni79]

Does this track us stocks/ etfs and UK stocks and etfs

[@Upholstered_]

Yes it can track all symbols.

[@bartoni79]

@@Upholstered_ in GBP?

[@stephennolan5776]

Can anyone send me a copy of this spreadsheet please?

[@Dividendology]

you can download it on my patreon page. Link in description.

[@mordebehar5032]

I paid my subscription, but cannot get in as discord tells me my invite is invalid when i try to reset my password it tells me invalid token, unless i can reach someone i am going to cancel my subscription its support sucks

[@Dividendology]

You’ll need to message Patreon if you’re having trouble signing in!