Publishing charts on X

How to send a chart?

You can send charts that you’ve made in Macrobond directly from the application to X. Here’s how:

  1. Start with the Macrobond document open and the chart you want to tweet selected in the analysis tree.
  2. Go to the File.
  3. Click Send to X.

Note: The first time you use this feature you’ll be asked to log in to your X account via the Macrobond application. See more under Connecting account.

  1. In this window, select the chart size and compose the tweet.

    Note:

    • You can create a default text or hashtag for your tweets. Just type the text you’d like to save and click the save icon to the right of to the text box.
    • It may be a good idea to select the Transparent as white option. X may show your tweet on canvases of different colors and making the transparent parts of your chart white is a effective way to ensure that it’s always legible.
  2. Click Send. You’ll get a notification from Macrobond that your tweet has been published.

My tweet is not longer than 280 characters but I can't send it?

X counts some glyphs as more than one character. See Counting characters.

Connecting account

The first time you will try to use this feature, you will be required to authorize the Macrobond Application to access your X account. There are two starting points where you can connect it:

  1. File > Send to X, a new window will pop-up, allowing you to obtain a pin-code:

    After pressing the button you will be redirected to the X page where you will be given a code to paste in Macrobond pop-up window.
  2. Configuration > Settings > Social media (for MB pre-1.28: Edit > Settings > Social media), press 'Login'. You will see new window with 'Obtain PIN code' button. After pressing the button you will be redirected to the X page where you will be given a code to paste in Macrobond window.

Disconnecting account (revoke access)

You can revoke the granted access at any time in the Apps section of your settings in LinkedIn or in Macrobond go to Configuration > Settings > Social media (for MB pre-1.28: Edit > Settings > Social media), press 'Forget' next to LinkedIn. You will be redirected to page where you can revoke access.

Privacy

Macrobond will not store your X credentials, but an encrypted key received from X that allows the application to send messages using your account.

Export charts as image or video

Overview

Exporting Macrobond charts as images is useful when you need to publish your charts in a universal file format like PNG or SVG, or when you want a chart that isn’t refreshable. Since version 1.28 we have also added animation option for SVG files.

How to export image or video?

Where to go?

There are two places from which you can export video. First from upper menu: File > Export image or video. And second, in main app working space right-click on a chart and select Export image or video.

Select format

You can choose from below formats:

  • images: PNG, EMF,
  • vector image/animation: SVG,
  • animation: GIF (looped), MP4.

For more options for copying images, including refreshable and/or linked-to-original-document images, see Copying & pasting charts.

For more information about animation settings see Animated charts.

Quality of image and video

See How to ensure the image and video quality? for tips.

Export favorites

Under Export charts as image or video you can save your preferred export settings with 'Save as export favorite.' Then on chart, after right-click, you will see Export favorites list where you can quickly select favorite format.

The Macrobond Excel formula functions

Overview

Macrobond Excel formula functions give you flexibility and enhance your work in Excel. There are three main use cases:

  1. Importing values or metadata from a particular series to Excel. Values should be put between quotation marks. For example, the following expression will retrieve the last value of the "uscpi" series:
    =MbndGet("uscpi")
  2. Parameters can be set to reference other cells, meaning that you can generate dynamic queries. Reference cells should be input without quotation marks.
  3. These formulas can be integrated into Excel formulas.

To update your calculations with the latest values from the database:

  • Use the Refresh button on the Macrobond tab
  • Do a deep refresh of the workbook by pressing Ctrl+Alt+F9.

List of formula functions

=MbndGet("series")

Returns the last value of a series.

=MbndGet("series"; "date")
or depending on your Excel's settings:
=MbndGet("series", "date")

Returns the value of the series at the specified date or, if the date is not associated with a value, a #N/A symbol.

=MbndGet("series"; "startDate"; "endDate"; includeDateColumn)
or depending on your Excel's settings:
=MbndGet("series", "startDate", "endDate", includeDateColumn)

Returns an Excel array of the observations in the specified date range. If includeDateColumn is TRUE, there will be two columns, with the first column containing the observation dates.

Notes about arrays:

To create an array, you need to have highlighted the cells first. If you consider including the date column, remember to highlight cells for two columns, one for the dates, the other for the values.

Remember to press Ctrl+Shift+Enter when you have entered the formula.

For more information regarding the use of Array functions, refer to Array functions in the documentation provided by Microsoft, within Excel.

=MbndDate("series")

Returns the observation date associated with the last observation. Observation date is the date representing the period which is the first date in the period (i.e., for date 4th May 2004 in Annual series the displayed date will be 1st Jan 2004).

=MbndDate("series"; "date")
or depending on your Excel's settings:
=MbndDate("series", "date")

Returns the observation date of the most recent observation prior to a certain point in time specified by the second parameter.

=MbndDate("series"; "startDate"; "endDate")
or depending on your Excel's settings:
=MbndDate("series", "startDate", "endDate")

Returns an Excel array of observation dates attributed to the series in the time interval.

=MbndMeta("series"; "name")
or depending on your Excel's settings:
=MbndMeta("series", "name")

Returns the metadata specified by the parameter "name". Metadata names are case sensitive.

Using formulas through 'insert' in Excel

Those formulas work as any other function in Excel.

  1. Go to Formulas tab > Insert functions.
  2. From the list select 'Mbnd.Excel.Udf.Functions'.
  3. Press 'OK'.
  4. Under 'Identifier' type in time series' code.
  5. Press 'OK'.

Question

Can I access vintage data through MbndGet?

Unfortunately, no.

Where do I find the list of metadata available with the MbndMeta Excel function?

The Macrobond Excel formula "MbndMeta(series; name)" (or "MbndMeta(series; name)") returns the metadata identified by the parameter "name" for a particular "series". Metadata names are case sensitive.

In order to find a particular metadata name, you can use the dynamic properties available in Macrobond:

Let’s use the "usgdp" series as an example.

  1. In the Macrobond application, create a new document and add the series "usgdp" to the Series list
  2. In the Time chart, double-click on the title to access the text editor
  3. On the right side of the window, you will see the Dynamic Properties tab, click on it
    • The dynamic properties are based on the metadata which is what we may import into Excel using the function
  4. Scroll through the properties. When you find the metadata, you are looking for, click on the red 'plus' sign


On the picture above, you can see the text {s .Release.NextReleaseEventTime}. The last part of this expression, after the first period, specifies the "name" of the metadata. In this case 'Release.NextReleaseEventTime' should be used as "name" when using MbndMeta.

Use the name of the metadata in a MbndMeta expression as such:
=MbndMeta("usgdp";"Release.NextReleaseEventTime") (or =MbndMeta("usgdp","Release.NextReleaseEventTime") )

We have full list of metadata available under Commonly used metadata.

Why it is not working?

To use UDF function the add-in must be active. See here on how enable it.

Closing app (remember/forget files)

Overview

When you will close Macrobond application it will ask you what to do with open documents.

If there are documents with changes that have not been saved, you will see a list of those documents with some options next to them. You can select to save each document here, or to discard the changes if the document has previously been saved. The document will then return to the last saved state.

Options

Close and remember

The list of open documents and their current state will be remembered and opened the next time the application is launched on this computer.

Close and forget

The application will not remember what documents that were open, and any changes made will be lost if not saved individually.

Always close and remember

The application when closed will always remember documents which were open. It will stop showing the window when closing.

You can turn this off under Configuration > Settings > Advanced > Always close and remember my state (for MB pre-1.28: Edit > Settings > Advanced > Always close and remember my state).

Settings

If you do not want to see this window when you close without saving, you can adjust the settings by clicking Configuration > Settings > Advanced > Enable auto recovery and saving of document state when closing (for MB pre-1.28: Edit > Settings > Advanced > Enable auto recovery and saving of document state when closing).

Presentation documents

Introduction

As the name suggests, Presentation documents are used to organize charts and tables so that you can easily and professionally showcase an overview of your work. The Presentation documents window opens outside the application to give you more flexibility for working with, sharing, and presenting charts. Charts can be organized by pages and in folders.

Benefits of Presentation documents

  • Get an overview of multiple charts at once. You can make changes to the charts in the application and see this reflected in the Presentation document in real-time. The Presentation document window can be viewed on a second monitor to enhance your ability to work with multiple charts efficiently.
  • Add and organize an unlimited number of charts from different documents in one place. Save Presentation documents for your personal use or for sharing with others. You can browse through the pages using the Page Down and Page Up keys on your keyboard.
  • Print or export a Presentation document with a number of charts. This will then work as an alternative to PowerPoint.

Basic commands & functions

Create a new document

Right click on the analysis tree to open the context menu.

Click on In new Presentation document.

Creating from Open documents tab

This feature is available in Macrobond 1.29 and later.

In Analytics tab > Open document you can now use multiselect. Right-click on selected charts and use Create presentation document.

Add to an existing document

Right click on the analysis tree to open the context menu. Click on Add to Presentation document.

An alternative to using the previous command is Add to documents. Using this command will allow you to add multiple presentations (charts or tables) at once. However, the default presentation for that document will always be used. You can identify which chart or table is the default by looking at what is displayed in the thumbnail.

To add a new presentation from the application select Add document(s) in the Home view of the menu bar. If there are no presentations in a document, the document will not be added, nor will this result in an error message being displayed.

Saving

To save a Presentation document, click on File, and Save, in the top menu bar.
You can save Presentation documents in your Personal account store or Company account store, just like other Macrobond documents.

Saving to the Company account store will allow you to share Presentation documents. If you share your Presentation document and it contains references to documents in your personal store, you will get a warning that other users might not be able to see all documents in your presentation.

Opening

To open a Presentation document, click on File, and Open in the top menu bar.
Select the Presentation document you would like to open from the dialogue box that appears.
You can distinguish them from other documents by the P in the lower right corner of the thumbnail, or by looking at the information in the tooltip.

Exporting your work

Printing

Click on File, and Print, from the top bar menu. In the print dialog there are options for selecting printer, paper orientation, margins, and page range.

Creating a PDF

In Windows 10 there is a built-in printer called Microsoft Print to PDF that can be used to create PDF files.

Exporting to Power Point

If you have prepared your Presentation in Macrobond but want to use it later in Power Point you can export it. To do this go to File > Export to Power Point.

To link together original charts and your presentation check last option 'Embed links to document instead of embedding a copy'. If you won't mark this, charts in presentation will be treated as a separate entity (they still can be edited).

Exporting images

This feature is available in Macrobond 1.28 and later.

With this feature you can export all (or some) charts from Presentation as an image, i.e.; as SVG. There are two important settings here:

  1. Pages/Individual charts - export whole pages or each chart as their own image.
  2. Keep file structure in export - if exporting 'Pages' this option will create a folder for each paginator, while with 'Individual charts' it will create a new folder for each paginator and page.

Updating or editing charts

To make changes to the charts in your presentation document simply edit them in the application as you normally would. The changes will be automatically reflected in any presentation the edited chart is in.

If you have linked the charts to presentation first, you will see first Referenced document information panel. Click on Open document to see the original file.

Organizing your work

Changing the order of your charts

There is a list of the charts, like a table of contents, on the left-hand side of the presentation. You can change the order of the charts by dragging them with the mouse.

Adding a page

A page is used when you want to collect several charts in one view.

In the menu bar at the top of the window, select Add page. Drag the charts in the table of contents, on the left, to the page you want to add them to.

Adding a folder

If you have many charts or pages in a single presentation document, you might want to organize them further into folders. In the menu bar at the top of the window select Add folder. Then drag charts and pages into that folder.

Adding a paginator

Adding a paginator will create a layout which will be applied to all pages below. By changing paginator layout you change, in one move, layout to all pages.

You can change the column setting under the 'table' icon.

Renaming

You can rename charts, pages, and folders in the table of contents by selecting Rename in the context menu, or by pressing F2 on your keyboard.

Navigating

Moving between pages

Using the Page Down or Page Up keys on the keyboard will take you to the next/previous page or chart that is not on a page.

Zooming in/zooming out

If you double click on a chart on a page, the chart will be displayed in full size. Backspace on the keyboard or the back button on the mouse will take you back to the page view. This is convenient if you have created a page with many small charts (using a low zoom factor). You can then double click on charts you want to take a closer look easily returning to the previous view.

Minimizing/maximizing the toolbar and Overview pane

To view the Presentation documents window with a minimized toolbar and Overview pane, press Ctrl+M on your keyboard.

Alternatively, you can select the View tab of the menu bar, and then click on the button on the left to minimize or maximize the toolbar.

Opening a chart in the application

On the context menu of a chart, you can select Open in analytics or Ctrl+Double Click, to open the linked document in the main application window.

Using embedded charts

You can use charts opened from charts embedded in Office documents or from a historic document revision in a presentation document but note that these charts can only be displayed as a single chart, and used until the window is closed. They cannot be combined with other charts, in a folder or page, and they cannot be saved.

Style & layout settings

Chart layout

The way your charts are displayed can be adjusted in the Home view of the menu bar, using the Layout, Zoom and Scale to fit options.

Layout options include:

  • Single column
  • Two columns
  • Three columns
  • Square

Selecting a zoom factor for all charts on a page will adjust the scale of the charts. For example, by setting a zoom factor below 100, such as 75 or 50, the charts will be displayed as thumbnails in the page.

