Hi,
I downloaded the trial of Portfolio Optimization, I work in the finance industry and find this tool great! I'm looking to buy the full version.
But my Download Market Data file crashes, when I tries to download historical data after I downloaded Windows 10.
I had Windows 7 with Excel 2007 and it worked fine for a couple of days. Now I have Windows 10 and Office 365.
The "Preparing Data Sheet Dates" appears and freezes, the the VBA troubleshooting appears and highlights "ActiveCell.Offset(1, 0).Select".
I have tried to clear cache and re installed the Download_Market_Data Excel-file.
Hope you have a solution for me.
We updated the download (in portfolio optimization download zip) to handle this bug.
Note, however that the reason for it is due to a new API limit for Alpha Vantage which states "The standard API call frequency is 5 calls per minute and 500 calls per day".
Therefore, you will only be able to get 5 symbols at a time per minute.
