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')
etf = xw.sheets[home_sheet].range('G7').value if fund and fund_country != "": req_fund_info = investpy.get_fund_information(fund=fund, country=fund_country) if index and index_country != "": req_index_info = investpy.get_index_information(index=index, country=index_country) if stock and stock_country != "": req_stock_info = investpy.get_stock_information(stock=stock, country=stock_country) if bond and bond_country != "": req_bond_info = investpy.get_bond_information(bond=bond) if etf and etf_country != "": req_etf_info = investpy.get_etf_information(etf=etf, country=etf_country) def GetFundInformation(): wb = xw.Book.caller() wb.sheets[fund_sheet].range('N1').options( transpose=True).value = req_fund_info def GetIndexInformation(): wb = xw.Book.caller() wb.sheets[index_sheet].range('N1').options( transpose=True).value = req_index_info