In Codebook, for RIC AOFG.DE I get duplicate entries

Question

In Codebook, for RIC AOFG.DE I get duplicate entries, which causes considerable problems in my workflow.

For example, the commands

import lseg.data as ld

ld.open_session()

RICs=['AAPL.OQ','AOFG.DE','ADSK.OQ']

Fields=['AVAIL(TR.F.CashSTInvstTot(PERIOD=FQ0),TR.F.CashSTInvstTot(PERIOD=FI0))','TR.CompanyName','TR.F.TotRevBizActiv','TR.PriceCloseDate','TR.PriceClose(Scale=0)','TR.Volume(Scale=3)','TR.ISINCode','TR.PriceTargetMean','TR.F.EV(Scale=6,curn=EUR)','TR.ISAccountingStandard']

df=ld.get_data(RICs, Fields, parameters={'NULL':'Blank','Scale':6})

produce duplicate results for AOFG.DE (see screenshot).

Why is this and can it be resolved?

ujjawal_khandelwal · Answer

Hi @RogelynMayAgustin,

While what my colleague said is true, it is a content related issue, I tried adding more parameters to filter the result and it worked. You can have a look at the results fetched by the code below:

What has changed:

I have added another parameter IncludePartial = No  at the field level. The default value is Yes so I changed it to No.

This brings only brings in complete reports ignoring partial ones.

import lseg.data as ld

ld.open_session()
RICs = ['AAPL.OQ','AOFG.DE','ADSK.OQ']

Fields = ['AVAIL(TR.F.CashSTInvstTot(PERIOD=FQ0,IncludePartial=No),TR.F.CashSTInvstTot(PERIOD=FI0,IncludePartial=No))',

'TR.CompanyName',
                'TR.F.TotRevBizActiv',
                'TR.PriceCloseDate',  
                'TR.PriceClose(Scale=0)',
                'TR.Volume(Scale=3)',
                'TR.ISINCode',
                'TR.PriceTargetMean',
                'TR.F.EV(Scale=6,curn=EUR)',
                'TR.ISAccountingStandard']

df = ld.get_data(RICs, Fields, parameters = {'NULL':'Blank','Scale':6})

df

Please let me know if this is helpful. Would like to know.

Still contacting the support team is recommended.

Thank you : )

Jirapongse · Answer

@RogelynMayAgustin

Thank you for reaching out to us.

I tested this formula in the Workspace Excel. It also returns the duplicated entry.

=@RDP.Data("AAPL.OQ;AOFG.DE;ADSK.OQ","AVAIL(TR.F.CashSTInvstTot(PERIOD=FQ0),TR.F.CashSTInvstTot(PERIOD=FI0));TR.CompanyName;TR.F.TotRevBizActiv;TR.PriceCloseDate;TR.PriceClose(Scale=0);TR.Volume(Scale=3);TR.ISINCode;TR.PriceTargetMean;TR.F.EV(Scale=6,curn=EUR);TR.ISAccountingStandard","Scale=6 CH=Fd RH=IN",B2)

It should be the content-related issue. Please contact the helpdesk support team directly to verify this formula.

You can typically determine whether the issue is related to content or the Python library by using the Workspace Excel.

EXPLORE OUR SITES