Massive Portfolio Change! (My Biggest Spreadsheet Update Ever!)

[@Dividendology]

Access Tickerdata and my Spreadsheets: tickerdata.com/ Tickerdata youtube channel: www.youtube.com/@tickerdata/featured

[@rangwood]

I have just signed up for a Premium Membership, how do I access the template spreadsheets?

[@rangwood]

Oh I found it, it was on the website/account/premium access :)

[@rangwood]

So far everything is working well, I can finally get ticker values data for my international stocks! My only gripe is the dividend portfolio recording tab, it's a pain to fill up. Can't we get that filled up automatically by inserting a purchase date to our stock? Something similar to the (free) Yahoo portfolio 2.0. By keeping track of purchasing lots, the portfolio automatically pulls up our past income for that stock(s).

[@glennhaggard6633]

That is value add, done right!

[@Dividendology]

thank you so much!

[@TortoiseInvesting]

Always thought your spreadsheet looked nice and clean, the layout has always been great.

[@Dividendology]

thank you!

[@Oachkatzerl]

Nice idea. Please let us know, when it works with Libre Office Calc as well.

[@zohahs5276]

Very nice move. Do you know if we can build something like Fastgraphs or top graphs where we can visually see in seconds if the stock is overvalued or undervalued by graphing its P/E + EPS against its Stock price?

[@Dividendology]

This is possible with tickerdata! Im working on sheet for this! :)

[@zohahs5276]

oh wow nice nice looking forward to see this feature thanks.@@Dividendology

[@ralts2001]

This looks great. Just a thought, maybe add the currency in the row before the year?

[@Dividendology]

nice idea!

[@graedenmiddel8203]

This is fantastic. Wondering though, do users gain complete access to the tickerdata functions to create their own custom spreadsheets? Also, are you planning on making the valuation spreadsheets or even the portfolio trackers built into the website rather than downloadable spreadsheets? Could reduce churn.

[@Dividendology]

Yes, users gain access to the Tickerdata functions so they can create their own custom spreadsheets! The spreadsheets are downloadable on the website and are powered by Tickerdata functions, so a membership is needed for them to work.

[@fightersfan5363]

Can you do a video on DELL? It went up by a lot today.

[@TomS-rv8me]

Looks really promising. Does it include a history of ex-div and payout dates/amounts and upcoming payouts when declared? I couldn't see it in the docs on the website so thought I'd check here. My thought is that it would make it easier to precisely track the history, automatically show when the next payments are due, and how much is expected.

[@Dividendology]

Looking to add that in a future update! Planning on lots of updates soon.

[@mitesh8522]

Is this because Dividend Talks is reselling your spreadsheet?

[@Dividendology]

I've had this update planned for a long time, but he won't be able to steal this 😂

[@lawfirmbersani]

Sorry but it's not working for me. The european ETF I've inserted has a wrong Price , and the spreadsheet doesn't show all the information regarding dividends (yield, etc.)

[@Dividendology]

Send an email to [e-mail] and we will help! :)

[@GENERALAMW3]

I'd love to see a video covering some top-notch ETFs available in the European market! It's always helpful to have insights into solid investment options tailored to this region.

[@Dividendology]

Great idea! Tickerdata will make this easily possible.

[@rangwood]

So far, as I understand, the dividend payouts have to be entered manually for the calendar sections to properly work (past and future payouts). That's a lot of hassle for someone like me owns close to a hundred stocks from all over the world. It should be automated. That's a shame because I really like the product.

[@Davenport27]

Awesome update! Any opinions on MRK?

[@Dividendology]

Thanks! I'll add it to my list of videos to make.

[@noahmorris5857]

So can I pay for the membership for 1 month and keep the spreadsheets forever or do I have to keep paying monthly for them to work?

[@Dividendology]

The spreadsheets are downloadable on the website and are powered by Tickerdata functions, so a membership is needed for them to work. Try out the free trial to see what you think! :)

[@TimR.1992]

Amazing update, I appreciate the effort you put in this and able to share with us!!

[@Dividendology]

My pleasure!

[@TheMillennialMint]

Is the spreadsheet otherwise the same from the Patreon one? Can you create attributes for metrics like 5 year div growth rate and 10 year stock growth rate? I made some customizations to your original spreadsheet that I use to help with projections.

[@Dividendology]

It now has way more capabilities and features. And yes! You can easily pull those metrics in!

