Finance, Forex and Investments

How do I code an interface to Yahoo FINANCE, to retrieve historical data to analyse ?

What I need is to get data from Yahoo Finance, for several "tickers", download them to an Excel spreadsheet and make some calculations. Any help ?

Public Comments

1. My best advice would be to see if an RSS feed exists, then to look for the XML file associated with it. With that, you should be able to use the tag groupings to populate the spreadsheet, and from there perform the calculations. Other than that, I have no idea how you would be able to accomplish this.
2. I've done several things like this. Put the list of tickers in Column A Write a VBA macro sub OpenQuotes counter = 1 do until len(cells(counter,1)) = 0 workbooks.open "http://finance.yahoo.com/q?s=" & cells(counter,1) 'Write some code to find and copy the appropriate datafields into your base spreadsheet activeworkbook.close counter = counter + 1 loop end sub