How to get Total Accrued Interest Amount over a period

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!
Best Answer
-
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.
0
Answers
-
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).
0 -
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.
0 -
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 :-/
0 -
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.
0 -
0
-
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.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 683 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 627 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 84 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