question

Upvotes
Accepted
1 0 0 0

incomplete time series MVEU.L

With EIKON Excel API request

=@TR(D$1;D$3;"SDate=#1 EDate=#2 Frq=D Curn=#3 RH=date SORTA=date NULL=BLANK";;$B$1;$C$1;$D$2)

Start date 30/11/2012

Currency EURO

Fund : MVEU.L

TR.NetAssetVal time series requested

Returns data starting from the 10/11/2021

Exporting data from the Chart Price and Dividends in EIKON MMI give the complete time series starting back 30/11/2012

Why is that ?

eikontime-seriesexcel
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.

Upvotes
Accepted
53k 137 44 63

@denis.vernet

I got the same data when using the following formula in Eikon Excel.

=@TR("MVEU.L","TR.NETASSETVAL.Date;TR.NETASSETVAL","SDate=2012-11-30 EDate=1D CH=Fd RH=IN",B3)

1661490776173.png

It looks like to be a content issue in Eikon Excel.

As this forum is more for programming-type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket with our helpdesk. That way a Content specialist can work closely with you and verify the assumption.

I hope this will help.


1661490776173.png (34.2 KiB)
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.

Upvotes
1 0 0 0

The issue has been solved with the help desk !

Thank you

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.