Hello Gary,
I don't mean to be a pain, but it appears that the QP dividend
related data needs a complete relook and overhaul. After finding
problems with the few stocks that I own, I decided to examine the
extent of the problem. I've already posted a list of some stocks
that appear to have duplicated dividends with duplicated payment
dates. Microsoft was one of them. There also appears to be scores of
stocks if not hundreds that have payable dates in the -3 hole in
1999, 1998, 1995, etc...yet the date in the 0 or -1 hole is 2006.
How can this be?
Below are just a few. This is using the Excel functions. This
creates problems. Using data such as this, how can one create
algorithms that identify the most recent payable date?..and
associated payment? Is it in the 0, -1, -2, or -3 hole? Seems to
vary all over the lot.
Question: with QP price data, the most recent price is in the 0
hole, 2nd most recent is in the -1 hole, etc. Why not make it the
same with the dividend data? Normally, it currently appears that
with QP dividend data, that the most recent payable date is in the
-3 hole, when I would expect it to be in the 0 hole. But also,
often, as shown below, the most recent can be in the -1, or -2 hole
with the other holes filled by some date that is years in the past.
This matter really needs to be fixed. Thx.
Below are just a fraction of these.
Dividend Payable Date
Ticker 0 -1 -2 -3
ABB 12/4/03 6/19/06 11/30/99 11/30/99
ABG 8/24/06 11/16/06 11/30/99 11/30/99
ACN 11/15/05 11/15/06 11/30/99 11/30/99
AFN 12/15/06 11/30/99 11/30/99 11/30/99
AFSI 1/16/07 11/30/99 11/30/99 11/30/99
AHD 8/14/06 11/17/06 11/30/99 11/30/99
AHGP 8/18/06 11/17/06 11/30/99 11/30/99
AMH 12/3/02 12/15/03 12/15/04 12/8/05
ARII 4/6/06 7/14/06 10/20/06 11/30/99
ARTW 11/30/05 11/30/06 11/30/99 11/30/99
ASX 10/22/03 11/30/99 11/4/05 11/4/05
ATE 11/30/99 11/30/99 11/30/99 11/30/99
AUO 9/22/05 9/2/05 9/7/06 11/30/99
AUY 10/13/06 1/16/07 11/30/99 11/30/99
AWH 12/21/06 11/30/99 11/30/99 11/30/99
AYR 11/15/06 1/15/07 11/30/99 11/30/99
BANR 10/9/98 7/10/98 1/9/98 4/9/98
BBSI 5/23/94 5/19/05 12/21/06 11/30/99
BBV 4/3/00 5/4/00 5/4/00 7/20/00
BC 12/13/02 12/12/03 12/15/04 12/15/05
BCA 3/1/04 3/4/05 11/30/99 11/30/99
