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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Carmila.Lazo1 avatar image
1 ●0 ●0 ●2

What parameters to use in ek.get to specify the date when using TR.FundNAV data item?

I was previously using the field TR.NETASSETVAL which stops population CRUD.L after the 3rd of May. In python API, the Formula I was using: ek.get_data(['CRUD.L','USO'],['TR.NETASSETVAL.Date','TR.NETASSETVAL', {'SDate':startDate.isoformat(), 'EDate':endDate.isoformat()})[0]

I am now using the formula below but results are not sorted and I need to specify that I want the date. ek.get_data(['CRUD.L'],['TR.FundNAV.Date','TR.FundNAV'], {'SDate':startDate.isoformat(), 'EDate':endDate.isoformat()})[0] print rawnavs.tail()

To obtain exactly the same result in Python API, what parameters would you use in ek.get_data?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonformula-builder
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
nick.zincone avatar image
9.7k ●49 ●38 ●60

Hi @Carmila.Lazo,

Can you provide an example of what your output looks like and where the sorting fails?

I tried a simplistic view of what you are doing and this is what the output looks like:


ahs.png (43.7 KiB)
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