philtsip

#Custom YQL Query Pointing at Unpublished XML via github
#  "balancesheet" can be replaced with incomestatement or cashflow to get those reports
use "https://raw.github.com/canada4663/yql-tables/master/yahoo/finance/yahoo.finance.balancesheet.xml" as yahoo.finance.balancesheet; 
select * from yahoo.finance.balancesheet where symbol="T";

#For Annual data
select * from yahoo.finance.balancesheet where symbol="T" and timeframe="annual";

#Once yql-tables pull request is completed, you can eliminate the "use..." portion and point directly at yahoo.finance.balancesheet