Past prices

Hi there,
Client is using desktop session for RD library desktop session to access historical pricing endpoint.
They are interested in:
- Scanning and extracting the existing issuances of the Thailand government bonds
- Retrieving the past EOD prices for these bonds, up to a year ago.
They would like to have an example of retrieving historical prices.
Thank you!
Best Answer
-
Hi @yeo.cy ,
I'd recommend you to check article Find content and functionality using Refinitiv Data Library with Eikon Advanced Search of how to use Advance Search (AS) app to find the government bonds, below is an example
As the moderators in this forum are not an expert in all of the contents available in our platform, you may need to check how to form the filter for advance search with content team to confirm if this is what the customer is looking for.
Then after you follow the instruction in mentioned article to export query from AS
import refinitiv.data as rd
rd.open_session()
# search for the bond you're looking for
df = rd.discovery.search(
view = rd.discovery.Views.GOV_CORP_INSTRUMENTS,
top = 10,
filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and IsActive eq true and (RCSCountryGenealogy eq 'M:DQ\G:1\G:3R'))",
select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,RCSCountryGenealogy"
)
# convert RIC in the result to a list for the next step
rics_list = df['RIC'].to_list()
# retrieve historical close price
# FOR DEMONSTRATION PURPOSE, ONLY FIRST 9 RICS ARE USED IN THE FUNCTION BELOW
rd.get_history(universe=rics_list[:10], fields=["TRDPRC_1"], interval="1D",
start = '2022-09-01', end = '2023-09-01')and here's the result
Please be aware of the limit of usage, for RD library desktop session, the limit can be checked at Usage and Limits Guideline.
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
- 693 Datastream
- 1.5K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 13 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 5 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 561 WebSocket API
- 39 FX Venues
- 15 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
- 281 Open PermID
- 46 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 728 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
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 96 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