:: Subscribe to our newsletter
Articles / Directory
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.

Latest version of NeuralCode(v1.3) for
Neural Networks Trading.

ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.

InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.

Launch of
Free Investment and Financial Calculator for Excel.

Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines

ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel

Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.

Time Weighted Rate of Return

The Time Weighted Rate of Return measures the compound rate of growth over a period of time by assuming an investment at the beginning of a period and measuring the growth of market value at the end of the period. This calculation removes the money weighted effects on investments and is typically used to compare the returns of investment managers.

The following Excel worksheet Time Weighted Rate of Return in the Rate of Return.xls spreadsheet describes how to calculate the Time-Weighted Rate of Return.

The worksheet first calculates the Holding Period Return of the Cash inflow and outflow of each period.

Time Weighted Return = ((1+Holding Period Return at time 1) *
                                     (1+Holding Period Return at time 2) *
                                     (1+Holding Period Return at time n)) - 1

Holding Period Return is described in the next section.

Next :
Holding Period Return

Back to Free Investment and Financial Calculator main page.

Back to Excel Add-Ins and Templates main page.


Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.

Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners