A free solution to download

Excel Help for A Free Solution To Download in Building Market Trading Systems

A Free Solution To Download

Rate this: (4/5 from 2 votes)

	These last two issues are indeed interesting ones: Downloading more than one security price at the same time, and Getting around the paging limit from the Yahoo Finance web page. But, we like a challenge so we developed a VBA program that uses the original code and overcomes these issues.  We liked it so much that we decided to host it and it can be downloaded freely here. For interest, the first issue was not so straight forward.  This is because the dates differ for each security due to availability, dividends etc. To overcome this, we first calculated the dates required and then matched the results of each web query to the dates. We even took into account public holidays. To overcome the second issue, we broke the date range into chunks and execute the web query multiple times to get the full date range specified. The VBA code is open and commented.  Any feedback is much appreciated. Enjoy.
	Excel Business Forums Administrator
	Posted by Excel Helper on 21 Nov 2009

View Full Post