Skip to content
All library documents

Limits of AI for Mapping RICs to Bloomberg Tickers

Article Quant Q&A · Author: Adam Software
Read the original

Summary

The document discusses whether AI can map Reuters Instrument Codes to Bloomberg tickers and describes practical obstacles to building such a system. Training examples may require licensed identifier data and substantial manual preparation, while full market coverage could depend on costly vendor services. Rules can vary by asset and series, so a few worked examples may not generalize across instruments.

Mappings also change as new securities and contracts are added, amended, or removed. The answer says updates arrive through exchange and vendor data notifications, and that data for a new series may not exist until trading begins. These timing and coverage issues create a need for ongoing human review and production testing. Identifier availability varies by region and asset class: ISINs can help with European equities but are not broadly available for Asian instruments or North American futures and options. Indices pose a particular risk because descriptions may refer to variants with different prices. The exchange offers cautionary experience, not a measured comparison of AI and rule-based accuracy.

Key ideas

  • RIC-to-Bloomberg mapping may require licensed reference data and extensive in-house training examples.
  • New, amended, and discontinued instruments make mappings an ongoing maintenance task.
  • Identifier coverage differs across regions and asset classes, limiting the usefulness of ISINs as a universal key.
  • Index variants can be difficult to distinguish, and a mismatch may lead to trading or evaluating the wrong instrument.
  • The responses recommend human oversight and production testing but provide no comparative accuracy results for AI tools.

Tags

EquitiesFuturesOptionsMarket microstructure
Full text
# Using AI tools to map RIC to Bloomberg ticker


# Using AI tools to map RIC to Bloomberg ticker












Has anyone tried to map RIC to Bloomberg tickers using AI tools: ChatGPT, Gemini, Claude?

## Answer by Greg Martin (score 0, accepted)

https://quant.stackexchange.com/a/85508

Yes ISINs should work for Europe, but ISINs are not used on Asian exchanges or North American Futures & Options exchanges. For these you are back to manual work.

Note that new series are added, deleted and amended daily (the vendors and exchanges publish dozens of Data Notifications each day which must be read and interpreted). Even if the AI tool can cope with new series, can you release it to production without testing?

Which brings us to the third issue of timing: the “training data“ isn’t available until the day it starts to trade. New mapping rules need to be established from the Data notifications.

I doubt all of this can be done without a human oversight, and for the cost of human oversight you can probably build and maintain the mapping algorithm without the AI tools, reducing the risk and cutting out the testing phase.

## Answer by George Martin (score 0)

https://quant.stackexchange.com/a/85506

The first problem you will encounter is building the Training data as the RIC is copyrighted and licensed. You will need to build the training data in-house and ensure you have the appropriate license from the data vendors.

If you want to map all exchange data rather than a subset, you will need both Bloomberg Back-office and LSEG Datascope Plus: both very expensive annual subscription services

Then you will have to provide worked examples of each transformation for each asset, and maybe each series!

Option > RIC MSFTL172724000.U Bloomberg ticker MSFT US 12/17/27 C240 Equity

Future > RIC FLGU6 Bloomberg ticker G U6 Comdty

Building the training data could be as big a job as establishing the rules themselves

## Answer by Greg Martin (score 0)

https://quant.stackexchange.com/a/85791

ISINs are great for Europe - but are licensed in North America (CUSIP-based,which is owned by CGS). ISINs are not used in Asia much at all.

Equities are the easiest asset class to map via ISIN. Indices are the hardest (no ID, just a brief description)

Indeed Indices provide a good example of the worst case scenario - Mismap and you're trading the wrong instrument, or evaluating the ETF against the wrong Index.

e.g. MSCI index has a base series ID e.g.105765 But there are 6 variants of this index - all with different closing prices: Price, Gross, Net,Short & Leveraged, Daily Hedged, FX Hedged

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.