php scripts - download stock data using yahoo api

I need a php script to download stock data using YQL from yahoo.? I have a database symbol list containing over 7500 symbols which I update daily.? We need to query YQL with each of these symbols, download the data via xml (preferred) or csv and append to a new table in mysql.? The script needs to perform this entire routine for each symbol.? A new table needs to be created from a script you provide with a suggested format for the downloaded data values.? I will kickoff the script via cron daily using the php script to:

1. Match to mysql symbol list table

2. Download data for each symbol on the list

3. Append data to newly constructed table where values have changed

4. If values have not changed for current symbol, go to next symbol.

Data Requirements for yahoo string: dee7e8e9j1j3j4np5p6qrr1r5r6r7sxy

The table data needs to be unique by record.? This could be solved by indexing every row in the table, but I think this will create rather large indexes, therefore I am looking for someone to design a table structure. Instructions can be found on the yahoo api and yql here:

1. <[url removed, login to view]>

2. <[url removed, login to view]>

3. <[url removed, login to view]>

## Deliverables

At complete you will provide me with: 1. 1 Table create script 2. 1 Php script for download and import/append

## Platform

php, mysql

Linux MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3693543

About the project