Oil from Quandl & SQL Example

Adding the Symbol

from trump.orm import SymbolManager
from trump.templating import QuandlFT, SQLFT

sm = SymbolManager()

oil = sm.create(name = "oil_front_month",
                description = "Crude Oil",
                units = '$ / barrel')

oil.add_tags(['commodity','oil','futures'])

f1 = QuandlFT(r"CHRIS/CME_CL2",fieldname='Settle')
f2 = SQLFT("SELECT date,data FROM test_oil_data;")

oil.add_feed(f1)
oil.add_feed(f2)

oil.cache()

print oil.df.tail()

sm.finish()

Using the Symbol

from trump.orm import SymbolManager

sm = SymbolManager()

oil = sm.get("oil_front_month")

#optional
oil.cache()

print oil.df.tail()

sm.finish()