Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Return to Overview

...

Guide

Name
Image/Description
Portfolio

Select a portfolio of interest.

Benchmark

Select a benchmark.

(The benchmark's summary statistics are also shown, and can be compared against that of the portfolio.)

If it is a future continuous contract, tick checkbox 'CONT' and fill in the 'Serial No.'. For more information, please refer to Futures Continuous Contract Data Setting.

Otherwise, select the 'Contract Month' and 'Contract Year' for the product(s) of interest.

Select Unit

Select the unit for the product. You may leave it as "Default". For more information about other units, please refer to Select Unit (Data Transformation Tool).

Risk Free Rate (%)

The risk-free interest rate is inserted by the user and is used in calculating various performance statistics.

(The current T-bill rate is the suggested risk-free rate.)

Comments

The inserted comments will be displayed at the bottom of the application. This can be useful for documentation purposes or for settings description.


Input

Name
Description
Type
Example
PortfolioPortfolio to be analysed.Portfolio (Selection)ABC
BenchmarkProduct to be used as a benchmark.Product NameBrent Crude Oil Futures
Contract month.MonthJuly
Contract year.Year2019
Continuous contract (for more information, please refer to Futures Continuous Contract Data Setting).Checkbox-
Serial number of starting futures contract (for more information, please refer to Futures Continuous Contract Data Setting).Numerical Value1
Unit (for more information, please refer to Select Unit (Data Transformation Tool)).UnitDefault
Risk Free Rate (%)The risk-free interest rate (inserted by user) to be used in calculating performance statistics.Numerical Value2.1
CommentsUseful for documentation purposes or for settings description.Text-


Output

Name
Description
Formula
1 Year R (%)

Total compounded return for the past 12 months.

(RoRt*RoRt-1*RoRt-2*...RoRt-11 -1) *100%,
 where t = current month

3 Year R (%)Total compounded return for the past 36 months.(RoRt*RoRt-1*RoRt-2*...RoRt-35 -1) *100%,
 where t = current month
Compounded Monthly R (%)Average compounded return per 1 month (across all months).((RoR1*RoR2*RoR3*...RoRN)1/N -1) *100%
Compounded Annual R (%)Average compounded return of each year (across all years).((1 + Compounded Monthly R)12 -1) *100%
Monthly Mean R (%)Average of monthly returns.(R1+R2+ R3+...RN) / N
Total Compound R (%)Total compounded rate of return.(RoR1*RoR2*RoR3* …RoRN - 1) *100%
YTD R (%)Year-to-date return, which is the total compounded return since first month of the current year.((RoRs+1*RoRs+2*...RoRN-s)1/(N-s) -1) *100%,
where s = last month of previous year
Alpha (%)Excess return of a portfolio, not accounting for returns correlated with overall market movements (tracked by a benchmark such as S&P).(M - Beta* BM)*100%
BetaCorrelation between the performance of a portfolio and that of a market benchmark (such as S&P).i (R- M)(Bi- BM)/ ∑i (Bi- BM)2
Risk Free Rate (%)Risk-free rate (inserted by user).2.1
Formula Symbols:
R = return, RoR = rate of return = 1 + (R/100%), N = number of months, M = mean return, Bi = benchmark return for a given month, BM = average benchmark return

Example

Image Added

Aren't these returns impressive? But please remember that past performance may not be indicative of future results. (big grin)

Functionality

Please refer to Table Settings for table functionalities.


...

Click to access:

Page Tree