I can display RICs in Quote window but I can't reach them via python in Codebook

Hello,

I encountered an issue with some RICs (e.g. USDEURFIXE=WM, PLN=D3, 0#CSRRF) which I can display in Quote window in Workspace, but I can't reach them via python (neither in Workspace Codebook nor with external python).

I have checked both with my internal teams as well as with LSEG support and it seems like I have all neccessary permissions to access these RICs (which is supported by the fact that I can display them in Quote).

However, when I try to reach them using python I either:

1. get empty values - in case I try following code:

import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['EURUSDFIXE=WM'],
fields = ['CF_ASK']
)
print(df)

2. Codebook doesn't display anything and it looks like it's loading indefinitely - in case I try following code:

import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['EURUSDFIXE=WM'],
fields = ['CF_ASK']
)
display(df)

version from point 2. is from Workspace CodeCreator.

I CAN access these RICs with Workspace Excel, I can't with python and R.

Can you please assist? I had 2 cases opened to LSEG support and after a month of no real answer I was redirected here.

Thank you.

Krzysztof

Answers

  • Hello @mB_KK34

    I don't have access to these RIC's so I couldn't get any data for these. Only one I can get is the chain RIC - for which there is a typo in your question.

    image.png

    I would recommend that you use the Data Item Browser (DIB) to see which fields have data available for them.

  • mB_KK34
    mB_KK34 Newcomer
    edited 9:40AM

    Hello @Gurpreet

    What do you mean there is a typo in my question? I can access RIC 0#CSRRF when I open it in Quote, but in CodeBook it returns nulls (as on screenshots). And the fields that I am looking for are in DIB so that's not the issue.

  • The typo I was referring to is missing ":" at the end of 0#CSRRF:, in your question. I have seen that I can query this RIC using LD Library, but for some reason RD library is not returning any data.

    Can you try your queries with the newer LD Library.

  • mB_KK34
    mB_KK34 Newcomer

    Hello @Gurpreet

    Sorry I don't know if I follow you.

    1. For now I am using CodeBook, not an external python. Do you mean that python inside Workspace doesn't have the newest LSEG Data libraries?
    2. My whole team had Workspace installed more or less at the same time. How come accessing these RICs works for some of us, while it doesn't work for others? Moreover none of us installed any additional/different libriaries in Workspace…
    3. If I have to still install any new library in CodeBook, how can I do it? When I try the command from the link you sent in your last reply (pip install lseg-data) I get an answer as on a screenshot. And after restarting the Kernel the behaviour is still the same…
    image.png
  • LD library is already available within the Codebook environment. Just do as shown in the screenshot. If you have relevant permission, you should be able to get data as shown -

    image.png
  • mB_KK34
    mB_KK34 Newcomer

    Hi @Gurpreet

    And that's the whole point of my question here and previous Cases to LSEG Support - I have all permissions (double checked by LSEG Support) yet I can't access anything for these RICs in Codebook:

    image.png

    All I get is "Empty DataFrame" .

    I know it should work. But as you can see, it doesn't. LSEG support was analysing WHY for a month, with no success. I was asked to try my luck here, in the developer portal.

  • @mB_KK34

    We are referring to two different libraries. The code snippet that you show is using the legacy RD libraries, and the one I show uses the newer LD libraries. These both are available in the Codebook environment; but the RD Libraries would eventually go away. Can you try the same code, but with LD Libraries instead:

    import lseg.data as ld
    ld.open_session ….
    

    The legacy RD library is trying to get the CF_ASK field from the real time feeds. The permissions on these RIC's are very restrictive, and so I am unable to request data.

    We don't have access to user entitlements. You should reach out to your LSEG account manager to help check why you can't get real time data for it.

  • mB_KK34
    mB_KK34 Newcomer

    Hey @Gurpreet

    Sorry I missed it. I tried with lseg.data, but the result is the same

    image.png

    In the meantime I contacted our account manager, thanks…