Getting stock information with YQL and open data tables

One question that the YQL and Pipes teams get asked is “how can I get stock quotes? There isn’t an API for it on developer.yahoo.com”. Interestingly, while there isn’t a more traditional web service API, Yahoo finance does provide a very nice way to get a lot of well structured information on a given company. For example, here’s Yahoo finance page on Yahoo

Here's a neat way to download stock data from Yahoo
Yahoo finance page on Yahoo
Console