Portfolio Performance Table

Return to Overview


The Portfolio Performance Table provides a summary of the performance of a trader's portfolio – including various returns measures, and other performance measures such as alpha. The measures may be benchmarked against an index or commodity of the user's choice (1 column shows statistics for the portfolio, and another for the benchmark). Please refer to 'Output' below for a more comprehensive description of each performance measure (Please also refer to the Portfolio Statistics Table for other statistics of portfolio performance).



Select a portfolio of interest.


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.)


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


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-


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


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


Please refer to Table Settings for table functionalities.

Click to access: