Using excel VBA, want to be able to automate getting historical market data from finance.yahoo.com/q/hp?s=qqqq for example, into a worksheet named qqqq in myWorkbook.xls (one wonders how they managed to have a symbol like qqqq snuck in there;)
The Yahoo! page allows you to specify a from date and a to date and a symbol. It has a link that downloads to a excel.csv file.
I saw an EE solution ID: 22532485 that somehow transfers data from another website to excel. But it looks plenty involved to port it to the finance!yahoo example. There is another solution that looks promising, ID: 21789537 however, it has some reference to a dynamically changing IP address. So in either case I am stymied. Hence the new question.