To see all bar charts in the provided space, select Scale to fit, by clicking on the square icon (highlighted in blue above). This setting is also available from the Defaults view in the tool bar and can be set in a stylesheet.

Text notes

For each page you can enable Presentation notes – short text note for each chart on the page. To write one just change the option from 'Hide' to anything else and double-click on the area which will appear in presentation document.

Notes can be located above, below or on one side of the chart (either left or right). Application will adjust charts’ sizes accordingly to the chosen method (by shortening or narrowing the chart area).  

To edit the text note, please click on the note and input text.  After clicking on the text note, the text formatting tab will appear on the Menu bar.  

Style sheet

The Style sheet settings for your Presentation documents are defined in the Macrobond application, under the activity Style sheets. You can define settings for the pages of your presentation documents, such as text styles and background color. To apply these settings, click on Style sheet in the Presentation documents toolbar.

Note: This refers to the settings of a given Presentation document and not the charts in the presentations, which have their own stylesheet settings.

Default style settings


You can define a standard layout for an entire presentation by using the Defaults tab. Settings defined here will be applied to all pages and folders of the current Presentation document.

In contrast to Style sheet, which can be reused across multiple Presentation documents, the default settings are specific to each Presentation document you create. As such, if you wish to use a default style across all pages and folders of a document, you will have to set up default settings every time you create a new document.

Pin/un-pin


Use the pin button to override the default style settings. This allows you to use a standard style across an entire document but change the settings for specific pages where needed.

To make use of this function, type the relevant values into the fields you would like to change. Then click on the 'pin' to lock the settings and override the default. 'Pin' buttons are located both in the Home view and Defaults view of the tool bar.

Change region for Presentation documents

If you go to upper menu’s File > Open document and open a Presentation document, you can use Change region and duplicate on it. It will create new Presentation with new underlying documents in the indicated place.

Note, it will change all series in Presentation into chosen country equivalents (if they are available).

Create reports in Excel

With the report tool in Excel, you can quickly get an overview of countries or companies by downloading Macrobond’s selected key indicators for them.
This same feature as in Macrobond main app under Browse tab > Overview > Reports.

1. Pick a country or company

Here, you select the country or company that you want to include in your report.

2. Add to a report

This area shows the actions that can be taken with the selected entity. You can add it to an active report if it exists, or start a separate report with the available data, such as key indicators.

3. Reports

The tabs here are separate reports that will be downloaded into separate Excel worksheets. Each tab lists the countries or companies included.

Exporting charts as refreshable and linked objects

You can copy the chart to Microsoft Office as an embedded object. Such chart can then be refreshed when source reports new values.

Right-click on a chart and select Copy special. In new window you can select from two Metafile and Macrobond Document object.
See here pre-1.29 version view

 

  • Compatibility mode: This is the default option. It works well in most cases when, for instance, copying to Microsoft Office.
  • Unrestricted mode: The unrestricted mode also copies a metafile and document data but works better with some applications such as Microsoft Publisher.

For these two modes, you can select to include a link to the document rather than embedding a copy of the document. (Before version 1.29 you find ‘Copy as a link’ option at the bottom of the list). The link will be established between the original document in Macrobond and the pasted chart. This allows you to paste a chart in several documents and have changes made to the original Macrobond document apply to all of them at once.

For more information see here: How to copy a chart to a Microsoft Office document?

Processed/Raw data selection

When downloading data from the application database to Excel, you will need to select one of two download modes: Processed and Raw. The primary difference between the two options whether start dates and/or frequencies have been harmonized. Which one of the options you select will effect which settings that are available to you from the download panel.

Which mode to use

  • Processed mode offers more settings for adjusting data before you download it and allows you to harmonize the data set in terms of frequency and start date. You can also apply calculations through that mode.
  • Raw mode is useful when you want to download multiple series while keeping their original form in terms of frequency, scale, etc.

Processed

  • Time series are presented relative to a single date column.
  • Data can be harmonized across parameters such as date range and frequency.
  • Choose from pre-defined calculations such as Rate of change and scale to apply to the data.

Adding calculations in the Processed mode

When using Processed mode to download data to Excel, there are a few basic calculations which are possible to use.

To perform calculations on your data set, you need to open the same window you used to download the data. To edit the data set, right-click there and select Edit. In the list of series, you’ll see that the analysis column contains an Edit button, which you can click to apply calculations.

As mentioned there's few calculations which you can use without opening document in Macrobond:

