Skip to content

Instantly share code, notes, and snippets.

@ryanh-ai

ryanh-ai/yql_custom

Created November 17, 2013 22:06
Show Gist options
  • Save ryanh-ai/7518842 to your computer and use it in GitHub Desktop.
Save ryanh-ai/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