Import csv list of DSCodes in DSWS API

markangelo.uy
markangelo.uy
in Datastream

Hi,


I'm trying to run DSWS request using a list of dscodes from a csv vile, but the code I'm using adds "[]" before and after the list, it's returning error. Here's my code


instruments= []


with open('DSCD list1.csv') as csvDataFile:

csvReader = csv.reader(csvDataFile)

for row in csvReader:

for ticker in row:

instruments.append(row[0])



ds.get_data(tickers=instruments,

fields=['SOHSDP032','SOHRDP0103'], start='-12Y', freq='Y')


dsws-api2.png


dsws-api1.png


Thank you.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @markangelo.uy

    Thank you for reaching out to us.

    The tickers parameter acceps a string. Each RIC can be separated by a comma character. 

    ds.get_data(tickers=','.join(instruments),
     fields=['SOHSDP032','SOHRDP0103'], start='-12Y', freq='Y')

    If you have any further questions regarding the retrieved content, please contact the Datastream support team directly via MyAccount to verify the content.

Categories