<?xml version="1.0" encoding="UTF-8" ?>
<table xmlns="http://query.yahooapis.com/v1/schema/table.xsd">
  <meta>
    <description>Aggregates summary information for a stock on Yahoo Finance</description>
    <sampleQuery>select * from stocks where ticker="yhoo"</sampleQuery>
  </meta>
  <bindings>
    <select itemPath="" produces="XML">
      <urls>
       <url></url>
      </urls>
      <inputs>
        <key id='ticker' type='xs:string' paramType='variable' required='true' />
      </inputs>
<execute><![CDATA[
    // pad string with leading char
    function pad(s, padchar, padlen) {
	while (s.length < padlen) {
	    s = padchar + s;
	}
	return s;
    }

    // Queue the queries
    var url = "http://finance.yahoo.com/q/pr?s="+ticker;
    var profileQuery = y.query("select * from html where url=@url and xpath='//table[@class=\"yfnc_datamodoutline1\"]/tr/td/table/tr' limit 4" , {url:url});

    var url = "http://finance.yahoo.com/q?s="+ticker;
    var quoteQuery = y.query("select h2,span from html where url=@url and xpath='//div[@class=\"yfi_quote_summary\"]/div[1]'" , {url:url});

    var url = "http://finance.yahoo.com/q/hp?s="+ticker;
    var historicalQuery = y.query("select * from html where url=@url and xpath='//option[@selected=\"selected\"] | //input[@maxlength=\"2\"] | //input[@maxlength=\"4\"]'" , {url:url});

    var stock = <stock symbol={ticker}></stock>;

    // First get the company name & market by looking at the Yahoo Quotes Summary page
    var results = quoteQuery.results;
    stock.CompanyName = results.div.h2.toString();
    var marketSymbolStr = results.div.span.toString();
    //var match = marketSymbolStr.match(/^[^:]+:\s+([^)]+)\)$/); matches ticker
    var match = marketSymbolStr.match(/^\(([^:]+):/);
    if (match != null) {
	stock.CompanyName += <Market>{match[1]}</Market>;
    }

    // Get the Historical Price Range
    var results = historicalQuery.results;
    startMonth = pad(String(parseInt(results.option[0].@value)+1), "0", 2);
    startDay = pad(results.input[0].@value.toString(), "0", 2);
    startYear = results.input[1].@value.toString();
    endMonth = pad(String(parseInt(results.option[1].@value)+1), "0", 2);
    endDay = pad(results.input[2].@value.toString(), "0", 2);
    endYear = results.input[3].@value.toString();

    startDate = startYear + "-" + startMonth + "-" + startDay;
    endDate = endYear + "-" + endMonth + "-" + endDay;

    stock.appendChild(<start>{startDate}</start>);
    stock.appendChild(<end>{endDate}</end>);

    // Get the Sector, Industry, Full Time Employees
    var results = profileQuery.results;
    for each (var tr in results.tr){
	//Remove trailing colon, and strip whitespace
	var property = tr.td[0].p.text().toString().slice(0, -1).replace(/\s+/g, "");
	switch (property.toLowerCase()) {
	    case 'indexmembership':
		continue;
		break;
	    case 'fulltimeemployees':
	        //Strip commas
		value = tr.td[1].*.text().toString().replace(/,/g, "");
		break;
	    default:
	        //Convert whitespace to single space
	        value = tr.td[1].*.text().toString().replace(/\s+/g, " ");
		break;
	}
	stock.appendChild(<{property}>{value}</{property}>);
    }

    response.object = stock

]]></execute>
    </select>
  </bindings>
</table>

>>> import urllib2
>>> url = "http://query.yahooapis.com/v1/public/yql?q=use%20%22http%3A%2F%2Fsites.google.com%2Fsite%2Ftrialballoonproject%2Fyahoo.finance.stocks.xml%22%20as%20stocks%3B%0Aselect%20*%20from%20stocks%20where%20ticker%3D%22yhoo%22%0A&format=xml"
>>> response = urllib2.urlopen(url)
>>> pageData = response.read()
>>> from lxml import etree
>>> root = etree.fromstring(pageData)
>>> stock=root.find(".//stock")
>>> stock.get("symbol")
'yhoo'
>>> for property in stock:
...     print "%s = %s" % (property.tag, property.text)
... 
CompanyName = Yahoo! Inc.
Market = NasdaqGS
Sector = Technology
Industry = Internet Information Providers
FullTimeEmployees = 13600
start = 1996-04-12
end = 2009-08-02
>>>