New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-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.

Upvotes
Accepted
4.6k 27 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
39.4k 78 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
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.

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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