Golden Cross pattern

Overview

Using analysis and formulas calculate when Golden Cross pattern appears in a series and how long the periods between Golden Cross and Death Cross are.

Examples

Golden Cross for S&P500

Here we have calculated Golden Cross for S&P 500 series.

Moving average convergence/divergence (MACD)

Overview

Our built-in formulas:
SMACD(series, short, long, signal)
FMACD(series, short, long)
utilizes the exponential method. The simple one can be replicated using difference in arithmetic means.

Example

MACD - simple and exponential

Comparison of two methods of calculating Moving average convergence/divergence (MACD).

Selecting series

Overview

Picking series from a large data set could be difficult. See below different functionalities which make it easier.

After selecting series use 'Add selected time series +' at the bottom.

View

Tabs

In some nodes if you look to the top left corner of the list, you’ll notice various tabs. Each tab groups series that share a common attribute.

All levels slide

Some nodes have more structured view with levels.
If you prefer not to use tabs and structured view, simply select Flat, to combine all the time series into a single list.

Finding older version of series

This feature is available in Macrobond 1.30 and later.

Macrobond may be required to create a new time series with a recent historical start point if there is a change made to the methodology of the time series or any other change. You can now easily locate related discontinued time series by right-clicking on series and selecting 'Add superseded'.

You can combine series with formula, for more information see Join().

Picking series

Ctrl and Shift

You can select series one-by-one with Ctrl key. Or use mark first one, press Shift, and mark last one.

Select all/Select this level

This feature is available in Macrobond 1.28 and later.

Right-click on series and you will see options

  • Select all - will mark all series in node
  • Select this level - will mark all series from that particular level. Note it also works on levels which 'All levels' slide does not catch.

Replace series

Overview

Change region function is fantastic when you want to replace all series but what if you want to change one of them in a big document? With Replace series function you do not have to deleted/paste/move series in Series list any longer.

Note it doesn't replace series inside Lists.

How to replace series?

Right-click on a series, select 'Replace series' - new window will open. Select to-be-replaced series. Press OK.

Document labels

This feature is available in Macrobond 1.28 and later.

Overview

This feature is available in Macrobond 1.28 and later.

You can assign keywords to your documents and use them for searching through files or to get notifications about changes.

Use cases

Search through files

When you are in File > Open document window you can use labels for filtering documents.

Get notifications

When you use Notification to subscribe to a folder you can choose to be notified only for files with certain labels.

Labels in document

How to assign label to a document?

Document labels can be set directly in the document in a section below the Analysis tree. Type in keyword and press 'Enter'. Macrobond will try to suggest labels which you have used in the past.

Inside 'Save as...' window

It is also possible to add document labels while saving document. At the bottom of window there will be row named 'Document labels' where you can type in new labels. Row below contains 'Suggested labels', click on one to add it to Document labels.

How to delete label from a document?

Open document, hover over label and press X or edit line and press 'Backspace'.

Notifications for a document label

Subscribe to a folder with Notifications feature. In 'Create subscription' mark first option and type in label's name. Press 'Create'.

For other information about this feature see Document notifications.

Document notifications

Overview

When working with your colleagues it is useful to know when something changes. With Notification you will be automatically informed when somebody make changes in document which you have currently opened. You can also use Notifications feature to keep track of changes in folders.

Types of notifications

Notification in opened document

While working on a particular document you will get an immediate notification in the application if a document you have open was modified by someone (you will also know who modify it). Yellow bar will appear above the document and under Open documents tab. You can choose to reload file or dismiss notification.

Notification of changes

You can subscribe to notifications of changes in a folder. First option works with Document labels.

In application you will receive those notifications on the Start tab and also, if you mark below marked boxes, as Windows notifications.


See here 1.27 version view

How to subscribe?

Document notifications panel

This feature is available in Macrobond 1.28 and later.

Go to Configuration > Document notifications..., in new window mark the folder and press 'Create subscription'. You'll see 'Create subscription' window. This subscription will refer to documents in that folder and all sub folders.

