How to get Total Accrued Interest Amount over a period

roman.wang01

Hi there,

I'm trying to compute the P/L value of a portfolio. I would need the "total accrued amount" for a fixed income security over a specific period.

For example, XS1700429480 (ISIN) has paid accrued interest of $0.00325 over the period of Apr 1 to May 11, 2021. Is there a way to fetch this number?

The formula I'm using now is: (but it's not correct)

=TR("XS1700429480","sum(TR.FiAccruedInterest)","SDate=1/4/2021 EDate=11/5/2021","CODE=ISIN")

Thanks so much!

Alex Putkov.1

@roman.wang01

There's no single function in Eikon that can return the number you're looking for. In order to calculate this number you need to generate bond cashflows (all coupon payments) between two dates, calculate accrued at the start and end dates and sum it all up.

Attached is an example spreadsheet.

BondReturnFromCoupon.zip

roman.wang01

https://community.developers.refinitiv.com/discussion/comment/79364#Comment_79364

Hi Alex, thanks for your reply! Can I check what is this "=BdCashFlows" function? The data don't show up on my end...I see all "#NAME?" instead!

I am using Refinitiv Eikon's excel add-in (please see attached).

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/79373#Comment_79373

@roman.wang01

To enable BdCashflows and other Adfin functions click on Settings under Refinitiv Eikon tab in Excel ribbon. In the Settings window click on Memory Optimization. Under Memory Optimization make sure that the module named Adfin is on.

roman.wang01

https://community.developers.refinitiv.com/discussion/comment/79431#Comment_79431

Thanks again for your reply! I do not have the Memory Optimization tab under my refinitiv settings. Is this something to do with my licence type, or the version of my refinitiv? I tried googling but can't really find an answer :-/

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/79503#Comment_79503

@roman.wang01

I opened a support case on your behalf with Refinitiv Helpdesk. You will be contacted by Refinitiv Support to help you enable Adfin functions in Eikon Excel on your machine. For your reference the case number is 09988441.

roman.wang01

https://community.developers.refinitiv.com/discussion/comment/79506#Comment_79506

Hi Alex, thanks a lot for your help! The issue got resolved

waglon

Accrued Interest formula calculates the interest amount which is earned or which is payable on the debt over one accounting period but the same is not received or paid in the same accounting period and it is calculated by multiplying the principal amount with rate of interest and number of days for which debt is given or taken and then dividing it with total number of days in a year.