Could you please create a formula in phyton?

Vikram_2910

LSEG series (1).xlsx

I have a data series for 'iBoxx EUR Banks Senior United Kingdom - Optional Adj Sprd - iBoxx EUR Banks Senior United Kingdom - Optional Adj Sprd' which I currently pull through into a spreadsheet with the IBEBSUK ticker. Would you have some sort of guide for doing similar things with R or other programming languages

Jirapongse

@Vikram_2910

The Excel uses the Datastream to retrieve data. Therefore, the client can use the Datastream Webservice with Python to retrieve data. The Python library for the Datastream Webservice is DatastreamPy.

The code looks like this:

import DatastreamPy as DSWS

ds = DSWS.DataClient(None, username = 'DSWS_USERNAME', password = 'DSWS_PASSWORD')

ds.get_data(
    tickers = 'IBEBSFR,IBEBSGR,IBEBSIT,IBEBSUK,IBEBSUS,IBEBSJP,IB£CSAL,IB£BSNR,IB£BSUB',
    fields = ['OAS'],
    freq = 'D',
    start = '-20Y',
    kind = 1)