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
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
55
●2 ●5 ●9
pull specific option volume
TR.TRADEVOL returns NaNs for all.
ric examples: FBK262134000.U, FBX032134000.U, MSFTL032134000.U, AAPLX032116000.U
Hello @rafi.levy1 ,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
10.2k
●18 ●6 ●9
@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
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.
