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 |
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:
- Copy the following Code or click to download python file MacroVar Python API
- Search MacroVar financial securities and macroeconomic indicators database using the search options above
- Insert your Query's criteria in d=am.load by specifying the variable name, start and end date
"""
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