[@MACFANTASTICKYPESS]

I dont understand what the website do? U didnt show that in video.

[@Dividendology]

The website is simply so you can create an account and download the spreadsheets! :) I'll have more tutorials soon!

[@MACFANTASTICKYPESS]

so why did u make that website if spreadsheets are on patreon aswell? :D whats the point of it lol @@Dividendology

[@elmayo1665]

Genius! I think it's going to do well for you!

[@Dividendology]

thank you!

[@viperabacillo3068]

What do you think about Hormel stock. Motley fool has an article stating its a dividend king and lowest price in 5 decades. Please give us your valuation.

[@Dividendology]

Maybe I’ll make a video on them soon.

[@Zhanji]

very cool, the crypto tabs have been a major help over these last few years with your previous spreadsheets, cant wait for that in the new one. Keep up the great work!

[@TheGeordiePig]

Great, I look forward to more analysis on this!

[@Dividendology]

More to come!

[@Zionwolves]

Sorry for daft question but do I still need to subscribe to Patreon for you as well? Have signed up just now via your link :-)

[@Dividendology]

nope! You don't have to join patreon! Just Tickerdata.com

[@Zionwolves]

@@Dividendologyperfect have signed up.

[@Dividendology]

Awesome!! Enjoy!

[@fredrikohlundd]

YES!!!! I love it, have waited for this

[@Dividendology]

Awesome! I think you'll like it!

[@beththomas5638]

Help, I am excited about Tickerdata but I am clueless as to what to do once I have the Tickerdata extension. I just want to be able to access the spreadsheets and go. What am I doing wrong?

[@Dividendology]

Hi Beth! On the tickerdata website, click on ‘account’ and then click ‘go to premium’ near the bottom of the screen. There you can download the spreadsheets! :)

[@AdamN0RR]

@@Dividendology It says i cant edit, and numbers wont load. Im a premium member.

[@diogoreis8385]

does the spreadsheet gives error if my membership ends? Asking because I frequently use temporary virtual credit cards

[@Dividendology]

membership will have to stay active for the spreadsheets to work.

[@diogoreis8385]

@@Dividendology that I understood, I'm asking if it ends and I repurchase it will work again or do I need to make a new spreadsheet?

[@Dividendology]

it will still work! You won't have to make a new spreadsheet.

[@diogoreis8385]

@@Dividendology Thanks! :)

[@instinct2870]

Hey, what if I just want the normal dividend tracking spreadsheet that's on your patreon? if i sign up for it right now, does it still work?

[@Dividendology]

I’ve moved it over to Tickerdata, because Tickerdata allows it to operate way more smoothly and efficiently. It will also give it the ability to have way more features!

[@FRANKWHITE1996]

Nice add bro 😊

[@Dividendology]

thank you!!

[@jasonmacdonald9955]

Great idea will be to implement an affiliate program ❤️

[@Dividendology]

nice idea!

[@writingpanda]

Congratulations!!! 🎉🎉🎉

[@Dividendology]

Thank you!!

[@bartletpollock7735]

Does your sheet have the ability to pull any crypto data other than price??

[@Dividendology]

We’re constantly looking to make updates. What crypto metrics would you like to see?

[@bartletpollock7735]

Nothing crazy. Daily changes that show +/-, maybe a YOY change, etc

[@Dividendology]

nice ideas! Thanks!

[@bartletpollock7735]

No problem! What I’ve done with my spreadsheet (stocks and crypto) is attempt to capture my average buy in price since I DCA into them weekly but it’s been more complicated than I anticipated. Heavily considering just subscribing to yours instead!

[@Dividendology]

Crypto tracking has been added! :) See this video: kzbin.info/www/bejne/nJy7Zn-vmt-HhNk

[@whoiswho22]

Finally! Great work!

[@Dividendology]

thank you!!

[@jikert4815]

First subscriber to new channel. LOL

[@Dividendology]

Let's go!

[@nordicexpat]

Boring

[@youngrc212]

How does tickerdata compare to wisesheets?

[@Dividendology]

Tickerdata will be a hub of some of the most powerful sheets on the internet as well as give people the ability to easily pull in 100's of stock metrics from all across the world. I'm focused on compounding the quality of tickerdata overtime as well! I believe Tickerdata is already the best spreadsheet tool for stocks out there, but I plan on making it even better!