Write a cron job to retrieve Yahoo finance information for stock symbols provided in a text file every 15 minutes. The job will destroy the database table once a day at midnight and build a fresh one. After that it will retrieve stock information once every 15 minutes and update the database. Write an HTML to display the stock information like shown on [url removed, login to view] except the column should be clickable and the information sortable according to Symbol, Price, Book Value, Earning, P/E, P/B, and Dividend. The display should automatically refresh itself once every 10 minutes. When first clicked on a column, say P/E, it should sort the stocks according to P/E in ascending order. When clicked again, it should sort it in descending order.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
The program will run on Apache Linux using LAMP.