Closed

Building A Complete Database of Historical and Realtime Data

This project received 15 bids from talented freelancers with an average bid price of $201 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
15
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online