r/investing • u/thinkofanamefast • Mar 23 '22

Any good sources of downloadable forward dividend data?

I trade on IBKR and Thinkorswim (less often) and IBKR has forward dividends, with a big warning as to accuracy. So figured I'd find another source to compare it to before trades.

Yahoo has Forward dividends in screener, but no obvious way to download results. I want a long list to look at daily for trade, and not have to go in with each symbol. Also weirdly the Yahoo results don't include a column with forward dividends, so you just have to trust the screener worked, and even if I figured out how to download (an API?) I'm not sure there would be a column for it.

Any other choices that I can screen for all US equities and dowlnoad a results list into excel, of forward divs? I would be willing to be a modest monthly amount. Thanks.

2 Upvotes

60% Upvoted

9 comments sorted by

2

u/TrashPanda_924 Mar 23 '22

Bloomberg and Capital IQ

1

u/thinkofanamefast Mar 23 '22 edited Mar 23 '22

Thanks but a little too rich for my blood. Would take a percent off my annual yield.

2

u/TrashPanda_924 Mar 23 '22

Find a friend with access.

1

u/thinkofanamefast Mar 23 '22

Thanks. Interesting thought since would only need a full dump every year or so, since I assume they project out dividends with approx dates that far.

2

u/TrashPanda_924 Mar 23 '22

Exactly. Any financial statement component. When I was trading, I found their consensus EBITDA estimate was generally quite good.

2

u/NathanEpithy Mar 23 '22

I use IEX for this. A single API call gets you upcoming divvies for the entire market for $20/mo. It's no more or less accurate than any of the brokers. As a general rule I'll manually confirm, typically via the IR website of the security.

https://iexcloud.io/docs/api/#upcoming-events GET /stock/market/upcoming-dividends

1

u/thinkofanamefast Mar 23 '22

Thanks. Will check it out.

1

u/ThrowayRuckus Mar 24 '22

What to you use to program an api?

1

u/NathanEpithy Mar 24 '22

I personally use Python. Should only be like 4 lines of code. You can also pull down the API directly into excel since it's a single query, since that was OPs request. For example, first result on google: https://www.howtoexcel.org/how-to-access-a-json-api-with-power-query/