2
$\begingroup$

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

$\endgroup$
4
$\begingroup$

What about DES_CASH_FLOW?

This field returns the securities cashflow schedule. All payment dates are included with the corresponding payment amount.

$\endgroup$
1
  • $\begingroup$ Thats exactly what I was looking for, thank you. $\endgroup$
    – vanguard2k
    Oct 18 '13 at 5:55
2
$\begingroup$

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.

$\endgroup$
3
  • $\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$
    – vanguard2k
    Oct 17 '13 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$
    – sets
    Oct 17 '13 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$
    – Matt
    Oct 18 '13 at 4:23
2
$\begingroup$

For any bond, you can type CSHF (Cashflow Analysis) and export the coupon/principal schedule.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.