I am looking for a PHP code that will allow me to do this :
1. Screen Import list of stock symbols into mysql database from CSV file using upload into web function. CSV file format will be this :
<Stock symbol>,<yahoo exchange>, <google exchange>
Note: If both exchange fields are blank for a specific symbol, then its US market. For example Canadian exchange symbol for yahoo is 'to' and google is 'tse'.
2. Screen to allow scrapping historical stock prices from Yahoo Finance and Google Finance going back 'X' number of days/months for all stocks in the database. This will require 2 scrapping engines Yahoo and Google, the screen will let me to choose which engine I will use to scrape historical information.
3. Have a screen to displace a collection of selected stocks from the database in this format :
<Date>, <Stock Symbol>, Closing Price, % of closing price from day before
I like the person who is biding for this project to have very good experience scraping websites using php and mySQL. My budget for this project will be $50
5 freelancers are bidding on average $125 for this job
I have 5 years of experience in scraping information from website using perl and mysql to load the database. if need can provide the out in CSV or excel file also.