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"))