Refinitiv security mapping
This mapping is used for all security types. The mapping is used in Tools → Create security → Refinitiv.
Mapping name: mapping.refinitiv
Updated fields
Security code
ISIN
Type
Sub type
Market place
Country
Currency
Status
Name
Trade code
Update code
Number of outstanding shares
Holiday calendar
Settlement date offset
Issue Price
Maturity Date
Multiplier
Coupon Frequency
First Coupon Date
Maturity Price
Call Date
Issue Date
Mapping table
Source field | Target field | Description |
|---|---|---|
Tags | Adds Reference data-Refinitiv equity tag | |
RIC | Security code | Reuters Instrument Code |
ISIN | ISIN code | |
CFI Code | Type | The first character of the CFI Code |
CFI Code | Sub type | First two characters of the CFI Code |
Market MIC | Marketplace | |
Country of Register Code | Country | |
Currency Code | Currency | |
Status | Sets the status as ACTIVE | |
Official Name | Name | |
RIC | Trade code | |
RIC | Update code | |
Total Shares - Default | Total outstanding amount | |
Holiday calendar | Based on the marketplace | |
Settement Days | Settlement date offset | |
Issue Price | Issue price | |
Maturity Date | Maturity date | |
Maturity Redemption Price | Multiplier, Multiplier 2, Maturity price | If no value is available, 100 is used for debt instruments |
Coupon Frequency | Coupon frequency | |
First Coupon Date | First coupon date | |
Next Call Date | Call date | |
Issue Date | Issue date |