Overview Due to its nature (many shorter series with one long) chart showing previous market expectations sometimes resembles a hedgehog. Examples Rikshog See previous market expectation for Sweden’s Policy Rate (prev. Repo Rate). 10-year US bond yield Using custom formula we have created market expectations lines.
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).
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”
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 You can assign keywords to your documents and use them for searching through files or to get notifications about changes. … 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)”