Workspace Codebook - Brokers Estimate Data

dan2025

Hello team,

I'm using Codebook to retrieve Brokers Estimate data for companies. With reference of DIB, I get some codes like this below,..

df=ld.get_data(

    universe=universe,

    fields=[

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY)',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY).rfperiod',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY).fperiod',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY).date',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY).origdate',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY1,Frq=FY).confirmdate',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY)',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY).rfperiod',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY).fperiod',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY).date',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY).origdate',

        'TR.EPSEstValue(SDate=0,EDate=2,Period=FY2,Frq=FY).confirmdate',

    ],

)

df

There’s parameter: OutputOption. When I set it to Prev, the query fails.

What im trying to achieve at the moment is this:

As of today, for a stock, lets say 7203.T and EPS and FY1, in a single row, get the Broker, Current Estimate, Current Estimate Date, Previous Estimate, Previous Estimate Date, or something like that.

I was hoping the OutputOption = Prev would give me the previous estimate.

Can you suggest a query to get the above?

Where can I get more information regarding parameters and outputs, the DIB documentation is only sometimes helpful.

Many thanks !

Jirapongse

@dan2025

Thank you for reaching out to us.

It looks like that the OutputOption parameter doesn't work with the EDate parameter. I can replicate this issue on the LSEG Workspace Excel, as shown below.

=@RDP.Data("7203.T","TR.EPSEstValue","EDate=2 Period=FY1 Frq=FY OutputOptions=Prev CH=Fd RH=IN",A3)

It works with the SDate parameters.

=@RDP.Data("7203.T","TR.EPSEstValue","SDate=-2 Period=FY1 Frq=FY OutputOptions=Prev CH=Fd RH=IN",A3)

Please contact the Workspace Excel support team directly regarding the OutputOption parameter.