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

mB_KK34
mB_KK34 Newcomer
edited June 4 in Workspace SDK

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

Tagged:

Answers

  • Gurpreet
    Gurpreet admin

    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 June 2

    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.

    sc1.png
    sc2.png
  • Gurpreet
    Gurpreet admin
    https://community.developers.refinitiv.com/discussion/comment/126077#Comment_126077

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

    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.

  • Gurpreet
    Gurpreet admin
    https://community.developers.refinitiv.com/discussion/comment/126098#Comment_126098

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

  • Gurpreet
    Gurpreet admin
    https://community.developers.refinitiv.com/discussion/comment/126104#Comment_126104

    PS: it should be ld.get_data and not rd.get_data.

  • pf
    pf LSEG
    edited June 18

    Hi @mB_KK34 ,

    rd.get_data() or ld.get_data() functions are very simple, but it's a catch-all that doesn't work in all cases, and when there is issues, it isn’t visible and error cannot be catched.
    It's better to use more specific APIs appropriate like rd.content.pricing

    In this case ('EURUSDFIXE=WM'), I cannot explain why data is empty.
    To get the underlying error, I'll suggest to use following code:

    response = ld.content.fundamental_and_reference.Definition(
    universe="EURUSDFIXE=WM", 
    fields=["CF_LAST"]).get_data()
print("result:", response.data.df)
print(response.errors)

    Output:

    result: Empty DataFrame
Columns: []
Index: []
[Error(code=-1, message="No data item defined. Requested universes: ['EURUSDFIXE=WM']. Requested fields: ['CF_LAST']")]

    For 0#CSRRF:, as it's a chain, it's recommended to retrieve its constituents before querying the fields:

    chain = ld.discovery.Chain("0#CSRRF:")
print("constituents:", chain.constituents)
df = ld.get_data(universe=constituents, fields=["CF_LAST"])
print(df)

    Output:

    constituents: ['CSRRM25', 'CSRRN25', 'CSRRQ25', 'CSRRU25', 'CSRRV25', 'CSRRX25', 'CSRRZ25', 'CSRRF26', 'CSRRG26', 'CSRRH26', 'CSRRJ26', 'CSRRK26', 'CSRRM26', 'CSRRN26', 'CSRRQ26']
Instrument  CF_LAST
    
0     CSRRM25    540.5
    
1     CSRRN25    538.0
    
2     CSRRQ25    543.5
    
3     CSRRU25    547.5
    
4     CSRRV25    554.0
    
5     CSRRX25    556.0
    
6     CSRRZ25    564.5
    
7     CSRRF26    569.5
    
8     CSRRG26    574.5
    
9     CSRRH26    582.0
    
10    CSRRJ26    589.5
    
11    CSRRK26    594.5
    
12    CSRRM26    594.5
    
13    CSRRN26    594.5
    
14    CSRRQ26    594.5

Categories