Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by FIS FastVal · Oct 21, 2019 at 10:41 AM · ricsintradayextraction on demandintradaypricingextractionrequestintraday pricing

No data for most RICs with Intraday Pricing Request

I am using the DSS API SDK with a C# client app to request intraday prices for a number of RICs. The only RIC I get any data for is SONIAOSR=. For all the other RICs, I get a valid response, the fields I have requested data for come back blank. Could it be an entitlement issue? I believe we are supposed to be entitled for the following RICs:

EONIA=

SONIAOSR=

USONFFE=

CORRA=

HONIA=

JPONMU=RR

NZCASH=BRNZ

SORA=MAST

IRONDFIX=FBIL

SARON.S

AUCASH=RBAA

USDSOFR=

I have tried sending the same request, just changing the Indentifier member of the InstrumentIdentifier class, requesting ContentFieldNames "Official Close Date" and "Official Close Price", but only the request with Identifier "SONIAOSR=" returns any data.

Our username is 9023715.

Below is a code snippet of the request, for example, for USDSOFR=; returns blank data. Exactly the same request for "SONIAOSR=" returns data for the fields requested:


identifiers[index] = new InstrumentIdentifier

{

IdentifierType = IdentifierType.Ric,

Identifier = "USDSOFR="

};

string[] fieldNames = { "Official Close Date", "Official Close Price" };

IntradayPricingExtractionRequest extractionRequest = new IntradayPricingExtractionRequest

{

IdentifierList = InstrumentIdentifierList.Create(identifiers),

ContentFieldNames = fieldNames

};

. . .

ExtractionResult extractionResult = extractionsContext.ExtractWithNotes(extractionRequest);


People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Oct 21, 2019 at 01:14 PM

@FIS FastVal,

There are many things to look at here. Let me go through them ...

There might be a permissioning issue, especially as this is an intraday request. You can easily check that in the extraction notes. As an example, when I ran your call, as I am not permissioned for real-time for SWR (i.e. SARON.S), I got this in the extraction notes:

Embargo delay of 1439 minutes required by SWR (SIX SWISS EXCHANGE REFERENCE RATES) for quotes from SWX\r\nThe last report will be embargoed until 22102019 12:39:00 (1439 minutes) due to quote: RIC,SARON.S,SWX

The extraction notes might give you other messages, depending on the permissions of your account.

Invalid RICs: these 2 are not found (I cannot find them in Eikon either):

  • NZCASH=BRNZ (This one is valid: NZCASH=RBNZ; could this be a typo in your list ?)
  • IRONDFIX=FBIL

Data availability: for an intraday request to deliver data, the instrument must have been quoted during the current day, which might not be the case for all instruments in a list. And for a closing price to be available, the market must have closed today. You could try adding the following 2 fields to your request: "Previous Close Date", "Previous Close Price". When I did that I got a previous day price for: USONFFE=, JPONMU=RR and SORA=MAST.

Choice of fields: I am not a data specialist, but maybe there are other closing price fields you could request, depending on your use case ?

Choice of endpoint: why use an intraday request (which is meant to retrieve a snapshot of current day prices) to retrieve closing prices ? If you only need the closing price you might use an End of Day or Price History request. As an example, here is the body of an EoD request (in Postman), to which I added the Universal Close Price (I added that field to increase the chance of getting data, but please note that I'm not a data specialist, I do not know the difference between the Official and Universal close price):

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
    "ContentFieldNames": [
      "RIC", "Official Close Price", "Previous Close Price", "Universal Close Price"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
          { "Identifier": "EONIA=", "IdentifierType": "Ric" },
          { "Identifier": "SONIAOSR=", "IdentifierType": "Ric" },
          { "Identifier": "USONFFE=", "IdentifierType": "Ric" },
          { "Identifier": "CORRA=", "IdentifierType": "Ric" },
          { "Identifier": "HONIA=", "IdentifierType": "Ric" },
          { "Identifier": "JPONMU=RR", "IdentifierType": "Ric" },
          { "Identifier": "NZCASH=RBNZ", "IdentifierType": "Ric" },
          { "Identifier": "SORA=MAST", "IdentifierType": "Ric" },
          { "Identifier": "IRONDFIX=FBIL", "IdentifierType": "Ric" },
          { "Identifier": "SARON.S", "IdentifierType": "Ric" },
          { "Identifier": "AUCASH=RBAA", "IdentifierType": "Ric" },
          { "Identifier": "USDSOFR=", "IdentifierType": "Ric" }
      ]
    }
  }
}

