I want a script to generate a table in Excel that shows the average accuracy of the predictions over time. (see the file called [url removed, login to view]) 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:
[url removed, login to view]