On 04/04/2018 09:31 PM, Thorsten Behrens wrote: > Great list, thx for breaking it down!
Were I working on a set of extensions to provide that functionality, I'd break it down into even more groups. That discussion, and breakdown would occur on day one of a Scrum Sprint. > There's an until-the-beginning-of-EUR times archive for > EUR-vs-other-currencies archive, IIRC even with sell/buy/daily median > data > (https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml?4e6747038ab5c1e1bf2d9e383e39a2d3 > etc). Also, what about oanda.com? XE.COM is the only source I'm familiar with. If other sources provide the same data, use them. > I have some python code for the above, that we use for TDF's accounting. > (obligatory rant: _current_ exchange or stock market rates in > spreadsheet functions have close to zero practical value, and only The only reason/use case I have for both currency exchange rates, and stock market prices, is to determine value for today. > encourage people to do shitty accounting. If one is stupid enough to use the same spreadsheet for historical data, as for current data, then your description is way too kind. >> * I don't know what the rules are, for any current vendors of stock >> market data. I didn't use Get_Quote, because it didn't cover the stock >> exchange I tracked - each stock market probably needs its own extension. >> > A great opportunity to mine websites, and perhaps push for more open data? Maybe. The limiting function here being federal/state/local legislation concerning securities. >> probably can be pulled, at least in part, from WikiData. > Do you have any further pointers for that? https://www.wikidata.org/wiki/Wikidata:Main_Page Distributed under a CC0 license. (https://creativecommons.org/publicdomain/zero/1.0/) Database dumps available as: * JSON; * RDF; * XML; JSON is updated daily, and is the recommended format for downloading the database. The database model is described at https://www.mediawiki.org/wiki/Wikibase/DataModel/Primer The database schema is described at https://www.mediawiki.org/wiki/Wikibase/Schema Database dumps are available at https://archive.org/details/wikimediadownloads?and=%22Wikidata%20entity%20dumps%22 The GZIP archive for 20180328 is 19.3 GB. https://dumps.wikimedia.org/wikidatawiki/entities/ also has database dumps. The GZIP archive for 20180402 is 31,445,496,877 bytes. jonathon _______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice