For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
nicklas.rehnby avatar image
16 ●1 ●2 ●1

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?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

nicklas.rehnby avatar image nicklas.rehnby

It worked. Thank you

Click below to post an Idea Post Idea