Downloading Market Data

Excel Help for Downloading Market Data in Building Market Trading Systems

Downloading Market Data

Rate this: (2.5/5 from 2 votes)

	Hi all, I have two questions about the code. 1.  The code gives me Run-time Error "5". Invalid procedure or argument. The URL link is the right one, but I can not figure out where this error originates. Is Excel 2007 different from the 2003 2. I wanted to download the S&P 500 stocks for 10 years of period with this code by modifiying it something like a loop that goes from. Colum E2  to E501 etc where each cell in E has a ticker symbol. Do you think it is a good idea? Thanks
	cano geel
	Posted by Oz on 18 Nov 2009

View Full Post