For a specific bond I need to calculate the time until each of the upcoming cash flow payments (for obvious reasons). So I wondered if there is a field (bulk data) that gives me all the dates of the coupons (if any)? I tried the FLDS command but found nothing...
3 Answers
What about DES_CASH_FLOW?
This field returns the securities cashflow schedule. All payment dates are included with the corresponding payment amount.
-
$\begingroup$ Thats exactly what I was looking for, thank you. $\endgroup$ Oct 18, 2013 at 5:55
I am not sure if the exact upcoming coupon dates can be retrieved in BBG, but using the fields:
DAYS_TO_NEXT_COUPON or NXT_CPN_DT (Days to next coupon / next coupon date)
plus
CPN_FREQ (coupon frequency)
it should be easy to calculate the time until each upcoming coupon date.
Of course, these coupon dates would be an approximation (ie: they might be off by a couple of days), so I am not sure if this appraoch is good enough for you.
-
$\begingroup$ Yeah I found those but I didnt want to play around with calenders, weekends, public holidays and so forth. Nevertheless, there is the sad possibility that the field I am looking for does not exist. For now, I only upvoted your answer. $\endgroup$ Oct 17, 2013 at 12:17
-
2$\begingroup$ You can always ask the support team in their live chat (HELP HELP). They will likely provide an answer within minutes $\endgroup$– setsOct 17, 2013 at 13:43
-
$\begingroup$ You can get the next coupon dates as the previous answers and this shows. But I do not understand your comment about not wanting to deal with calendars. Bloomberg has also calendar functions with overrides where you can specify the locality and start and end date and hence get the number calendar and business days between the specified dates. What else do you need? $\endgroup$ Oct 18, 2013 at 4:23
For any bond, you can type CSHF (Cashflow Analysis) and export the coupon/principal schedule.