Eikon API guidance summary data gets mixed up

@Francisco

Yes, it is easy to learn. There are a lot of examples available on GitHub.

The code can be changed to:

import lseg.data as ld
ld.open_session(app_key = 'APP_KEY')

df = ld.get_data(…)

You can use the Data Item Browser tool to list all available fields and parameters.

However, this forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through MyAccount. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

@Francisco

Please try this one:

df = ld.get_data(
        universe=['MSFT.O'],
        fields = ['TR.GuidanceDate(GuidAcctType="ALL")',
                  'TR.GuidancePeriodYear(GuidAcctType="ALL")',
                  'TR.GuidancePeriodMonth(GuidAcctType="ALL")',
                  'TR.GuidanceLowValue(GuidAcctType="ALL")',
                  'TR.GuidanceHighValue(GuidAcctType="ALL")',
                  'TR.GuidanceUnitType(GuidAcctType="ALL")',
                  'TR.GuidanceMeasure(GuidAcctType="ALL")',
                  'TR.GuidanceSegmentName(GuidAcctType="ALL")',
                  'TR.GuidanceDocType(GuidAcctType="ALL")',
                  'TR.GuidanceSpeaker(GuidAcctType="ALL")',
                  'TR.GuidanceAcctType(GuidAcctType="ALL")',                 
                  'TR.GuidanceText(GuidAcctType="ALL")'],
        parameters = {
            'Period':'FQ1',
            'Frq':'FQ',
            'SDate':'2020-01-01',
            'EDate':'2025-07-30',
            'Scale':6
        }
)

The warning indicates the the library uses the deprecated pandas method (replace) which will be removed in a pandas future version. The product team is aware of this warning.

C:\Python312\Lib\site-packages\lseg\data\_tools\_dataframe.py:192:FutureWarning: Downcasting behavior in `replace` is deprecated and will be removed in a future version. To retain the old behavior, explicitly call `result.infer_objects(copy=False)`. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`

Currently, you can ignore this warning by using the following code.

import pandas as pd
pd.set_option('future.no_silent_downcasting', True)

@Francisco

I rechecked it and found that the issue happens randomly.

I can replicate this issue on the Workspace Excel with the following formula.

=@RDP.Data("MSFT.O","TR.GuidanceDate;TR.GuidancePeriodYear;TR.GuidancePeriodMonth;TR.GuidanceLowValue;TR.GuidanceHighValue;TR.GuidanceUnitType;TR.GuidanceMeasure;TR.GuidanceSegmentName;TR.GuidanceDocType;TR.GuidanceSpeaker;TR.GuidanceAcctType;TR.Guida"&"nceDataForm;TR.GuidanceText","Period=FQ1 Frq=FQ SDate=2020-01-01 EDate=2025-07-30 CH=Fd RH=IN GuidAcctType=ALL Scale=6",B2)

Because the problem also happens on the Workspace Excel, please contact the helpdesk team via MyAccount to investigate this issue.

@Francisco

I have contacted the helpdesk to refresh the formula several times to replicate the issue.

You may ask them for the same.

@Francisco

The problem must be solved at the server side, not Python.

Please contact the support team on the case#14796016 to investigate this issue.

Python and Excel retrieve data from the same data source. I think if the issue on Excel has been solved, the issue on Python will be solved too.

The Period and Frq parameters accept one value at a time. Therefore, as far as I know, it can't be used to pull quarterly and annual guidance in the same request. However, you need to contact the helpdesk team to confirm it.

'Period':'FQ1',

'Frq':'FQ',