Wikidata:Property proposal/MIC

From Wikidata
Jump to navigation Jump to search

MIC market code[edit]

Return to Wikidata:Property proposal/Authority control

   Under discussion
Descriptionaliases: MIC, ISO 10383 market code
RepresentsMarket Identifier Code (Q6770697)
Data typeExternal identifier
Domainstock market (Q475000) or stock exchange (Q11691) (for the main market operated by the exchange)
Allowed values[A-Z0-9]{4}
Example 1Bulgarian Stock Exchange - SME Growth Market Beam (Q69322780) -> GBUL
Example 2Bulgarian Stock Exchange - Approved Publication Arrangement (Q69324839) -> PBUL
Example 3Bulgarian Stock Exchange (Sofia) (Q1003968) -> XBUL
Example 4Winnipeg Commodity Exchange (Q8025740) -> IFCA
Example 5NASDAQ Global Select Market (Q69336177) -> XNGS
Example 6NASDAQ (Q82059) -> XNAS
Sourcehttps://www.iso20022.org/10383/iso-10383-market-identifier-codes
Formatter URLhttp://www.iotafinance.com/en/Detail-view-MIC-code-$1.html
Robot and gadget jobsEasy to import the ISO 10383 excel, but first need to decide the scope of market/exchange
See alsoOperating MIC

Motivation[edit]

Good for linking and cross references with other databases. Iwan.Aucamp (talk) 19:42, 3 October 2019 (UTC)

Discussion[edit]

MIC exchange code[edit]

Return to Wikidata:Property proposal/Authority control

   Under discussion
Descriptionaliases: Operating MIC, ISO 10383 exchange code. The main market operated by the exchange often uses the same MIC
RepresentsMarket Identifier Code (Q6770697)
Data typeExternal identifier
Domainstock exchange (Q11691)
Allowed values[A-Z0-9]{4}
Example 1Bulgarian Stock Exchange - SME Growth Market Beam (Q69322780) -> XBUL
Example 2Bulgarian Stock Exchange - Approved Publication Arrangement (Q69324839) -> XBUL
Example 3Bulgarian Stock Exchange (Sofia) (Q1003968) -> XBUL
Example 4Winnipeg Commodity Exchange (Q8025740) -> IFCA
Example 5NASDAQ Global Select Market (Q69336177) -> XNAS
Example 6NASDAQ (Q82059) -> XNAS
Sourcehttps://www.iso20022.org/10383/iso-10383-market-identifier-codes
Formatter URLhttp://www.iotafinance.com/en/Overview-operating-MIC-code-$1.html
Robot and gadget jobsEasy to import the ISO 10383 excel, but first need to decide the scope of market/exchange
See alsoMIC

Motivation[edit]

Kopiersperre Jklamo ArthurPSmith S.K. Givegivetake fnielsen rjlabs ChristianKl Vladimir Alexiev User:Pintoch Parikan User:Cardinha00 User:zuphilip MB-one User:Simonmarch User:Jneubert Mathieudu68 User:Kippelboy User:Datawiki30 User:PKM User:RollTide882071 Kristbaum Andber08 Sidpark SilentSpike Susanna Ånäs (Susannaanas)


Pictogram voting comment.svg Notified participants of WikiProject Companies

Datasets such as Crunchbase (Q10846831), Thomson Reuters Open Perm ID (Q69297407), S&P Capital IQ (Q4035851) include public company stock info including ticker (symbol) and exchange code. Eg

To connect this info to stock exchanges, we first need to have exchange codes.

  • TR permid has TR exchange code (eg BGR, NSM) and MIC (eg XBUL, XNGS)
    • For the individual ticker it has ticker (eg SKK, BIDU) and RIC (eg SKK.BB, BIDU.OQ)
  • CrunchBase uses different codes, eg NASDAQ, NYSE, LON.
  • Google Finance works with the CB codes, eg NASDAQ:BIDU, LON:LGRS. It even works with alternative codes, eg LSE:LGRS

MIC ISO 10383[edit]

Nevertheless, I think we should start with Market Identifier Code (Q6770697), which is international standard ISO 10383 "Codes for exchanges and market identification". Unlike most ISO standards, this one is available free of charge at https://www.iso20022.org/10383/iso-10383-market-identifier-codes .

