Get reference data from ISIN list

Question

Question by nicklas.rehnby · Jan 18 at 10:01 AM · python api python api eikon

Get reference data from ISIN list

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?

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2021-01-18T10:11:47Z

REFINITIV

Best Answer

Answer by jason.ramchandani · Jan 18 at 10:11 AM

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

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nicklas.rehnby · Feb 03 at 03:22 PM 1

Share

It worked. Thank you

Get reference data from ISIN list

1 Reply

Watch this question

Related Questions