I require someone to write me a script to extract the following from google finance using the google finance API ([url removed, login to view]):
This needs to be done for every stock in the asx (australian) stock exchange which I can supply as a list and should ultimately be stored in an online table.
Every day I want to run this script (cron job) and have it dump the end of day data to a mysql database so that I can build up historical data for share prices in the australian stock exchange.
All of the information on how to interrogate the google finance API is supplied by google in the link above and I will be suppling the list of companies for which the data needs to be returned, therefore I don't see this as an overly complicated job.
Forgot to mention,
This script needs to be bullet proof. There are thousands of stocks on the asx. If this script fails to get the data for just one of them every time it is run, the data integrity will be ruined and the whole data will be useless. The script therefore needs to be able to handle timeouts or error codes when the requests are made. This shouldn't be too much of a problem considering the data is coming from google servers but still is a very important consideration and needs to be mentioned.