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
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
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.
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 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.
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
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!
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.
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.
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
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
How can i add EU stocks in spreadsheet?
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
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.
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?
You simply need to update the total amount of shares you own and the average purchase price! Just list this once.
@@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.
Thank you for your update. Amazing! New learnings too for my dividend portfolio. Keep it up. God bless.
Your spreadsheet is amazing
Does your spreadsheet take into account enhanced equity dividend trust 's of instance BCX, BDJ, BST?
Any update on Canadian markets being supported? Would love to support!
Hopefully in less than a month. Finished product is very close.
Hi, big thanks for this tracker portfolio. Very useful thing.
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
You just have to use the Tickerdata add on and click ‘refresh’! Here’s a quick tutorial: th-cam.com/video/_ktIP6-O_eA/w-d-xo.htmlsi=8vhhVnxpvX4a_c23
Been looking forward to this update! Any new guidance on where to get Industry data pulled into the spreadsheet?
My spreadsheet pulls it automatically!
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!
About to roll out an update, but you can also email help@tickerdata.com ! :)
Is it only for US Stocks?
Besides rolling it for the new year, are there any other changes/updates/improvements?
Does the spreadsheet cover UK stocks?
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.
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.
Crypto table is not working correctly. I enter a symbol (for example BTC) but output N/A in tables.
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
So I do daily buys for dollar cost avg. For this sheet, and I doing rows each day? This will get big pretty fast.
Nope! You simply update the total amount of shares you own and the average purchase price.
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.
Does the excel sheet also covers stocks on the european exchanges?
Would u provide a tutorial on how to track SGX and KLSE stocks on google sheets
Can be available Indian market stock ETF sip mutual fund etc?
Does this work if we buy stocks in other market eg SGX
it all error for me and can i delete what all reddy fillied in
Make sure you download the Tickerdata add on!
@@Dividendology i did i have log in
I have brought the pantheon gold and the tickerdata and still can’t figure how to make them work
check out the tickerdata youtube channel! There are some tutorials here: th-cam.com/video/_ktIP6-O_eA/w-d-xo.html
not working for me... in canada and all im seeing is #name? for price, market value etc... please help
Have you joined Tickerdata at Tickerdata.com ? That will allow the sheet to work for Canadian stocks!
@@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
Does this track us stocks/ etfs and UK stocks and etfs
Yes it can track all symbols.
@@Upholstered_ in GBP?
My sheet is not populating and no one is responding to my messages
Not sure who you are messaging, but feel free to email help@tickerdata.com and we can help you!
I downloaded it but it just gives me errors. I have a tickerdata account.
Working on an update right now! Email help@tickerdata.com with any questions! :)
Can anyone send me a copy of this spreadsheet please?
you can download it on my patreon page. Link in description.
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
You’ll need to message Patreon if you’re having trouble signing in!