How would I find all RICS with Certificate of Deposit filtered to USD issued currency and country...

Options
jason.koulouras
jason.koulouras Newcomer
in Refinitiv Data Platform

... of issuer the United States (I would like to use RDP API, not Eikon AS) Thanks

Using RDP API Playground. I thought this might work but alas RIC is not an acceptable parameter:


"View": "Quotes",

"Query": "CERTIFICATE OF DEPOSIT",

"Top": 10000,

"RIC": "%US%",

"Skip": 0

Thanks in advance

Jason

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @jason.koulouras

    Thanks for reaching out to us.

    Yes, RIC is not a valid parameter. You can use it in the Filter, as shown below.

    {
      "View": "Quotes",
      "Query": "CERTIFICATE OF DEPOSIT",
      "Select": "DocumentTitle, RIC,BusinessEntity,RCSIssuerCountry,RCSIssuerCountryName",
      "Filter": "startswith(RIC,'US')"
    }

    Otherwise, you can try the following query.

    {
      "View": "Quotes",
      "Query": "CERTIFICATE OF DEPOSIT",
      "Select": "DocumentTitle, RIC,BusinessEntity,RCSIssuerCountry,RCSIssuerCountryName,RCSCurrency,RCSCurrencyName",
      "Filter": "RCSIssuerCountry eq 'G:6J' and RCSCurrency eq 'C:6'"
    }

    You can use the https://api.refinitiv.com/discovery/search/v1/metadata/views/Quotes to get the list of properties in the Quotes view.

    1679978470784.pngMoreover, you can refer to the Reference tab regarding how to use this endpoint.

    I hope that this information is of help.

Answers

Categories