Hallo everyone
i am trying to reterive fund nav prices using timeseries . its showing me error or NAN values . please help me out .
for example
AT0000675665Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●4 ●1 ●4
How to get FUND NAV using time series ?
Hello @booze007,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks
-AHS
Hello @booze007,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS
39.4k
●77 ●11 ●27
The only symbology that can be used with get_timeseries method is Thomson Reuters RIC. For this fund you can use RIC LP60077908, e.g.
ek.get_timeseries('LP60077908',end_date='2017/11/15',start_date='2017/11/01')
To get the RIC given an ISIN you can use
ek.get_data('AT0000675665',['TR.RIC'])
Alternatively you can retrieve fund NAV history using an ISIN and get_data method:
ek.get_data('AT0000675665',['TR.NETASSETVAL.Date','TR.NETASSETVAL'],{'SDate':'2017/11/15', 'EDate':'2017/11/01'})
1
●4 ●1 ●4
@alex putkov thanks alot for the answer .. but somehow i am able to retrieve only 1000 funds nav and then it BAD REQUEST ERROR. please help
Can you elaborate? Which method are you using (get_data or get_timeseries). Do you submit a single request for more than 1K funds? Or do you send 1K+ requests (one for each fund) in a loop? At what point do you receive Bad Request error? And example of the request that returns Bad Request would be most helpful.
Hello @booze007,
If the issue still persists, please add the info requested by Alex,
Otherwise, please let us know that the issue is resolved.
Thanks
-AHS
0
●0 ●0 ●2
... surprisingly, if you try to get the NAV of an xetra listed ETF (e.g. SPDR Msci World) you get two different NAV timeseries:
- ek.get_data('IE00BFY0GT14',['TR.NAVPSActValue.Date','TR.NETASSETVAL'],{'SDate':'2023/07/01', 'EDate':'2023/07/07'})
--> this results in an euro denominated NAV
- ek.get_data('LP68537195',['TR.NAVPSActValue.Date','TR.NETASSETVAL'],{'SDate':'2023/07/01', 'EDate':'2023/07/07'})
--> here you get the issures published NAV in the funds base currency
Is there a possibility to ..
- retrieve the field "Currency" of the NAV Timeseries?
- retrieve always the base currencys NAV without Lipper?
BR, Frank
