Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Refinitiv Data Platform /
avatar image
Question by XINGTIAN.XU · Mar 24 at 02:19 PM · datascope-selectdatastream-api

Closing auction imbalance data via API

I'm trying to pull end of day imbalance/closing auction information. Below is an example that I would scale for additional tickers (.NOI and .ITC) and FIDs. I am receiving the following message: Extraction notes: All identifiers were invalid. No extraction performed. I've tried to look at other questions but still seem to be missing something. Below is my JSON. Appreciate your help.

{

"ExtractionRequest": {

"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",

"IdentifierList": {

"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

"InstrumentIdentifiers": [

{

"Identifier": "IBM.NOI",

"IdentifierType": "Ric"

},

{

"Identifier": "JNJ.NOI",

"IdentifierType": "Ric"

}

]

},

"Condition": {

"MessageTimeStampIn": "LocalExchangeTime",

"ReportDateRangeType": "Range",

"TimeRangeMode": "Window",

"QueryStartDate": "2021-12-01T10:15:00.000Z",

"QueryEndDate": "2021-12-31T16:00:00.000Z",

"DomainCode": "MarketPrice",

"Fids": "4334, 4335, 4336",

"FidListOperator": "OR",

"FidDisplayOption": "Matching",

"ExtractBy": "Ric",

"DisplaySourceRIC": 'false'

}

}

}

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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Gurpreet · Mar 24 at 03:06 PM

Ok, for Historical instrument, you will have to specify that as such. Please use this query:

{
  "ExtractionRequest": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
    "IdentifierList": {
      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
          "Identifier": "IBM.NOI",
          "IdentifierType": "Ric"
        }, {
          "Identifier": "JNJ.NOI",
          "IdentifierType": "Ric"
        }
      ],
      "ValidationOptions": {
        "AllowHistoricalInstruments": true
      },
    },
    "Condition": {
      "MessageTimeStampIn": "LocalExchangeTime",
      "ReportDateRangeType": "Range",
      "TimeRangeMode": "Window",
      "QueryStartDate": "2021-12-01T10:15:00.000Z",
      "QueryEndDate": "2021-12-31T16:00:00.000Z",
      "DomainCode": "MarketPrice",
      "Fids": "4334, 4335, 4336",
      "FidListOperator": "OR",
      "FidDisplayOption": "Matching",
      "ExtractBy": "Ric",
      "DisplaySourceRIC": 'false'
    }
  }
}


I am unable to get Auction Imbalance data due to permission issues with my ID:

Historical Instrument <RIC,IBM.NOI> expanded to 1 RIC: IBM.NOI.
Historical Instrument <RIC,JNJ.NOI> expanded to 1 RIC: JNJ.NOI.
Total instruments after instrument expansion = 2

Range Query from 2021-12-01T15:15:00.000 to 2021-12-31T21:00:00.000 (UTC)
Query window is 15:15:00.000 to 21:00:00.000 (UTC)
(RIC,IBM.NOI,)  row suppressed for lack of 'NOI (NYSE ORDER IMBALANCE)' permission.
(RIC,JNJ.NOI,)  row suppressed for lack of 'NOI (NYSE ORDER IMBALANCE)' permission.
Report suppressed because no instruments are permitted


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
REFINITIV
Answer by Gurpreet · Mar 24 at 02:32 PM

Hi @XINGTIAN.XU,

I can't find any securities for IBM.NOI or JNJ.NOI. Did you mean IBM.N and JNJ.N?


1648132315791.png


1648132315791.png (31.0 KiB)
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 XINGTIAN.XU · Mar 24 at 02:37 PM

I believe I see this. Similar for JNJ. These are two of the identifiers I used when going through the online GUI without issue.

1648132580753.png


1648132580753.png (17.5 KiB)
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 XINGTIAN.XU · Mar 24 at 03:18 PM

Ah, I see now. Thank you.

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 >
9 People are following this question.

Related Questions

Pull data from datastream

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • FX Venues
    • FX Trading – RFQ Maker
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • Yield Book Analytics
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges