Property talk:P7534

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

MIC market code
ISO 10383 market identifier code

Data type	External identifier
Domain	stock market (Q475000), stock exchange (Q11691), systematic internaliser (Q91437908), Approved Publication Arrangement (Q85742512), futures exchange (Q2298435) or commodities exchange (Q695817)
Allowed values	^[A-Z0-9]{4}$
Example	Bulgarian Stock Exchange - SME Growth Market Beam (Q69322780) → GBUL Bulgarian Stock Exchange - APA (Q69324839) → PBUL Bulgarian Stock Exchange (Q1003968) → XBUL ICE Futures Canada (Q8025740) → IFCA NASDAQ/Ngs (Global Select Market) (Q69336177) → XNGS Shenzhen Stock Exchange (Q517750) → XSHE New York Stock Exchange (Q13677) → XNYS
Source	https://www.iso20022.org/10383/iso-10383-market-identifier-codes
Formatter URL	https://www.iotafinance.com/en/Detail-view-MIC-code-$1.html https://www.iotafinance.com/Vue-detail-code-MIC-$1.html https://www.iotafinance.com/de/Detailansicht-MIC-code-$1.html
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Complex constraint violations/P7534 Database reports/Constraint violations/P7534 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 4,377 Main statement 2,217 out of 2,536 (87% complete) 50.7% of uses Qualifier 7 0.2% of uses Reference 2,153 49.2% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Type “stock market (Q475000), stock exchange (Q11691), systematic internaliser (Q91437908), Approved Publication Arrangement (Q85742512), futures exchange (Q2298435), commodities exchange (Q695817)”: item must contain property “instance of (P31)” with classes “stock market (Q475000), stock exchange (Q11691), systematic internaliser (Q91437908), Approved Publication Arrangement (Q85742512), futures exchange (Q2298435), commodities exchange (Q695817)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Type Q475000, Q11691, Q91437908, Q85742512, Q2298435, Q695817, SPARQL

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Single value, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Unique value, SPARQL (every item), SPARQL (by value)

Format “^[A-Z0-9]{4}$”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Format, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#Scope, SPARQL

Qualifiers “applies to jurisdiction (P1001), reason for deprecated rank (P2241), start time (P580), end time (P582)”: this property should be used only with the listed qualifiers. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7534#allowed qualifiers, SPARQL

FIX ALLCAPS LABELS
see Help:Label (Help)
Violations query: SELECT ?item ?l WHERE { ?item wdt:P7534 []; rdfs:label ?l. FILTER( lang(?l) ="en" && REGEX(?l,"[A-Z]{4,}") ) } LIMIT 10
List of this constraint violations: Database reports/Complex constraint violations/P7534#FIX ALLCAPS LABELS

FIX ALLCAPS DESCRIPTIONS
see Help:Descriptions (Help)
Violations query: SELECT ?item ?l WHERE { ?item wdt:P7534 []; schema:description ?l. FILTER( lang(?l) ="en" && REGEX(?l,"[A-Z]{4,}") ) } LIMIT 10
List of this constraint violations: Database reports/Complex constraint violations/P7534#FIX ALLCAPS DESCRIPTIONS

MIC Market Categories

The new MIC format has a controlled field for kind of exchange/market/facility. We need to match them to existing WD items, creating subclasses if needed.

Then record the codes as "catalog code" with qualifier "catalog=MIC". See examples:

• Approved Publication Arrangement (Q85742512)
• organised trading facility (Q87120569)
• systematic internaliser (Q91437908)
• Swap Execution Facility (Q7653780)

Here's a count in the latest MIC data:

csvtk cut -f "MARKET_CAT_CODE" ISO10383_MIC-202208.csv|sort|uniq -c

count CAT  Name
   24 APPA Approved Publication Arrangement
      ARMS Approved Reporting Mechanism
   83 ATSS Alternative Trading System
    3 CASP Crypto Asset Services Provider
      CTPS Consolidated Tape Provider
    3 DCMS Designated Contract Market
    1 IDQS Inter-Dealer Quotation System
  154 MLTF Multilateral Trading Facility
  103 OTFS Organised Trading Facility
  199 RMKT Regulated Market
    4 RMOS Recognised Market Operator
   10 SEFS Swap Execution Facility 
  298 SINT Systematic Internaliser 
    4 TRFS Trade Reporting Facility

    3      (missing)
 1640 NSPD Not Specified
    7 OTHR Other

I added this to Wikipedia: https://en.wikipedia.org/wiki/Market_Identifier_Code#Market_Categories

--Vladimir Alexiev (talk) 10:03, 24 August 2022 (UTC)