question

Upvotes
Accepted
3 0 0 3

Unable to get Lotsize from Refinitiv Data libraries as without using Eikon Workspace

I am using Refinitiv Data Platform libraries and using the Python module 'refinitiv-data'. I am trying this on Codebook and also on my local machine(windows).


I am working on Getting data for the commodities and looking for the unit of measure of the commodity spot. I am unable to map it to any of the existing API fields that are provided in the codebook metadata file.



I have a got a response from the Refinitiv contact(Dave Stewart) that I can use LotsZUNIT2 to fetch the field, but I am getting an integer value 29 instead of getting the value LBS.




I have been asked to raise it in this Developer portal to get the expert's advice.

#productrdp-apipython api
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.

Upvote
Accepted
87.2k 294 53 79

@shouldcost

Thanks for reaching out to us.

When using the platform.rdp session, you can use the below code to get the data.

stream = rd.open_pricing_stream(
    universe=['/SBc1'],
    fields=['LOTSZUNITS']
)
stream.get_snapshot()

The output is:

1682571666945.png

I hope that this information is of help.


1682571666945.png (10.9 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
3 0 0 3

Hi @Jirapongse


Thanks for you answer. I have tried to use the field to get the data. I was unable to get information for the fields in my RIC list. I did not get any data for them


I even tried the example that you have shown in your screenshot. I have below response instead of LBS. Please let me know if I am doing anything wrong in here. I am just trying in codebook not even in my local editor.


1682575465831.png



1682575465831.png (17.2 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.

Upvote
87.2k 294 53 79

@shouldcost

I checked and found that the desktop session and codebook return the enumerated value (29), not the expanded string (LBS). This could be a limitation of the desktop session and codebook.

The workaround could be loading the data dictionary files (RDMFieldDictionary and enumtype.def) to expand the enumerated fields.

You can use the code (RDMFieldDictionary.py) on GitHub.

1682584507593.png

Rename the RDMFieldDictionary file to RDMFieldDictionary.txt and the enumtype.def to enumtype.def.txt.

For example:

%run ./RDMFieldDictionary.py
dict = RDMFieldDictionary("RDMFieldDictionary.txt", "enumtype.def.txt")
stream = rd.open_pricing_stream(
    universe=['/SBc1'],
    fields=['LOTSZUNITS']
)
df = stream.get_snapshot()
dict.GetExpanedEnumString("LOTSZUNITS",df["LOTSZUNITS"][0])

The output is:

1682584665338.png


1682584507593.png (32.3 KiB)
1682584665338.png (22.9 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.