Is there a direct way to find net equity expansions for different countries in Thomson Reuters Ei...

nyks

Is there a direct way to find net equity expansions for different countries in Thomson Reuters Eikon api?

Alex Putkov.1

@nyks
The moderators on this forum do not have deep expertise in every type of content available through Eikon. Content questions such as this one are best directed to Refinitiv Helpdesk, which you can reach by either calling the Helpdesk number in your country or by using Contact Us capability in Eikon application.
I do not believe we produce country level statistics such as net equity expansion. If I understand correctly, net equity expansion can be defined as 1 - (1 + MarketReturn(t)) * MarketCap(t-1) / MarketCap(t). In order to calculate net equity expansion using this definition you'd need to retrieve and aggregate market cap for each company listed in the country at times t and t-1. For MarketReturn you could use the return on an all stock market cap weighted index such as Australian All Ords or Moroccan All Shares Index. In lieu of such index you'd need to either use the closest proxy (a market cap weighted index representing broad market for a given country) or calculate such an index yourself using market cap values and stock prices for each stock listed in the country.