Yahoo! YQL library with tools focusing on the finance portion (eventually).
Description
YFi allows you to create and run queries against Yahoo's YQL datatables.
It is currently in the beginning stages and supports the following YQL statments:
- select
- where
- in (_in)
- and (_and)
- equal (eq)
You can also set YQL variables, the following of which are supported:
- store
- table
- endpoint
- format
The plan is to also provide tools to use specifically with the finance tables.
Usage
The following is a example that returns all the data from the yahoo.finance.quotes table for the symbols 'TSLA' and 'GOOG'
from yfi.yql import Yql
# create a Yql object
y = Yql()
# this object supports chaining so we can build our query in one line. select() defaults to '*'
y.select().where('symbol')._in('TSLA', 'GOOG')
# the exec() method returns a json object unless format has been changed otherwise
j = y.run()The following is a shortcut for the above. It will select('*') from whatever table is set (default: yahoo.finance.quotes) for the given symbol(s)
from yfi.yql import Yql
y = Yql()
y.symbol('TSLA', 'GOOG')
j = y.run()Upcoming Features
- Better error handling
- Processing of the JSON response into a class that provides facilities for applying analytics easily
- Support for API tokens
- Stored queries
- Interval execution
Running Tests
To run all tests: python -m unittest discover
To run just Yql: python -m unittest test.TestYql