Subscribe to folder in documents

To do this, while in Documents tab, right-click on a folder, or a file in folder, and select Subscribe to folder. You'll see 'Create subscription' window. This subscription will refer to documents in that folder and all sub folders.

'Create subscription'

Mark option(s) and press 'Create'. First option works with Document labels - note that it is available only in MB 1.28 or later.

See here 1.27 version view

How to check my subscriptions?

This feature is available in Macrobond 1.28 and later.

In Subscriptions panel

Go to Configuration > Document notifications..., select 'Show only subscribed folders'. Subscribed folders will be bolded.

In Documents

Go to Documents tab > Files > Subscription folder.

The exclamation mark means that this folder was deleted.

How to modify or cancel my subscription?

In Subscriptions panel

This feature is available in Macrobond 1.28 and later.

Go to Configuration > Document notifications..., select 'Show only subscribed folders'. Click on bolded folder and select 'Edit subscription' or 'Cancel subscription'.

In Documents

To edit or cancel folder subscription right-click on a folder, or a file in folder, and select one of the options.

and also under Documents tab > Files > Subscription folder.

Notification is not working

There is a symbol in the status bar when the document event notification is not working. This can happen when our servers are blocked in a firewall. See the Deploying the Macrobond application for what is needed to be whitelisted.

Note you can click on the icon to bring up a dialog, and send the error message to our Support team.

Absolute change

Overview

Calculating absolute change (new value − reference value), other than a simple subtraction, can be used to show how the series evolves around specific reference points.

Examples

Election time

Let's see how USD per EUR exchange rate looks like around US presidential elections.

Rate is going up

How to find specific turning points in a series and then use those points to calculate absolute change.

Months’ mean

Overview

Macrobond has easy-to-use tools for calculating rolling mean, but what to do when you want to calculate mean from all Januaries, Februaries, etc.? See below for a solution.

Example

Months' mean for 10 years

There are a few ways to calculate months' mean - in this file you can compare them. File presents method with outcomes as a category series or time series.

All about counting observations

Aggregate all declining values

Aggregate all consecutive declines of the series.

Aggregate all declining values

Calculation based on a condition

Do calculation when series fall below its average

When series falls below its 200-day average for more than 5 days subtract average from main series.

Subtract when series fall below 200d average for more than 5d

Number of series which have risen

See how to count number of series which have risen for 3 months or more.

Number of series which have risen

Count(), Count valid, Counter()

See how those basic formulas work and how they differ.

Count, Count valid, Counter - see comparison

Count days between Fed Funds Rate hikes/cuts and cuts/hikes

Use various formulas to measure period(s) from first hike to first cut and from first cut till first hike.

Count days between Fed Funds Rate hikes and cuts

Countdown till 0

Count number of forecasted observations from 'now' till the end of forecast - from highest number till 0.

Countdown till 0

Find local peaks, count/aggregate observations

All-time highest value and aggregated number of days above/below certain value

Find all-time highest value(s) and when there is a 10% decline or more. Aggregate number of those values.

All-time highest value and aggregated number of days above/below certain value

All-time highest value and number of days between

Find all-time highest value(s) and count number of observations between them. Also, count number of days since higher value than 'current'.

All-time highest value and number of days between

Highest value in each year and after x business days

Find all-time highs in each year. Compare how many all-time-highs was in each year at the same moment current year is ('after x business days').

Highest value in each year and after x business days

How many series go up/down/no change

How many stocks go up or down?(Advance/Decline line)

See the difference between the number of advancing and declining stocks on a daily basis with calculated A/D line.

How many stocks go up or down - (Advance/Decline line)

How many series from list went up (in %)?

Calculate how many banks hiked their policy rates in each point in time. Also, based on that show series when percentage of hiking banks is below or above 50%.

How many series from list went up (in %)

How many series from list went up, down or remained in place?

See how Policy rates series from various banks behaved - how many rates were hiked, cut or had 'no change' - in numbers and percentage.

How many series from list went up, down or remained in place