The new version can be installed directly via the Macrobond platform by clicking the yellow line which appears on the screen or by selecting Check for update on the Help menu. If you need assistance, a description of how to upgrade may be found here. You might need additional help from your IT-department.

Selection of new functionality

Horizontal and vertical lines in charts

The lines, called axis annotations, are associated with a value or date on the axis. There can be labels that are displayed either in the graph area or as axis value labels.

There is an example in the chart library.

New user interface for the Smoothing analysis

You can now specify several methods per series. There are also a couple of new filter types: Baxter-King and Christiano-Fitzgerald band pass filters.

There is an example in the chart library.

Added option to store snapshot of in-house series

The application can now store a snapshot of all in-house series in a document, which is useful when sharing documents.

This is enabled in the new Document properties dialog that can be found on the File menu,

There is also a corresponding option when sending support messages. By including in-house data in the document, the support team can address your query more efficiently.

Per document series

You can now define series that are available only in the current document. This is useful if you have some data that you will only use once. The “Paste document series…” button will paste the result of a copied document series or text consisting of one date and one value column

Document keywords

You can specify one or more keywords for a document. These keywords can then be used when searching for documents in the File Open/Save dialog.

The keywords are specified in the Document properties dialog.

Seasonal adjustment using Census X-13

There is a new analysis that allows you to do seasonal adjustment using the Census X-13-ARIMA-SEATS program. This is a superset of the X-11 and X-12-ARIMA programs.

There is an example in the chart library.

Principle components analysis

The Principle components analysis allows you to calculate a set of linearly uncorrelated series, or components, from a set of possibly correlated series. The calculated series are calculated using an orthogonal transform so that the first series captures the highest possible variance of the original set of series. Each successive series captures the highest possible remaining variance under the constraint that it is orthogonal to the preceding series.

The analysis also presents the eigenvectors, as a matrix, and the eigenvalues as a category series.

There is an example in the chart library.

Multiple tabs in the Search activity

Sometimes it is convenient to retain the result from a previous search when doing a new search. Now you can do another search in a new tab.

Specifying the window length unit in more places

We have added the option to specify the unit, such as year, in a number of places where a period length is specified:

New formula functions

Some new formula functions have been added:

BkFilter, CfRandomWalkFilter, CfStationaryFilter, CorrelationBestLag, Drawdown, LowObs, HighObs, EndOfWeekAhead, StartOfWeek

Additional fields for series in the Excel add-in

You can select additional fields to be included when importing data into an Excel sheet. The set of fields will depend on the series that you have selected

Multiple local document stores

You can now specify several local directories for documents that will be displayed in the File Open/Save dialog.

Misc

• Improved tooltips in Series browser tree to include information about the location in the tree.
• A Search tab has been added when you browse for series in the EViews add-in. We have also added support for pasting a list of series names.
• Lines in tree controls, such as the analysis tree, makes it easier to see the relations.
• Keyboard navigation for Add/Insert analysis. You can type the beginning of the analysis name to select and then press enter to execute.
• You can now duplicate a branch of the analysis tree by selecting Duplicate on Edit or context the menu or by pressing Ctrl+2.
• You can duplicate a set of expressions in the Series list by selecting them and then select Duplicate on the Edit or context menu or by pressing Ctrl+2.
• You can turn off the labels on the x and y axes in charts so that the text is not presented.
• There are now settings for each graph to use the alternate scale setting in the graph layout dialog.

The new version can be installed directly via the Macrobond platform by clicking the yellow line that appears on the screen or by selecting “Check for update” on the Help menu. If you need assistance, a description of how to upgrade may be found here. You might need additional help from your IT-department.

Selection of new functionality

Dynamic text

All texts in charts can now use Dynamic text in order to reference values and metadata of time series.

For instance, you can have a textbox with a text like “The last value is 2.33“, where the number 2.33 comes from a time series and is automatically updated.

The part of the text that is dynamic is written within curly brackets. The example above might have been written like “The last value is “. The text within the brackets will be processed and replaced with the result in the output.

You can have any number of dynamic text elements in a text. For example: “The value at is “, which could result in something like “The value at 2009 Q2 is -4.09”

You may also reference metadata, such as the region. In this example, the default legend text is set to “”:

In order to make it easier to enter Dynamic text as part of the text, we have introduced a new text editor dialog that is used when you edit any text in a chart. There are also two new shortcuts for this dialog: double click on a chart element that is associated with a text or select it and then press Ctrl+E.

The editor presents lists of available dynamic text properties, gives you syntax highlighting, useful tooltips and suggestions of dynamic text properties as you type.

You can read much more about Dynamic text on the help site.

Axis value labels

We have added a new type of labels called Axis value labels. These labels are always presented to the right of the chart and are primarily intended to show the last value:

The text can be customized and by using Dynamic text you can, for instance, include the region and unit of each time series:

New standard style sheets

The default Macrobond style sheet has been updated with a new look. You will also find that the location of the default style sheet has been changed so that it is found in a specific location called Macrobond. Macrobond can now provide more than one style sheet and there are currently two variations available:

The new Statics analysis allows you to add several statistics for each series. You can specify the estimation sample range for each calculation and also determine if the resulting time series should cover the whole range or only the estimation range.

Links to documents, series folders and series

You can create links to documents, series folders and series that you can click on to open them in the Macrobond application. For instance, here is a link to a Macrobond document:

Macrobond chart library : Examples/Financial/Investment strategy

You can create such a link by selecting Copy for a document in the File Open/Save dialog. You can then paste the link into an Office document or e-mail.

This is a link to a folder:

Economics – by country > United States > Prices > Consumer Price Index > All Urban Consumers > Totals

Links to series folders can be created by selecting Copy for a folder in the Series browser.

Here is a link to a series:

United States, Consumer Price Index, All Urban Consumers, All Items

Links to series can be created by selecting Copy for a series in the Series browser.

This is a link to a Release:

Japan, Corporate Goods Price Index

It can be created by selecting Copy for an item in the list of releases in the Release Activity.

New buttons for adding/inserting analyses

We have improved the user interface for adding/inserting analyses. There are now two buttons, called Add and Insert that will show a structured menu of the analyses:

New setting in the Scalar analysis: One series per input

Traditionally the Scalar analysis produces one series per calculation. We have now introduced a new option, called “One series per input”, that will produce one series per input series where each series contains all the calculations. This can be used to produce a chart like this:

Pin favorite colors

You can pin colors to the list of recently used colors so that they are always presented at the top:

Selection of series in Cross section analysis per calculation

In the Cross section analysis you can now specify a description of each calculation and the selection of what series to include is also per calculation.

The list of most recently used documents is per account

If you use the same Macrobond account on several computers you will notice that list of most recently used documents, which you can find in the Start activity and on the File menu, is synchronized between your devices.

Delete from the list of most recently used documents

You can remove an item from the list of most recently used documents by selecting “Remove from recent documents” from the context menu (right click) on an item in the Start activity:

Rolling regression

With the Rolling regression analysis you can calculate how the result from a linear regression model varies over time.

Data range for graphs in scatter charts

When selecting a graph in a scatter chart, you can limit the data range to include in the chart:

Select a graph via the menu

Usually you select a graph by clicking on it with the mouse. There are cases when this is difficult though. Such as if you have made the graph completely transparent or selected a display range that does not include any values. For this purpose you can now select a graph from the Chart menu:

Search for related series

We have started to add hierarchical relationships to some of our series. You can see this as new Search Actions for series such as US GDP:

New formula functions

There are some new formula functions:

NextGreaterOrEqual, NextLessOrEqual, PreviousGreaterOrEqual, PreviousLessOrEqual, FirstGreaterOrEqual, LastGreaterOrEqual, RunLength

Here is an example that uses the PreviousGreaterOrEqual function:

‍

The new version can be installed directly via the Macrobond platform by clicking the yellow line that appears on the screen or by selecting “Check for update” from the Help menu. If you need assistance, a description of how to upgrade is provided by the IT-department, which may be found here.

Selection of new functionality

Support for 64-bit add-ins

The major new feature of 1.12 is that Macrobond now supports 64-bit versions of Microsoft Office, EViews and MATLAB.

There are now two installation packages:

• The 32-bit installation package contains only the 32-bit versions of the add-ins. You have to install this package if you run on 32-bit versions of Windows.
• The new 64-bit installation package contains both the 32-bit and 64-bit versions of the add-ins and we recommend that you always use this package on 64-bit versions of Windows.

If you use the automatic upgrade functionality, you will always continue to use the same type of installation as before. To switch from the 32-bit to the 64-bit installation package, you need to run Setup as described on https://redir.macrobond.com/go/installation.

Note of important series

There is a new column in the lists of series results called “Notes” that shows an exclamation mark for important series.

You can move it or turn it off in the “Edit|Select columns” dialog.

New way to group in the Scalar analysis

We have added a new way of grouping series in the Scalar analysis called “Partition into”. There is also a new column called “Group” in the list of input series that illustrates which group each series goes into.

The new Statics analysis allows you to add several statistics for each series. You can specify the estimation sample range for each calculation and also determine if the resulting time series should cover the whole range or only the estimation range.

Disable month initials on chart x-axis

There is a new setting that controls if month initials, such as J, F and M, can be used when showing month labels on the x-axis:

Log change in Rate of change

There is a new setting in the Rate of change analysis for calculating the logarithmic change:

This calculates 100 x (Ln(xi)-Ln(xi-t))

Information about 5% tail in Histogram report

We have added another section to the report from the Histogram analysis containing not only the 1% but also the 5% tail expectations. This can be used to estimate Value at Risk (VaR) and Expected shortfall (ES).

No intercept in the Regression analysis

There is a new setting in the Regression analysis called “No intercept”. When this option is selected, the model is solved without a constant.

The new version can be installed directly via the Macrobond platform by clicking the yellow line which appears on the screen or by selecting Check for update on the Help menu. If you need assistance, a description of how to upgrade is provided by our IT-department, which may be found here.

Selection of new functionality

MATLAB API

You can now download as well as upload Macrobond time series in MATLAB.

There is documentation with examples and requirements on our website.

Enhancements in the Regression analysis

The Regression analysis now supports the creation of several models within one instance of the analysis. Each model has separate settings.

The report will contain information about all the models.

The covariance matrix has been moved from the report and can be viewed by using the Matrix presentation. This also makes it possible to copy a Macrobond Excel Data set with the matrix data. The matrix is calculated only for the first model.

There is a new option for adding residuals for forecasted values to the series of residuals. The Standard error of the forecasts is presented in the report.

Chart enhancements

You can select the position of the legend to be below, above, on the sides or floating. When not floating, the alignment can be set. There is a new setting for the margin around the text of the legend.

In the chart above we have also made use of the new settings for the margin between columns , hi-lo-close and stripe graphs. For column charts, you can also set the relative size between groups which emphasises what columns that go together.

We have also introduced a setting for the margin between panes .

Another new type of margin that you can set is an extra end margin called “End margin”. This will add some extra margin to the right of the x-axis when you are at the end of the time series.

You can see what this looks like in the chart below. This margin will only be applied when no end date has been set for the display margin.

In the chart above, you can also see that the years are written without the century. This is accomplished by changing the new setting called “Include century”:

As you can see from the same settings panel, you can now turn off the automatic step length logic for the time axis and specify your own step length. In the example below, the step length has been set to 5 years.

In this chart you might also notice that the tick marks are inside the graph area . This is accomplished by the new setting called “Tick position”, which is available for both x and y axes.

The last new chart setting we have introduced in this version is called “Include new series automatically”. It is turned on by default. By turning it off, new series will not be automatically added to the chart. You can still add them in the Graph layout dialog (Ctrl+L).

Sort analysis

With the new Sort analysis, you can sort values in either an ascending or descending order. The most common usage is to sort the values after the Scalar analysis, which can be seen in the example below.

Histogram analysis

The Histogram analysis can calculate the empirical distribution of a series as the density or cumulative distribution. There are two kernels to choose from. This can then be presented in a chart as a histogram. You can compare with a normal distribution as shown in the chart below.

The report contains common statistics such as skewness and kurtosis.

You can find comprehensive documentation on our website.

New calculations

We have added functions for calculating the mean value of the upper and lower tails to the Scalar analysis, Cross section analysis and also as formula functions.

The method Average absolute correlation has been added to the Cross section analysis as a complement to the Average correlation method.

Some new formula functions have been added: DateAtOrAfter, Kurtosis, Skewness, LowerTailMean and UpperTailMean. There is also a new version of the PercentRank function that takes a window length.

Recent searches

When entering text in the search field, you now get suggestions based on earlier searches. You can select among the previous searches by using the arrow down key and enter or clicking using the mouse.

Forecast editor supporting scale

You can now set the scale when you enter the forecasts:

Enhancements in the Excel add-in

When importing time series you can set the default output options:

When importing the result from a Macrobond document in a Macrobond Excel Data set, there is a new setting for the analysis description text:

Selection of new content

Consensus estimates from Consensus Economics

Minor additions

• Basic macro coverage initiated for Middle Eastern countries
• Australian surveys from the Melbourne Institute
• NBER Macro History database
• The Conference Board TED database
• Chinese property data from SouFun-CREIS

Soon to be released

Property indices for Scandinavia and the U.K. from IPD as an add-on database.

The new version can be installed directly via the Macrobond platform by clicking the yellow line that appears on the screen or by selecting Check for update on the Help menu. If you need assistance, a description of how to upgrade is provided by the IT-department, which may be found here. Simply click Upgrade for further instructions.

Selection of new functionality

Multiple chart panes

Charts can now have multiple panes. Each pane has a separate y-axis, but a shared x-axis.

You can add and remove panes in the Graph layout dialog.

Calculated series

You can now take any time series calculated in a Macrobond document and define an in-house series based on those calculations. When you use the time series in a document, the observations will be calculated based on the current data.

To create a calculated time series, select a series in a Time table and chose “Save calculation as in-house series…” from the Edit or context menu. The calculations will be stored as a special copy of the document.

When you edit a calculated time series, you will see the document where the series is defined. You can then make changes to the document and also define several time series to be published from the same document.

New Statistics and Detrend analyses

We have renamed the analysis formerly known as “Statistics” to “Statistics (old)”, which you might still find in old documents, and replaced it with two new analyses: Statistics and Detrend.

The new Statics analysis allows you to add several statistics for each series. You can specify the estimation sample range for each calculation and also determine if the resulting time series should cover the whole range or only the estimation range.

There is also a new method in Statistics where you can draw a line between two points on a graph.

The Detrend analysis can remove components such as the linear trend, exponential trend and the mean.

The new Cross variance analysis

With the Cross variance analysis you can calculate one of three matrices: Covariance, Correlation or Regression slope. The elements of the matrix are the pairwise calculation of the selected method.

In the Matrix presentation, you can highlight the lowest and highest values. You can also reorder the rows and columns.

Search for similar series in other regions

There is a new Action that can be used to search for corresponding series in other regions. This works for series that are identified as region key series in our database.

Change regions

When you use series that are identified as region key series in our database, there is a new feature that helps you replace the series in a document with the corresponding series for another region.

The command “Change region…” on the File menu will bring up a dialog where you can change to another region.

Additional modes in the Yield curve analysis

With the option called “Rates at a future time” we calculate forward rates that start at the point of the maturity length that you provide. This will, in essence, give you a view of the yield curve at a future point in time relative the observations.

For instance, this chart shows what the yield curve of January 2013 looked like in January 2011, 2012 and 2013.

The second option allows you to calculate the forward rates between the instruments.

Improved relative points in time

In earlier versions you could specify a relative point in time like -36, which is interpreted as 36 observations before the end. The drawback is that the actual length is then dependent on the frequency.

We have now added support for writing expressions such as: -3y, -3q, -3m, -3w and -3d. There is also a new user interface to help you out.

Select columns visibility, order and formatting in the Table presentation

In the new “Change table layout” dialog, you can select what columns that should be visible, in what order to show them and how numbers are formatted.

Warning about discontinued series

Discontinued series are now marked with red in the Series list and formula editor. The tooltip contains information that it is discontinued.

When a document contains one or more series that have become discontinued, there will be a yellow stripe notification. You can dismiss this warning by clicking on it. If more series becomes discontinued in the document, the warning will be displayed again.

Specify the DPI when exporting a chart image

When exporting a chart bitmap image (PNG) you can specify another DPI than 96, which is what is used on the screen. By using a higher DPI you get an image with higher resolution, which might make it look better when scaled or printed. The drawback is that the image file will be larger.

Excel UDF functions

