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 TopicPost Reply Login

Download Market Data Crashes....

Rate this:
(4/5 from 2 votes)
OopsHi, 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 on
 
Replies - Displaying 11 to 12 of 12Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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 on
Confused
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 on
 Displaying page 2 of 2 

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 Tools
Categories: Market Data Access