question

Upvotes
Accepted
FrankMars avatar image
0 ●0 ●0 ●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.

wasin.w avatar image   wasin.w

Hi @frank.marsollek

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

Jirapongse avatar image   Jirapongse

@frank.marsollek

Hi,

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

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

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