Print Page  
FUNDAMENTALS / CORPORATE ACTIONS
DaysToDivEx
Full Description


This is an example showing a stock that has paid two dividends. The AsOf Date is the Point In Time date. The values the functions return are color coded to the corresponding date that is used in the calculation. Please note that these values are, at the moment, only calculated once a week when run in the past. Note also that the "to" functions are null prior to announcements of dividends, so forward knowledge should not be a concern in using these functions.

 

DivA:      ex-date   9/5/2011    pay-date  9/20/2011

DivB:      ex-date   6/1/2011    pay-date  6/30/2011

Dates   DaysFromDivEx DaysFromDivPay DaysToDivEx DaysToDivPay
9/20/11 DivA Pay         
........
9/15/11 AsOf -->  10  N/A N/A  5 
........
9/05/11 DivA Ex        
........
7/30/11 AsOf -->  59   30   37   52 
........
6/30/11 DivB Pay        
........
6/20/11 AsOf -->  19  N/A N/A  10 
........
6/01/11 DivB Ex        
........
5/15/11 AsOf --> N/A N/A  15   45