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
Here we have calculated Golden Cross for S&P 500 series.
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.
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.
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.
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().
You can select series one-by-one with Ctrl key. Or use mark first one, press Shift, and mark last one.
This feature is available in Macrobond 1.28 and later.
Right-click on series and you will see options
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.
Right-click on a series, select 'Replace series' - new window will open. Select to-be-replaced series. Press OK.
This feature is available in Macrobond 1.28 and later.
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.
When you are in File > Open document window you can use labels for filtering documents.
When you use Notification to subscribe to a folder you can choose to be notified only for files with certain labels.
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.
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.
Open document, hover over label and press X or edit line and press 'Backspace'.
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.
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.
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.
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.
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.
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.
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
This feature is available in Macrobond 1.28 and later.
Go to Configuration > Document notifications..., select 'Show only subscribed folders'. Subscribed folders will be bolded.
Go to Documents tab > Files > Subscription folder.
The exclamation mark means that this folder was deleted.
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'.
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.
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.
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.
Let's see how USD per EUR exchange rate looks like around US presidential elections.
How to find specific turning points in a series and then use those points to calculate absolute change.
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.
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.
Aggregate all consecutive declines of the series.
Aggregate all declining values
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
See how to count number of series which have risen for 3 months or more.
Number of series which have risen
See how those basic formulas work and how they differ.
Count, Count valid, Counter - see comparison
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
Count number of forecasted observations from 'now' till the end of forecast - from highest number till 0.
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
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
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
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)
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 %)
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