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

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

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

Answers

  • Gurpreet
    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:

    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


Categories