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?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

formula-builder

Accepted answers

nick.zincone

Hi @Carmila.Lazo1,

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:

All comments

nick.zincone

Hi @Carmila.Lazo1,

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:

EXPLORE OUR SITES