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 Ezar11 · Jul 05, 2019 at 11:00 AM · eikon apipython real-time apitimes and sales

Real-time Tick-by-tick Times and Sales with SIDE flag via Python API

Hi TR tech team,

I would like to know if it would be possible to access programatically (i.e. via your APIs, more specifically via the Python API) some specific data:

Asset classes: ETFs like SPY and Futures like ES, EUROSTOXX, DAX, YM...

Data needs: We need REAL-TIME tick-by-tick times and sales data (executed orders size, timestamp, price and direction). An example would be: at 10:22:23.313 a SELL order with lot size 5 was executed at price 230 > 10:22:23.213 - SELL - 5 - 230. Some vendors display this information BUT they don't have the SIDE flag (i.e. SELL or BUY).

API: We would primarily want to do all in python and linux (data retrieval, data processing, orders sending — we know that you have a Python API). Our business model is pure consultancy, so we need to know if the requested "data type and feed" is available in order to then create a solution based on the client requirements.

¿Is this doable? Please, if you could confirm that this kind and type of data is accesible via the python API and for the majority of the assets gathered into the asset classes noted above it would be awesome.

Also, ¿is there any other option or product like WebSockets via Python to access this kind of data? Help to dig more is much appreciated.

Many thanks in advance,

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.

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Jul 10, 2019 at 03:42 AM

@Ezar11, just a few more details that you might find useful:

Nature of the TRTH API, programming languages

The TRTH API is a RESTful API. As such, it is language agnostic, you can use any language you want to access it. We do not have a "Python API" per se, but Python can be used to interface with TRTH, and we deliver a few samples to illustrate this. We also deliver samples in Java, as well as C# (they use the TRTH .Net SDK, which is the only language specific extension we deliver). We also have a set of samples in pure HTTP (using Postman); these show the API calls, which you can then recreate in the language of your choice. There are also some articles on using Go and R.

"Real-time" tick data

TRTH allows requesting tick data, as described in REST API tutorial 4. This is historical tick data, i.e. you get all the ticks (quotes, trades) for a date range in the past. TRTH does not deliver streaming data in real-time (i.e. events as and when they occur on the market), for that you'd need to look at the Elektron APIs.

Available TRTH tick data fields

The REST API tutorial 4 sample only shows a few fields out of a wide range of available ones. To find out exactly which fields are available, and for which asset classes, you can refer to the TRTH data dictionary. In tab "Field Descriptions", filter column C on "Tick History Time and Sales" (that is the tick data). Column D lists all the available fields, columns O to AH list availability by asset class.

BUY and SELL

I'm not a financial specialist, but I am a bit intrigued by the notion of side for a trade. For a quote the notion of buy / sell is obvious, but for every trade there is a seller and a buyer, so having a side flag on a trade implies a referential. In the TRTH data dictionary I filtered column D on fields containing either "sell" or "buy"; in the fields we deliver you will find the Seller and Buyer IDs, as well as the total sell and buy value and volume:

Would that be of help for your use case ?

As suggested by Alex, this topic should be discussed with a financial product specialist, as this is beyond the (mainly) technical expertise of the forum moderators.


side.png (41.6 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
REFINITIV
Answer by Alex Putkov. · Jul 05, 2019 at 06:47 PM

Based on your data requirements and technology stack it appears that Refinitiv product that best suits your use case is TRTH. You may want to look at this tutorial for an idea of what the interface looks like. However data requirements and technology stack are not the only variables. Other variables one needs to consider when selecting a product include data licensing and commercials.
I suggest you reach out to Refinitiv Sales Team, who will be happy to help you select the product that best fits your use case from all angles. I also suggest that you confirm with the sales team that whatever product they recommend has all the data that you require.

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 Ezar11 · Jul 06, 2019 at 06:31 AM

Hey Alex,

Thanks for your quick response.

Firstly to say, I'm here exactly because the Sales Team directed me here to get answers to my "technical" questions. Sure about that there are other variables in play, but I would like to firstly know about if the data I want is present.

I have gone through the TRTH technology but as I see, it is historical tick-data and I don't see the word real-time anywhere in the documentation. So, ¿is TRTH the product I'm looking for or might be a confusion?

Furthermore, however it seems that it is not the most optimal product, it seems that times and sales data is available. There is a flag/field called Type. As I'm not a TRTH product and I cannot pass the auth step so that I can check if there is a field that gives information about if the TRADE was a SELL or a BUY, ¿could you please give me that information or direct me to where I can find the answer and check the different fields?

Thanks Alex,

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 Alex Putkov. · Jul 08, 2019 at 10:54 AM

@Ezar11
This forum is indeed the best resource for technical questions related to using Refinitiv APIs. What you're asking about is the confirmation of data availability in a specific product or a product recommendation based on your data requirements. Moderators on this forum do not have deep expertise in every type of content available through various Refinitiv products to provide authoritative answers to whether very specific piece of content is or isn't available thorough a particular product. Refinitiv Sales Team can confirm this for 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.

avatar image
Answer by Ezar11 · Jul 08, 2019 at 11:25 AM

Hey again Alex,

Alright. I will get back a step to the Sales team to see if they finally can resolve my doubt.

Thanks for the support and work,

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 Ezar11 · Jul 10, 2019 at 06:21 AM

Hey Christiaan,

Thank you so much for the time and the detailed response.

So, to summarize what you have said:

1) REST API is perfect. My question was previous to finding the type of API you used. Furthermore, there is a WebSocket based Elektron API, which is in fact what we may need (we need real-time, no historical data).

2) Data fields. I see. You intrigue is normal. Let me state it again so that you understand it (I have already forwarded this to the Sales Team and I'm waiting for the answer). The idea with the SIDE of the trade is to know the AGGRESSOR (i.e. the participant that submitted the market order-like type) and to dissect if it is a BUYER or a SELLER. Just knowing if the aggressor side was a buy or a sell would be sufficient; no need to have an associated ID. I will explain this to the Sales Team so that we can see if that is possible actually.

As said, many thanks for trying to help as much as possible.

Best,

Comment

People who like this

0 Show 1 · 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
Christiaan Meihsl ♦♦ · Jul 10, 2019 at 07:34 AM 0
Share

@Ezar11,

thank you for taking the time to explain the details.

1) Yes, for real-time data, the Elektron Websocket API is a good option.

2) Ok, now I understand what you would like with the SIDE field. To my knowledge you will not find that in the (historical) fields TRTH delivers in a T&S request. If such data is available via Elektron, then it might also be available (but again, only as historical data) via a TRTH extraction request for raw data (with filtering on specific FIDs), but retrieving that via TRTH would only be useful if you required historical values.

I hope the sales team finds a good solution for you.

Kind regards

avatar image
Answer by mihanix.it · May 04, 2020 at 03:26 PM

Hi!


I am looking for real-time time&sales data with aggressive side specified for NYSE. Preferably via web socket connection.

Could you please tell me if it is now available for Eikon Data API or Elektron API?

Comment

People who like this

0 Show 1 · 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
Alex Putkov. ♦♦ · May 04, 2020 at 03:51 PM 0
Share

@mihanix.it
Old threads that already have accepted answer are not monitored by forum moderators. To ask a new question, always start a new thread.

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

issues with installing of the EIKON API for R package

  • 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