Skip to content

Instantly share code, notes, and snippets.

@canada4663

canada4663/yql_custom

Created November 17, 2013 22:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save canada4663/7518842 to your computer and use it in GitHub Desktop.
Save canada4663/7518842 to your computer and use it in GitHub Desktop.
Download ZIP
Custom YQL Query Example
Raw
yql_custom
#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