💸 The Freetrade ETFs Spreadsheet 💸

Yep, it is. Ex/Pay/Amount in the dividend functions relate to latest or upcoming if a future one has been declared. It doesn’t pull total year amount… I’ll look to add it for you… hopefully tomorrow

1 Like

Thanks that would be awesome! :money_with_wings::money_with_wings::money_with_wings:

For equities (not ETFs) you could us ukDividendHistory and parse the results by the years you’re interested in

https://finki.io/callAPI.php?isin=GB00BH4HKS39&function=ukDividendHistory&startDate=2009-01-01&endDate=2019-31-12

But it won’t work for ETFs unfortunately as it is… I’ll look at that too and see what I can do.

Morning

Full year dividends in GBP here:

https://finki.io/callAPI.php?isin=IE0005042456&function=etf2018
https://finki.io/callAPI.php?isin=IE0005042456&function=etf2017
https://finki.io/callAPI.php?isin=IE0005042456&function=etf2016

or TTM here:

https://finki.io/callAPI.php?isin=IE0005042456&function=etfTTM

Enjoy

Only tested quickly on the Freetrade ETF universe… if you run it over any other ETF I can’t say it won’t crash on you! But if it does please let me know!

it can be a little slow , sorry , I;ll tweak it

2 Likes

Looks good! Thanks!

Would be great to have this on equities too, am working on a spreadsheet for my direct holdings.

Best :money_with_wings:

1 Like

Added Latest Price and Dividend Amount (£) - Thanks FinKi

1 Like

This is Marvellous @J4ck & other contributors! Thanks for putting this together, its very convenient to give a quick snapshot of ETF options, I always found it a nightmare trying to individually research ETF yields.

No worries @J4ck Excellent work! Keep it up. Any new data points give me a shout.

Would love the TTM dividend code for equities, is that possible? Going to try and work up a spreadsheet for the available equities too.

Best

This is very cool, @J4ck (and contributors) – thanks for sharing it! :money_with_wings:

2 Likes

@J4ck sure thing. It’s kinda there already if you parse the dividendHistory function but i can tweak that call so you simply get a numeric return rather than an entire JSON string as currently.

For example, Vodafone
https://finki.io/callAPI.php?isin=GB00BH4HKS39&function=ukDividendHistory&startDate=2009-01-01&endDate=2019-31-12

1 Like

Function call added for UK Equities and Investment Trusts dividend history by year. Only year 2018,2017 and 2016 included for now unless you need more.

Very much a ‘beta’ version. Not thoroughly tested.

US version coming soon but for now UK only.

For example.

https://finki.io/callAPI.php?isin=GB00B11V7W98&function=ukDiv2018
https://finki.io/callAPI.php?isin=GB00B11V7W98&function=ukDiv2017
https://finki.io/callAPI.php?isin=GB00B11V7W98&function=ukDiv2016

Enjoy

Please test and report any bugs. I expect there to be a few!

FYI - All UK dividends are rebased to GBX regardless of the denomination they actually paid in. Therefore there might be a fractional FX difference. I thought this a better option than calling a second function to test the dividend declaration currency!

Looks good so far! Very impressive

Will get working on a template, best :money_with_wings:

Sorry to be late to the party. Is there an update to this since Aug 19? Does anyone have a link please?

Is there an update of this sheet? Or maybe a similar list of Freetrade ETF paying dividends? Even if there is no Yield column.

1 Like

I was just thinking the same

This is very useful

Would be very welcome. Why don’t freetrade produce something like this?

1 Like