Here is the result:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "EONIA=",
            "RIC": "EONIA=",
            "Official Close Price": null,
            "Previous Close Price": -0.463,
            "Universal Close Price": -0.462
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "SONIAOSR=",
            "RIC": "SONIAOSR=",
            "Official Close Price": null,
            "Previous Close Price": 0.7107,
            "Universal Close Price": 0.7101
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "USONFFE=",
            "RIC": "USONFFE=",
            "Official Close Price": null,
            "Previous Close Price": 1.9,
            "Universal Close Price": 1.85
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CORRA=",
            "RIC": "CORRA=",
            "Official Close Price": null,
            "Previous Close Price": null,
            "Universal Close Price": 1.7366
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "HONIA=",
            "RIC": "HONIA=",
            "Official Close Price": null,
            "Previous Close Price": 1.13503,
            "Universal Close Price": 1.24747
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "JPONMU=RR",
            "RIC": "JPONMU=RR",
            "Official Close Price": null,
            "Previous Close Price": -0.045,
            "Universal Close Price": -0.031
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "NZCASH=RBNZ",
            "RIC": "NZCASH=RBNZ",
            "Official Close Price": null,
            "Previous Close Price": null,
            "Universal Close Price": 1
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "SORA=MAST",
            "RIC": "SORA=MAST",
            "Official Close Price": null,
            "Previous Close Price": 1.2586,
            "Universal Close Price": 1.3364
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "SARON.S",
            "RIC": "SARON.S",
            "Official Close Price": null,
            "Previous Close Price": -0.73652,
            "Universal Close Price": -0.737191
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "AUCASH=RBAA",
            "RIC": "AUCASH=RBAA",
            "Official Close Price": null,
            "Previous Close Price": 0.75,
            "Universal Close Price": 0.75
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "USDSOFR=",
            "RIC": "USDSOFR=",
            "Official Close Price": null,
            "Previous Close Price": 2.05,
            "Universal Close Price": 1.95
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "IRONDFIX=FBIL",
            "Error": "Not found"
        }
    ],
    "Notes": [
        "Extraction Services Version 13.1.40889 (ec84d57d2aa3), Built Aug  9 2019 18:16:31\r\nHoliday Rollover of Universal Close Price waived.\r\nUser has overridden estimates broker entitlements.\r\nProcessing started at 21102019 14:46:26.\r\nUser ID: 33314\r\nExtraction ID: 392590091\r\nSchedule: _OnD_0x06d60862e4a10c2a (ID = 0x06d60862e8d10c2a)\r\nInput List (11 items): _OnD_0x06d60862e4a10c2a (ID = 06d60862e6710c2a) Created: 21102019 14:46:24 Last Modified: 21102019 14:46:25\r\nSchedule Time: 21102019 14:46:25\r\nReport Template (10 fields): _OnD_0x06d60862e4a10c2a (ID = 0x06d60862e4e10c2a) Created: 21102019 14:46:24 Last Modified: 21102019 14:46:24\r\nProcessing completed successfully at 21102019 14:46:26, taking 0.438 Secs.\r\nExtraction finished at 21102019 12:46:26 UTC, with servers: x11n01, QSHC18 (0.0 secs), QSSHA1 (0.0 secs)\r\nUsage Summary for User 33314, Client 11122, Template Type EOD Pricing\r\nBase Usage\r\n        Instrument                          Instrument                   Terms          Price\r\n  Count Type                                Subtype                      Source         Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n      1 Money Market                                                     N/A            European Money Markets Institute (EMMI)\r\n     10 Money Market                                                     N/A            N/A\r\n-------\r\n     11 Total instruments charged.\r\n      0 Instruments with no reported data.\r\n=======\r\n     11 Instruments in the input list.\r\nNo TRPS complex usage to report -- 11 Instruments in the input list had no reported data.\r\nWriting RIC maintenance report.\r\n",
        "Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
    ]
}

If we ran this one closer to the end of the day today (after markets close) I guess we would get values for the Official Close Price.

I suggest you experiment in Postman to better understand what results you will get before coding in C#, you might gain some time.

Again, I am not a data specialist, and I'm making guesses as to what you are trying to achieve, so I hope my explanations can help you understand the nature of the calls, and their impact on the resulting data. To better understand the differences between the different closing prices, I strongly suggest you ask a data specialist, by opening a content-related enquiry via MyRefinitiv or by calling the Refinitiv Help Desk directly.

Comment
FIS FastVal

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by FIS FastVal · Oct 21, 2019 at 02:11 PM

Thanks for your detailed response @Christiaan Meihsl. You're right, it was basically just an issue with requesting data for fields where data isn't actually available. I was also advised by a support representative to use the fields 'Trade Date' and 'Primary Activity', which both return data. Apologies for the typos in the original post - you're right again, it should have been 'NZCASH=RBNZ' and 'INRONDFIX=FBIL'. The only ones I'm failing to get any data for now are 'EONIA=' and 'SARON.S' but from what you've said, it looks as though the latter of these at least is down to a permissioning issue.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by FIS FastVal · Oct 21, 2019 at 02:39 PM

RE: choice of Intraday requests, what we're actually trying to do here is retrieve the latest available published rates for these indices. I only chose to use 'Official Close Price' because I couldn't see any more suitable field (I tried 'Last Price' but it yielded no data).

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Given a Ric, how do I find the currency using the Rest API?

Intraday history for the current day.

At what time Datascope has intraday data available for the current day? It is market dependent? Or it is always after midnight?

Delay Request using DSS

On demand extraction via HTTP requests with list and template ids?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges