| Home > Forum Home > Excel Portfolio Optimization Template > Download Market Data crashes.... | Share |
Download Market Data crashes....
Excel Help for Download Market Data Crashes.... in Excel Portfolio Optimization Template
| Forum Topic | Post Reply Login |
Download Market Data Crashes.... | Rate this: (4/5 from 2 votes) |
 | 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. | |
| Lars-Olof Moberg | ||
| Posted by Lalla150 on | ||
| Replies - Displaying 1 to 10 of 12 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (3/5 from 3 votes) We just tested on Windows 10 with Excel 2016 under the latest update for Office 365 without any issues. Suggestions to try:
|
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
 | Rate this: (3/5 from 1 vote) Download Market Data sometimes crashes with "Run-time Error '13': Type Mismatch". When this happens, the debugger shows a blank value for 'querydate' in the 'ProcessSymbol_AV' function. It doesn't seem to be related to the symbol. Using the same symbol in another column works.
I'm using the latest version of the spreadsheet with Adj Close Data Type and Alpha Vantage data source.
Quandl API downloads the data but I can't find the symbol for the S&P 500 index with this data source. Also, the data values appear to be different for these two sources.
I can download all of the data by using multiple copies of the spreadsheet with some of the symbols in one and the ones that didn't load after the crash in the other one. |
| Posted by alb998 on |
| Rate this: (4/5 from 2 votes) If you can provide the symbols and frequency you were using, that will help us replicate and fix the issue. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 2 votes) The symbols are:
SPY ARCC GAIN MFA MO PPL PSEC XOM The frequency is monthly, starting 1-Jan-13 |
| Posted by alb998 on |
| Rate this: (2/5 from 2 votes) 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. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) Thanks.
When will the portopt.zip download be updated on your website?
|
| Posted by alb998 on |
 | Rate this: (3/5 from 1 vote) |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) The Download_Market_Data.xls in the portopt.zip file appears to be identical to the one I downloaded on 10-24-2018 according to WinDiff.
Also, the spreadsheet in the portopt.zip file that I downloaded from the link still only loads the first 5 ticker symbols that it comes with:
| |||||
| Posted by alb998 on |
| Rate this: (3/5 from 1 vote) |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (4.3/5 from 3 votes) |
| Posted by alb998 on |
| Displaying page 1 of 2 | Next |
Excel templates and solutions matched for Download Market Data crashes....:Solutions: Download Market Data Download Stock Quotes Complete Trading System Download Company Data Real Time Stock Quotes Options Trading Yellow Pages Data Mining Financial Investment ToolsCategories: Market Data Access |