I want a script to generate a table in Excel that shows the average accuracy of the predictions over time. (see the file called [login to view URL]) The script should be able to be run manually but also to be run by windows scheduler on a daily basis. The horizontal and vertical axises of the table are the number of stocks included in the accuracy calculation and the number of days into the past for which the accuracy is calculated. Please see the attached example and Full Description.
There is also a video description of the project here:
[login to view URL]
I've already developed many application with Visual Basic 6 to Export data into Excel, and Read data from Excel, and Process it. So, I'd like to work with this project.