question

Upvotes
Accepted
FrankMars avatar image
0 ●0 ●2 ●2

NAV of ETC (e.g. 4GLD.DE) missing

Hi Team,

I'm interested in getting historical NAVs of ETPs at all. Therefore i use the ek.get_data to get NAVs vom ETFs (which works fine for SPY5 e.g. ).

If i want to receive NAVs from ETCs (g.e. 4GLD.DE "Xetra Gold") with the same code, i don't get sufficient data.

Here's my code:

NAVs = ek.get_data('DE000A0S9GB0',['TR.NETASSETVAL.Date','TR.NETASSETVAL'],{'SDate':'2023/03/15', 'EDate':'2023/07/12'})
dataList = list(NAVs)
df_NAVs= dataList[0]
df_NAVs

Using the RIC or LipperID instead of ISIN provides the same result.

Is this the right API for this purpose?


br,

Frank

eikon#product#contentetf
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
Jirapongse avatar image
83.1k ●281 ●53 ●77

@frank.marsollek

Thank you for reaching out to us.

Please contact the helpdesk support team via MyRefinitiv to verify if there are other fields that can be used to retrieve NAVs from ETCs.

If this data is available via Eikon Excel, it is likely that the same data can be retrieved through the APIs.

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.