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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 4

Full trade history through API

remit.png

Hi,

How can we get full trade history for TRDEBD1 through API?

Also, I would also be interested in pulling in data which may not have an RIC, namely intraday power outages. (screenshot below)

is that through point connect?

thank you!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontrade
remit.png (160.8 KiB)
icon clock
10 |1500

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

Upvotes
Accepted
39.2k 75 11 27

@caroline.hynniewta1, @ludomir.garreau
The timeseries available through Eikon Data APIs are not as detailed as in the screenshot @ludomir.garreau provided, but you can get all the trade prices for the day using

ek.get_timeseries('TRFRBD1', fields=['VALUE'], interval='tick', start_date='2019-02-20', end_date='2019-02-21')
icon clock
10 |1500

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

Upvotes
4.6k 26 7 22

@caroline.hynniewta1, yes, you can pull trade data for TRDEBD

df = ek.get_timeseries('TRDEBD1')

As for your seconds question, I am not sure whether this data is within pointConnect, as this is not a part of Eikon offering, I suggest you contact the support desk, or leave a comment if you need help finding a correct contact for this sort of question.


icon clock
10 |1500

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

thank you so much Zhenya. It probably is point connect. thank you !

Upvotes
1 0 1 4

Follow on question pls - Zhenya’s timeseries contains the low, high, open close prices every day for the past days.

Im looking for something which will return, for a specific day only, all trades of the day ahead product. Could you ask him if that is available, and if so would it include all the brokers and what is the latency of the feed?

icon clock
10 |1500

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

Upvotes
1 0 0 0

@Zhenya Kovalyov Did you manage to look into the above? Im looking for a bit of code which will return something like the attached timeseries for French baseload power for delivery tomorrow refinitiv.png


refinitiv.png (48.7 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea