HELP - HOW DOWNLOAD THIS DATA WITH EIKON API??

Nabil Edriss Sanchez1

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.

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