def test_google_finance_daily():
start = datetime.datetime(2010, 1, 1)
end = datetime.datetime(2013, 1, 27)
symbol = "F"
#symbol = "GOOG"
print("="*5 + "New DataReader" + "="*5)
dr_gfd = DataReader("GoogleFinanceDaily", expire_after=expire_after)
data = dr_gfd.get(symbol, start, end)
print(data)
print(type(data))
print(data.dtypes)
print("="*5 + "Pandas original DataReader" + "="*5)
f = web.DataReader(symbol, 'google', start, end)
print(f)
print(type(f))
print(f.ix['2010-01-04'])
print(f.dtypes)
for col in ['Open', 'High', 'Low', 'Close']:
f[col] = f[col].map(to_float)
f['Volume'] = f['Volume'].map(to_int)
print(f.dtypes)
diff = f - data
print(diff)
assert(diff.sum().sum()==0)
print("="*5 + "New DataReader with multi symbols" + "="*5)
symbol = ["F", "GOOG"]
dr_gfd = DataReader("GoogleFinanceDaily", expire_after=expire_after)
data = dr_gfd.get(symbol, start, end)
print(data)
print(type(data))
print(data.dtypes)
def test_openexchangerates():
app_id = os.environ['OPEN_EXCHANGE_RATES_API_KEY']
print(app_id)
dr = DataReader("OpenExchangeRates", expire_after=expire_after, app_id=app_id)
#data = dr.get()
#print(data)
#print(type(data))
#print(data["matrix"])
#data["matrix"].to_excel("rates_matrix.xls")
currencies = ["EUR", "GBP", "CHF", "USD", "AUD", "CAD", "HKD", "INR", "JPY", "SAR", "SGD", "ZAR", "SEK", "AED"]
data = dr.get(currencies)
#print(data)
assert(isinstance(data, dict))
print(data["matrix"])
assert(isinstance(data["matrix"], pd.DataFrame))
print(dr.convert(100, "EUR", "USD"))
print(dr.convert(100, "USD", "EUR"))
