How can I extract daily data for all Datastream indices in Excel using a formula similar to DSGRID?

Question

I am currently using the following DSGRID formula to extract data for the FTSE 100 index using its Datastream code: Any suggestion in extracting data through Python also helps.

=@DSGRID("LFTSE100","WSCD,SECD,NAME,TIME,WC05661","Latest Value","","","RowHeader=true;ColHeader=true;Heading=true;DispSeriesDescription=true

Jirapongse · Answer

@Nirmala

Thank you for reaching out to us.

You can use the Datastream Webservice (DatastreamPy) to extract data. The code looks like this:

df = ds.get_data(tickers='LFTSE100',fields=['WSCD','SECD','NAME','TIME','WC05661'], start='LATESTDATE', kind=0)
df.pivot(index='Instrument', columns='Datatype', values = 'Value')

EXPLORE OUR SITES