Category: Technical information

X (Twitter) authorization successful

You have successfully authorized the Macrobond application post on X (Twitter). Please close this window and return to the Macrobond application

X (Twitter) authorization cancelled

You've cancelled the authorization of Macrobond application to post on X (Twitter). You can initiate the process again from within the Macrobond application.

Macrobond 1.27

Charting

Setting to show label for last year

There is a new setting called “Prefer last year” that will tell the application to prioritize showing a label for the last year in the case where every year is not included on the x-axis.

In the chart below, every odd year is used for the labels due to this setting.

Macrobond users can access the chart here.

‍

Analytics

Setting for "Start at shortest" and "End at shortest" in Index Builder

The new settings for starting or ending the calculation when the shortest series starts or ends simplifies some scenarios when using the Index Builder.

Metadata about actual sampling observation date for Cross-sampling

The date of the observation is added as metadata to the series in case the “Last common” or “Value at” methods are used in the Cross-sampling analysis.

This can be used in charts to get automatic texts. In the example below, the text “{s .ObservationDate}” has been used as the default legend text.

Macrobond users can access the chart here.

New method to calculate levels after differentials in Regression analysis

In the Regression analysis there are nowt wo different ways to calculate the levels after first order differentials have been used:

  • Legacy – add the differences to the dependent series
  • Aggregate – aggregate the differences

Include only periods with data in all series in Slice analysis

The new setting in the Slice analysis called “Include only periods available in all series” will exclude periods that are not available in all series. A common use case for this feature is to exclude the leap year of daily series.

Without this setting, the leap year will result in a gap in the graph as can be seen in this example:

With the new setting February 29th will not be included:

Macrobond users can access this chart here

TrimMean formula function

The TrimMean takes a series and calculates the mean value by excluding the highest and lowest values. The number of values to exclude is specified as a percentage (0-100) or the total number of values. An equal number of values are removed from the top and bottom tails.

New methods Standardize and Trim mean in Cross-sampling analysis

In the Cross-sampling there is a new method called Standardize.

This is calculated as the mean divided by the standard deviation.

The new Trim mean method corresponds to the formula function covered in the previous section.

Application features

Filter by frequency for all database types

The filter by frequency in the list of series in the data browser now works for all types of data bases and not just the ones provided by Macrobond.

Configure what document events result in Windows notifications

You now have even more fine control over what document events that are shown as Windows notifications.

Event notification status in status bar

If the document event notification is not working, there is a symbol in the status bar. This can be the case if the required servers are blocked in a firewall. See the deployment guide for requirements.

You can click on the icon to bring up a dialog, where you can send the error message to our support team that can help rectify this.

Actions are opened as Preview documents in Analytics

Actions that you find in the Action bar after selecting one or more time series, such as Line chart, will now open as Preview document in the Analytics activity, unless you are in the Browse activity. Previously they were always opened in the Browse activity.

Our long-term goal is to remove the Browse activity.

Chart in series tooltip

When you hover the mouse of the title of a series in the database view, the tooltip will show a line chart of the series.

Option to replace all discontinued series

The new button “Automatically select alternative series” in the dialog for replacing discontinued series will select the replacement series.

If there are several suggestions for a series, you will still have to make a selection.

Support for revision history in Web API Series Provider

The Web API Series Provider allows the Macrobond application to connect to your internal data sources. We have now also added support for accessing revision history that you have stored internally. Please see documentation here.

Other

  • Add option to set missing value representation when copying Excel dataset from MB app.
  • Performance enhancements and reduced memory footprint.

Installation

You can begin installation directly within the application. Either by clicking on the yellow banner that appears in the application, or by going to Help|Check for update in the menu of the Macrobond application.

If updating requires involvement from your IT department, please see the instructions provided here.

If you have asked us to contact your IT department directly, an email with information about upgrading to the latest version will be sent to your IT contact person. You are always welcome to contact the Macrobond team if you have any questions.

Changed requirements

  • This version of the Macrobond application requires .NET Framework 4.7.2 or later.

FactSet authorization cancelled

Attempt to authorize Macrobond application access to FactSet was cancelled. To retry - please initiate the process again from within the Macrobond application.

 

FactSet authorization successful

You have successfully authorized the Macrobond application to retrieve time series data from FactSet.

Please close this window and return to the application.

FactSet authorization denied

