Getting Started with AssetMacro Python API

Welcome to AssetMacro API platform trusted by 12,000 analysts & investors. AssetMacro API allows you to download millions of datapoints for 35,000+ financial datasets and 25,000+ macroeconomic indicators for 120 countries.

Enable your Assetmacro Python API access, by creating your account.

If you need additional help, Chat with us Now

AssetMacro Excel functionality in 5 steps:

1. Copy & Paste the Python Code Below:

import http.client<br /> from urllib.parse import quote<br /> import pandas as pd<br /> class AssetMacro(object):<br /> user_name, password, conn, headers, payload = None, None, None, None, None<br /> def __init__(self, user_name, password):<br /> self.auth(user_name, password)<br /> self.conn = http.client.HTTPConnection(“api.assetmacro.com:8080″)<br /> def auth(self, user_name, password):<br /> self.user_name = user_name<br /> self.password = password<br /> self.headers = {‘Authorization’: ‘{};{}’.format(self.user_name, self.password)}<br /> def get_vars(self):<br /> self.conn.request(method=”GET”, url=”/vars”, headers=self.headers)<br /> response = self.conn.getresponse()<br /> data = response.read()<br /> str_data = data.decode(“utf-8”)<br /> return str_data.split(‘,’)<br /> def load_data(self, var_name, start_date=None, end_date=None):<br /> v = self.get_vars()<br /> if var_name not in v:<br /> raise ValueError(‘Variable name not found, check the get_vars() result.’)<br /> params = ‘name={}’.format(quote(var_name))<br /> if start_date:<br /> params += ‘&start_date={}’.format(start_date)<br /> if end_date:<br /> params += ‘&end_date={}’.format(end_date)<br /> url = “/query?” + params<br /> self.conn.request(method=”GET”, url=url, headers=self.headers)<br /> response = self.conn.getresponse()<br /> if response.status == 200:<br /> data = response.read()<br /> str_data = data.decode(“utf-8”)<br /> data_rows = str_data.split(‘\r\n’)<br /> if len(data_rows) <= 1: return data_rows data_arr = [] for d in data_rows: data_arr.append(d.split(',')) d = data_arr[:-1] # skip the last empty row return pd.DataFrame(d[2:], columns=d[0]) else: raise ValueError('Server error {} {}'.format(response.status, response.reason)) return None if __name__ == '__main__': am = AssetMacro('riskvartest', 'test') v = am.get_vars() d = am.load_data('US-1Y', '2010-01-03', '2019-02-01') print (d)

2. Sign Up Now to get your username & password

Explore the financial and macroeconomic datasets covered by AssetMacro.

Click to use Excel for data retrieval