Rate of change

Similarly as in Macrobond Rate of change analysis, you can choose Method of calculation and Length, however it is not possible to use Mode option here.

Scale

It is also possible to adjust series scale in Processed mode. To do this you need to select the relevant option from the scale drop-down.


In both cases to apply the same settings to all the series in the list, use the Fill-down button. Click Update when you are ready to apply your changes to the data set.

When you use Refresh to update your document with the latest values, all your calculations will also automatically be updated.

Raw

  • Download time series in their original state and frequency.
  • No predefined calculations can be applied.
  • Each time series is presented with a data column.
  • Each series can have its own start date.


All Series mode

All series mode is the main access point for downloading data into Excel. It gives you access to your entire application database and provides various options for downloading the data in a specific format.

The All series workspace

  1. Series browser
  2. Download settings
  3. Data download list

Purpose

Use it to:

  • Search through all the time series available from the application database.
  • Select the data you want to work with.
  • Apply settings that modify the series before downloading the data to an Excel document.
  • Verify the selected time series and metadata in the download list, before adding to the excel sheet.

Have a look at the follow up materials to find out how to use the settings you’ll encounter when downloading data in All series mode.

Saving documents

How to save?

You have two options for accessing the Save settings:

  1. Click on the 'Save current document' button in the tool bar
  2. Click on File in the menu bar and select Save as

Save settings

The Save document dialog is made of four main parts:

  1. List of directories
    View and select the available locations for saving. There are four main directories to choose from. Each of these has implications for how you access your documents and to whom you grant access to.

    • Personal account
      • Access is limited to you
      • Files are saved on Macrobond servers which means you can access them wherever you log in with your user credentials
    • Department account
      • Access is given to all Macrobond users in a department or team
      • Each user can only be assigned to one Department account
      • Files are saved on Macrobond servers
    • Company account
      • Access is given to all Macrobond users in the organization
      • Files are saved on Macrobond servers
    • My computer
      • Saved to your computer or network
      • Can be viewed in Macrobond by anyone who has access to the physical file
  2. File information & preview
    • Preview the files in a selected directory or folder
    • Set the display to a thumbnail or file name view
    • Use Search tab to locate specific documents
  3. Command buttons
    • Create and delete folders
    • Publish documents online
    • Update documents to reflect the latest data
  4. Name bar and confirmation buttons
    • Name the document
    • Select a local directory to save to (if not selecting one of the four listed above)
    • Confirm or abandon the action

Refreshing saved files

To update all charts in current folder, click on a lightning bolt icon.
You can stop the process in any moment.

Discontinued series


This symbol means the document contains a discontinued series. Open the document to delete or change the corresponding series.

Saving files outside of the application

When saving files outside of the application, there are two options you can use: predefined directories or local files. When we use the term 'directories', we mean the locations, like Personal account, Company account, or My computer, that you select in the Save document dialog, shown below. 

Options for saving locally 

Predefined directories 

Set up and save specific locations on your computer or local network as directories you can save to at a later point in time. The benefit of doing this is that you don’t have to define a path every time you save and can easily use the application to check where files are located instead of searching your computer. 

Save as > Local files  

You can also browse your computer or local network and find a location to save in at the time of saving. Find out more about this in Saving a document.

 Adding a new directory 

  1. Click on Edit in the menu bar and select Settings... from the bottom of the list. 
  2. Select the Document paths tab and click on Add. 
  3. Under Path properties, enter a name for the path, e.g.; 'Charts'.  
  4. Click on the ellipsis button to select location for the directory. 

Removing or editing your custom directories

  1. Select Settings from the Edit menu, and click on the Document paths tab  
  2. All the directories you have created will be displayed on the left, under Additional directories. 
  3. Simply select the one you want to edit or remove, and either edit its properties or click Remove. 

Changing the default location of the My Computer directory

By default, the My computer directory saves files to the Documents folder on your computer.
While you cannot delete this directory, you can edit its location to one of your choices. 

  1. In the Document paths tab of the Settings dialog box, deselect Default. 
  2. Enter or browse for a new location and press OK. 

How to share?

Company account and Department account are shared with your colleagues. Charts (and in-house series) saved in those directories are visible and can be edited by users with same level access. Just go to File > Open document, right-click on chart image, select Copy and send that link to another Macrobond user.

If you want to share charts outside of your department (or from your Personal account), and it has in-house data, please see here how to embed it: How to embed an in-house series in a document?

Publishing

To publish Macrobond chart you can use one of the below: