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