Import csv list of DSCodes in DSWS API

markangelo.uy

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')

Thank you.

Jirapongse

@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.