question

Upvotes
Accepted
1 0 1 1

How can I get the ROE, ROI, WACC for the constituents of the Stoxx600?

I need the estimates of ROE, ROI, and WACC from 1970 with the highest available frequency for all constituents of the Stoxx 600. Thank you to anyone who can provide assistance with this.

python#technologyconstituentsindices
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.

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
5.8k 18 2 7

Hi @aforino ,


I am afraid the data will not go back that far. Please see an example code below for a particular date and fields (Please check Dara Item Browser (by typing DIB in Workspace/Eikon) for another fields if required):

rd.get_data(universe=["0#.STOXX('2022-02-02')"], fields=["TR.WACC", "TR.ROE", "TR.ROEMean", "TR.ROICActValue"], parameters = {'SDate': '2022-02-02'})

screenshot-2024-03-04-at-182421.png

Please note that there is no streamlined way of getting the full history so you would need to make request for each day.

In that sense the Joiner/Leaver code below might be useful to avoid the loop and building the historical constituents based on the results from this request:

rd.get_data(universe='.STOXX', 
            fields = ["TR.IndexJLConstituentRIC", "TR.IndexJLConstituentRIC.date",  "TR.IndexJLConstituentRIC.instrument",
                      "TR.IndexJLConstituentRIC.change","TR.IndexJLConstituentName"],
            parameters={"SDATE": '2020-01-01',"EDATE":'2024-03-04', 'IC':'B'}
        )


screenshot-2024-03-04-at-182437.png


Hope this helps.



Best regards,

Haykaz


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 1 1

Thank you for your advices.

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.