The information is available in:

  • XLS: sheets MIC by country, MIC by CC (country code), MIC by MIC, Additions, Modifications, Deactivations, Monthly updates (since last month), Deactivated MICs
  • CSV
  • XML
  • PDF and a PDF annex (updates since last month's publication).

Markets: 1902 active (US: 305)

Fields:

  • COUNTRY
  • ISO COUNTRY CODE (ISO 3166): `ZZ` means "not applicable" (eg OFF-EXCHANGE TRANSACTIONS - LISTED AND UNLISTED INSTRUMENTS, NO MARKET (E.G. UNLISTED))
  • MIC: lower-level MIC. 1902, all unique
  • OPERATING MIC: higher-level MIC. 1085 values (full coverage). Most populous: XSTO (NASDAQ Sweden/Stockholm: 25 markets), XNAS (NASDAQ US: 18 markets). Distribution:
    count     markets
     819       1 
     104       2 
      54       3 
      35       4 
      17       5 
      16       6 
      11       7 
       7       8 
       6       9 
       7      10 
       3      11 
       1      13 
       1      14 
       1      15 
       2      18 
       1      25 
  • O/S: 1085 "o" for the primary or only market of an exchange (the two MIC codes coincide), 817 "s" for other markets
  • NAME-INSTITUTION DESCRIPTION
  • ACRONYM: 1163 missing, 611 values, a few misspellings (`CBOE EUROPE` with 1 or 2 spaces). Distribution:
    count     markets
     553       1 
      40       2 
      16       3 
       4       4 
       2       5 
       1       6 
       1       7 
       1       8 
       1      12 
  • CITY. Some misspellings, eg: BERN vs BERNE (CH), KIEV vs KYIV (UA), PORT VILA vs VILA (VU). Some not normalized values, eg WASHINGTON vs WASHINGTON/NEW YORK.
  • WEBSITE.
  • STATUS DATE
  • STATUS: ACTIVE, MODIFIED (inactive MIC are in a separate sheet)
  • CREATION DATE
  • COMMENTS: various nature:
    • description (ELECTRONIC BLOCK TRADING PLATFORM FOR EQUITIES),
    • corporate mergers (MERGER BETWEEN XASX AND XSFE),
    • technical news (ASX LAUNCHED VOLUMEMATCH IN JUNE 2011, AN ASX TRADE EXECUTION FACILITY THAT ENABLES END USERS TO SEARCH FOR LIQUIDITY AND EXECUTE LARGE ORDERS ANONYMOUSLY)

Iota Finance[edit]

http://www.iotafinance.com/en/ISO-10383-Market-Identification-Codes-MIC.html

This site has a useful reference of ISO 10383 MIC codes. It is up to date (Publication date : 10-09-2019), and has 2079 entries because it includes INACTIVE entries.

It has individual pages for each Operating MIC and MIC, so I've used it as Formatter URL. Eg:

Refinitiv (TR) tables[edit]

I googled `thomson reuters "mic"` and struck gold: on the page https://community.developers.refinitiv.com/questions/25624/getting-ric-from-isin-and-mic.html I found several lists of exchanges and their related organizations and codes.

In addition to ISO 10383, this has two Excel mapping tables:

mic-to-exchange-table-may-2017[edit]

https://community.developers.refinitiv.com/storage/attachments/2007-mic-to-exchange-table-may-2017.zip

This maps ISO 10383 MIC codes to TR exchange codes, eg XNGS -> NSM (NASDAQ Global Select market).

mifid-basic-venue-20180308[edit]

https://community.developers.refinitiv.com/storage/attachments/2046-mifid-basic-venue-20180308.zip

Markets (exchanges): 1653 (US: 274). This complements ISO 10383 MIC codes with extra information, eg market type, market category, whether it is regulated, who is the regulatory authority, trading venue classification, and SI asset classes (TODO what is SI?)

Fields:

  • `Market_Attributable_Source_Perm_ID`: unique. not available on permid.org (neither 1- nor 2-)
  • `Market_Type`: BBD DV ETP IDB NETP RA SP. TODO what do the codes mean? I made a pivot
  • `Market_Category`: PLT REG SBD TSC TSG (blank: 865 of 1653). TODO what do the codes mean? I made a pivot
  • `Market_Name`: mostly unique (only INSTINET BLOCKCROSS ATS is duplicated: regulated vs unregulated)
  • `MiFID_Regulated_Flag`: whether is regulated: 719 N, 934 Y
  • `Market_Location`: country (ZZ means none)
  • `Operating_MIC`: MIC code, eg BULGARIAN STOCK EXCHANGE is XBUL, NEW YORK STOCK EXCHANGE, INC. is XNYS
  • `Market_Segment_MIC`: a more fine-grained version of `Operating_MIC`. Eg BULGARIAN STOCK EXCHANGE, BULGARIAN STOCK EXCHANGE - ALTERNATIVE MARKET, BULGARIAN STOCK EXCHANGE - INTERNATIONAL INSTRUMENTS all have the same `Operating_MIC` (XBUL), but different `Market_Segment_MIC` (XBUL, ABUL, IBUL)
  • `MIC_Created_Date`: ddddmmyy
  • `Operating_Entity_Org_Perm_ID`: 532 empty or N/A, 633 unique. Most populous is https://permid.org/1-4298007875 TP ICAP PLC, which operates 40 exchanges in Europe (eg TULLET PREBON EUROPE - OTF * MADRID - CORPORATE BONDS AND SECURITISED DEBT). Sometimes works (eg https://permid.org/1-8589934165 New York Stock Exchange LLC is operator of NYSE DARK), sometimes not (eg https://permid.org/1-5000365450 NEW YORK STOCK EXCHANGE, INC returns no data)
  • `Operating_Entity_LEI`: 1182 empty or N/A, 107 unique, 26 used twice. The most populous is [213800ZMKPUV1VKLCT69](https://search.gleif.org/#/record/213800ZMKPUV1VKLCT69) MTS S.P.A. (MTS Italia) with 27 exchanges in GB, named after different European countries
  • `MiFID_Trading_Venue_Classification`: 1001 empty, MTF, RM, SI, OTF; RMLMTF, APA:ARM, APA
  • `Exchange_Code`: 1233 empty, 259 unique. Most populous are MIL (11, all IT), ISD (7, all GB), OTC (6, all US)
  • `Regulatory_Authority_Perm_ID`: 66 empty, Most populous: https://permid.org/1-8589934357 GB Financial Conduct Authority regulates 324 exchanges, https://permid.org/1-5000007215 US Commodity Futures Trading Commission regulates 225. The 2-3 that I tried resolve ok
  • `Regulatory_Authority_Name`: corresponds to `Regulatory_Authority_Perm_ID`
  • `Is_'SI'_In`: 1596 empty, the others have a combination of these flags: BOND CRFT DERV DPRS EMAL ETCS ETFS ETNS OTHR SDRV SFPS SHRS
  • `SI_Asset_class_Start_Date`
  • `SI_Asset_class_End_Date`
  • `MIFID_Third_Country_Equivalence`: 1543 empty, 57 3CDT, 50 3CTO
  • `MIC_Last_Update_Date`: ddddmmyy
  • `Action`: 1577 empty (create), 55 D, 21 U

Exchange vs Market[edit]

I think that the difference between stock exchange (Q11691) and stock market (Q475000) is not very clear. The proposal above is written on the assumption that an exchange (Operating MIC) may operate several markets (MIC). As always, things in the real world are complex: successful exchanges spawn in new countries, buy other exchanges, create a variety of products (markets) to diversify their activity, etc.

If you don't think that's true, please comment. Furthermore, ISO's distinction between (market) MIC and (exchange) operating MIC is not very useful and may confuse people. The formatter URL resolves no matter which URL template is used, eg:

After voting for the two MIC codes, I may make proposals for TR, CrunchBase and Google Finance exchange codes. Another option is to have a universal prop "exchange code" with some qualifier (eg "catalog"? that's not quite appropriate). Please comment.

Vladimir Alexiev (talk) 15:02, 30 September 2019 (UTC)

Discussion[edit]

  • Symbol support vote.svg Support both David (talk) 15:25, 30 September 2019 (UTC)
  • Symbol support vote.svg Support both, would be very useful Niko.georgiev (talk) 15:56, 30 September 2019 (UTC)

Thanks folks, but I'd also like to see some discussion whether we need to capture the two MIC levels in two different props. I tend to think one prop is enough --Vladimir Alexiev (talk) 10:38, 3 October 2019 (UTC)

I think two properties would be better, seeing an item that has two values on an authority control property that takes you to two different pages with different info would be confusing. The two URLs for NASDAQ above may resolve (although they still don't resolve correctly: the second URL doesn't return as much info as the operating MIC url), but the IDs for Bulgarian Stock Exchange (XBUL) are the same for both, so you have to have the different url formattings on the property to get both the MIC and the operating MIC? So since the codes can be the same for both MICs maybe thats enough of a reason to have two properties instead of one. Niko.georgiev (talk) 09:34, 4 October 2019 (UTC)