Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRTH /
avatar image
Question by ricardo.siguero · Jul 19, 2018 at 05:06 AM · intradayintraday extractionmarket datadepthendofday

Requesting Intraday prices for (inactive) instruments fails but it does not when retrieving Depth and EndOfDay data

Hi,

We are retrieving intraday/end-of-day/depth prices for the same instrument list and time interval (11th of June)

As we were not getting data from the intraday-data access, we had a look at its related Notes file, that indicated that some of the instruments from that list were inactive (i.e. ALFAA.MX)

Manifest: #RIC,Domain,Start,End,Status,Count
Manifest: ALFAA.MX,Market Price,,,Inactive,0
Manifest: CREAL.MX,Market Price,,,Inactive,0
Manifest: EUR2WV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: EUR3WV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: EURMXN=,Market Price,2018-06-10T22:20:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,196
Manifest: EURMXNTNV=,Market Price,2018-06-11T05:45:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,195
Manifest: EURTNV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: FHIPO14.MX,Market Price,,,Inactive,0
Manifest: FUNO11.MX,Market Price,,,Inactive,0
Manifest: LABB.MX,Market Price,,,Inactive,0
Manifest: MEGACPO.MX,Market Price,,,Inactive,0
Manifest: MXN2MV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXN2WV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXN3MV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXN3WV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXN=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXNONV=,Market Price,2018-06-11T06:45:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,182
Manifest: MXNSNV=,Market Price,2018-06-10T23:45:00.000000000Z,2018-06-11T21:00:00.000000000Z,Active,256
Manifest: MXNSWV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,288
Manifest: MXNTNV=,Market Price,2018-06-10T22:00:00.000000000Z,2018-06-11T21:55:00.000000000Z,Active,287

Despite some of instruments seemed to be inactive, we retrieved end-of-day and market depth data for them and within the same time interval.

Taking the symbol ALFAA.MX as an example:

End-of-day prices

RIC,Open,High,Low,Volume,Universal Close Price,Trade Date,Trading Status
ALFAA.MX,20.88,21.28,20.47,7708645,21.14,11/06/2018,1
CREAL.MX,22.9,23.49,22.7,622590,23.28,11/06/2018,1
EUR2WV=,1.178546,1.183065,1.178145,,1.179357,11/06/2018,1
EUR3WV=,1.179549,1.184066,1.179147,,1.180333,11/06/2018,1
EURMXN=,23.9783,24.274,23.9399,,24.266,11/06/2018,1
EURMXNTNV=,23.972242,24.26712,23.937714,,24.245119,11/06/2018,1
EURTNV=,1.17732,1.181823,1.176915,,1.178126,11/06/2018,1
FHIPO14.MX,15.79,16.19,15.73,753436,16.01,11/06/2018,1
FUNO11.MX,27.9,27.97,27.82,17177658,27.95,11/06/2018,1
LABB.MX,16.67,16.9,16.51,3172784,16.61,11/06/2018,1
MEGACPO.MX,84.89,86.43,84.75,177882,85.77,11/06/2018,1
MXN2MV=,20.5238,20.8064,20.4736,,20.7901,11/06/2018,1
MXN2WV=,20.3639,20.6471,20.3159,,20.6283,11/06/2018,1
MXN3MV=,20.6245,20.9126,20.5676,,20.8962,11/06/2018,1
MXN3WV=,20.39,20.6744,20.3422,,20.65,11/06/2018,1
MXN=,20.3175,20.599,20.2678,,20.588,11/06/2018,1
MXNONV=,20.2984,20.5907,20.261,,20.5742,11/06/2018,1
MXNSNV=,20.3348,20.6021,20.2716,,20.5846,11/06/2018,1
MXNSWV=,20.341,20.6231,20.2928,,20.6065,11/06/2018,1
MXNTNV=,20.3132,20.5948,20.2649,,20.5783,11/06/2018,1

Market-depth prices

#RIC,Domain,Date-Time,GMT Offset,Type,L1-BidPrice,L1-BidSize,L1-AskPrice,L1-AskSize
ALFAA.MX,Market Price,2018-06-11T08:45:31.350936961Z,-5,Normalized LL2,,,,
ALFAA.MX,Market Price,2018-06-11T10:32:45.651010060Z,-5,Normalized LL2,20.2,2200,,
ALFAA.MX,Market Price,2018-06-11T10:32:45.651113484Z,-5,Normalized LL2,20.2,2200,20.97,3057
ALFAA.MX,Market Price,2018-06-11T13:00:00.456208155Z,-5,Normalized LL2,20.2,2200,20.95,3000
ALFAA.MX,Market Price,2018-06-11T13:00:02.780010152Z,-5,Normalized LL2,20.25,8000,20.95,3000
ALFAA.MX,Market Price,2018-06-11T13:00:03.512449553Z,-5,Normalized LL2,20.6,57,20.95,3000
ALFAA.MX,Market Price,2018-06-11T13:03:00.119452016Z,-5,Normalized LL2,20.7,150,20.95,3000
ALFAA.MX,Market Price,2018-06-11T13:03:20.971553487Z,-5,Normalized LL2,20.73,483,20.95,3000
ALFAA.MX,Market Price,2018-06-11T13:22:28.678681430Z,-5,Normalized LL2,20.74,1500,20.95,3000

Any idea about what is happening?

Thanks,

Regards,

Ricardo



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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by veerapath.rungruengrayubkul · Jul 23, 2018 at 02:51 AM

@ricardo.siguero

I have found the same result. However, if the date has been changed to 2018-06-18, the data is generated properly so this likely is not API issue. Raw tick data generated from the TickHistoryRaw report template also indicates that there was data provided that day and the timestamp was the same as the Market Depth report template. This could be TRTH content issue.

Please contacting the TRTH support team directly at https://my.thomsonreuters.com/ContactUsNew .

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

Related Questions

Download market depth day by day

Consecutive intraday-data extractions differ in their contents (TRTHv2)

Field for accessing intraday bond yields

Availability of intraday price data on oil futures

Data is not returned for certain RICS - Identifier Validation Error in Intraday Summaries Extraction

  • 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