使用MSXML2。使用Excel VBA中的XMLHTTP从网站中提取大量文本数据

I am trying to download historical stock price data from finance.yahoo.com for 1000s of stocks. The website only displays 60 days of data on a single page so I have to loop through the time period that I am downloading for along with the loop for different securities. I have used the following code to access the relevant page.I am trying to download historical stock price