SYMBOL DIVIDEND AMT EX-DIV-DATE LAST PRICE PERCENT CHANGE
Needs to pulled in by program. This is today's Net
I am currently
If ex-Div date is in the past, use Change. Also
using MSN Money
Entered manually last dividend amount. If ex-Div currently provided
Needs to pulled in Add-In for this.
by me. Probably date is in future, I want the by MSN Money Add-
by program. Need to decide
several hundred. new declared amount. This In. Need to decide
whether to stick
should be the same field on whether to stick
with that or not.
many data sources. with that or not.
EXAMPLE - EX-DIV DATE IN PAST or TODAY
AGNC $ 1.400 9/24/2010 Varies Varies
AGNC
EXAMPLE - EX-DIV DATE IN FUTURE
ELNK $ 0.160 12/6/2010 Varies Varies
ELNK
PROGRAM REQUIREMENTS
Must be compatible with Excel running on a Windows Server 2008 via Terminal Services.
Program must have a refresh function (ideally a fixed button on toolbar) to allow for downloading of updated information.
Stock symbols are only present in one column (approx 300). Cells in other columns ideally can reference the stock symbol co
Should ideally be compatible with all valid symbols including those for Preferred Stocks (e.g XCJ, GE-A), OTC stocks (e.g. BLXJF
BONUS FEATURES (NOT ESSENTIAL BUT DESIRABLE IF EASY TO DO)
Ability to download Stock Scouter rating and display it in a cell on the same row of info. http://moneycentral.msn.com/inves
Ability to download Navellier OVERALL rating and display it in a cell on the same row of info. http://www.navellier.com/tool
Ability to download Risk and Analyst rating from MSN Watch List. http://moneycentral.msn.com/investor/quotewatchlist.as
#1 Prior Ex-Div Date #1 Peak #2 Prior Ex-Div Date #2 Peak
If Ex-Div date is TODAY or
This is the High interday
in the past, the date
trading price (not
displayed here should be
closing price) reached This is the High
the Ex-Div date.
during the 5 trading trading price
This would be the
days immediately reached during the
If Ex-Div Date is in future, previous Ex-Div Date
BEFORE the #1 Ex-Div 5 trading days
this date should be the prior to the one
date. If this can’t be immediately
previous Ex-Div Date. ending up in #1
done, then I'll settle for BEFORE the #2 Ex-
the high on just the last Div date
I always want the last Ex-
trading day preceding
Div Date that has actually
the #1 ex-Div date.
occurred.
9/24/2010 $ 30.090 6/28/2010 $ 29.020
9/2/2010 $ 8.770 6/10/2010 $ 8.650
updated information. REFRESH BUTTON
nce the stock symbol column rather than needing the symbol to be hard coded in their formula.
A), OTC stocks (e.g. BLXJF), and Pink OTC stocks (e.g. BTBIF).
ycentral.msn.com/investor/StockRating/srsmain.asp?Symbol=agnc
www.navellier.com/tools_research/view_stock_grade.aspx?Symbol=agnc
vestor/quotewatchlist.asp or similar ratings from another source.