We have a Recession bands (Fill range) functionality with pre-made bands of different types. You can also set 0/1 series as Fill range graph type in Graph layout. Below you will find an example how to create recession band from a 'normal' series.
Combine analysis and formulas to calculate 2 consecutive quarters of decline and turn series into recession band.
You can calculate Drawdown with the Drawdown formula. There are ways of constructing it differently to fit your desired output – please see examples below.
Historical drawdown from each peak to bottom. Our drawdown() formula is defined as 100*(peak - value)/peak.
From our formula Drawdown() the outcome is in percentage. Here we change it into a number.
See how to calculate length of a simple drawdown and length of drawdown from certain value to local peak.
Calculate maximum value for each year including current one.
See drawdowns, but only when there is a recession.
Calculate swaps with Zero coupon rate analysis and/or with formulas.
Calculate from SEK swap rates (1 year-10 year) from SEB (Skandinaviska Enskilda Banken).
Calculate from EUR swap rates (1 year-10 year) from SEB (Skandinaviska Enskilda Banken).
With formulas calculate 5y5y from inflation swaps for EUR and USD. This chart requires series from ICAP database which is outside core package.
EUR 5y5y Forward Inflation Swap - Bloomberg Method (requires ICAP)
With formulas calculate 5y5y from inflation swaps for EUR. Method used here is based on Bloomberg's method of calculating 5y5y. This chart requires series from ICAP database which is outside core package.
Creating a diffusion index with a combination of analyses and formulas.
Check general tendency of a selection of series with value '50' as a base.
See the number/percentage of countries with rising unemployment.
See below examples how to connect Position-series with each other, creating a curve. Then it can be connected to the main-series.
Create curve, but only from 1st Position to 24th Position series.
Create curve from all Position series - for current date and for 1 year before.
Create curve for Gas futures and connect it to 1st Position series.
Create futures curve for a currency (latest and selected date).
Create futures curve for a currency (latest and selected date). It's the same file as above but currency is flipped from USD/ILS to ILS/USD.
Create Yield curve (with analysis) or through formulas & analyses.
Global credit impulse - a term created by Michael Biggs - it measures the change in new credit issued as a percentage of growth (GDP).
We have used mix of series from BIS and national sources and weighted them with GDP series from IMF.
Some sources provide separate series for contribution to inflation or GDP. But what happens when they don't, or there are no weights? Or when you simply want to calculate some series as part of another one? See examples below.
Under Files\Macrobond chart library\Examples\Watchlist Charts you'll find folders for selected countries where we have added ready-made Contribution to GDP or/and CPI (inflation) files.
Example with contribution series provided by the source.
Contribution to growth - subcomponents with Total and weights
Manual calculation for when source provides separate series for subcomponents and their weight-series.
Contribution to growth - series with Total but without weights
Manual calculation for when you have a Total series but not weight-series - you can calculate them based on the Total.
Manual calculation for when there is no Total series and no weight-series. You decide which series would be Total (or calculate it) and which ones use as subcomponents.
Some charts and analyses require a combination of calculations. See below different ways of mixing different analyses and formulas for popular queries:
If you are working with series expressed in a variety of currencies it can be helpful to convert all the series to a single currency. In Macrobond there is an automatic currency conversion feature you can apply to your entire document.
Currency conversion works only if series has currency metadata. If series is a non-currency series then no calculation will be performed on it.
Parameters which are taken into consideration in the process of converting currency are:
In the conversion process, Daily exchange rate series are used, but they are sometimes extended with data of a lower frequency if needed to get longer history.
If you want to know exactly which series was used to perform the conversion, navigate to the Forecast tab in Series list. As you can see in the picture below, the FX series used for currency conversion are listed in addition to those added to the Series list.
If your series contain forecasts, you can also add forecasts to the series used for the currency conversion. See How to add a forecast values?.
All currency series are Daily. So, if series is in Daily frequency conversion is straightforward. When your series have a lower-than-Daily frequency there are several options for how to do the currency conversion.
After selecting currency in Currency box on Series list:
‘Currency conversion method’ box will become available under Conversion settings:
By default, all series are set to ‘Automatic’ (method is set according to the properties of the series) but you can change it manually to:
The default setting is 'Automatic'. This means that the method will be decided according to the properties of the series:
This method was used in documents created before Macrobond version 1.22.
Relevant parameters which are taken into consideration in the process of converting currency are:
The process of converting is a bit different because of the third step:
If you only want to convert a specific series in your document, you can use the formula language and a suitable exchange rate series. Note that all exchange rates are in Daily frequency and they will change frequency of document.
Our ready made currency series can be found under:
Currency per USD
Concept & Category > Interest & Exchange Rates > National Sources > FX Rates > USD Rate
Currency per EUR
Concept & Category > Interest & Exchange Rates > National Sources > FX Rates > EUR Rate
From HKD to USD or EUR:
hkgdp*1/hkd hkgdp*1/hkdeur
From NOK to USD or EUR:
nobank2048/nok nobank2048/nokeur
From USD or EUR to HKD:
usgdp*hkd eunaac0019*hkdeur
From NOK to HKD through USD:
nobank2048/nok*hkd
From NOK to HKD through EUR:
nobank2048/nokeur*hkdeur
Exchange series are in Daily frequency, but what happen when you apply it to a non-Daily series and select its frequency as main?
If Currency conversion method is set to 'Automatic' the application chooses method according to properties of the series: 'Last 5d median', 'Average' or 'First 5d median'. For more information which applies to what series see What’s behind ‘Automatic’ method?.
The whole process is based on series’ metadata. If series doesn’t have them, currency conversion won’t work.
For example, all series downloaded with The Macrobond Bloomberg Connector do not have currency metadata. We suggest either using manual conversion mentioned above or downloading series from Bloomberg already in desired currency with an override:
"ih:bl:ndueacwf index:PX_LAST:Curr=ZAR"
To improve workflow, we introduced new tabs in one of the Analytics tab activity’s segments:
In this tab you can manage documents on which you are working by:
*Also available when right-clicking on document’s tab.
This is an alternative way to open documents instead of using the File > Open document. It also integrates the list of Recent documents that can also be found in the Start tab activity.
By default, you see three directories – crumb bars – and can easily switch between them. You can switch between directories by:
You can decrease/increase number of bars (up to 10). To do this click on cog icon (More settings) and change number of bars. From here you can also sort documents.
When you select one of the documents (it works for Presentations too) it will open in document’s segment as a preview. The tab will be in orange color. If you click on another file, the content of the preview will be replaced.
To change document’s status from preview to permanent:
If you want to share location of the file with your colleagues, you can right-click on document’s tab and select Copy path. Now you can paste in a hyperlinked path to this directory.
When you have opened file, you can right-click on its tab and select Open containing folder. It will open that folder in the Documents tab.
