def test_investpy_bonds():
"""
This function checks that bond data retrieval functions listed in investpy work properly.
"""
params = [
{
'country': 'spain',
},
{
'country': None,
},
]
for param in params:
investpy.get_bonds(country=param['country'])
investpy.get_bonds_list(country=param['country'])
params = [
{
'country': None,
'columns': ['full_name', 'name'],
'as_json': True
},
{
'country': None,
'columns': ['full_name', 'name'],
'as_json': False
},
{
'country': 'spain',
'columns': ['full_name', 'name'],
'as_json': True
},
{
'country': 'spain',
'columns': ['full_name', 'name'],
'as_json': False
},
{
'country': 'spain',
'columns': None,
'as_json': False
},
]
for param in params:
investpy.get_bonds_dict(country=param['country'],
columns=param['columns'],
as_json=param['as_json'])
investpy.get_bond_countries()
params = [
{
'as_json': True,
'order': 'ascending',
'debug': False
},
{
'as_json': False,
'order': 'ascending',
'debug': True
},
{
'as_json': True,
'order': 'descending',
'debug': False
},
{
'as_json': False,
'order': 'descending',
'debug': False
},
]
for param in params:
investpy.get_bond_recent_data(bond='Spain 30Y',
country='spain',
as_json=param['as_json'],
order=param['order'],
debug=param['debug'])
investpy.get_bond_historical_data(bond='Spain 30Y',
country='spain',
from_date='01/01/1990',
to_date='01/01/2019',
as_json=param['as_json'],
order=param['order'],
debug=param['debug'])
investpy.search_bonds(by='name', value='Spain')
def test_investpy_bonds():
"""
This function checks that bond data retrieval functions listed in investpy work properly.
"""
params = [
{
'country': 'spain',
},
{
'country': None,
},
]
for param in params:
investpy.get_bonds(country=param['country'])
investpy.get_bonds_list(country=param['country'])
params = [
{
'country': None,
'columns': ['full_name', 'name'],
'as_json': True
},
{
'country': None,
'columns': ['full_name', 'name'],
'as_json': False
},
{
'country': 'spain',
'columns': ['full_name', 'name'],
'as_json': True
},
{
'country': 'spain',
'columns': ['full_name', 'name'],
'as_json': False
},
{
'country': 'spain',
'columns': None,
'as_json': False
},
]
for param in params:
investpy.get_bonds_dict(country=param['country'],
columns=param['columns'],
as_json=param['as_json'])
investpy.get_bond_countries()
params = [
{
'as_json': True,
'order': 'ascending',
},
{
'as_json': False,
'order': 'ascending',
},
{
'as_json': True,
'order': 'descending',
},
{
'as_json': False,
'order': 'descending',
},
]
for param in params:
investpy.get_bond_recent_data(bond='Spain 30Y',
as_json=param['as_json'],
order=param['order'],
interval='Daily')
investpy.get_bond_historical_data(bond='Spain 30Y',
from_date='01/01/1990',
to_date='01/01/2019',
as_json=param['as_json'],
order=param['order'],
interval='Daily')
params = [
{
'bond': 'spain 30y',
'as_json': False
},
{
'bond': 'argentina 3y',
'as_json': True
},
{
'bond': 'germany 3m',
'as_json': False
},
]
for param in params:
investpy.get_bond_information(bond=param['bond'], as_json=param['as_json'])
params = [
{
'country': 'united states',
'as_json': True,
},
{
'country': 'united kingdom',
'as_json': False,
}
]
for param in params:
investpy.get_bonds_overview(country=param['country'], as_json=param['as_json'])
investpy.search_bonds(by='name', value='Spain')
import investpy
import xlwings as xw
import pandas as pd
fund_sheet = 'funds'
index_sheet = 'indices'
stock_sheet = 'stocks'
bond_sheet = 'bonds'
etf_sheet = 'etfs'
crypto_sheet = 'cryptos'
req_fund_countries = investpy.get_fund_countries()
df_fund_countries = pd.DataFrame(req_fund_countries)
req_bond_countries = investpy.get_bond_countries()
df_bond_countries = pd.DataFrame(req_bond_countries)
req_index_countries = investpy.get_index_countries()
df_index_countries = pd.DataFrame(req_index_countries)
req_stock_countries = investpy.get_stock_countries()
df_stock_countries = pd.DataFrame(req_stock_countries)
req_etf_countries = investpy.get_etf_countries()
df_etf_countries = pd.DataFrame(req_etf_countries)
def GetCountries():
wb = xw.Book.caller()
wb.sheets[fund_sheet].range('A1').value = df_fund_countries
wb.sheets[index_sheet].range('A1').value = df_index_countries