We have added three functions that can be used in Excel spreadsheet formulas: MbndGet, MbndDate and MbndMeta. These can be used when you want to get a few values from a time series, such as the last value. For example, to retrieve the last value or the “eur” time series, you can use this expression in Excel:

=MbndGet(“eur”)

If you want to download large parts of a time series, you should use the Macrobond Data sets as before.

For more details, see the Getting started document.

Source, Unit and Region as optional data in Excel

You can now select to include information about the source, region and unit when downloading data in Excel.

Selection of new content

World Oil data from JODI

JODI Oil consists of data from more than 90 countries or regions and the members of the six pioneer organizations (APEC, EUROSTAT, IEA, OLADE, OPEC and UNSD) that participate represent over 90% of global oil supply and demand. For more information about JODI please visit http://www.jodidata.org

The database consists of:

• Ten product categories: Crude Oil, NGL, LPG, Naphtha, Gasoline, Kerosene, Kerosene Type Jet Fuel, Diesel Oil, Fuel Oil and Total Oil
• Seven flows: Production, Demand, Refinery Intake, Imports, Exports and Closing Stock Levels
• Data in three different units: barrels, barrels per day and tons
• Data for more than 90 participating countries
• Data from January 2002

The series have been integrated in the existing Tree structure for each country under for instance Foreign Trade or Stock Levels/Inventories. It is also available in: Economics – by source > JODI (Joint Organizations Data Initiative).

Financial Instruments from ICAP

World class data for the G7 countries and the Nordic region available in our new ICAP add-on database. The database covers a multitude of OTC interest rate instruments, with an emphasis on interest rate swaps, denominated in eight currencies and priced in several different geographical locations as well as other types of data like FX spot and FX forwards. The almost 35 000 available daily frequency time series have extensive history and are updated throughout the day as different markets closes.

The database includes:

• Bonds – corporate, sovereign and US agency
• Currency spot and forward rates
• Deposit rates, FRAs and repos
• Basis swaps and cross currency basis swaps
• Inflation swaps
• Interest rate swaps
• Swaptions, straddles and cap/floor
• Overnight indexed swaps
• Swap spreads

Minor additions

Increased coverage for Kazakhstan, Mongolia, Georgia and Colombia. Added Milwaukee PMI, selected items from the ECB SAFE Survey, BIS private credit data, the CFTC TFF report and increased coverage of investment fund balance sheet data from ECB.

Soon to be released

Consensus estimates from Consensus Economics as an add-on database.

The new version can be installed directly via the Macrobond platform by clicking the yellow line that appears on the screen or by selecting Check for update on the Help menu. If you need assistance, a description of how to upgrade is provided by the IT-department, which may be found here. Simply click Upgrade for further instructions.

Selection of new functionality

Web publish

The purpose of the Web publish feature is to simplify the process of publishing Macrobond charts in on-line publications, such as a blog, a content management system (CMS) on your intranet or on the Internet or when using social services such as Facebook and Twitter.

Improvements in analyses

• We have implemented a one-sided HP filter in the Smoothing analysis and as a formula function.
• It is now possible to define a range for the “Performance since” operation in the Scalar analysis.
• You input which date you want to look at.
• The following analyses now supports category series: Aggregate, Correlation, Covariation, Rate of change, Smoothing and Statistics. This means that they can be used after analyses such as Slice and Scalar.
• You can now specify a maturity date instead of a maturity length for an instrument in the Scalar analysis.

More ways to search for related series

We have added some new Actions that make it easier to find other series that belong to the same Index, Source, Security or Release:

Action for navigating directly to the Release

There is now an action for going directly to the information in the Release Activity for a time series:

Go back to a previously selected entity for Actions

There is a new list of what entities that were previously used in the Action bar and you can navigate back to a previous selection:

Thumbnails for the most recently opened documents

You will now find thumbnails for the documents in the list of most recently opened documents in the Start Activity:

Information about creation date and creator of a document

In the File Open/Save dialog, we have added information about when and by whom a document was created. The name of the creator is only available for documents created since 2013.

Performance improvements

We have improved the performance in many places. The most visible changes are:

• Faster Table presentation when you have a large sets of series.
• Faster copy/move in the File Open/Save dialog when many folders or documents are selected.
• Faster display of the list of documents in the File Open/Save dialog when there are a lot of documents.
• Snappier operation when expanding folders in the File Open/Save dialog and in the database Browser.
• Faster Average correlation calculation in the Cross section analysis.
• Faster application start since some non-critical things are delayed and done in the background when the application is idle.

