Yes, I believe Yahoo would rather have me visit their site and the ads than to download their data to Excel without going there. So, I'd also be interested in hearing about any other Excel resources on the web that feature Web Queries and innovative applications using them. namely, save the web page as a text file, (optionally, remove a lot of the crap), import it into an Excel sheet, try to get the original columns to become Excel columns, etc, etc.Īpologies for running on, but I'm sold on the WebQuery concept and hope that Microsoft has people working on enhancing it. So, the only workaround I can think of is REALLY time-consuming. Yahoo allows you to display all kinds of financial data for lists of stocks onscreen, but will only allow let you download price data for your lists of stocks.

If anyone else out there has used Yahoo! Finance web queries from Excel and has found a work-around, I'd love to hear about it. As I say, that was a year ago (and many follow-up emails to them, with the same response). I contacted Yahoo! and was told that the problem was known and being worked on. Instead of my data coming in, I received a login page in my spreadsheet, which obviously does not work from there. I use the past tense (*was* above) because about a year ago, this suddenly quit working. I'd set up my portfolios, set up my web queries to access the URLs of those, and (once signed on to Yahoo! Fianance) the data would flow into my spreadsheets. probably the best FREE source of financial data on the net. Sure beats downloading (if that's even possible) and importing into Excel afterwards.Īnyway, my favourite place to find tabular data on the web for my purposes *was* Yahoo! Finance. Being able to dynamic import web tables into Excel for further processing is an incredible productivity tool. I don't know about the rest of you, but I think Web Queries are one of the best features ever introduced to Excel.

Download yahoo my portfolio