Building A Complete Database of Historical and Realtime Data

CLOSED
Bids
15
Avg Bid (USD)
$201
Project Budget (USD)
$30 - $250

Project Description:
Phase 1:
I need a PHP programmer to read in ALL of the historical stock prices from such a table as shown on:

[url removed, login to view]

UP till the present day, ie from since the start date of the stock such as Nov 26, 1997 until present day.

Have all the data captured inside MySQL database, one table for every stock, with 7 columns in the table, ie
Ticker symbol, followed by Date, Open, High, Low, Close, Volume, Adj Close*.

-I will supply a continuous list of several thousands of ticker stock symbols.
-You have to enable AUTOPILOT execution of running down this list of ticker symbols, to feed the corresponding ticker symbol's data into the MySQL database's tables.

MySQL database be structured this way:
-(a) 1 table for every tick symbol, ie every stock
-(b) 1 consolidated table for all the tables, ie all the stocks put together.

Follow rest of page details on [url removed, login to view]:

########################################
Set Date Range

Start Date: day Year Eg. Jan 1, 2010

End Date: day Year

Allow Frequency to vary between: Daily
Weekly
Monthly
Dividends Only

######################################################

Phase 2:

I will subscribe to real time stock quotes from [url removed, login to view], and you will update in real-time mode, all these new data alongside with the historical data from Phase 1, to preferrably upload into the same corresponding table, (a) above, for the particular ticker symbol in the MySQL database, so as to add on new data to the old data for the same stock. Of course, the consolidated table of all tables, ie (b) above will also be updated at the same time.

Phase 2 will run continuously so as to read in the latest data available into the MySQL database.

Additional Project Description:
02/02/2013 at 22:08 EST
Since the real download can take a long time to finish, and I need to pay the programmer fast as soon as the setup is done, suggest 2 further steps to produce a win-win situation (so that the programmer can get paid earlier):

1) Create a frontend window or option to select a ticker symbol and download all its stock data from the corresponding table from mysql database into csv files. We can use the csv files to check against actual data from Yahoo finance to confirm the data are accurate and all downloaded. The same goes for the conso table, a download of which, shows all the stock data all downloaded up to that point, in csv file format, which reflects what is in the state of the mysql table now.

2) Ability to bring in a different list of ticker symbol names, each time to do the continuous download of data from Yahoo finance. This is just a csv file. If successful each time a different list is used, it shows the download is successful.

Skills required:
MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 7 days
$ 250
in 15 days
$ 170
in 8 days
$ 200
in 1 days
Hire rajibdebslg
$ 150
in 15 days
$ 250
in 20 days
$ 250
in 15 days
$ 185
in 10 days
Hire phongpp2000
$ 180
in 5 days
Hire codehard
$ 199
in 10 days