Download single contributor IBIS python api

Hello!

I am working with the python API to get IBIS estimation of financial statements for some companies. In the codecreator, I can find information about the mean. However, I am interested in the distribution of forecast instead of one single indicator.

For instance, I am interested in General Motors (GM) historical values and forecast of individual contributors of the fields of GM (screen attached). How can I get those estimates by the python API?

Find more posts tagged with

python api

estimates

fundamentals

refinitiv-dataplatform-eikon

#content

#technology

Accepted answers

m.bunkowski

Hi @carlosgk
Here is how you can get a sample set of values. You can find the the formulas that are in form of hints under the selected data items:

Once you know the field you can use the formula builder (Excel od CODECR app) to help you find right parameters:

After adjusting that you can get something similar to:

rd.get_data(
    universe=['GM'],
    fields=['TR.Cash&EquivalentsEstValue(Brokers=US_61910).fperiod',
            'TR.Cash&EquivalentsEstValue(Brokers=US_61910)',
            'TR.Cash&EquivalentsEstValue(Brokers=US_61910).brokername'],
    parameters = {'Period':'FY1:FY3', 'Frq':'FY'}
)

All comments

Jirapongse

@carlosgk

Thanks for reaching out to us.

I checked the Data Item Browser and was unable to find any parameters to specify contributors when retrieving those fields. You may need to contact the Eikon support team directly via MyRefinitiv and ask for the Eikon Excel formula that can be used to retrieve the required data.

If the formula is available, we may be able to convert it to the Python code.

m.bunkowski

Hi @carlosgk
Here is how you can get a sample set of values. You can find the the formulas that are in form of hints under the selected data items:

Once you know the field you can use the formula builder (Excel od CODECR app) to help you find right parameters:

After adjusting that you can get something similar to:

rd.get_data(
    universe=['GM'],
    fields=['TR.Cash&EquivalentsEstValue(Brokers=US_61910).fperiod',
            'TR.Cash&EquivalentsEstValue(Brokers=US_61910)',
            'TR.Cash&EquivalentsEstValue(Brokers=US_61910).brokername'],
    parameters = {'Period':'FY1:FY3', 'Frq':'FY'}
)

EXPLORE OUR SITES