0

I want retrieve the financial data from Refinitiv, I use the code below, the 122.csv have many ric of companies, but when I run the code, the results only shows the first company's information, and the ric of the first company is incomplete,

with open (r'C:\Users\zhang\Desktop\122.csv',encoding='utf-8') as date:
 for i, line in enumerate(read_csv(date)):
          RIC = line[0]
          SDate = '2013-06-10'
          EDate = '2015-06-10'
df1,das= ek.get_data(RIC,fields =[
                                  'TR.F.TotAssets(Scale=6)',
                                  'TR.F.DebtTot(Scale=6)',]                                                                        
                                  parameters = {'SDate':'{}'.format(SDate), 'EDate': '{}'.format(EDate)},
                                         )
df1

the result:

    Instrume  ntTotal Assets Debt - Total
0   A   10686   2699
1   A   10815   1663

How can I generate the whole list of ric of companies in my csv file?

0 Answers0