HELP - HOW DOWNLOAD THIS DATA WITH EIKON API??

Good evening,

I'm trying different Eikon API functions for downloading the Reuters screen "NARODOWY" as dataframe. Also considering words as "ROWS80_7" I have no results...

If anybody can help me i'll be very grateful.

My intention is to obtain a dataframe in my python code with the table attached.

Find more posts tagged with

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Jirapongse

@Nabil Edriss Sanchez1

You can use the following code to get the ROW80_nn fields.

df, err = ek.get_data('NBPFIXA', 
                      ['ROW80_1','ROW80_2','ROW80_3','ROW80_4','ROW80_5',
                       'ROW80_6','ROW80_7','ROW80_8','ROW80_9','ROW80_10',
                       'ROW80_11','ROW80_12','ROW80_13','ROW80_14','ROW80_15',
                       'ROW80_16','ROW80_17','ROW80_18','ROW80_19','ROW80_20',
                       'ROW80_21','ROW80_22','ROW80_23','ROW80_24','ROW80_25'])   
df.T

The output is:

All comments

Jirapongse

@Nabil Edriss Sanchez1

You can use the following code to get the ROW80_nn fields.

df, err = ek.get_data('NBPFIXA', 
                      ['ROW80_1','ROW80_2','ROW80_3','ROW80_4','ROW80_5',
                       'ROW80_6','ROW80_7','ROW80_8','ROW80_9','ROW80_10',
                       'ROW80_11','ROW80_12','ROW80_13','ROW80_14','ROW80_15',
                       'ROW80_16','ROW80_17','ROW80_18','ROW80_19','ROW80_20',
                       'ROW80_21','ROW80_22','ROW80_23','ROW80_24','ROW80_25'])   
df.T

The output is:

Nabil Edriss Sanchez1

MANY THANK YOU

Gurpreet

Hi @Nabil Edriss Sanchez1, Here is how you can get the ANSI page into dataframe. This is exactly that @Jirapongse has posted, but further splitting the rates data into a table.

idx = [1, 7, 16, 22, 31, 37, 46, 52, 61, 67, 76]
flds = ['ROW80_{}'.format(x) for x in range(7, 15)]
df, err = ek.get_data('NBPFIXA', fields=flds)
dfRes = pd.DataFrame()
for fld in flds:
    sStr = [df[fld][0][pre:cur].strip() for pre,cur in zip(idx, idx[1:])]
    dfRes = dfRes.append(pd.Series(sStr), ignore_index=True)
dfRes

EXPLORE OUR SITES