Coder Social home page Coder Social logo

ga-group / iso10383 Goto Github PK

View Code? Open in Web Editor NEW
1.0 3.0 1.0 7.25 MB

RDF dataset of ISO10383's MICs (similar to fibo-fbc-fct-mkti) with business centres from ISDA/FpML and historical identifiers.

Home Page: http://data.ga-group.nl/iso10383/

Makefile 39.97% R 40.91% XSLT 12.02% Awk 7.10%
exchange fibo fpml lei mic stockexchange wikidata businesscenter iso10383

iso10383's People

Contributors

hroptatyr avatar

Stargazers

 avatar

Watchers

 avatar  avatar  avatar

Forkers

hroptatyr

iso10383's Issues

broken links, improve README

The only branch here is gh-pages rather than the commonly used master or main.
Unless you plan to turn this into a github.io website, I'd suggest you move to master.


These links in the README are broken:
"For ease of access the latest versions of the datasets can be downloaded here:

The correct link is https://github.com/ga-group/iso10383/blob/gh-pages/MarketsIndividuals.ttl

improve MIC-wikidata alignment

I added MIC to Wikidata. Last update was maybe 1y ago. Spent a lot of time on matching existing exchanges.
I think most items are ok, but I'm sure there are omissions and merges that still need to be done.

  • Do you get your alignments skos:closeMatch wd:Qnnn directly from WD?
  • Would you like to help with improving the situation in WD?
  • Below is some info on ambiguous/duplicate codes, but I have a lot more files locally.
    • In particular, we need to check which current MIC codes are still missing from WD.
      A year ago they were COTC|ECHO|JSES|JSJX|LMEC|MIBG|NMRA|OTCN|TPSL|TSGI|XSWB|XZAP

MIC and Crunchbase Exchange IDs on Wikidata

Table of Contents

Results and counts as per 17-Aug-2022

MIC Codes

Duplicate MIC

Two MICs per exchange: https://w.wiki/5agv: 7

item itemLabel mic1 mic2
wd:Q21072594 Equilend EQIE EQLD
wd:Q5973741 FXCM FXCM FXGB
wd:Q25245262 Hudson River Trading HRTF HRTX
wd:Q795936 Oddo BHF ODDO ODOC
wd:Q7829724 Tower Research TRCX TRSI
wd:Q60742651 XTX Markets XTXE XTXM
wd:Q66320 over-the-counter trading BILT XOFF

Ambiguous MIC

One MIC for two exchanges: https://w.wiki/5ah$ : 3 (now fixed all)

Crunchbase Exchanges

Out of 164 CB exchange codes.

Ambiguous Crunchbase Code

Same code for two exchanges: https://w.wiki/5aYS : 1

item1 item1Label mic1 item2 item2Label mic2 cb
wd:Q1752885 Mongolian Stock Exchange XULA wd:Q43080281 Metropolitan Stock Exchange MCXX mse

Duplicate Crunchbase Code

Two CB codes per exchange: https://w.wiki/5aYP : 8 (this is ok)

item itemLabel cb1 cb2 mic
wd:Q5013179 Canadian Securities Exchange cnsx cse XCNQ
wd:Q43080281 Metropolitan Stock Exchange mse msei MCXX
wd:Q151139 Frankfurt Stock Exchange fra fwb FRAA
wd:Q496672 Hong Kong Stock Exchange hkg sehk XHKG
wd:Q661834 SIX Swiss Exchange six swx XSWX
wd:Q824533 Berne eXchange bx sbx XBRN
wd:Q846626 NYSE American amex nysemkt XASE
wd:Q2068453 Belarusian Currency and Stock Exchange bvfb jsc BCSE

Crunchbase Without MIC

Crunchbase exchanges without MIC: https://w.wiki/5aYM : 13

item itemLabel cb
wd:Q111263879 Afghanistan Stock Exchange afx
wd:Q28129219 ALTX East Africa Exchange altx
wd:Q4670553 Abuja Securities and Commodities Exchange asce
wd:Q1003245 Bucharest Stock Exchange bvb
wd:Q5072409 Channel Islands Stock Exchange cise
wd:Q702192 Eurex eurex
wd:Q111263885 Iran Energy Exchange irenex
wd:Q111263892 Lusaka Securities Exchange luse
wd:Q23308122 National Equities Exchange and Quotations neeq
wd:Q7374819 Royal Securities Exchange of Bhutan rsebl
wd:Q7914256 Vancouver Stock Exchange vse
wd:Q20992132 Yangon Stock Exchange ysx
wd:Q111263909 Zambian Commodity Exchange zamace

broken record in BusinessCentersIndividuals.ttl

You have this broken record in BusinessCentersIndividuals.ttl:

fibo-fbc-fct-bci:
	a	fibo-fnd-plc-loc:BusinessCenter ;
	a	owl:NamedIndividual ;
	dct:description	"the international business center of " ;
	lcc-cr:isPartOf	cc:BR , cc:ES , cc:EU , cc:GB , cc:IL , cc:NY , cc:US ;
	rdfs:label	"" .
  • I guess it comes from some empty cell in download/business-center-latest.xml but I don't know where to download it from
  • handling multivalued cells is a bit tricky in tarql, but I don't see where you do it? No afs:strSplit in FpML.tarql?

Btw, what is -cat in the makefile? I wonder about the minus sign

`cc:BM` vs `lcc-3166-1:Bermuda`

I'm comparing MarketsIndividuals.ttl to the official FIBO version.
(I've used https://gist.github.com/VladimirAlexiev/a4d9d715c5d079378384f3a30c8ce061 to convert FIBO to turtle)

You use fibo-fbc-fct-mkt:operatesInCountry cc:BM, they use lcc-3166-1:Bermuda

  • It's better to use the same prefix lcc-3166-1: to avoid confusion
  • You must use the FIBO country URLs, though it'd take a lookup table and is inconvenient.
  • I raised the same problem in edmcouncil/fibo#1816 with @ElisaKendall
  • I don't see owl:sameAs statements so this is quite mandatory

use uncefact's LOCODE namespace

In BusinessCentersIndividuals-align.ttl you use a "private" LOCODE namespace, eg

@prefix un-loc: <http://data.ga-group.nl/un-locode/> .
... skos:closeMatch un-loc:DKAAB

However, UNCEFACT is already producing linked data (@kshychko , @onthebreeze, @nissimsan).

Eg in https://github.com/uncefact/codes-locode/blob/main/vocab/unlocode/ you can see:

Please use those uncefact namespaces in your alignment.

Cheers!

why use dbp props?

In ISO10383.tarql you have this:

<MIC exchange/market>
		dbp:formerLabel	?NAME_INSTITUTION_DESCRIPTION ;
		dbp:formerName	?NAME_INSTITUTION_DESCRIPTION ;
		fibo-fbc-fct-mkt:hasExchangeName	?NAME_INSTITUTION_DESCRIPTION ;
		rdfs:label	?NAME_INSTITUTION_DESCRIPTION ;

<MIC code>
		rdfs:label	?_miclbl ;
		dbp:formerLabel	?_miclbl ;
  • Why emit the same label as both current and "former"? Or is the idea that at some point "DELETED" entries will be left only with "former"?
  • @ElisaKendall doesn't FIBO or LEI have a term for "former name"?
  • dbp is not a very good namespace because it applies only to English dbpedia and signified a "raw" (unmapped) prop.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.