How to retrive ALL, Median function on Codebook
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)
Find more posts tagged with
Sort by:
1 - 1 of
11
Sort by:
1 - 1 of
11
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.
@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.