How to extract all LIBOR rates(USD, GBP, CHF, EUR, JPY) with all 7 different maturities(Overnight...

How to extract all LIBOR rates(USD, GBP, CHF, EUR, JPY) with all 7 different maturities(Overnight, 1 week, 1 month, 2 month, 3 month, 6 month, 12 month) by sending request to DSS REST API? Please give an example, urgent.

Find more posts tagged with

dss

rest-api

dss-rest-api

datascope-select

Accepted answers

veerapath.rungruengrayubkul

@beatgtech

The rates and maturities could be identified using RIC name. For example, USD overnight rate, the RIC should be on USDONFSR=. If the extraction takes tool long to complete, it possibly is due to embargo. Please find more information in this tutorial.

Anyway, you can try the /LIBOR=which is delayed RIC. The delayed RIC is not affected by embargo.

Below is the request sample.

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "Last Price",
            "Trade Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "IdentifierType": "ChainRIC",
                    "Identifier": "/LIBOR="
                }
            ]
        }
    }
}

All comments

veerapath.rungruengrayubkul

Hi @beatgtech,

You can use chain RIC: LIBOR= to extract all LIBOR rates. Below is the sample of request.

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames": [
            "Bid Price",
            "Ask Price"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "IdentifierType": "ChainRIC",
                    "Identifier": "LIBOR="
                }
            ]
        }
    }
}

beatgtech

What field names should be used for referencing to rates on 7 different maturities?

beatgtech

The request takes a very long time to complete....

veerapath.rungruengrayubkul

@beatgtech

Anyway, you can try the /LIBOR=which is delayed RIC. The delayed RIC is not affected by embargo.

Below is the request sample.

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "Last Price",
            "Trade Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "IdentifierType": "ChainRIC",
                    "Identifier": "/LIBOR="
                }
            ]
        }
    }
}

beatgtech

all fields are null...

These are LIBOR rates I queried from other websites. So what the request template should be if I want to retrieve today or yesterday LIBOR rates (in 7 maturities (from overnight to 12 months) and in 5 different currencies mentioned in the question) ?

EXPLORE OUR SITES