Skip to content

Instantly share code, notes, and snippets.

@philtsip
Forked from canada4663/yql_custom
Created November 20, 2013 13:53
Show Gist options
  • Save philtsip/7563514 to your computer and use it in GitHub Desktop.
Save philtsip/7563514 to your computer and use it in GitHub Desktop.
#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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment