For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
emmanuel.godet avatar image
3 ●1 ●1 ●1

Time And Sales in Python: select fields to retrieve

Hi, I am trying to pull trades for MiFID RICs. I wrote:

df = ek.get_timeseries(["DE0001102408=TWEA"],
interval = 'tick',
start_date="2018-06-01",
end_date="2018-06-30")

THis retrieves trade datetime, value and volume.

Can someone tell how to retrieve publication time, trade id, trade flags, etc.?

Cheers,

Emmanuel

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apitime-seriesmifid
icon clock
10 |1500

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

3 Answers

Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

this data is not present in the tick interval views, but rather time and sales (TAS) which is not currently supported.

icon clock
10 |1500

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

Upvotes
Alex Putkov.1 avatar image
39.3k ●77 ●11 ●27

@emmanuel.godet
The only two APIs currently available through Eikon that provide the capability to retrieve the data you're after are RHistory COM library, which can only be used in Excel VBA, and Eikon .NET API.

icon clock
10 |1500

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

Upvotes
emmanuel.godet avatar image
3 ●1 ●1 ●1

Thanks both of you. Is the permissioning of the calling python app, which uses a key I created with my Eikon account, will be the same as when I use Eikon? (I could probably experiment a bit, but you can probably answer my question quicker:))

icon clock
10 |1500

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

Alex Putkov.1 avatar image Alex Putkov.1

If you're asking about data entitlements, the answer is yes. Since Eikon APIs retrieve data from Eikon platform, the same data entitlements are enforced as when you use Eikon application or Eikon Excel.