Is there a way to obtain OSP/WLD quote data page in API in Eikon?

marceugene.belen

Find more posts tagged with

eikon

api

python api

commodities

eikon-data-api

#technology

Accepted answers

Jirapongse

@marceugene.belen

Yes, the client can use RD library for Python to retrieve this page. The code looks like this:

rics = Chain("OSP/WLD")
df = rd.get_data(rics.constituents)
for index, row in df.iterrows():
    for i in range(1,26):     
      print(row["ROW80_"+str(i)])

It uses the Chain example on GitHub.

All comments

Gurpreet

Hi @marceugene.belen,

The OSP/WLD is an ANSI page based data and the data in the rows/columns can be extracted using real time fields. The page data is contained in the chain RIC's which are in the fields longlink1.. longlinkn.

For e.g:

# display all the columns of data
pd.set_option('display.max_columns', None)
rd.get_data('OSP/WLD')

result:

and now get the data from individual page that form this chain from the RIC contained in Longlink1 (OSPRGHT01):

The page data is contained in the Fields Row80_1 to Row80_n

Jirapongse

@marceugene.belen

Yes, the client can use RD library for Python to retrieve this page. The code looks like this:

rics = Chain("OSP/WLD")
df = rd.get_data(rics.constituents)
for index, row in df.iterrows():
    for i in range(1,26):     
      print(row["ROW80_"+str(i)])

It uses the Chain example on GitHub.

EXPLORE OUR SITES