I finally got a the single stock query version of this code working perfectly, but converting the VBA from GOOGLE historical data download for multiple stocks, well that stopped working. No surprise there! The download portion of the code works fine, but it runs through the code and ends on the first query without pasting the data into the cells of the SummaryReport's next available line. Not sure as to what I did to the step process. I have spent 2 days playing around with the code with no success. As for the adding data to the SummaryReport, has not worked since converting from COOGLE
The process:
Sub BarchartDataSummaryReportDownload()
Call ConvertArrayToValues [cut and pastes an Array data into plain cell values]
Call CopyToSummaryReportBulk [copies content from worksheet "BackTest" cells AS8 through BC8 to next available row in SummaryReport worksheet]
I know that the code is probably not the best, but I did have it working once
Thanks in advance
Don
Bookmarks