Set up the LSEG DataScope integration (formerly Reuters, then Refinitiv), which imports FX rates, interest rates, commodity prices, energy prices, bond prices, FX option data and fund prices into TS. Then map each rate or price in TS to its code at LSEG.
Before you start
- Save the DataScope login as a credential in Settings › Credentials. See Credentials and Password.
- To fetch historical data, the service must be included in your agreement with LSEG.
Steps
Open the integration
- Go to Register › Autopilot.
- In the list on the Autopilot page, select the DataScope integration.
Fill in the settings
Open the Basic tab.

Under Credentials, in CREDENTIAL ID, choose the DataScope credential.
TS logs the imports automatically, so there's no log setting to select.
- Under Historical, select FETCH HISTORICAL if you want to fetch historical data.
- For historical data, enter the first and last dates in FETCH FROM and FETCH TO.
Under Filter, select the template to use:
- FETCH END OF DAY: you get the closing prices. Depending on the currencies and the time you schedule the fetch, you get the closing rate from the last banking day, or from the same day if you fetch late.
- FETCH INTRADAY: you get a snapshot of the rates available at that moment. For intraday FX rates in a table of their own, see Intraday FX rates.
The fields each template fetches are listed under Available fields below.
Under General Settings, choose whether to select OVERWRITE ON MERGE:
- Selected: a rate is overwritten if a new one is available on the next run.
- Not selected: TS keeps the rates already imported and only fills in the ones missing from the previous run.
Map the market data
On the Mappings tab, each tab holds one kind of market data. In each row, the rate or price in TS is under SystemData, and the LSEG data under Supplier Data:
- SUPPLIER CODE: the LSEG code, the RIC.
- BID COLUMN NAME, ASK COLUMN NAME and DATE COLUMN NAME: the LSEG fields TS reads. When they're Not set, TS uses the defaults in the table.
| Tab | BID COLUMN NAME | ASK COLUMN NAME | DATE COLUMN NAME |
|---|---|---|---|
| FX | Bid Price | Ask Price | Trade Date |
| Market Data (interest rates) | Bid Price | Ask Price | Trade Date |
| Commodity | Universal Bid Price | Universal Ask Price | Trade Date |
| Bond | Bid Price | Ask Price | Trade Date |
| Fund | (none) | Universal Close Price | Trade Date |
For FX rates and interest rates, TS also fetches Universal Bid Price and Universal Ask Price. It uses them when Bid Price and Ask Price have no values.
FX rates
Map FX rates on the FX tab.

The PLN rate is a fixing, so enter Close Price in both BID COLUMN NAME and ASK COLUMN NAME.
Interest rates
Map interest rates on the Market Data tab. Some IBOR rates need a slash (/) before the RIC. Some examples:
| Rate | SUPPLIER CODE |
|---|---|
| STIBOR | /STISEK1WDFI= |
| CIBOR | /CIDKK1MD= |
| EURIBOR | /EURIBOR1MD= |
| PLN IBOR | /WIPLN3MD= |
Delayed rates
Some fixing rates used at the short end of the yield curve are published one or more days late. Market valuation needs a complete yield curve, so the delay can leave rates missing on the valuation date.
To value your positions every day, set up two separate curves for these fixing rates:
- On the Market Data tab, map both curves with the same SUPPLIER CODE.
On the curve for market valuation, enter Today in DATE COLUMN NAME.

Commodities
Map commodity prices on the Commodity tab. To set a close price on a commodity, import its price quoted against every currency you have commodity deals in.

- In Currency, choose the currency the price is quoted against.
- In Commodity, choose the commodity.
In PERIOD, enter the period:
- Cash price: enter CASH.
- Forward prices with one code for each month, such as ULSDCNWEMc1 and ULSDCNWEMc2: enter the period of each code, for example 1CMM and 2CMM.
- Forward prices with one code for several months, such as MAL 24M: leave it blank.
- In MARKET DATA TYPE, choose Commodity.
In SUPPLIER CODE, enter the code:
- Cash prices: enter a code for each cash price you need, for example MAL0 for Aluminium/USD cash and MALEUR0 for Aluminium/EUR cash.
- Forward prices for the third Wednesday ahead: enter the code and the number of months, for example MAL 24M for prices 24 months ahead. You won't find this code in DataScope.

Energy
Map energy prices on the Energy tab. Add one row for each energy and contract.
- Select Add.
- In Currency, choose the currency, for example EUR.
- In Energy, choose the energy, for example SYS, SE3 or SE2.
- In MARKET DATA TYPE, choose the type, for example Power.
In SUPPLIER CODE, enter the type of contract followed by the number of tenors, for example M2, Q3 or Y4.
In the example below, the power prices read Settlement Price in both BID COLUMN NAME and ASK COLUMN NAME.

Bonds
Map bond prices on the Bond tab.
- Select Add.
- In SUPPLIER CODE, enter the RIC.
In ISIN, enter the ISIN used in the bond's definition.

FX options
Map FX option data on the FX Options tab. Add one row for each currency pair, period and option type.
- Select Add.
- In Base Asset, choose the base currency, for example USD.
- In Price Asset, choose the price currency, for example JPY.
- In PERIOD, enter the period, for example 1W, 1M or 1Y.
- In PUT OR CALL, choose the option type, for example Call.
- In MARKET DATA TYPE, choose FxOption.
In SUPPLIER CODE, enter the LSEG code for the currency pair and period, for example USDJPYV1W for USD/JPY 1W, USDJPYV3M for 3M and USDJPYV1Y for 1Y.

Funds
Map fund prices (NAV) on the Fund tab.
- Select Add.
- In MARKET DATA DEFINITION, choose the fund.
In SUPPLIER CODE, enter the code.

Available fields
The LSEG fields each template fetches, for use as column names:
| LSEG field | End of day template | Intraday template |
|---|---|---|
| RIC | Yes | Yes |
| Ask Price | Yes | Yes |
| Universal Ask Price | Yes | Yes |
| Bid Price | Yes | Yes |
| Universal Bid Price | Yes | Yes |
| Low Price | Yes | Yes |
| High Price | Yes | Yes |
| Mid Price | Yes | Yes |
| Universal Close Price | Yes | No |
| Trade Date | Yes | Yes |
| Expiration Date | Yes | Yes |
| Universal Close Price Date | Yes | No |
| Previous Close Price | No | Yes |
| Previous Close Date | No | Yes |
| Primary Activity | No | Yes |
| Secondary Activity | No | Yes |
| Bid Yield | Yes | Yes |
| Settlement Price | Yes | Yes |
| Last Price | No | Yes |
| Close Price | Yes | No |
| Lot Size | Yes | Yes |
| Yield | Yes | No |
| Close Yield | No | Yes |