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 jwaldron · Nov 15, 2020 at 01:20 PM · tickhistoryv2datascope

How to fetch both TS data as well as Level2 data in Datascope

I'm trying to get L2 data, while at the same time retain Time and Sales for futures markets... looking at ExtractionRequest type TickHistoryRawExtractionRequest ... As far as I can tell this can't be done... for the MarketByPrice and MarketByOrder Domains, it seems you get a Delete message, but I don't see a definitive way to tell if it was a TS or simply a cancel, yet in the MarketPrice Domain, you get all the trades, but only L1 data... am I missing something?

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 zoya.farberov · Nov 16, 2020 at 05:49 PM

Hello @jwaldron,

Tick history raw data TickHistoryRawExtractionRequest will result is the raw data response, as recorded from Elektron data feed. MarketPrice is how L1 realtime data is structured, and MarketByPrice and MarketByOrder is how L2 is structured, if available for the instrument. To concolude, what is available from realtime feed, is exactly what is recorded in Refinitiv Tick History.

For example, MbO request:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "CARR.PA",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2016-09-29T12:00:00.000Z",
      "QueryEndDate": "2016-09-29T12:10:00.000Z",
      "ExtractBy": "Ric",
      "SortBy": "SingleByRic",
      "DomainCode": "MarketByOrder",
      "DisplaySourceRIC": true
    }
  }
}

Will return order book, that consists from adds and deletes:

...
CARR.PA,Market By Order,2016-09-29T12:02:32.567054249Z,+2,Raw,UPDATE,UNSPECIFIED,,,,6508,,42256,,0
,,,,Summary,,,,,,,,,,2
,,,,FID,4148,,TIMACT_MS,43352516,
,,,,FID,6952,,TIMACT_MSP,871,
,,,,MapEntry,,ADD,,,,,,14428-20160929-95796,,11
,,,,FID,3426,,ORDER_ID,14428-20160929-95796,
,,,,FID,3427,,ORDER_PRC,23.26,
,,,,FID,3428,,ORDER_SIDE,2,ASK
,,,,FID,3429,,ORDER_SIZE,250,
,,,,FID,6524,,OR_TIM_MS,43352516,
,,,,FID,6525,,OR_TIM_MSP,871,
,,,,FID,3886,,ORDER_TONE,2,
,,,,FID,6520,,PR_TIM_MS,33832516,
,,,,FID,6521,,PR_TIM_MSP,869,
,,,,FID,6522,,PR_DATE,2016-09-29,
,,,,FID,6526,,OR_DATE,2016-09-29,
...

Does this answer your question?


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 jwaldron · Nov 16, 2020 at 11:09 PM

@zoya.farberov ... thanks for the reply... You touch on it in the MarketByOrder.. the point is, as far as I would understand it not all Deletes are trades... many Orders are simply cancelled, so it does not seem to me that one could accurately compute Time & Sales in either the MarketByPrice or MarketByOrder View.. if all Deletes are trades, than it is easy... so I guess if someone can clarify that, it would help.

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 zoya.farberov · Nov 16, 2020 at 11:28 PM

Hello @jwaldron,

I am gathering that the clarification you are looking for is, what kind of market situation can result in Delete action in an order book, except for execution. As a customer, the most efficient approach to clarify a matter of content is via Refinitiv Helpdesk Online -> select "I need help understanding content within the product ", and your question will be assigned directly to a Refinitiv content expert.

This forum is targeted at Refinitiv API specifics general questions and discussions.

If you are unable to do so, let us know and we will create a content case on your behalf?

I am a developer, rather then an expert on content, so what I think of this should not be considered a complete definitive answer, but to me, it does not make sense that all order book Deletes are executions. One can, at a minimum, cancel an order, that is not executed yet. Plus, most markets allow for modifications of the active orders...

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

Related Questions

Documentation for Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest

I need to resolve a chain of historical RICS, e.g. 0#TFI: how do I qualify historical RIC chains in the API?

Documentation for Market Conditions Qualifiers

Tick History Client want their GUI custom extractions output files downloaded to their system automatically with no manual intervention. As Tick History does not support FTP, looking for a way to do the same through API

Historical TickHistory Data Download

  • 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
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • 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