Excel Help for Download Market Data Crashes....

Excel Help for Download Market Data Crashes.... in Excel Portfolio Optimization Template

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 30 Dec 2015

Replies - Displaying 1 to 10 of 12

Order Replies By: Most recent | Chronological | Highest Rated

	New Version Revised Again Rate this: (3/5 from 1 vote) Thank you. Using Yahoo eliminates the need to use SPY and also the limitation on the number of securities that can be downloaded at one time.
	Posted by alb998 on 06 Nov 2018

	New version revised again Rate this: (3/5 from 1 vote) We updated the solution again with the following changes: Replaced Google Finance with IEX Global as Google Finance no longer allows data download. Fixed the adjusted close issue with Yahoo Finance so that now it does get the correct adjusted close values.
	Excel Business Forums Administrator
	Posted by Excel Helper on 06 Nov 2018

	New Download Tested With Fix Rate this: (4.3/5 from 3 votes) That worked. Thanks!
	Posted by alb998 on 03 Nov 2018

	New download tested with fix Rate this: (3/5 from 1 vote) The download definitely has the new version. You may need to clear your browser cache before downloading.
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 Nov 2018

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:

SPY

AAPL

MSFT

GOOGL

Posted by alb998 on 02 Nov 2018

	Download is already updated Rate this: (3/5 from 1 vote) The file is already updated in the download here.
	Excel Business Forums Administrator
	Posted by Excel Helper on 02 Nov 2018

	Alpha Vantage API Limit Rate this: (3/5 from 1 vote) Thanks. When will the portopt.zip download be updated on your website?
	Posted by alb998 on 02 Nov 2018

	Alpha Vantage API Limit Rate this: (2/5 from 2 votes) 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.
	Excel Business Forums Administrator
	Posted by Excel Helper on 02 Nov 2018

	Alpha Vantage bug 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 02 Nov 2018

	Alpha Vantage bug Rate this: (4/5 from 2 votes) Thanks for the bug report here. 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 02 Nov 2018

Displaying page 1 of 2

Download Market Data crashes....