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.
Best Answer
-
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:
I hope that this information is of help.
0
Answers
-
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.
0 -
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.
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:
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