Excel formula builder 1m total returns different dates

Question

Question by Greg_deprecated_0 · Apr 17, 2020 at 08:55 PM · excel formula builder

Excel formula builder 1m total returns different dates

Hi,

I'm using the formula builder in Excel to retrieve monthly total return for a bunch of stocks. Most total returns ends up on the end dates, say 1999-01-31, but for some stocks the total returns ends up on earlier dates. Is there some setting in the formula builder that would result in me getting all the monthly returns on the same date?

Thanks!

=TR('RICS DK'!$A$2:$A$127,"TR.TotalReturn1Mo","SDate=1989-01-01 EDate=-1AM Frq=M CH=IN RH=date;Fd",$A$1)

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-04-27T04:14:46Z

REFINITIV

Best Answer

Answer by jirapongse.phuriphanvichai · Apr 27, 2020 at 04:14 AM

@Greg

For Eikon Excel questions, please directly contact the Eikon support team via MyRefinitv for answers.

1587960846293.png (16.8 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Excel formula builder 1m total returns different dates

1 Reply

Watch this question

Related Questions