Reference Data Management in Banking
Reference Data Management in Banking
Management
Agenda
Words
Numbers
Pictures
• AlphaSense
• Bloomberg L.P.
• Cbonds
• CQG
• Dealogic
• Eurekahedge
• FactSet
• Fidessa • Mergermarket
• FIS (SunGard) • [Link]
• ICE Data Services • Moody's Analytics
• Interactive Data Corporation • Morningstar, Inc.
• IRESS • NYSE Technologies
• Markit • Preqin
• Quandl
• S&P Capital IQ
• SIX Financial Information
• Thomson Reuters
• TraderMade
• Vela Trading Technologies
Private and Confidential 7
Building blocks
Types of Data
Types of Data
Static/Reference Market/Streaming
Data Data
STP enables the whole trade process for capital markets and the payments to be conducted
electronically without the need for manual intervention.
Private and Confidential 10
List of Counterparty Static Data
2
Authorized Credit Limits
3 Standard Settlement
Instructions
4
Date of Account Set up
4
Type of Institution
5
Tax Status
6
Registered Representatives
1 Middle Office
The MO forwards request to
2
Front Office requests for Compliance via email
Front Office
new account via email
Compliance
3
Compliance checks client info
4 for accuracy and completeness
Client
Compliance verifies details
If information is missing, Compliance seeks from client, approves request
all details along with the relevant 5
and forwards to RDM team
documents as applicable under the KYC via e-mail
and AML norms.
Client updates and sends back the same.
Ref Data Team
The RDM team opens
6 account in RDM
Middle Office
1 2 The MO forwards request to the
RDM Team
Front Front Office requests for
Office new trading account
Middle Office
1 The MO forwards this request
2 via web form to the RDM team.
Client Client sends request to set up
standard settlement
instructions via email.
Alternative/
Type of
Currency Maturity Date External
Instrument
References
03 04
01 02
SYMBOL/
TICKER/
ISIN CUSIP CINS
STOCK
SYMBOL
08 07 06 05
BLOOMBERG VALOREN
RIC SEDOL
GID
Examples
Usually it is uncommon to see ticker symbol for fixed income security as it is mostly traded
over the counter.
Private and Confidential 21
International Securities Identification Number (ISIN)
A global uniform unique code that identifies instruments to facilitate cross-border trading.
US 049580485 1 US0495804851
CUSIP
A nine-digit numeric
identifier, called the If a national number is The numeric identifier
National Securities composed of less than has no intrinsic
Identifying Number nine digits, it is padded meaning it is essentially
(NSIN), and assigned by with leading zeros to a serial number.
each country’s or region’s become a NSIN.
National Numbering
Agency (NNA).
Some European countries have adopted ISINs as their primary security identifier.
ISIN are implicitly used in the U.S. and Canada because they are built upon CUSIP numbers.
The [Link] is the CUSIP Global Services (cusips are owned by the American
Bankers Association and managed by Standard & Poor’s) and its NSIN is a
CUSIP number.
The Stock Exchange Daily Official List (SEDOL) is used as the NSIN source,
issued by the country’s NNA, the London Stock Exchange.
Indian ISINs are managed by the Securities and Exchange Board of India.
Classification of
Financial Instruments
Standardized
Universally recognized (CFI)
descriptions
identification codes to group
for up to 50 data
for more than 9.1 million instruments with similar
attributes for over 6
unique financial features; for example, the
million securities offered
instruments. CFI codes for equities
in the U.S. and Canada.
include instrument
groups such as shares,
preferred stock, mutual
funds and UITs.
Allows various
Custodians and
market participants If you own a
sub-custodians to
to easily identify Depositories to
easily communicate
and access issue- accurately manage
on securities
specific data. transactions and
transactions.
examine historical
data.
CGS CUSIPs are 9-character identifiers that capture an issue’s important differentiating
characteristics within a common structure. It is issued for financial instruments offered in
the U.S. and Canada.
023135 10 6 023135106
First 6 Characters Next 2 Characters
identifies the identifies the type
unique of the: of Instrument: Next 1 Character
The mathematical
• Company • Debt formula checks the
• Muncipality • Equity accuracy of the Resulting 9
• Government previous 8 Characters -
Agency Uniquely identifies characters A unique
the issue within Identifier
A hierarchical the issuer Delivers as one
alpha numeric character check
convention linked A hierarchical result.
to alphabetic alpha numeric
issuer name convention.
G 0052B 10 5 G0052B105
Next 1
First Characters Next 2
Next 5 Character
identifies the Characters
Characters The
unique of the identifies the
combined mathematical
territory type of
with country formula Resulting 9
code uniquely Instrument checks the Characters -
CGS rule based
identifies the accuracy of A unique
engine governs Uniquely
issuer the previous 8 Identifier
designation identifies the characters and
In this case: issue within
In this case: delivers 1
G=United the issuer
Abingdon character
Kingdom
result.
Private and Confidential 38
CGS ISIN
A global uniform unique code that identifies instruments to facilitate cross-border trading.
US 023135106 7 US0231351067
CUSIP
JM P19231102 6 JMP192311026
CINS
Stock Exchange Daily Official List SEDOL codes are now issued to all
(SEDOL) is a seven-Character countries for both listed and unlisted
identification number traditional instruments covering all asset classes.
used for securities traded in UK and It serves as a unique country level
Ireland generated by the London identifier. This facilitates the issue of
stock exchange. UK ISINs.
SEDOL
SEDOLs issued prior to January 26, After January 26, 2004, SEDOLs
2004 were composed only of were changed to be alpha-numeric
numbers. and are issued sequentially,
beginning with B000009.
• SEDOLs issued to Asia and Africa
typically begin with 6. At each character position numbers
• SEDOLs issued to UK and Ireland precede letters and vowels are
(until Ireland joined the EU) never used. All new SEDOLs,
typically begin with 0 or 3. therefore, begin with a letter. Ranges
• SEDOLs issued to Europe beginning with 9 are reserved for
typically began with 4, 5, or 7. end user allocation.
• SEDOLs issued to Americas began
with 2.
It is responsible for
allocating Swiss security
identification numbers
known as valoren
numbers. It is typical six
to nine digits in length.
These numbers are similar to the CUSIP numbers that are used in Canada and the U.S
.
In Switzerland and Liechtenstein, the VALOR number is the main identifier in the Swiss
Value Chain. It is used as the main identifier by financial institutions throughout Europe.
Bloomberg is a financial software, data and media company headquartered in New York
City. It was founded by Michael Bloomberg in 1981.
It provides financial software tools such as an analytics and equity trading platform, data
services and news to financial companies and organizations through the Bloomberg
terminal.
Private and Confidential 48
Bloomberg Global ID (BBGID)
The end-of-day pricing data covering around 120 markets and exchanges and is
delivered to clients after the markets close.
Is provided at
regular intervals Is also provided
Is provided to
during the with details of
clients from a
business day for dividend and
broad range of
Investment security
global sources at
mangers to make information for by
a varying speeds.
an informed certain Exchange.
decisions.
Common and
Options and
preferred stock,
futures contracts
rights, warrants, and
1 depositary receipts 2
Indices and
market indicators Data items
7 8
The prices US OTC securities are sourced from a range of sources as under:
Common
Rights Warrants units
stock
Pricing vendor provide pricing data for OTC securities according to the following:
01 02 03 04
Client Data Organizational Product Data Calendar Data
Data
Is useful in getting Is useful in trading, Is useful in
clients on-boarded , dealing, risk maintaining trade
Is useful to maintain management, and settlement
that helps the bank
the books, legal settlements and other holidays within
to book and process
entities and general back office functions systems to help the
trades. Included
ledgers for financial such as instruments settlement process
counterparty data,
reporting. data, corporate action include holiday data
SSI data, payment
instructions etc. data, pricing data and and settlement dates.
intra day prices.
Workflow of RDM
• Malicious trading
• Confirmations to
• Opening bank
wrong parties • Payments to wrong
systems to
• Data privacy parties
unwanted audience
breach • Loss due to interest
• Non- compliance to
• Compliance issue claims
regulatory
• Client dis- • Reputational
authorities
satisfaction damage
• Heavy fined levied
• Reputational
• Reputational
damage
damage
In Class Activity
In Class Activity
Please find the below details of the following Securities:
• Apple Shares
• Apple Bonds
• Berkshire Hathaway Inc. Class A Shares
• HDFC Bank Shares
• HDFC Bank Basel III Perpetual Bonds Series
In Class Activity
Details to find out:
Name of Security:
Security Type:
Current Price:
ISIN:
CUSIP:
SEDOL:
Issued Currency:
Coupon Rate:
Coupon Frequency :
Learn more:
[Link]
Email us:
info@[Link]
Visit us:
Mumbai | Thane | Pune | Bangalore | Delhi - NCR |
Hyderabad | Chennai | Coimbatore