"Microsoft Excel Is Going Beyond Text and Numbers"

[Jan Iversen]

Sent from my iPad

> On 5 Apr 2018, at 11:40, toki <toki.kantoor at gmail.com> wrote:
> 
>> 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.
you use historical data to build and monitor trends, f.x. I have a 1 year trend analysis on my portfolio, this helps in deciding when to sell (e.g. not sell in panic today for reasons of the beginning trade war). So having historical values for stocks and exchange rates are useful.

rgds
jan i 
> 
>> 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 at lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice