Overview View Tabs All levels slide Finding older version of series Picking series Ctrl and Shift Select all/Select this level 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 … Continue reading “Selecting series”
Overview How to 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. … Continue reading “Replace series”
This feature is available in Macrobond 1.28 and later. Overview Use cases Search through files Get notifications Labels in document How to assign label to a document? Inside ‘Save as…’ window How to delete label from a document? Notifications for a document label Overview This feature is available in Macrobond 1.28 and later. You can … Continue reading “Document labels”
Overview Types of notifications Notifications in opened documents Notification of changes in subscribed folder How to subscribe? Document notifications panel Subscribe to folder in documents ‘Create subscription’ How to check my subscriptions? How to modify or cancel my subscription? Notification is not working Overview When working with your colleagues it is useful to know when … Continue reading “Document notifications”
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 … Continue reading “Absolute change”
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 … Continue reading “Months’ mean”
Aggregate all declining values Calculation based on a condition Counting days when market is closed Do calculation when series fall below its average Number of series which have risen Counting time Count(), Count valid, Counter() Count days Count days between Fed Funds Rate hikes/cuts and cuts/hikes Countdown till 0 How far from a point? How … Continue reading “All about counting observations”
Overview 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. Examples Recession bands with formulas Combine analysis and formulas to calculate … Continue reading “Recession bands (with formulas)”
Overview You can calculate Drawdown with the Drawdown formula. There are ways of constructing it differently to fit your desired output – please see examples below. Examples Drawdown – historical drawdown Historical drawdown from each peak to bottom. Our drawdown() formula is defined as 100*(peak – value)/peak. Drawdown – as a number or percentage From … Continue reading “Drawdown”
Overview Calculate swaps with Zero coupon rate analysis and/or with formulas. Examples Forward swaps SEK Calculate from SEK swap rates (1 year-10 year) from SEB (Skandinaviska Enskilda Banken). Forward swaps EUR Calculate from EUR swap rates (1 year-10 year) from SEB (Skandinaviska Enskilda Banken). Euro Area & US 5Y5Y Inflation Swap Rate (requires ICAP) With … Continue reading “Forward Swaps & 5y5y”