Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apicodebook
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
39.4k 77 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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.