APIs/Feeds/Connectors

Connect Macrobond to your data

You can use external time series data in Macrobond application. Such solutions can be found below.

SQL Database Connector

You can read time series and metadata from your own SQL database in Macrobond. For more information see The Macrobond SQL Database Connector.

We also host a SQL database which you can connect to as a demonstration of our SQL Database Connector. To obtain access, please contact your Account Manager.

Web API Series Provider

Solution similar to SQL Connector but communicating via HTTP and JSON with a server that implements a Web API providing access to your time series. Specification of the Web API can be found on the page describing The Macrobond client Web API Series Provider.

Bloomberg Connector

We have a connector for Bloomberg Terminal which converts '=BDH' queries and allows you use the data in our application. For more information see The Macrobond Bloomberg Connector.

FactSet Data Provider

We also have connector for FactSet data which converts "=FDS" expression from Excel and URL from the Formula API Request Builder. For more information see The Macrobond FactSet Data Provider.

Note you can also upload external data from your own code to Macrobond and with code, download Macrobond data. For these solutions see sections about Data Scientist tools (i.e., Python, R) and Office package.

Data Scientist tools

Here you can find list of our Commonly used metadata. Metadata attributes can be used in the below solutions.

EViews

Add-in enables you to upload and download data from and to EViews. For more information see The Macrobond EViews add-in.

Matlab

This API enables you to upload and download data from and to Matlab. For more information see The Macrobond API for Matlab.

Python

Here you can find special Macrobond package which can be used in Python environment for uploading and downloading data. Package is designed to run alongside Macrobond application on Windows. For more information see The Macrobond Data API for Python (Python wrapper).

For more information about our old Python package see The Macrobond API for Python.

R

Here you can find special Macrobond package which can be used in R environment for uploading and downloading data. Package is designed to run alongside Macrobond application on Windows. For more information see The Macrobond API for R.

Feed solutions

FTP/SFTP data feed

This data feed allows automated integration between our data and your own solution. For more information see The Macrobond FTP/SFTP data feed.

Data Web API feed

This data feed is communicating via HTTPS to REST API exposed by Macrobond’s servers. It allows clients to programmatically access time series and metadata from our database. For more information see The Macrobond Data web API feed.

Office add-ins

Excel/Power Point/Word/Publisher

We have integrated Office package into our application and created separate add-in which allows you to use Macrobond data in Excel or our Presentation documents in Power Point. You do not need to install anything - add-in will install itself together with main application. For more information about it see Using Macrobond data in Excel.

Render Solutions

Chart Server

Best solution if you want to programmatically generate Macrobond charts with up-to-date information e.g. for publishing, web pages or mobile applications. For more information see The Macrobond Chart Server.

Web Publish

This is a feature inside our main application. It allows you to quickly publish charts - static or dynamic. For more information see Web Publish.