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

FrankMars

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

Jirapongse

@FrankMars

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.