How to retrive ALL, Median function on Codebook

raju.sharana

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)

Alex Putkov.1

@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.