cmallwitz
How do you force the real-time data to update?
The .oxt file works fine in Arch Linux, but the data doesn’t update very often. Is there a setting for update frequency?
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 requests when for a given symbol there are multiple lookups on different fields (e.g. price + currency + date) which would otherwise hit the same URL containing all the data.
Furthermore I don't know about an automatic update feature in *Calc - what I do to force a recalculation is press Ctrl+Alt+F9 - if the 5 minute period has passed that will reload data from the web.
Maybe a broader question: may I ask how you use the extension in terms of number of symbols, exchanges/countries, google vs yahoo (I find the FT data quite nice and was wonder if I would add it eg. https://markets.ft.com/data/equities/tearsheet/summary?s=VOD:LSE) ? I'm thinking about adding a feature to map symbols between providers (to make switching easier) but I'm not sure how to make it useful.
Cheers Christian
Having a way to force a recalculation would be great. However, when I press Ctrl + Alt + F9, my linux desktop goes away and I get switched to a console.
I’ve found that adding a new sheet forces the data to update. (Once it updates, I delete the sheet.) Other than that, though, I haven’t found a consistent way to refresh the data.
At the moment I’m tracking 8 or 10 symbols, all in the US. I’ve been using the Yahoo data, which works fine. Some of the fields don’t seem to work right for me with Google: 
.
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 fixed the issue with the HTML bits in Ticker/Exchange/Name. Is this with the latest version?
You can maybe use a macro to create a refresh button on the spreadsheet (see https://askubuntu.com/a/1357255 or https://ask.libreoffice.org/t/how-to-reload-file-via-macro-on-calc/31458/2 )
I'm having mixed results with it so far (seems to work every few minutes) but feels a bit more usable over remembering keyboard shortcuts. Can add to the example.ods if you're okay with having macros on it.
