Please find the below Client query, kindly look into it the query please:
Query:
I have used the Eikon API for quite a few years now. I rewrote the code to use the LSEG-data API.
- The Eikon API has worked very well with no problems
- The LSEG-data API has problems.
The following code works when configured for the Eikon API worked fine. Configured for LSEG-data causes problems. It is not the code, it is the LSEG-data API that is not behaving correctly.
df = ld.get_data( universe=['BP.L',"GM.N",'F.N','STLAM.MI','JPM.N','META.OQ','HD.N','VOWG.DE', 'MCK.N', 'SHEL.L', 'COST.OQ'],
fields = ['TR.RICCode','TR.OrganizationID','TR.CommonName','TR.IR.RatingSourceCode','TR.IR.RatingScopeDescription','TR.IR.RatingSourceDescription','TR.IR.Rating','TR.IR.RatingDate','TR.IO.Outlook','TR.IO.OutlookDate',' TR.IO.OutlookEndDate','TR.IW.WatchType','TR.IW.WatchTypeDescription','TR.IW.WatchDate','TR.IW.WatchEndDate','TR.IR.VerifiedDate','TR.IR.RatingEndorsement'],
parameters = {'IssuerRatingSrc':'DIS', 'IssuerWatchSrc':'DIS' ,'IssuerOutlookSrc':'DIS', 'RatingScope':'DMS', 'Null':'Blank'})
df.to_csv(rf'C:\Data_aaPython\Paul_Test_Credit Dominion_2.txt', header=True, sep='\t', index=False)
print (df)
The ‘TR.IO.OutlookEndDate’ column of data is shifted to the last column rather than being positioned after ‘TR.IO.OutlookDate’. As a result, all the columns after ‘TR.IO.OutlookDate’ are in the wrong position creating a problem for the code that is looking for specific data. This does not happen with the Eikon API.
