{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KEY","Demo"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"KEY","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ENTER YOUR SUPER SECRET API KEY HERE >>>>"]

{"sheet":"Demo","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["go to finki.io/finkiAPI.html to see some of the functions available"]
[]
["The format of the call is   [ISIN]   and [FUNCTION]",null,"Don't forget to get your API Key from hello@finki.io","Here's the output"]
["the excel command to summon this data is '=finkiAPI'"]
["then add ISIN and FUNCTION….see \"Output\" right"]
["ukBid","GB00BH4HKS39","Bid (or closing Bid if market closed) for UK securities.",{"$f":"finkiAPI(B6,A6)","v":"109.54\n"}]
["ukAsk","GB0008829292","Ask (or closing Ask if market closed) for UK securities.",{"$f":"finkiAPI(B7,A7)","v":"634.0\n"}]
["ukCurrency","GB00BH4HKS39","Trading currency",{"$f":"finkiAPI(B8,A8)","v":"GBX\n"}]
["ukSymbol","GB0008829292","Symbol/Ticker/EPIC (take your pick depending how old you are!)","TEM\n"]
["ukDividendYield","GB00BH4HKS39","UK Dividend Yield (not 100% accurate. Usually 12 months rolling methodology)","7.57\n"]
["ukDividendExDate","GB00BH4HKS39","UK Dividend Ex Date - Point at which shares no longer receive the next dividend","2019-11-28\n"]
["ukDividendPayDate","GB00BH4HKS39","UK Dividend Pay Date - Point at which you should receieve your payout","2020-02-07\n"]
["ukDividendAmount","GB00BH4HKS39","UK Dividend Amount - the rate per share you receive for this dividend (use ukDividendCurrency if unsure of currency of quotation)","0.045\n"]
["ukDividendCurrency","GB00BH4HKS39","UK Dividend Currency - So you know the currency which is being quoted as the rate per share / ukDividendAmount)","EUR\n"]
["ukDividendFrequency","GB00BH4HKS39","UK Dividend Frequency - How many times per year (historically) to expect a dividend payment","2\n"]
["usBid","US0378331005","Bid (or closing Bid/or 0 if market closed) for US securities.","0\n"]
["usAsk","US0378331005","Ask (or closing Ask/or 0 if market closed) for US securities.","0\n"]
["usLatest","US0378331005","Latest (might be Bid, might be Ask) - Useful if you want a quick gauge of the current price","254.29\n"]
["usCurrency","US0378331005","Currency code - not always USD - so this is to verify","USD\n"]
["usDividendYield","US0378331005","US Dividend Yield (not 100% accurate. Usually 12 months rolling methodology)","1.19\n"]
["usDividendExDate","US0378331005","US Dividend Entitelement Date","2020-02-07\n"]
["usDividendPayDate","US0378331005","US Dividend Payment Date","2020-02-13\n"]
["usDividendAmount","US0378331005","US Dividend Amount Per Share **Intermitent Errors Occuring - Being Investigated**","0.77\n"]
["usDividendCurrency","US0378331005","US Dividend Currency - usually USD.. but not always! **Intermitent Errors Occuring - Being Investigated**","USD\n"]
["usDividendFrequency","US0378331005","US Dividend Frequency - How many times per year (based on historical averages)","4\n"]
[]
[null,null,"Turn manual formulas on/off depending on preference… and if your sheet hangs!"]