Quick answers & simple, step-by-step solutions

- Application’s functions
- How to include discontinued series in my search results?
- How to remove a series from a chart or from a document?
- How to stop new series from being automatically added to a chart?
- How to rearrange analyses in the Analysis tree?
- How can I get all market caps for the S&P 500 constituents?
- How to delete a document?
- How to access the MB chart library?

- 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 to 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 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 to rebase a series?
- How to 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 to calculate percentage change (Y/Y, Q/Q, P/P, M/M)?
- 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 to turn series into percentage?
- How do I calculate R2 coefficient using a formula?
- How do I calculate the parameters for a linear regression?
- How to add a trend line/best fit 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 to reverse or invert a series?
- How to add/sum up series?
- How do I calculate the rolling correlation between two series?

- Chart’s graphics & elements
- How to change the language of the automatic text in my chart?
- How to display multiple y-axes in my chart?
- How to synchronize values of two y-axis?
- How to change the time range on the x-axis?
- How to change the default font used in the text elements of my chart?
- How to reverse / invert the y-axis?
- How to edit / remove the axis text: lhs and rhs?
- How to hide analysis texts like, c.o.p 12 months?

- Frequency & currency conversion
- Formula language
- Graph layout
- MS Office
- Excel
- Technical
- 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?