How to add/sum up series?

If you want to sum values across few series, there are two main ways to achieve this: 1. Formula language You can sum multiple series by typing a simple expression with the ‘+’ sign. It will add up only common part for all series. 2. Cross Section analysis Use the Cross section analysis to calculate … Continue reading “How to add/sum up series?”

How to specify date in formula language?

You should refer to a date using the Date() formula. Date(year, month, day) It returns the observation number of the specified date. Make sure you input the components of the date in the right order. For example: Date(2017, 01, 01) For more information: Formula analysis

How to edit / remove the axis text: lhs and rhs?

Click outside the chart area and go to the Presentation properties tab. In the Format panel, you can edit or delete the ‘, lhs’ and ‘, rhs’ text. If you change your mind you can click on the ‘x’ button to bring back the default text. For more information: Elements of the chart

How to hide analysis texts like, c.o.p 12 months?

By default, the analysis text appears in brackets in the legend text. You can remove it by clicking outside of the chart area. In the Presentation properties tab, untick the setting ‘Analysis texts’. For more information: Elements of the chart

How to delete a document?

To delete a document, go to the upper menu, File and choose Open. Locate the document you would like to delete, select it and click the ‘Delete’ button at the top of the window. Note that the document will still be available in the Recently deleted folder in the account from where the document was … Continue reading “How to delete a document?”

How to rebase a series?

Add or insert the Rebase analysis in the analysis tree. This is different from the Index builder analysis, which is used for portfolio construction as well as creating indices from weighted averages of several series. You’ll find more information on using the Rebase here: Rebase analysis How to create an index? Rebase in Slice analysis