How to properly use Python to extract data from LSEG workspace

Government bonds, for example RIC = 'GB10YT=RR', which is the 10 Year Government Bonds of the UK. I am trying to grab its daily data. At first, I am using fields=['TR.OpenPrice.date','TR.OpenPrice','TR.HighPrice','TR.LowPrice','TR.ClosePrice'] in my code. But The close price showed nothing.
Then, I changed the fields to ['CF_DATE', 'OPEN_PRC', 'CF_HIGH', 'CF_LOW', 'CF_CLOSE']. This time the result gives me the proper close price. However, The 'CF' can only gives me the data of the latest day, which is shown below
Similarly, I also encountered issues with the FX CROSS RATE for currencies. For example, RIC = 'USDEUR=R'. In Python, I used the corresponding fields=['TR.OPENPRICE.DATE', 'TR.OPENPRICE', 'TR.HIGHPRICE', 'TR.LOWPRICE', 'TR.CLOSEPRICE'], but I was unable to retrieve any data. Then I tried fields=['CF_DATE', 'OPEN_PRC', 'CF_HIGH', 'CF_LOW', 'CF_LAST'], which allowed me to retrieve data for the latest day, but I couldn't retrieve any data for previous days.
I wonder if there is an appropriate way to grab those data.
Answers
-
Thank you for reaching out to us.
Please try the get_history method.
response = ld.get_history( universe = ["GB10YT=RR"], fields = ['BID','HIGH_1','LOW_1','OPEN_PRC'], interval='1D', start='2025-03-18', end='2025-06-18') response
0 -
Thank you very much for your help.
Similarly, I also encountered issues with the FX CROSS RATE for currencies. For example, RIC = 'USDEUR=R'. In Python, I used the corresponding fields=['TR.OPENPRICE.DATE', 'TR.OPENPRICE', 'TR.HIGHPRICE', 'TR.LOWPRICE', 'TR.CLOSEPRICE'], but I was unable to retrieve any data. Then I tried fields=['CF_DATE', 'OPEN_PRC', 'CF_HIGH', 'CF_LOW', 'CF_LAST'], which allowed me to retrieve data for the latest day, but I couldn't retrieve any data for previous days.
This time I tried the method you told me, but it did not work.
0 -
It supports different fields. You can ignore the fields parameter to retrieve all available fields for the subscribed RIC.
response = ld.get_history( universe = ["USDEUR=R"], interval='1D', start='2025-03-18', end='2025-06-18') response.columns
0 -
Thank you for your reply. I have tried your code, and it did print out some results. However, it did not show the result that I wanted.
I want to have the Open, High, Low, and Close price, which are the transaction prices, but the columns printed seemed that it only had ask and bid. Is there any other way (like Item Code) that can help me get the trade price?
Moreover, after I get those fields for different RICs, sometimes there are plenties of fields for only one RIC, how do I get the definition list of those fields instead of checking those fields one by one on the workspace?
0 -
As far as I know, the TRDPRC_1 field is not available in USDEUR=. This is similar to other currencies, such as JPY=, and EUR=.
Please contact the helpdesk team directly via the LSEG Support to confirm this.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 702 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.2K Eikon Data APIs
- 14 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 6 Trading API
- 2.9K Elektron
- 1.5K EMA
- 257 ETA
- 566 WebSocket API
- 40 FX Venues
- 16 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 283 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 24 RDMS
- 2.1K Refinitiv Data Platform
- 823 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
- 122 Open DACS
- 1.1K RFA
- 107 UPA
- 195 TREP Infrastructure
- 232 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 100 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