How to retrive ALL, Median function on Codebook

Unknown
Unknown
in Eikon Data APIs

How to fetch the following data in codebook

1. ALL(TR.Volume(sdate=0d,edate=-89d,frq=d)>0)

2. MEDIAN(TR.Volume(sdate=0D,edate=-19D,frq=D))>=100000

3. MEDIAN(TR.DailyValueTraded(sdate=0D,edate=-19D,frq=D,CURN=USD))>=500000

4. ALL(TR.CompanyMarketCap(ShType=FFL,sdate=0D,edate=-9D,frq=D,CURN=USD)>500000000)


Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    @raju.sharana

    I'm afraid comparison operators cannot be used in formulas with Eikon Data APIs. In other words, using Eikon Data APIs you cannot use as a field name the expression like "MEDIAN(TR.Volume(sdate=0D,edate=-19D,frq=D))>=100000", and get a Boolean value in return. The only option I see is to retrieve the value for "MEDIAN(TR.Volume(sdate=0D,edate=-19D,frq=D))", and then compare it to your threshold of 100000 in your code.

Categories