The world's first open-source Financial & Economic Indicators Database

The premier source for financial and economic datasets, serving investment and business professionals. MacroVar delivers data from hundreds of sources via API, Excel or the Web interface. MacroVar offers free access to a large part of our database to MacroVar members. Other providers sell their data through MacroVar.

Start Downloading & Using Data

Create your free account, so that you can use our data via all tools, directly through our API, Excel or our web interface.



Search over 20,000 Financial, Economic and Social Datasets

Variable Symbol Country Type Provider Download
POSCO CDS.POSCO South Korea Corporate CDS MacroVar
RIO TINTO LIMITED CDS.RIO-TINTO Australia Corporate CDS MacroVar
BHP BILLITON LIMITED CDS.BHP-BILLITON Australia Corporate CDS MacroVar
Hutchison Whampoa Limited CDS.Hutchison-Whampoa Hong Kong Corporate CDS MacroVar
PEUGEOT SA CDS.PEUGEOT France Corporate CDS MacroVar
ARDAGH PACKAGING FINANCE PUBLIC LIMITED COMPANY CDS.Ardagh-Packaging-Finance United Kingdom Corporate CDS MacroVar
CROWN EUROPEAN HOLDINGS CDS.Crown-Holdings France Corporate CDS MacroVar
CMA CGM CDS.CMA-CGM France Corporate CDS MacroVar
Aktiebolaget Electrolux CDS.Electrolux Sweden Corporate CDS MacroVar
GKN HOLDINGS PLC CDS.GKN-HOLDINGS United Kingdom Corporate CDS MacroVar
Variable Symbol Country Type

Market Data

Pricing Data covering multiple financial assets and countries

Economic Data

Quantitative indicators of the entire global economy and individual countries

Alternative & Derived Data

Predictive data from alternative sources or derived data

PARTNERS

We offer the expertise, technology and reach to transform your data assets into a recurring revenue stream



MacroVar API

Follow the Steps below to Access the MacroVar Database via the following API:

  1. Copy the following Code or click to download python file MacroVar Python API
  2. Search MacroVar financial securities and macroeconomic indicators database using the search options above
  3. Insert your Query's criteria in d=am.load by specifying the variable name, start and end date
# -*- coding: utf-8 -*-
"""
MacroVar API Python Script
Upgrade your Account to gain unlimited access https://macrovar.com/plans
Please find and search the full list of macroeconomic variables & financial variables at https://MacroVar.com/financial-database-variables
Instructions: 1. Insert your username, password 2. variable name, start date, end date 3. Run Script
"""
import http.client
from urllib.parse import quote
import pandas as pd
class MacroVar(object):
user_name, password, conn, headers, payload = None, None, None, None, None
def __init__(self, user_name, password):
self.auth(user_name, password)
self.conn = http.client.HTTPConnection("api.MacroVar.com:8080")
def auth(self, user_name, password):
self.user_name = user_name
self.password = password
self.headers = {'Authorization': '{};{}'.format(self.user_name, self.password)}
def get_vars(self):
self.conn.request(method="GET", url="/vars", headers=self.headers)
response = self.conn.getresponse()
data = response.read()
str_data = data.decode("utf-8")
return str_data.split(',')
def load_data(self, var_name, start_date=None, end_date=None):
v = self.get_vars()
if var_name not in v:
raise ValueError('Variable name not found, check the get_vars() result.')
params = 'name={}'.format(quote(var_name))
if start_date:
params += '&start_date={}'.format(start_date)
if end_date:
params += '&end_date={}'.format(end_date)
url = "/query?" + params
self.conn.request(method="GET", url=url, headers=self.headers)
response = self.conn.getresponse()
if response.status == 200:
data = response.read()
str_data = data.decode("utf-8")
data_rows = str_data.split('\r\n')
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 = MacroVar('MacroVartest', 'test')
v = am.get_vars()
d = am.load_data('US-1Y', '2010-01-03', '2019-02-01')
print (d)

MacroVar Excel

Download MacroVar using MS Excel