Help with Excel Add-In for RDP Bond Time Series and Static Data (Formulas Not Returning Values)

Farnad

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:

1. 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")

1. 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.

Bonds.xlsx

raksina.samasiri

Hi @Farnad ,

Thank you for participating in the forum. However, your question is about the Excel add-in issue and the available functionality, rather then about the API usage. Hence, the best approach is to reach out to helpdesk directly, by submitting Workspace Excel question via MyAccount and the helpdesk will assist you on this.