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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Tulkkas avatar image
37 ●3 ●3 ●10

Download historical volume for (continuation) Futures with Eikon API

Hi, I am looking to download close,high,low, open and volume for a continuous futures chain, historically. I am using the Eikon API 'get_data' function with parameters equal to the start and end dates of my period.

Example RIC - EScv1, which is the SP500 mini.

Unfortunately I am not able to obtain data for Volume, I used the fields TR.Volume and the CF_Volume fields but none of them worked. I do not get any historical data for volume.

I get everything else (Close, Open, Low, High) by using the correct field...

Would anybody have an idea?

Thank you


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonfutures
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.

3 Answers

Upvotes
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@Tulkkas try using TR.ACCUMULATEDVOLUME for the historical volume. You can check all fields available for any RIC using the Data Item Browser App (type DIB into eikon search bar) - this also gives values if you type in an instrument - so its easy to zero in on exactly what you want, I hope this can help.

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
Tulkkas avatar image
37 ●3 ●3 ●10

@jason.ramchandani, thank you, I will try that! Thanks for the tip with the DIB - indeed, that is how I came up with trying the CF_Volume field. I will let you know if it worked

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.

Upvote
Tulkkas avatar image
37 ●3 ●3 ●10

@jason.ramchandani - it worked, thank you very much!

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