Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

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

1722520121076.png

eikoneikon-data-api#technologyapipython apicommodities
1722520121076.png (93.3 KiB)
icon clock
10 |1500

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

Upvotes
Accepted
85.1k 290 53 77

@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)])

1722566923228.png

It uses the Chain example on GitHub.


1722566923228.png (27.3 KiB)
icon clock
10 |1500

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

Upvotes
24.5k 63 15 21

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:

1722524203544.png

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

1722524592621.png

The page data is contained in the Fields Row80_1 to Row80_n



1722524203544.png (19.0 KiB)
1722524592621.png (41.8 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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