What tools are useful for Stockpickers? [2025]

I think the XIRR function in google sheets does that, eXtended Internal Rate of Return or “interner Zinsfuss”.

If you have changes (adding or subtracting money) use the XIRR (eXtended Internal Rate of Return) function. If you don’t have changes the formula (actual / entry) ^ (365 / (today() - entrydate + 1). You can use table fields for actual, entry and entry date, today() is the function for today’s date.

Like it less. Dividends appear then disappear and the change with the withholding tax was a bit annoying because I only found out recently about that change.

At the moment dividends for ABBV and GIS are missing and I could swear they were still present some time ago.

2 Likes

I found that sending them an email fixes things quickly even if you are only on the free tier.

info@divvydiary.com

A guy that has the aristocrat subscription told me it is visible to him. It is that one that is missing (from TipRanks) :

I don’t care as I now only use the free version. Was a subscriber when they started, but then was bored having to write them to take in new stocks that were not included while other (free) sites have all the data. The only point is that you cannot only use that site. If this dividend would not have been shown a few weeks ago I would have completely missed it…

It is just my bookkeeping, but I like things to be correct.

What do you guys use for dividends? I think I will use the combination of Interactive Brokers, Tipranks and divvydiary. Until now I did use only divvydiary for the bookkeeping.

When hoolie was still a bit more useful financially they had a portfolio function with dividends included. Unfortunately they left that to yahoo. Yahoo has a dividend feature too, but I did not try it out until now.

I don’t see a 2026 ABBV dividend in DivviDiary (and I am an aristocrat), neither in the stock overview

nor in the dividend calendar.

ABBV indeed has already announced their first 2026 dividend.

I’ve sent the DivviDiary guys a note. You’re in the CC of the email.[@]

Fair enough. It will eventually be correct, though … :wink:

I still like DivviDiary as a tool.

I believe you and I are the only ones tracking them … :laughing:


@   Just kidding about the CC.

Tradingview shows dividends, but maybe only for well-known securities. And I don’t know where they fetch the data from.

:index_pointing_up:t2: now now :wink:
Is this about divvys from stock one owns or is considering owning, I believe the former, because discussion started with portfolio performance.

Anyhow, a bit old-fashioned, but here goes, so for stocks I own, I have them in a Google Sheets, and I get an email from IB when dividends are announced, how much, and when, and manually write it in the 2025 divvy column. Not much work, and get that Ka-ching feeling every time.

With the Sparkline :beer_mug: function even get a nice visual trend once a stock has been paying divvys for a few years.

When I’m missing or checking something I have often noticed those dividend history sites (divvydiary etc) often have mistakes. AI hallucinations?

:beer_mug: actually, IIRC, I got this function from one of your sheets files that you generously share with us, @Your_Full_Name , so thank you for that, googlejedimaster.

4 Likes

The IB notice is OK, but is kind of late. I do more or less the same, enter the dividend in a google sheet, but I prefer doing this as early as possible so I see where the cash goes.

I think I’ll still use Divvydiary, but will control with the notices from IB to detect missing dividends.

1 Like

Just the Two Three of Us … :musical_notes: :saxophone: then.

I mainly use DivviDiary as the source as it’s easy to spot increases in their “News” tab.
I can’t really spot increases from the IBKR emails (I only update my sheet with current dividends when a company increases or – God forbid! – decreases their dividend).
I also follow @dividendhike on Twitter which is probably how I caught ABBV’s recent hike.

:folded_hands:

I’m just a Google Sheets Padawan. And at work, I’m forced to switch to the Dark Side occasionally (Excel).

1 Like

I use:

3 Likes

The Wall Street Journal publishes those daily.

1 Like

Indeed! Even found them in the (e-)print edition:

Do you know if they also publish this with a directly reachable URL on wsj.com? I don’t ever go read them via the e-print edition (except for looking for the Dividend Changes now).

Still is a bit cumbersome to check whether any of my holdings have an update in that section.

1 Like

I reactivated my account there and entered the divi portfolio. The data is complete, the two missing dividends from divvydiary are present. The looks are not that nice as in divvydiary but the data quality seems to be better. I like the “estimated data” for the future.

Thanks for reminding me of that site.

BTW: they have a feature to import too, did not use that.

To lower my maintenance I probably will only use one in the future. For the moment I use trackyourdividends and proof with the IBKR messages but I will still update divvydiary.

I have a script which processes the report from IBKR into a file which can be uploaded to TMD.

1 Like

For wealth tracking, I’m using Kubera (https://www.kubera.com/)

To analyse individual stocks, I like simplywall.st

1 Like

Just got a note from the guys a couple of hours ago, it’s fixed. I indeed see the next dividend now.

It also appears in the dividend calendar.

Nothing is fixed, GIS dividend is still missing. Must be an error in their software because both dividends were present a few weeks ago. How can a giant like General Mills be deleted?

That is the point I don’t like. You have to tell them every time a new item appears because it is not automatically imported. I wrote tons of emails over the years and that was the reason I did cancel the subscription. Other sites seem to import just all the data and that’s it.

This mirrors, eerily accurately, frequent discussions between my partner and I. :sweat_smile:

7 Likes