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
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.
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.
Databricks feed
This data feed pushes Macrobond and third-party time series into your Databricks. For more information see Databricks feed.
Snowflake data feed
This data feed pushes Macrobond and third-party time series into your Snowflake tables and views for direct consumption within your Snowflake environment. For more information see Snowflake data 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.