"Microsoft Excel Is Going Beyond Text and Numbers"

[toki]

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