Eikon API sum company data per country list

AAMZ

Dear Refinitiv team,

I'm trying to obtain some country-specific benchmarks for a few company-specific variables, such as "TR.AnalyticEstimatedCO2Total" and "TR.TotalAssetsReported". For example, I'd like to obtain the total "TR.TotalAssetsReported" for France as at end-2020. One way to do this would be to know in advance all French companies, get a list of their tickers/ISINs, download the field "TR.TotalAssetsReported", and then sum that number.

However, I was wondering if there is a way, using Eikon, to just obtain the sum of "TR.TotalAssetsReported" for all French companies within Eikon's databases as at end-2020, without having to know in advance all firms, their tickers, etc. and downloading data for all those firms?

Thank you very much in advance

chavalit-jintamalit

Hi @AAMZ

I think you still need to download each company TR.TotalAssetsReported before you can sum them.

Here is the sample code:

Unknown

Eikon Python
Data API : Getting
Data for CONSECUTIVE CORN CSO options ... financial
data relating to a specific
business segment of a
company through the
api? ... variable parameter values for a
list of instrument in R/Python
API ... dsws.
api data on
company level currency conversion rates error handling side
by side divinity original sin 2 <a href="
https://screamreality.com/divinity-original-sin-2-cheats/">console commands</a>...

AAMZ

I have reported this post

AAMZ

@chavalit.jintamalit Thank you so much--this is brilliant in its simplicity and speed. Two quick follow-up questions: do you know whether there's a way to output time series data from this and also to ensure that all results are converted to euros (not relevant for France, but in case I run this for a non-Euro country)? I'm not so familiar with the screener to be honest--if you know whether there's a guide I could read then I can also try to educate myself.

Thank you again in any case

chavalit-jintamalit

Hi @AAMZ

For SCREENER, you can read more detail at https://developers.refinitiv.com/en/article-catalog/article/find-your-right-companies-with-screener-eikon-data-apis-python

For currency conversion, you can add more parameters.

I am using only 1 instrument for demonstration purposes.

AAMZ

Great, thank you again
@chavalit.jintamalit . Have a nice rest of the day