Wikidata:Property proposal/MIC

From Wikidata
Jump to navigation Jump to search

MIC market code

[edit]

Originally proposed at Wikidata:Property proposal/Authority control

DescriptionISO 10383 market identifier code. Aliases: 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) or systematic internaliser (Q91437908)
Allowed values[A-Z0-9]{4}
Example 1Bulgarian Stock Exchange - SME Growth Market Beam (Q69322780) -> GBUL
Example 2Bulgarian Stock Exchange - APA (Q69324839) -> PBUL
Example 3Bulgarian Stock Exchange (Q1003968) -> XBUL
Example 4ICE Futures Canada (Q8025740) -> IFCA
Example 5NASDAQ/Ngs (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)[reply]

Discussion

[edit]

MIC exchange code

[edit]

Originally proposed at Wikidata:Property proposal/Authority control

   Not done
DescriptionISO 10383 stock exchange code for a financial market. The main market operated by the exchange often uses the same MIC. Aliases: Operating MIC, ISO 10383 exchange code.
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 - APA (Q69324839) -> XBUL
Example 3Bulgarian Stock Exchange (Q1003968) -> XBUL
Example 4ICE Futures Canada (Q8025740) -> IFCA
Example 5NASDAQ/Ngs (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]
MD Imtiaz Ahammad Kopiersperre Jklamo ArthurPSmith S.K. Givegivetake fnielsen rjlabs ChristianKl Vladimir Alexiev Parikan User:Cardinha00 MB-one User:Simonmarch User:Jneubert Mathieudu68 User:Kippelboy User:Datawiki30 User:PKM User:RollTide882071 Andber08 Sidpark SilentSpike Susanna Ånäs (Susannaanas) User:Johanricher User:Celead User:Finnusertop cdo256 Mathieu Kappler RShigapov User:So9q User:1-Byte pmt Rtnf econterms Dollarsign8 User:Izolight maiki c960657 User:Automotom applsdev Bubalina Fordaemdur DaxServer Laurenz Sommerlad

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)[reply]

Discussion

[edit]

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)[reply]

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)[reply]

Reminder about MIC codes

[edit]
MD Imtiaz Ahammad Kopiersperre Jklamo ArthurPSmith S.K. Givegivetake fnielsen rjlabs ChristianKl Vladimir Alexiev Parikan User:Cardinha00 MB-one User:Simonmarch User:Jneubert Mathieudu68 User:Kippelboy User:Datawiki30 User:PKM User:RollTide882071 Andber08 Sidpark SilentSpike Susanna Ånäs (Susannaanas) User:Johanricher User:Celead User:Finnusertop cdo256 Mathieu Kappler RShigapov User:So9q User:1-Byte pmt Rtnf econterms Dollarsign8 User:Izolight maiki c960657 User:Automotom applsdev Bubalina Fordaemdur DaxServer Laurenz Sommerlad

Notified participants of WikiProject Companies Any comments? I got enough supporters for this proposal, but would like to solicit wider comment

@Jura1, Pintoch, ChristianKl: This proposal has garnered only Support votes and has been sitting for quite a while. Could you please create the 2 props above? --Vladimir Alexiev (talk) 13:15, 6 November 2019 (UTC)[reply]

  •  Comment @Vladimir Alexiev: I don't think the second property qualifies as an external identifier as the same value applies for many different items, at least from your examples. That is, it's not an identifier for the market, it identifies the exchange the market is on, if I understand correctly? It would be better to have it apply exclusively on the exchanges as a real identifier, and use a separate item-valued property to link market and exchange, if that makes sense. ArthurPSmith (talk) 13:35, 6 November 2019 (UTC)[reply]
    • "use item-valued property to link market and exchange" makes sense, however we have very few Markets on WD (as opposed to Exchanges), and markets evolve quickly in time (they are after all, marketing devices for the exchanges to sell their services, so I don't know who'd be willing to create them and maintain them on WD. I myself am ambivalent whether we need "Operating MIC" but --others above said they'd like to have it --Vladimir Alexiev (talk) 11:53, 10 November 2019 (UTC)[reply]

@ديفيد عادل وهبة خليل 2, ChristianKl, Jklamo, ArthurPSmith, Vladimir Alexiev, Niko.georgiev: @PKM, Iwan.Aucamp: ✓ Done: MIC market code (P7534). − Pintoch (talk) 13:48, 10 November 2019 (UTC)[reply]

Missing MIC of TSE MOTHERS

[edit]

The official MIC dump is at https://www.iso20022.org/market-identifier-codes . Even in the latest update "ISO10383_MIC-2021-09-13.csv" there's no info about Mothers (Q11340130), which is part of Tokyo Stock Exchange (TSE) and operated by JPX. MOTHERS seems to be missing in the latest MIC dump: 

csvtk grep -f "OPERATING MIC" -p XJPX ISO10383_MIC-2021-09-13.csv

So I emailed a request asking for a new MIC:

  • To: MIC-ISO10383.Generic@swift.com
  • Subject: MIC code for JPX TSE "Mothers"
  • Date: 20-Sep-2021

It seems a new MIC is needed for "MOTHERS" (Market of the high-growth and emerging stocks), a section of Tokyo Stock Exchange for high-growth startup companies.

It is described at the following URLs:

17 companies on Wikidata claim to be listed on MOTHERS: https://w.wiki/46Ku

--Vladimir Alexiev (talk) 14:05, 21 September 2021 (UTC)[reply]

I think this is a misunderstanding. TSE MOTHERS is an index, like the Dow Jones Industrial Average. The 15 of the 17 companies you mentioned are indeed members of the index (3694 and 8789 aren't). Hroptatyr (talk) 12:50, 24 August 2022 (UTC)[reply]

StockMarketMBA

[edit]

https://stockmarketmba.com/globalstockexchanges.php is another list of exchanges.

  • It has only 102 (compared to MIC's couple of thousands), but presumably these are the most active/important ones.
  • Shows number of stocks, which can be used for guidance.
  • And has Bloomberg, Google and EOD exchange codes (don't know what is "EOD") --Vladimir Alexiev (talk) 14:05, 21 September 2021 (UTC)[reply]
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Property_proposal/MIC&oldid=1712096050"