Get reference data from ISIN list

nicklas.rehnby

Im trying to get reference data for a list of ISINs that I read from an excel file.

instrument_list=pd.read_excel("file path...")

I then want to create a df with the reference columns for all ISINs

df, err = ek.get_data(

instruments = instrument_list['ISIN'],

fields = [

'TR.FiAssetStatus',

'TR.FiAssetStatusDescription',

'TR.MUNIInstrumentType',

'TR.FiCurrency',

'TR.FiIssuerName',

'TR.FiIssueDate',

'TR.MUNIAssetStatusEffectiveDate',

'TR.FiFaceIssuedTotal',

'TR.MUNIOriginalAmountIssued',

'TR.ADF_COUPON',

'TR.FiCouponType'])

display(df)

I not sure how to get the the list in to the formula and how to use only use the ISIN-code to get the data.

Any ideas?

jason.ramchandani01

@nicklas.rehnby Please try the code below:

df, err = ek.get_data(
instruments = instrument_list['ISIN'].astype(str).values.tolist(),
fields = [
'TR.FiAssetStatus',
'TR.FiAssetStatusDescription',
'TR.MUNIInstrumentType',
'TR.FiCurrency',
'TR.FiIssuerName',
'TR.FiIssueDate',
'TR.MUNIAssetStatusEffectiveDate',
'TR.FiFaceIssuedTotal',
'TR.MUNIOriginalAmountIssued',
'TR.ADF_COUPON',
'TR.FiCouponType'])
display(df)

I hope this can help.

nicklas.rehnby

It worked. Thank you