VbaFin.com

Visual Basic for Financial Professionals
   Home      CA Tool
The spreadsheet is designed to retrieve Equity Corporate Actions Data based on the following Bloomberg fields:

  • Dividends: DVD_EX_DT, DVD_PAY_DT, EQY_DVD_CASH_NET_NEXT, LAST_DPS_GROSS, DVD_CRNCY, DVD_TYP_LAST
  • Splits: EQY_SPLIT_DT, EQY_SPLIT_RATIO, EQY_DVD_SPL_EX_DT_NEXT, EQY_DVD_SPL_PAY_DT_CURR
  • Rights: EQY_DVD_RIGHT_EX_FLAG, EQY_DVD_RIGHT_EX_DT_CURR, EQY_DVD_RIGHT_PAY_DT_CURR
  • Spin Off: SPINOFF_EX_DT
  • Mergers and Aquisitions: MA_TRANSACTION_ANN_TODAY
It can then be emailed. Click on the image to download the file.