Quick answers & simple, step-by-step solutions

- Data
- Analysis
- Why does the output from the Performance analysis not start with 0?
- How do I compare different time periods of a series when using the Slice analysis?
- What is the difference between the Rate of change analysis and selecting ‘Rate of change since’ when doing a Scalar analysis?
- How do I set custom ranges when using the Slice analysis?
- How do I use custom points in time in the Slice analysis?
- How do I create an index?
- How should I read the category chart produced from a Correlation analysis?
- How do I add a dummy variable to a regression model?
- How do I add a regression line (or “line of best fit”) in a scatter chart?
- How do I calculate the mean of a series across several periods?
- How do I sort category series after Scalar?

- Calculations
- How do I calculate a Z-Score / How do I standardize a series?
- How do I annualize a monthly P/P series with a formula?
- How do I rebase a series?
- How do I aggregate a series?
- How do I calculate the median value for a series?
- How do I splice two series together?
- How do I calculate a spread, or subtract one series from another?
- How do I calculate a moving average / rolling mean?
- How do I calculate percentage change over period (Y/Y, Q/Q, P/P, M/M)?
- How do I “disaggregate” a series?
- How do I calculate a rolling sum?
- How do I lag or lead a series?
- How do I calculate / draw Bollinger lines?
- How do I replace all missing values in a time series with a 0?
- How do I retrieve as output the coefficients / beta from a Regression model?
- How do I calculate the percentile value of an observation in a series?
- How do I change a series from a ratio to a percentage?
- How do I calculate R2 coefficient using a formula?
- How do I calculate the parameters for a linear regression?
- How do I add a trend line?
- How do I add a trend channel / trend band?
- How do I determine the percentile value of a series using formula language?
- How do I define custom functions formula?
- How do I reverse or invert a series?
- How do I calculate the sum several series?
- How do I calculate the rolling correlation between two series?

- Chart elements
- How do I stop new series from being automatically added to a chart?
- How do I adjust the gap between columns in a column chart?
- How do I remove the grid lines from a chart?
- How do I edit the formatting of all the values in a text column of a bar chart at the same time?
- How do I add labels next to the series on a graph?
- How do I change a scatter chart from a connected line to dots?
- How do I remove the borders from a chart?
- How do I highlight the latest observation on a scatter chart?

- Chart style
- How do I reverse the order of the legend?
- How do I quickly change the scale of y-axis when working with large numbers?
- How do I change the default font used in the text elements of my chart?
- How do I predefine the size of my charts?
- How do I change the color of a series when it’s below / above 0 (or any other value)?
- How do I create, save and apply a new style sheet?
- How do I change the background color of a chart?
- How do I change the font and color of a chart’s title?
- How do I change the font and color of the axis labels in a chart?
- How do I change the color of a series’ graph in a chart?
- How do I properly display candlestick graph?

- Frequency & currency conversion
- Axis format
- Can I display multiple y-axes to my chart?
- How do you add an alternate axis to the chart?
- How do you add a second, mirrored axis to my chart?
- How do I add value labels to the x-axis?
- How do I add value labels to the y-axis?
- How do I change the time intervals on the x-axis?
- How do I reverse / invert the y-axis?
- How do I set a logarithmic scale?

- Formula language
- How do I specify the window length when using the Macrobond formula language?
- Is Macrobond’s formula language case sensitive?
- How can I calculate the drawdown of a series using Macrobond?
- How can I specify a date in the Macrobond formula language?
- What is the difference between ExtendLinear and LinearExtend formulas?

- Logical conditions
- Extending series
- Fill range
- Graph layout
- Text elements
- How do I change the language of the automatic text in my chart?
- How do I edit the title of my chart?
- How do I edit the source text on a chart?
- How do I edit the text in the legend of a chart?
- How do I edit / remove the axis text: lhs and rhs?
- How do I remove a legend text?
- How do I hide analysis texts like, c.o.p 12 months?

- Annotations
- Bloomberg Connector
- General topics
- MS Office
- Excel
- Application
- How do I change my password?
- How do I check which version of Macrobond is installed?
- How do I check if I am using a 32-bit or a 64-bit version of Macrobond?
- How do I sign out of Macrobond?
- Can I run Macrobond on a Mac?
- Can I run Macrobond on Linux?
- Can I decide to print a chart from MB in color or grayscale from within the application?
- How do I use the automatic proxy configuration tool in Macrobond?