Guest User | Sign In

Knowledge Base

Annual Rate of Return

The Annual Rate of Return tool calculates the compounded growth over a defined period - also known as Compounded Annual Growth Rate (CAGR). In this example, the ASX200 index has grown 25.31% over the last 3 years, which is an annual rate of return 7.81% per year ((1+0.0781)^3)-1 = 25.31%.

image

Scripting Function - ARR()


To calculate the Annual Rate of Return in a watchlist column use the ARR() function. In this example, the formula used is ARR(PERIODAMT=5)/100 for a 5 year annual rate of return, which has been divided by 100 so it can be displayed in a percentage format. This shows Microsoft (MSFT) has grown at an average rate of 25.7% for each of the last 5 years, compared to 17.9% for AAPL:

image


Actions & Properties


Actions


Copy Data to Clipboard: Will copy the tool's values to the clipboard which can then be inserted into a spreadsheet, for example, allowing for further analysis.

Add to Toolbar: Click this action to add the selected custom tool to your toolbar.

Apply Settings to All: When multiple tools have been applied to a chart, page or workbook, this action can be used to apply the settings of the one selected to other instances of the tool. This is a great time saver if an adjustment is made to the tool - such as line colour- as this allows all the other ARR tools in the chart, page or entire workbook to be updated instantly.

Copy Tool: Allows you to copy the selected tool, which can then be pasted onto a different chart window.

Move to Back: If the tool is displaying in front of other tools or indicators clicking this action will move the lines view to the background.

Move to Front: If the tool is displaying behind other tools or indicators on the chart, clicking this action will bring the lines to the forefront.

Restore Default Settings: Click this action if you have adjusted the default settings of the ARR tool, and wish to return to the standard properties originally installed with Optuma.

Save Settings as Default: If you have adjusted any of the ARR Properties (colour, for example) you can save the adjustments as your new default setting. Each time you apply a new ARR to a chart, the tool will display using the new settings.

Delete: Delete the tool from the chart.

Properties


Tool Name: Allows you to adjust the name of the tool, as it's displayed in the Structure Panel.

Years: Allows you to select the number of years the ARR is calculated.

Zero-Based: Starts the calculation from 0 or 100 if the box is unticked.

Plot Style: This option expands to show the following:
  • Plot Style - Allows you to change how the RSI is displayed on your chart. There are 6 options available: Line, Dot, Histogram, Step, Shaded, Shaded Step.
  • Line Style - The Line Style property allows you to adjust the type of the line displayed. There are 8 options available: Solid, Dots, Dash, Dash Dots, Long Dash, Long Dash Dot, Long Dash Dot Dot, Stippled.
  • Line Width - Allows you to adjust the width of the lines. Moving the slider bar to the right increases the thickness of the line.
  • Colour Scheme - Allows you to select the colour of the line. Clicking on the drop down arrow will display a colour swatch. Locate the desired colour and left-click it once to select it.

Centre Line Style: Change the line style and colour of the centre line.

Offset: Moves the tool forward or backwards in time. The offset is measured in bars, so a value of 2 will push the tool forward 2 bars and -2 will move the tool back 2 bars.

Tool Transparency: Use this slider bar to adjust the transparency of the tool. Moving the slider to the left will increase the transparency of the tool.

Visible: Un-tick this checkbox to hide the tool from the chart.

Show In Price Scale: When selected the current value will be displayed in the Price Scale.

Please Wait!

Please wait... it will take a second!