kiloran wrote:csearle wrote:Excellent, thank you. Several of those I've had a cursory look at but many are new! I'll let you know!
Cheers,
Chris
There's some stuff new to me in the link from mc2fool (many thanks!).
Most of these APIs tend to only provide share price (and/or historic price) so are somewhat limited.
https://finnhub.io/ seemed to have a lot of other stuff which is interesting, so I had a gander at dividends since that's of interest to many people. Data for Dunedin Income Growth (DIG) shows:
[{"symbol":"DIG.L","date":"2019-11-07","amount":3},{"symbol":"DIG.L","date":"2019-08-01","amount":3},{"symbol":"DIG.L","date":"2019-05-02","amount":3.45}]
The dates are ex-div (I think most of us would prefer payment date), and it is missing the payment with ex-div 2020-02-06 (2 months ago) and also that for 2020-05-07 (though that does have an ex-div date in the future. I found similar issues with more mainstream shares such as BP.
The site is fast, allows 60 queries/min and data is in a very usable form, but I'm not sure it is reliable or greatly useful. It may just be an issue for non-US shares.
I'll continue to review these sites.
--kiloran
I've had a further look at FinnHub, the breadth of data looked quite interesting.
Price:
Code: Select all
Symbol | Price
LLOY.L | 32.57
MRCH.L | 387.9824
BP.L | 316.25
RDSA.L | 1328.6
RDSB.L | 1284.39
SSE.L | 1261.5
CTY.L | 343.9665
VWRL.L | 64.55928
BHP.L | 1352.4
MUT.L | 756.2432
CRV.L | 2.9
At first sight, the prices looked OK, but......
Most shares are normally quoted in pence. and they look OK. However, VWRL.L in in pounds, and CRV.L is in USD, and there is no indication of currency. One of the API elements does indicate currency, but this is a premium feature, not free, and I don't know if the currency is just the currency used for accounting purposes, or price quote.
Trailing 12m dividends:
Code: Select all
Symbol | dividendsPerShareTTM
LLOY.L | 0.0112
MRCH.L | 0.204
BP.L | 0.3321
RDSA.L | n/a
RDSB.L | n/a
SSE.L | 0.922
CTY.L | 0.095
VWRL.L | n/a
BHP.L | n/a
MUT.L | 0.4275
I did not check the values, but a lot of gaps, which also applies to other dividend and yield data elements
Dividend Payments. Looked interesting with data going back 20 years or so, but the date is ex-div, not payment date, and no indication of currency (though it typically is in pence)
Code: Select all
Symbol | Ex-Div Date | Amount |
LLOY.L | 16 Apr 20 | 2.25 | Wrong.... this was cancelled
LLOY.L | 08 Aug 19 | 1.12 |
LLOY.L | 04 Apr 19 | 2.14 |
LLOY.L | 16 Aug 18 | 1.07 |
LLOY.L | 19 Apr 18 | 2.05 |
LLOY.L | 10 Aug 17 | 1 |
LLOY.L | 06 Apr 17 | 1.7 |
Code: Select all
MRCH.L | 23 Apr 20 | 6.8 | pence
MRCH.L | 30 Jan 20 | 0.068 | pounds
MRCH.L | 03 Oct 19 | 6.8 | pence
MRCH.L | 11 Jul 19 | 6.7 | pence
MRCH.L | 11 Apr 19 | 6.6 | pence
MRCH.L | 31 Jan 19 | 0.065 | pounds
MRCH.L | 04 Oct 18 | 0.065 | pounds
MRCH.L | 12 Jul 18 | 0.064 | pounds
Code: Select all
BP.L | 13 Feb 20 | 8.1558
BP.L | 07 Nov 19 | 7.825
BP.L | 08 Aug 19 | 8.3475
BP.L | 09 May 19 | 8.0655
BP.L | 14 Feb 19 | 7.7382
BP.L | 08 Nov 18 | 8.0251
OK, but until yesterday, the data for 13Feb20 showed a value of 10.5, which was the declared dividend in USD cents. It's taken around 10 weeks to display in pence (and there is no indication of currency.
Code: Select all
CTY.L | 23 Apr 20 | 4.75
CTY.L | 23 Jan 20 | 0.0475
CTY.L | 24 Oct 19 | 4.75
CTY.L | 25 Jul 19 | 4.75
CTY.L | 25 Apr 19 | 4.75
CTY.L | 24 Jan 19 | 0.0455
CTY.L | 18 Oct 18 | 0.0455
CTY.L | 26 Jul 18 | 0.0455
Again, a random mixture of pounds and pence
Code: Select all
BHP.L | 05 Mar 20 | 38.9402
BHP.L | 05 Sep 19 | 42.8283
BHP.L | 07 Mar 19 | 28.4244
BHP.L | 06 Sep 18 | 48.7182
BHP.L | 08 Mar 18 | 39.7916
I can't make any sense of the 3 most recent payments, the values just don't make sense
Overall, it's a real shame. There's a load of data there, it's fast, the data is in JSON format which is easy to handle. Pity the quality of the data is so poor, on my random sample.
--kiloran