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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

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)


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

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

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