Giter VIP home page Giter VIP logo

iso10383's Introduction

License: MIT

ISO10383 (MIC)

This repository is an RDF view on ISO10383's MICs in the fibo-fbc-fct-mkti namespace. Business centres have been taken from the ISDA/FpML business centre specification in the fibo-fbc-fct-bci namespace.

See https://spec.edmcouncil.org/fibo/ or https://github.com/edmcouncil/fibo

Why?

FIBO's official ontology lacks historical identifiers and, consequently, annotations about their temporal validity.

FIBO's business centres are not distinctive.

How?

The Makefile contains some recipes to assemble a file that resembles FIBO's.

For MarketsIndividuals the primary source is the latest list of Market Identifier Codes in the new data structure and format, to be obtained here: https://www.iso20022.org/market-identifier-codes. The choice of vocabulary is largely identical to FIBO's, except for fibo-fbc-fct-mkt:operatesInCountry which refers to ISO 3166-1 codes per means of ISO3166-1-CountryCodes-Adjunct, i.e. lcc-3166-1-adj:BM is used instead of lcc-3166-1:Bermuda.

For BusinessCentersIndividuals the primary source is the latest business-center spec file as published by FpML working group: https://www.fpml.org/coding-scheme/. The choice of vocabulary is largely identical to FIBO's, except for lcc-cr:isPartOf which refers to ISO 3166-1 and 3166-2 codes per means of ISO3166-1-CountryCodes-Adjunct and ISO3166-2-SubdivisionCodes-Adjunct/.

The resulting files are then enriched using supplementary files (maintained in this repo).

The supplementary files contain alignment data with wikidata, geonames, and dbpedia.

Where?

The official github repository contains the published datasets as well as separately maintained alignment and enrichment files.

The project's canonical home is http://data.ga-group.nl/iso10383/.

For ease of access the latest versions of the datasets can be downloaded here:

Tracking Historical Identifiers

In this repository identifiers turn historical once the entity that's been assigned a MIC changes, i.e. causing the MIC to be reassigned to a new entity.

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

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

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!

`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

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

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.