Closed

Building A Complete Database of Historical and Realtime Data

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.

Skills: MySQL, PHP

See more: stock building supply, php programmer prices, need mysql programmer, high volume database, execution table, consolidated supply, new mode, realtime data feed, g finance, realtime, database building, data structured, d a, autopilot, structured database, list stocks, daily stock volume list, stocks list, stocks data, database rest, finance database, realtime php, data feed quotes, stock prices mysql, yahoo stock historical data

About the Employer:
( 154 reviews ) SINGAPORE, Singapore

Project ID: #4203339

12 freelancers are bidding on average $207 for this job

SigmaVisual

Bid for phase 1.

$250 USD in 7 days
(236 Reviews)
7.8
srinichal

I can deliver a script to your specs

$250 USD in 15 days
(82 Reviews)
7.0
gopalvora

Hi Ready to start Thanks

$170 USD in 8 days
(171 Reviews)
6.9
ETNASoftware

Hello, I have couple of guys who would be perfect fit with extended technological background & experience with real-time data streaming and historical data database design. Examples of our projects: etnasoft.com/ More

$200 USD in 1 day
(1 Review)
5.0
rajibdebslg

HI, THANKS FOR YOUR INVITATION. PLEASE SEE PMB FOR DETAILS.

$150 USD in 15 days
(40 Reviews)
5.0
Voyageinfo

Dear sir, A software company which established in 2001 , having HO in Indore (India) , we are having our clientele in all over the world. I am representing Voyage Infosystems Pvt. Ltd.. We are a team of 50+ high More

$250 USD in 20 days
(14 Reviews)
4.8
stefanache

Hello, Please consult your PMB. Thanks.

$250 USD in 15 days
(15 Reviews)
4.8
raziel27

Ready to Work

$185 USD in 10 days
(4 Reviews)
4.5
phongpp2000

ready to start

$180 USD in 5 days
(20 Reviews)
4.2
codehard

We are PHP Experts and are in business since 2006 and have developed more then 300+ PHP Projects . Lets get this PHP project done and you will not be disappointed . Please check your PMB

$199 USD in 10 days
(5 Reviews)
3.2
phpcoderguru

We can do it

$150 USD in 5 days
(1 Review)
0.0
unibit

25 years experience in building sofisticated web and desktop solutions. Please check PM

$240 USD in 7 days
(0 Reviews)
0.0
richardcoffee

I already have a perl program that does almost exactly what you want. Converting it to php would be simple. However, you need to be aware that the yahoo csv file, which gives the complete price history, does not incl More

$200 USD in 6 days
(0 Reviews)
0.0
tsft

20 years Old experienced Programmer and Translating Service offer the quality you need. I am ready to start, HTML, PHP, MySQl, Text parsing experience. Ready to start and deliver the best with control of the running s More

$250 USD in 30 days
(0 Reviews)
0.0