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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 0 2

How do I get MEDIAN volume instead of Average volume in python API?

Ringt now I have a list of RICs (Tickere) that I want to get Company name, revenues and median volume for:

df2, err = ek.get_data(Tickere,["TR.CommonName",'TR.Revenue',"TR.AvgDailyVolume90D"])

What should I replace "TR.AvgDailyVolume90D" with to get median daily volume for last 90 days?

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

A similar question has been previously asked on this thread.
Here's what you're looking for:

df2, err = ek.get_data(Tickere,["TR.CommonName","TR.Revenue","TR.AvgDailyVolume90D","MEDIAN(TR.Volume(SDate=0,EDate=-89D))"])
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