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?

Best Answer

  • Alex Putkov.1
    Answer ✓

    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))"])