Additional metadata in the SQL DB Connector

There are a few more pieces of metadata that can be specified in the Macrobond SQL DB Connector: ForecastCutoffDate, MaturityDate, MaturityDays and RateMethod.

There is more information in the documentation.

Selection of new content

Foreign Direct Investment data from UNCTAD

Data for inward and outward flows and stocks for countries and regions has been added and is available here:

Economics – by region > World > Foreign Finance > Foreign Direct Investment

Economics – by source > UNCTAD United Nations Conference on Trade & Development > UNCTAD Foreign Direct Investment.

OECD Long Term Baseline Projections

The OECD Long Term Baseline analyzes the major economic trends beyond the OECD short-term projections. For all OECD economies, and the major non-OECD economies, it provides coverage of components of potential growth, fiscal balances and debt accumulation, domestic saving and investment balances, and external balances (through the current account). It also includes interest rates consistent with those projections.

The database contains annual data to 2060. Variables are defined in such a way that they are as homogenous as possible for the countries covered. Breaks in underlying series are corrected as far as possible. Sources for the historical data are publications of national statistical agencies and OECD statistical publications such as the Annual National Accounts, the International Monetary Fund, the United Nations, and Eurostat.

The series are available in: Economics – by country major > (country name) > Forecasts > OECD Economic Outlook > Long-Term Baseline Projections

IMF’s Fiscal Monitor

The IMF Fiscal Monitor contains estimates for items such as government expenditure, revenues, balance and debt in relation to GDP. Current estimates go to 2017 and are available for a wide selection of countries and regions.

The data can be found here:

Economics – by source > International Monetary Fund (IMF) > IMF Fiscal Monitor

It is also available under forecasts for individual countries in the by country tree.

Unrevised data

Over 1 million time series from the St. Louis Fed ALFRED database added. It allows you to retrieve vintage versions of economic data that were available on specific dates in history.

It contains primarily U.S. data but also some international items. Note that some U.S. data is available under international data and that the more specific U.S. items have their own categories in the ALFRED tree.

The data is presented in three ways:

Initial release – The data is presented as a normal time series but does only contain the first released data for each time period.

By vintage – The time series is presented like it looked at a specific point in time, the vintage date, which is the date included in the series title.

For reference period – This allows you to see the revisions over time for a specific reference period, like Q4-2012, which is the date included in the series title. Unlike the two variants above the series observation date is the date it was revised.

The new version can be installed directly via the Macrobond platform by clicking the yellow line that appears on the screen or by selecting Check for update on the Help menu. If you need assistance, a description of how to upgrade is provided by the IT-department, which may be found here. Simply click Upgrade for further instructions.

Selection of new functionality

Yield curve analysis

With the Yield curve analysis you can produce charts showing yield curves, where one axis shows the maturity length and the other the yield.

It works like this:

1. As input it takes a number of series with interest rates of different maturity lengths.
2. You input the maturity lengths and type of rate (simple or effective). For some series there might be information in the database about this and it will then be filled in automatically. Right now, very few series have this information, but we are working on that.
3. You input which date you want to look at.
4. The analysis will produce two time series for each yield curve: one series which contains the maturity lengths expressed as years and one series with the interest rate at the specified point in time for the corresponding maturity.
5. If you plot these two series in a scatter chart and combine the dots with lines, you will get a yield curve with “years” on one axis and “%” in the other.
6. In the analysis you can select to combine the lines with a natural cubic spline, which will give you a smooth yield curve. When this setting is turned on, a rate will be calculated for each month.

You can calculate several curves at the same time. Either at different dates or with different settings or selection of series. If you select the special date called “Latest”, the last date where there are observations for the majority of the series is used.

A tip is to add two curves, where one calculates splines and one does not. You can then configure the chart to draw one of them as lines, without labels and the other as just markers, but including labels. It will then look something like this:

Here is an example showing several yield curves at different points in time:

Frequency conversion analysis

The Frequency conversion analysis can perform the same frequency conversions as in the Series list, but since it is an analysis, the conversion can be done after other calculations.