You've denied the authorization of Macrobond application for FactSet. You can initiate the process again from within the Macrobond application.

The Macrobond Data API for Python (Python wrapper)

Introduction

The Macrobond Data API for Python uses either the Macrobond Web REST API or the Macrobond Client data API to obtain time series with values and metadata. The API consists of a set of functions in common between the underlying APIs as well as specialized functions unique to each implementation.

You get time series directly as Pandas series.

Requirements

This API can be used only with Data+ license.

Macrobond Data API for Python officially supports Python 3.6+.

Installation

Macrobond Data API for Python is available on PyPI:

python -m pip install macrobond-data-api

Keyring

When using WebClient it is recommended to use the system keyring. Keyring should only be necessary if you have a license which includes the Web API. If you have Data+ license it shouldn't be needed.

This can be done easily by running the include script using this command:

python -c "from macrobond_data_api.util import *; save_credentials_to_keyring()"

Supported keyrings:

Error: failed testing username and password

raise self.oauth_error_class(
authlib.integrations.base_client.errors.OAuthError: invalid_client:

Error: failed testing username and password

This error usually derives from two situations:

  1. You do not have the proper Macrobond license to use it – the Keyring should only be necessary if you have a license which includes the Web API.
    Using Python, R, EViews or MATLAB API you must use the COM API - you do not need to enter any passwords in them as they are fetched from the Macrobond application.
  2. The credentials are being mistyped. When using Windows Command Prompt to set up the Keyring it might be confusing as nothing shows up when you type the password - this is normal security mechanism. Also, by default, you cannot copy and paste in the password field, it must be typed manually.
    • To be able to copy the password in the Command Prompt you must enable it in the Command Prompt Properties. To do that, open Command Prompt, right-click on the title bar and select Properties. In here enable 'Use Crtl+Shift+C/V as Copy/Paste'.

Working with Python wrapper

Learn more about the Commonly used metadata in Macrobond.

Download one series (Basic usage)

import macrobond_data_api as mb_api

usgdp = mb_api.get_one_series("usgdp")

print(usgdp)

Download one series (Advanced usage)

#web
from macrobond_data_api.web import WebClient

with WebClient('client id', 'client secret') as api:
    series = api.get_one_series('usgdp')

print(series)
#com
from macrobond_data_api.com import ComClient

with ComClient() as api:
    series = api.get_one_series('usgdp')

print(series)

Extensive guide - more examples

We have prepared examples in Jupyter Notebooks to help you start using Python wrapper. See them on our Github.

How to install Macrobond main app from downloaded files?

Go to installation page, scroll to the 'Install from downloaded files'. Press on 'Macrobond installation files for Windows' and download zipped package.

Shorter method (recommended)

It does the same as 'Longer method' but you don't have to install each file separately, it will do it for you.

Open zip file, navigate to the install.bat file and run it

You will see new window with 'Macrobond XY-bit Setup'. Press 'Next':

Select installation folder, press 'Next':

It's ready for installation. Press 'Install':

The whole process is automated. At the end you will see:

Press 'Finish'.

Longer method

It does the same as 'Shorter method' but here you have to install each file separately.

Open zip file, navigate to pkg folder. You will find there two files.

First install .msi file, then .msp. Macrobond will work only when you install both of them in that order.

After running first file you will see new window with 'Macrobond XY-bit Setup'. Press 'Next':

Select installation folder, press 'Next':

It's ready for installation. Press 'Install':

The whole process is automated. At the end you will see:

Press 'Finish'.

You have successfully installed base for the main app. But you cannot use Macrobond yet. Go back to pkg folder from zipped file. Run second file (.msp file starting with 'Patch'). This will upgrade your Macrobond to the newest version.

You will see new window with 'Macrobond XY-bit Setup'. Press 'Upgrade':

The whole process is automated. At the end you will see:

Press 'Finish'. Now you can use your Macrobond.

How to install Macrobond main app from the Setup Program?

Please close all opened Office programs (Word, Excel, PowerPoint). Go to installation page, scroll to the 'Download the setup program' button and press it.

It will download launcher .exe program. Run it, you will see a new window with 'Macrobond XY-bit Setup'. Press'Next':

Select installation folder, press 'Next':

It's ready for installation. Press 'Install':

The whole process is automated. At the end you will see:

Press 'Finish'. Now you can use your Macrobond.