Converting excel formula to python code

Francisco

Hello,

I am trying to convert Refinitiv excel formula:

=@RDP.Data("WY.N","TR.GuidanceDate(GuidAcctType=ALL);TR.GuidancePeriodYear(GuidAcctType=ALL);TR.GuidancePeriodMonth(GuidAcctType=ALL);TR.GuidanceLowValue(GuidAcctType=ALL Scale=6);TR.GuidanceHighValue(GuidAcctType=ALL Scale=6);TR.GuidanceUnitType(Gu"&"idAcctType=ALL);TR.GuidanceMeasure(GuidAcctType=ALL);TR.GuidanceSegmentName(GuidAcctType=ALL);TR.GuidanceDocType(GuidAcctType=ALL);TR.GuidanceSpeaker(GuidAcctType=ALL);TR.GuidanceAcctType(GuidAcctType=ALL);TR.GuidanceDataForm(GuidAcctType=ALL);TR.Gui"&"danceText(GuidAcctType=ALL)","Period=FQ1 Frq=FQ SDate=2020-01-01 EDate=2025-07-30 CH=Fd RH=IN SORTA=TR.GuidanceMeasure",B2)

into a python code.

The equivalent python code would be:

df = ld.get_data(
universe=['WY.N'],
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
}
)

df

but I am not sure how to add the sorting parameter

SORTA=TR.GuidanceMeasure

into the python code.

Please help me with this issue.

Thank you very much.

Jirapongse

@Francisco

Thank you for reaching out to us.

Some parameters are only valid on Excel. I think the SORTA parameter is one of them.

However, you can use the Dataframe method, such as sort_values to sort values. For example:

df = ld.get_data(
    universe=['WY.N'],
    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
    }
    )

df.sort_values(['Guidance Measure'],na_position="first")