def _build_index(self): def with_index(df, type, column, new_name="symbol"): if not "country" in df: df["country"] = "unknown" else: df["country"] = df["country"].replace({ None: "unknown", "": "unknown" }).fillna('unknown') df.index = pd.MultiIndex.from_tuples([ (s, type, c) for s, c in zip(df[column].to_list(), df["country"].to_list()) ]).rename([ new_name if new_name is not None else column, "type", "country" ]) df = df.drop([column, "country"], axis=1) df = df.drop(df.index[df.index.duplicated('first')], axis=0) return df.loc[df.index.dropna()] symbols_df = pd.concat( [ with_index(ip.get_bonds(), "BOND", "name"), # country "name" full_name with_index( ip.get_certificates(), "CERT", "symbol" ), # country', 'name', 'full_name', '"symbol"', 'issuer', 'isin', 'asset_class', 'underlying' with_index(ip.get_cryptos(), "CRYPTO", "symbol"), # 'name', '"symbol"', 'currency' with_index( ip.get_commodities(), "COMM", "name" ), # 'title', 'country', '"name"', 'full_name', 'currency', 'group' with_index( ip.get_etfs(), "ETF", "symbol" ), # 'country', 'name', 'full_name', '"symbol"', 'isin', 'asset_class', 'currency', 'stock_exchange', 'def_stock_exchange' # with_index(ip.get_funds(), "FUND", "isin"), # 'country', 'name', 'symbol', 'issuer', '"isin"', 'asset_class', 'currency', 'underlying' with_index( ip.get_indices(), "INDEX", "symbol" ), # 'country', 'name', 'full_name', '"symbol"', 'currency', 'class', 'market' with_index( ip.get_stocks(), "STOCK", "symbol" ), # ['country', 'name', 'full_name', 'isin', 'currency', '"symbol"' with_index( pd.DataFrame( [f'{c}/USD' for c in ip.get_available_currencies()], columns=['symbol']), "FX", "symbol") ], axis=0) # update the index table upsert(self.engine, symbols_df, DataProvider.symbols_table_name, if_row_exists='ignore')
def test_investpy_currency_crosses(): """ This function checks that currency cross data retrieval functions listed in investpy work properly. """ params = [ { 'base': None, 'second': None, }, { 'base': 'EUR', 'second': None, }, { 'base': None, 'second': 'EUR', }, { 'base': 'EUR', 'second': 'USD', }, ] for param in params: investpy.get_currency_crosses(base=param['base'], second=param['second']) investpy.get_currency_crosses_list(base=param['base'], second=param['second']) params = [ { 'base': None, 'second': None, 'columns': None, 'as_json': True }, { 'base': None, 'second': None, 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': None, 'columns': None, 'as_json': True }, { 'base': 'EUR', 'second': None, 'columns': None, 'as_json': False }, { 'base': None, 'second': 'USD', 'columns': None, 'as_json': True }, { 'base': None, 'second': 'USD', 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': 'USD', 'columns': None, 'as_json': True }, { 'base': 'EUR', 'second': 'USD', 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': 'USD', 'columns': ['name', 'full_name'], 'as_json': False }, ] for param in params: investpy.get_currency_crosses_dict(base=param['base'], second=param['second'], columns=param['columns'], as_json=param['as_json']) investpy.get_available_currencies() params = [ { 'currency_cross': 'EUR/USD', 'from_date': '01/01/2018', 'to_date': '01/01/2019', 'as_json': True, 'order': 'ascending', }, { 'currency_cross': 'EUR/USD', 'from_date': '01/01/1990', 'to_date': '01/01/2019', 'as_json': False, 'order': 'descending', }, { 'currency_cross': 'XAG/USD', 'from_date': '01/01/2010', 'to_date': '01/01/2015', 'as_json': False, 'order': 'descending', }, { 'currency_cross': 'XAU/USD', 'from_date': '01/01/2010', 'to_date': '01/01/2015', 'as_json': False, 'order': 'descending', } ] for param in params: investpy.get_currency_cross_recent_data(currency_cross=param['currency_cross'], as_json=param['as_json'], order=param['order'], interval='Daily') investpy.get_currency_cross_historical_data(currency_cross=param['currency_cross'], from_date=param['from_date'], to_date=param['to_date'], as_json=param['as_json'], order=param['order'], interval='Daily') params = [ { 'currency_cross': 'EUR/USD', 'as_json': False }, { 'currency_cross': 'EUR/USD', 'as_json': True }, { 'currency_cross': 'XAU/USD', 'as_json': True }, { 'currency_cross': 'XAG/USD', 'as_json': True } ] for param in params: investpy.get_currency_cross_information(currency_cross=param['currency_cross'], as_json=param['as_json']) params = [ { 'currency': 'try', 'as_json': False, 'n_results': 100 }, { 'currency': 'amd', 'as_json': True, 'n_results': 100 } ] for param in params: investpy.get_currency_crosses_overview(currency=param['currency'], as_json=param['as_json'], n_results=param['n_results']) investpy.search_currency_crosses(by='base', value='EUR')
def test_investpy_currency_crosses(): """ This function checks that currency cross data retrieval functions listed in investpy work properly. """ params = [ { 'base': None, 'second': None, }, { 'base': 'EUR', 'second': None, }, { 'base': None, 'second': 'EUR', }, { 'base': 'EUR', 'second': 'USD', }, ] for param in params: investpy.get_currency_crosses(base=param['base'], second=param['second']) investpy.get_currency_crosses_list(base=param['base'], second=param['second']) params = [ { 'base': None, 'second': None, 'columns': None, 'as_json': True }, { 'base': None, 'second': None, 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': None, 'columns': None, 'as_json': True }, { 'base': 'EUR', 'second': None, 'columns': None, 'as_json': False }, { 'base': None, 'second': 'USD', 'columns': None, 'as_json': True }, { 'base': None, 'second': 'USD', 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': 'USD', 'columns': None, 'as_json': True }, { 'base': 'EUR', 'second': 'USD', 'columns': None, 'as_json': False }, { 'base': 'EUR', 'second': 'USD', 'columns': ['name', 'full_name'], 'as_json': False }, ] for param in params: investpy.get_currency_crosses_dict(base=param['base'], second=param['second'], columns=param['columns'], as_json=param['as_json']) investpy.get_available_currencies() params = [ { 'currency_cross': 'EUR/USD', 'from_date': '01/01/2018', 'to_date': '01/01/2019', 'as_json': True, 'order': 'ascending', 'debug': True }, { 'currency_cross': 'EUR/USD', 'from_date': '01/01/2018', 'to_date': '01/01/2019', 'as_json': False, 'order': 'descending', 'debug': False }, ] for param in params: investpy.get_currency_cross_recent_data( currency_cross=param['currency_cross'], as_json=param['as_json'], order=param['order'], debug=param['debug']) investpy.get_currency_cross_historical_data( currency_cross=param['currency_cross'], from_date=param['from_date'], to_date=param['to_date'], as_json=param['as_json'], order=param['order'], debug=param['debug']) investpy.search_currency_crosses(by='base', value='EUR')