![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Simple Php/mysql Script |
![]() |
Bidding Time: |
16/07/2008 02:32 - 30/07/2008 02:32 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
I need a simple script that will perform the following tasks: 1) Scrape dividend data from the following pages (for previous day) http://aol.ccbn.com/dividend.asp?date=20080715&client=aol http://www.smartmoney.com/marketcalendar/index.cfm?story=dividends&symbol= http://www.earnings.com/dividend.asp?date=20080716&client=cb http://online.wsj.com/mdc/public/page/2_3022-dividends.html?mod=topnav_2_3100 2) Compare and consolidate data 3) Insert unique records into a database. If the record (date. ticker) already exists, do not insert. Here is a sample insert query: INSERT INTO `db_name`.`div_Dividend` ( `StockTicker` , `CompanyName` , `DividendAnnouncementDate` , `DividendRecordDate` , `DividendPayDate` , `DividendAmountPerShare` , `updateTime` ) VALUES ( 'FL', 'Foot Locker, Inc.', '2008-07-15', '2008-07-18', '2008-08-01', '.15', '2008-07-15' ); Yes. Very simple. Related Projects: This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
N/A |
Database System: |
N/A |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /0.69 |