The analysis also lets you specify a list of date ranges to include in the calendar. This can be used to include or exclude certain time periods from the series. In the chart below, 2006-2007 has been excluded.

Analysis comments

You can now enter a comment for each analysis in a document.

The comment field can be expanded/collapsed by the small arrow in the lower right corner. The arrow will be highlight in yellow if there is a comment in the field. There are some options for controlling when the comment field should be visible in the menu at “View|Analysis comment”.

Thumbnails and comments in File Open/Save dialog

When a document is saved to any of the accounts, a small-scale version of the current chart is saved together with the comment. You can view the thumbnail and comment in the dialog when opening a document. Currently this does not work with documents save to My computer.

The File Open/Save dialog now has three modes:

• Basic list – this shows a list of documents with the columns Title, Last modified and Modified by. The tooltip shows the thumbnail and comment.
• Thumbnails – Show the documents as thumbnails with a title below. The tooltip shows further details such as the comment.
• Details – Show the thumbnail and details of the selected document.

Bloomberg “overrides”

Bloomberg has a concept called “overrides” which is a parameter you can pass to data requests that influences the data. There is now support for specifying such “overrides” in Macrobond by adding a colon followed by “override=value” in the series name. For instance “ih:bl:nky Index:BEST_PE_RATIO:eqy_consolidated=N”.

Average correlation

There is a new method in the Cross section analysis called Average correlation. It calculates the average of the pairwise correlations between the series. It only includes the off-diagonal elements of the correlation matrix.

New formula functions

There are two new formula functions:

• PercentRank(series, value) – Returns the rank of a value in a series as a percentage (0..100) of the values in the series.
• Round(value, decimals) – The value is rounded to the closest value with the specified number of decimals. If the value is exactly in between two values, it is rounded to the value that ends with an even digit

SQL DB Connector with dynamic depth of trees

The SQL DB Connector now supports browse trees of varying depth. See the section “Trees of varying depths” in the documentation at https://redir.macrobond.com/go/technicalInfo.

Selection of new content

Colombia and Morocco

Two new countries have been added recently to Macrobond: Colombia and Morocco. The primary sourced data is available in the Economics view in Macrobond.

The Penn World Table

The Penn World Table (PWT) is a national accounts economic time series, with annual frequency, covering majority of countries. Its expenditure entries are denominated in a common set of prices and common currency so that real quantity comparisons can be made, both between countries and over time. The database also provides information on relative prices within and between countries, as well as demographic data and capital stock estimates.

The Penn World Table can be found directly in the Penn World Table view in Macrobond.

The Royal Institution of Chartered Surveyors (RICS) Market Surveys

Addition of Market Surveys published by the Royal Institution of Chartered Surveyors– RICS Rural Market, Commercial Market, Construction and Residential Market surveys so now Macrobond carries a complete RICS data suite. All the newly-added surveys together with UK Housing Market Survey analyze the UK economy whereas Portuguese Housing Market Survey, prepared in partnership with Confidencial Imobiliário (a Portuguese real estate information publisher), is Portugal oriented.

The series are available in the Economics – by country major > United Kingdom > Business Surveys > RICS, or Economics – by country major > Portugal > Business Surveys > RICS

Expansion of Eurostat data – MIP Scoreboard, Demography > Population projections

Macrobond continues to expand its data coverage from Eurostat. Macroeconomic Imbalance Procedure Scoreboard, Demography > Population projections sections have been recently integrated with our database.

Data can be found under:

Eurostat > Select area > Macroeconomic Imbalance Procedure Scoreboard

Eurostat > Select area > Population

Additional indices from EuroMTS

We have increased our coverage of Euro Area bond indices from EuroMTS.

The data is available under: Economics – by country major > Euro Area > Interest > Exchange Rates > Fixed Income Indices

The Conference Board U.S. Business Cycle indicators

Addition of the U.S. Business Cycle Indicators provided by the Conference Board. U.S. BCI database includes the full history for each series, including revisions, along with the latest data. The historical data series goes back as far as 1945, most start in the late 1950s.

These series are available in the Economics – by country major > United States > Leading Indicators > Conference Board

Canada – CANSIM

Major methodological change for Canadian index-based indicators within National Accounts and Balance of Payments, following recent switch to 2007 base year introduced by CANSIM. As a result approx. 1000 further new series will be introduced by the end of this week.