Welcome Freetraders to the finKi API

finKi was overwhlemed by Freetraders use of the recent Dividend Data we published

So much so that you crashed our site and servers!

So here's a short term fix - a super simple API you can use to monitor your Freetrade portfolio holdings

API Parameters

Super simple demo of the syntax

https://finki.io/callAPI.php?isin=[ISIN]&function=[FUNCTION]

Excel and Google Sheet demos soon....

function example ISIN notes call API
ukBid GB00BH4HKS39 Bid (or closing Bid if market closed) for UK securities. Run
ukAsk GB0008829292 Ask (or closing Ask if market closed) for UK securities. Run
ukCurrency GB00BH4HKS39 Trading currency Run
ukSymbol GB0008829292 Symbol/Ticker/EPIC (take your pick depending how old you are!) Run
ukDividendYield GB00BH4HKS39 UK Dividend Yield (not 100% accurate. Usually 12motnsh rolling methodology…but sometimes not. Sorry. It's pretty good for free!) Run
ukDividendYieldv2 GB00BMMV6B79 UK Dividend Yield version 2 - from another source - in case version 1 reports a 0.00% yield. Try this. Run
ukDividendExDate GB0008829292 Date at which UK securities are no lomger entitled to the next dividend Run
ukDividendPayDate GB00BH4HKS39 Date at which the next/last dividend will be paid Run
ukDividendAmount GB0008829292 Dividend amount (can be USD, GBP, GBX..so make surre to call the API request below) Run
ukDividendCurrency GB00BH4HKS39 Dividend currency Run
ukDividendFrequency GG00B4ZPCJ00 Dividend payments per year (1= Annual, 2=Semi Annual, 4= Quarterly, 12=Monthly) Run
ukOCF IE00B1FZS798 IT/ ETF Ongoing Charge Run
ukIndex GB00BG226J60 Which tier of the UK exchange does the security trade on (AIM, FTSE 100 etc.) Run
usDividendExDate US0378331005 US Dividend Ex date Run
usDividendPayDate US0378331005 US dividend pay date Run
usDividendAmount US0378331005 US dividend amount Run
usDividendFrequency US0378331005 US dividend frequency Run
usDividendCurrency US0378331005 US dividend currency Run
usBid US0378331005 US Bid price - only during market hours, otherwise returns blank Run
usAsk US0378331005 US Ask price - only during market hours, otherwise returns blank Run
usLatest US0378331005 US Latest price (close price if market closed) Run
usOpen US0378331005 Opening price today/last Run
usClose US0378331005 Closing price today/last Run
usDividendHistory US0605051046 Dividend History from [startDate] to [endDate] in YYYY-MM-DD format please (sorry beginners! you'll have to parse it!) Run
ukDividendHistory GB00BH4HKS39 Dividend History from [startDate] to [endDate] in YYYY-MM-DD format please (sorry beginners! you'll have to parse it!) Run
ftOCF GB0003052338 Ongoing Charge : Freetrade costs and charges data Run
ftTRANS GB0003052338 Transaction Costs : Freetrade costs and charges data Run
ftOTHER GB0003052338 Incidental Costs : Freetrade costs and charges data Run
ukSector GB00BH4HKS39 Sector Name Run
ukIndustry GB00BH4HKS39 Industry Name Run
usSector US0378331005 Sector Name Run
usDebt US0378331005 Long Term Debt (Currently down for repair. Back soon!) Run
usEquity US0378331005 Total Equity (use Debt / Equity to get approx Debt-to-Equity ratio) Run
fxUSDGBP US0378331005 USD GBP FX Rate (ISIN is irrelevant - just maintains the common syntax) Run
fxEURGBP US0378331005 EUR GBP FX Rate (ISIN is irrelevant - just maintains the common syntax) Run

Google Sheets Example:

You could use the =IMPORTXML or =IMPORTDATA function

=IMPORTXML("https://www.finki.io/callAPI.php?isin=GB00BH4HKS39&function=ukDividendFrequency","/html/body")

=IMPORTDATA("https://www.finki.io/callAPI.php?isin=GB00BH4HKS39&function=ukDividendFrequency")

Excel Example:

You could use the =WEBSERVICE function but it will need a forced refresh that get's annoying

=WEBSERVICE("https://www.finki.io/callAPI.php?isin=GB00BH4HKS39&function=ukDividendFrequency")

For anyone able I'll place a VBA function here soon for you to insert into the VBA IDE - it makes things very easy

Need more data points Get in touch

What do you need? PE ratio, Dividend cover, KIID documents, factsheets?

Say Hi! hello@finki.io

Feedback Form