I am downloading price quotes for around 700 stocks and the SP500 every day (2 minutes interval data). Using these values I calculate the Beta values using the 900 latest data. I need an application that automatically can download/store the data every day at a set time, and then calculate the values and save them in a list. Every three months when the SP500 changes I need to change the data symbol for the SP500 (saving the old data for the old symbol, reloading it into the new, and then start downloading the data for the new one like a rollover). Also, I need to change the stock list from time to time, and the order which the output is saved for the stocks.
I download the data from www.qcharts.com.
14 freelancers are bidding on average $227 for this job
I have been programming and designing for many years working with the likes of MorganStanely, SmithBarney, WheelerFinancials, etc in Excel using visual basic. I am excited to take on a new project.