Hi,
I'm trying to retrieve both time-series and static bond data in Excel using the Refinitiv Data Library Add-In. I'm logged into Refinitiv Workspace and the Excel add-in is active.
However, the following formulas aren't returning any data, even though the RIC in F4 is valid and the dropdown setup works:
- Time-series pricing formula:
=@RDP .HistoricalPricing(F4,"YLDTOMAT;BMK_SPD;DIRTY_PRC;MID_YLD_1;MOD_DURTN","INTERVAL:P1D SOURCE:RFV NBROWS:2000","FRQ:SNAP","CH:Fd TSREPEAT:NO RH:Timestamp")
- Static metadata formula:
=@RDP .Data(F4,"TR.FiIssueDate;MATUR_DATE;TR.FiCurrency;TR.FiMinCreditRating;TR.ADF_COUPON;TR.FIInstrumentTypeDescription")
I've tried testing with simpler queries (e.g., just one field like DIRTY_PRC) and hardcoded RICs, but none of the fields return data. I've confirmed the Refinitiv Data Library Add-In is enabled and that I'm signed into Workspace on a university-provided machine.
Could you please confirm:
- Whether these fields are supported and entitled under my institutional license?
- Whether historical yield fields like
YLDTOMAT and BMK_SPD are available for the RICs I’m using (e.g., MYSUK220317=)? - If there are any known issues with RDP formulas failing silently even when connection is active?
Any help would be much appreciated — I’m using this for my dissertation and just need to confirm that I’m querying things correctly and that the entitlements are in place.
I've also attached the excel sheet for reference.
