We need to build a new tool, Split Reporter, to view a split calendar and compare it with our securities that we currently hold in our database. Then email out an email with the list of securities that will be split next week in our portfolios, along with the pre-number, the split count, and the post number. For example the email could be formatted like:
November 17, 2003 <--- b/c split b4 market open on 11/18
ERTS 2 for 1 split
TLF 84,400 pre; 168,800 post
TVF 250,000 pre; 500,000 post
AXAVIP 20,100 pre; 40,200 post
The split calendar is located below in html format which we need to parsed the XML data from the web page and insert it to our SQL 2000 database for comparison:
[url removed, login to view]
We need to run this task every morning and check for any changes to the splits calendar and update the database. Then send out any email for next week split for any securities in our portfolios.
Should be an easy project!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).