Hi all,
I made a blog post on how I’m using Finki API to pull the dividend payout date and ex-dividend date into my Google Sheets spreadsheet.
Also how I’m using Finviz to pull the dividend payout amount and forward P/E.
Youtube video shows a spreadsheet and portfolio.
It’s really nice being able to pull the data automatically now.
Thanks,
Sean
Glad you’re enjoying it 
You know you can get PE and prices via my API too? You could ditch finvis and google finance from your spreadsheet entirely! 
Loads more API functions than I actually list on the site! Must update that site at some point!
Havn’t checked Finki out yet, but what language have you done all this in? Curious 
Backend is mostly powered by VB.NET sprinkled with a little Javascript.
Finki.io runs on PHP… but really I’m just cURL’ing the VB.NET pages
Hi Mr Finki,
Yes its really good so far, no issues have cropped up yet.
I was not sure if there was a limit to how many API calls can be done so thought I would spread the load across Google Finance/Finviz/Finki .
How come your system uses the ISIN rather than the ticker? It’s not an issue as the URL you gave to convert works perfectly. I just wondered that’s all.
Also when pulling the US dividend pay date - I left the function at ukDividendPayDate and it still returns the correct date - as checked against seeking alpha. This is the case for companies that only trade on the NYSE.
Is this just a sort of bug? I left it as it was because it worked flawlessly. I randomly picked 5 US and 5 UK stocks to double checked all is well against seeking alpha and it was all good.
Thanks,
Sean
None - but I’ve instigated the “key” so I can monitor usage. “Someone” remaining unnamed hits me up for about 100k calls a day … and it’s slowing certain other services down! I don’t plan on limiting use right now but never say never. No user (other than the one mentioned) is hitting me with too many calls per day.
Ticker is not unique across exchanges. You can have IHP on London and IHP on NYSE. Therefore you’d still need a prefix/suffix to identify. ISIN is 99% unique except in the annoying instances of multi currency ETFs. In those instances SEDOL is the best identifier but that’s got restricted publishication rules due to the LSEs “ownership” of this identifier.
Yep. Everyone is annoyed with the “us” or “uk” prefix and I’m gradually moving away from it. There is a generic “dividendLast” , “dividendNext”, “bid” and “ask” functions that do not require this prefix. The ukDividend function looks for UK and when it doesn’t find it it defaults to US… so you can call ukDividend and get a US result - I put that in place last week as it annoyed a few users who didn’t want to “uk” “us” prefix… I know it’s weird…but it kinda works for now until I kill the prefix off entirely.
Currently overhauling the entire dividend process behind the scenes as some “heavy” users require the API to query multiple ISINs and Exchanges at once. ie. Give me all dividends going Ex today on the LSE. Give me all dividends paying next week. Give me the entire history of dividend payments for Vodafone etc… This is a bit of a beast but it’s looking and working well. Hopefully I’ll bang it out for demo soon. Those with “keys” get notified for testing first.
Thank you very much for your informative response. I only have around 30 positions so I may just switch over to your API completely then.
Yeah that makes sense with regards to the tickers.
Thanks for the extra info!
@Seanyc5 Hi Sean - I’ve been trying to sign up to your mail list for a copy of your google sheet but I get a Cloudflare error when I submit my email addy?
@solfer Thanks for letting me know!
I just tested it and its back up now. Must of went down for a minute or two, may have been an update running the in the background or something.
Let me know if you cant get through still. You can DM me on Instagram @usefulrandom_investing
Thanks,
Sean
@Seanyc5 Thanks for getting back - I’ve tried again, still get the same error. Have been getting it all morning tbh.
Sorry for pinging you back here, I’m not on insta 
Cheers,
Solfer
Wondered why I had a flurry of FinKi API sign ups all specifically referencing dividend data…
FinKi.io if any one else is interested. Super cool dividend api (pro and free versions) that’s pretty much ‘live’ (kinda, minus some lag for validation)
@Finki Oh wow, loving the new site!
Will have a look through to see if I’m missing out on any goodies!
Just seen your location as well. I would of put money on you being in Aberdeen as well haha
Edinburgh
Wannabe-Scottish but born down South
‘Sassenach’ as my Father In Law loves to call me
You’re not missing much on the free API. There are hundreds of functions in the background but I just don’t advertise them as Dividends are peoples key thing.
ETF Search, ISA Eligibility determination, Key Information as-a-service…etc…etc… all built out… but for Retail Investors : Dividends … via the Free API
(but the pro version runs 10x faster!!!)