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
Carmila.Lazo1 avatar image
1 ●0 ●1 ●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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiformula-builder
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.

Jirapongse avatar image   Jirapongse
@Carmila.Lazo

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
17.2k ●82 ●39 ●63

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