Financial Instruments Reference Database System

File:FIRDS ecosystem.svg

The Financial Instruments Reference Database System (FIRDS) is published by the European Securities and Markets Authority (ESMA) and lists meta-information to all financial instruments included in the scope of MiFID II. This reference data is necessary to find metadata on a given financial instrument, uniquely identified by a so-called International Securities Identification Number (ISIN).{{Cite web |title=Mastering Data Analytics: Insights & Techniques |date=24 August 2023 |url=https://www.prodigitalweb.com/data-analytics/ |access-date=2023-11-10 |language=en-US}}

Regulation

The Article 4(1)(20) of Directive 2014/65/EU (MiFID II) considers "investment firms dealing on own account when executing client orders over the counter (OTC) on an organised, frequent, systematic and substantial basis" systematic internaliser and requires them to report their trades.{{Cite web |date=2023-12-11 |title=Advanced Algorithms to Identify Optimal Market Conditions |url=https://forexobot.com/ |access-date=2024-05-24 |language=en}} From this data, ESMA computes on a best effort basis, the total volume and number of transactions executed within the EU.

Technical details

According to the technical specification,{{cite web |last= |title=Financial Instruments Reference Data System (FIRDS) |url=https://www.esma.europa.eu/system/files_force/library/esma65-8-5014_firds_-_instructions_for_download_of_full_and_delta_reference_files.pdf?download=1 |publisher=European Securities and Markets Authority |accessdate=30 August 2018 |archive-date=30 August 2018 |archive-url=https://web.archive.org/web/20180830210203/https://www.esma.europa.eu/system/files_force/library/esma65-8-5014_firds_-_instructions_for_download_of_full_and_delta_reference_files.pdf?download=1 |url-status=dead}} new entries are published on a daily basis, every morning by 09:00 CET as XML-file. It contains the ISIN and the Market Identifier Code (MIC) as well as e.g. the Classification of Financial Instruments (CFI)-code and other information of the instrument.

The Legal Entity Identifier (LEI) code is conveyed by the ISSR. In the following example record in JSON format,{{cite web |title=Importing nested JSON documents into Elasticsearch and making them searchable |url=https://stackoverflow.com/questions/56293134/ |website=Stackoverflow |accessdate=14 June 2019}} the ISSR is represented by "Issr" : "851WYGNLUQLFZBSYGB56". This LEI code can be looked up using the [https://search.gleif.org/#/search/ website search].{{Cite web |title=LEI Search |url=https://search.gleif.org/#/record/851WYGNLUQLFZBSYGB56 |access-date=2023-11-10 |website=search.gleif.org}} The LEI code corresponds to Commerzbank Aktiengesellschaft (Frankfurt) according to the LEI Registration Exception.

{

"RefData": {

"DebtInstrmAttrbts": {

"NmnlValPerUnit": "2000",

"IntrstRate": {

"Fxd": "3.1415"

},

"MtrtyDt": "2020-01-01",

"TtlIssdNmnlAmt": "200000000",

"DebtSnrty": "SNDB"

},

"TradgVnRltdAttrbts": {

"IssrReq": "false",

"Id": "BMTF",

"FrstTradDt": "2019-04-01T12:34:56.789"

},

"TechAttrbts": {

"PblctnPrd": {

"FrDt": "2019-04-04"

},

"RlvntCmptntAuthrty": "GB"

},

"FinInstrmGnlAttrbts": {

"ClssfctnTp": "DBFNXX",

"ShrtNm": "AVGO 3.625 10/16/24 c24 (URegS)",

"FullNm": "AVGO 3 5/8 10/15/24 BOND",

"NtnlCcy": "USD",

"Id": "USU1109MAXXX",

"CmmdtyDerivInd": "false"

},

"Issr": "851WYGNLUQLFZBSYGB56"

}

}

See also

References

{{Reflist}}