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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
21 0 0 0

pull specific option volume

I am trying to pull the average volume of a many specific options (for x amount of days).
I cant seem to find the right function, TRDVOL_1 is returning NaNs for nearly all options..

thanks

python api
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.

TR.TRADEVOL returns NaNs for all.

ric examples: FBK262134000.U, FBX032134000.U, MSFTL032134000.U, AAPLX032116000.U

1 Answer

Upvotes
Accepted
6.7k 8 6 7

@rafi.levy1 Please try TR.ACCUMULATEDVOLUME:

df,err = ek.get_data(['FBK262134000.U', 'FBX032134000.U', 'MSFTL032134000.U', 'AAPLX032116000.U'],['TR.ACCUMULATEDVOLUME(SDate=0,EDate=-4,Frq=D).date','TR.ACCUMULATEDVOLUME(SDate=0,EDate=-4,Frq=D)'])

df

1637667076515.png

You can check all fields available for any RIC to find the right field name for the instrument or asset class using the Data Item Browser app (type DIB into Eikon search). Here I am searching for volume and if the instrument is present you will also get values returned which is helpful in zeroing in on what you need. I hope this can help.

1637667175143.png



1637667076515.png (52.3 KiB)
1637667175143.png (270.2 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