cmallwitz

Thanks - re: iexcloud.io - this doesn't seem to be a good replacement for anything. it only seems to have US stocks - no FX and no international markets.

There isn't really a setting for that - at the moment the script caches values for up to 5 minutes. I put that in mostly to reduce the number of...

My bad - the forced recalculation in Calc is Shift+Ctrl+F9 The problem with fields being available or not is really down to differences between the web sites but I thought...

I can format cells with the ex div date as "Date" in format "1999-12-31". When I then e.g. do +1 or -1 against those cells, the date is correctly reflected....

Having said that I'm struggling to get any conditional formatting to work with dates...

I tried to do something like this: one cell contains e.g. '=GETREALTIME("IBM",72,"YAHOO")' - the another cell says ={this ex-div date cell}+30 . then I see another date 30 later than...

If you try HYU on the FT web site, it looks like a Euro listing is available as HYU:BER (And, no - I'm not currently looking to add another data...

Because it isn't available on https://markets.ft.com/data/equities/tearsheet/summary?s=HYU:BER either What is your use case for getting market cap from secondary exchanges instead of just using the primary exchange of a particular equity...

Then try Yahoo - either (in different currencies) https://uk.finance.yahoo.com/quote/005380.KS?p=005380.KS&.tsrc=fin-srch or https://uk.finance.yahoo.com/quote/HYMTF?p=HYMTF&.tsrc=fin-srch The file examples.ods in the "Release" area here on GitHub has FX lookup examples.

Based on my experience Yahoo and FT have similar reliability. While Yahoo has more symbols/exchanges (e.g. Hyundai on South Korean exchange in this example and/or US option details), FT is...