Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
leequen avatar image
1 ●0 ●0 ●1

hi i would like to have the relative dates of each row

Dear community,

I am trying to retrieve yearly data (fiscal year) using this Excel formula:
=@TR(Tabelle1!$B$3:$B$318,"TR.TotalReturn........[other parameters]...","Period=FY-1 Frq=FY SDate=0 EDate=-10 Curn=USD CH=Fd RH=IN").

and this is the result

Total Return .....

KEPL3.SA 70.7614344 .....

KEPL3.SA 32.5659314

KEPL3.SA 31.3511968

KEPL3.SA 99.8024326

KEPL3.SA -23.604711

KEPL3.SA 8.5

KEPL3.SA 11.8889632

KEPL3.SA -64.652856

KEPL3.SA 25.7346261

KEPL3.SA 248.57733

KEPL3.SA 8.25829311

MYPK3.SA -18.284535

MYPK3.SA 5.67791972

MYPK3.SA -27.533555

MYPK3.SA -0.1703796

MYPK3.SA 8.22311756

MYPK3.SA 101.657333

MYPK3.SA -2.9930456

MYPK3.SA 3.28022009


I would like to know how I can display the dates near the row headers, for instance :

#NAME? dates Total Return ..........

KEPL3.SA 31/12/2011 70.76143442 ..........

KEPL3.SA 31/12/2012 32.56593144

KEPL3.SA 31/12/2013 31.35119676

KEPL3.SA 31/12/2014 99.80243261

KEPL3.SA 31/12/2015 -23.6047107

KEPL3.SA 31/12/2016 8.5

KEPL3.SA 31/12/2017 11.88896318

KEPL3.SA 31/12/2018 -64.65285624

KEPL3.SA 31/12/2019 25.73462606

KEPL3.SA 31/12/2020 248.5773305

KEPL3.SA 31/12/2021 8.258293107

MYPK3.SA 31/12/2011 -18.28453476

MYPK3.SA 31/12/2012 5.677919724

MYPK3.SA 31/12/2013 -27.53355469

MYPK3.SA 31/12/2014 -0.170379623

MYPK3.SA 31/12/2015 8.223117561

MYPK3.SA 31/12/2016 101.6573328

MYPK3.SA 31/12/2017 -2.993045583

MYPK3.SA 31/12/2018 3.280220095

MYPK3.SA 31/12/2019 -52.75088318

.........

(sorry for the structure)

Thank you

#productexceldateformula-builder
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.

raksina.samasiri avatar image   raksina.samasiri

Hi @leequen ,

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

@leequen

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

@leequen

Thank you for reaching out to us.

You can request the TR.TotalReturn.date field, as shown below. 

=@TR("KEPL3.SA","TR.TotalReturn.date;TR.TotalReturn","SDate=1D EDate=-10 Frq=FY CH=Fd RH=IN",B2)

The output is:

1689309761144.png



1689309761144.png (30.9 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.

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.