Portfolio Statistics Table

Return to Overview

About

The Portfolio Statistics Table provides a table of key statistics of a trader's portfolio – such as standard deviation and various ratios. The user can also include a benchmark (a commodity or index) against which these statistics are compared (the benchmark is chosen by the user – 1 column shows statistics for the portfolio, and another for the benchmark). Please refer to 'Output' below for a more comprehensive description of each statistic (please also refer to Portfolio Performance Table for other statistics of portfolio performance).


Guide

Name
Image/Description
Portfolio

Select a portfolio of interest.

Benchmark

Select a benchmark (of which its summary statistics are shown, and against which the portfolio is compared).

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 portfolio 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 portfolio statistics.Numerical Value2.1
CommentsUseful for documentation purposes or for settings description.Text-


Output

Name
Description
Formula
Mean RAverage of monthly returns.(R1+R2+ R3+...RN) / N
Std Dev (%)Root-mean-square of deviations from the mean (for monthly data).sqrt(((R1 – M)2 + (R2 – M)2 + … + (RN – M)2) / (N-1))
Annualised Std Dev (%)Annualised standard deviation.Std Dev* sqrt(12)
Downside Dev (%)Root-mean-square of excess returns only for underperforming months (where return < risk-free rate).sqrt((D12 + D22 + … + DN2) / N) ,
where Di = min(Ri – Rfr, 0)
Max DD (%)Max Drawdown: largest historical percentage decline in value (from peak to trough).max((VAMIj – VAMIi ) / VAMIi) *100%,
where j > i
Winning MonthsNumber of months with positive returns.count(i), where Ri ≥ 0
Losing MonthsNumber of months with negative returns.count(i), where Ri < 0
Average Monthly Gain (%)Average gain in winning months.(W1 + W2 + W3 + … WN) / Winning Months, where Wi = max(0,Ri)
Average Monthly Loss (%)Average loss in losing months.(L1 + L2 + L3 + … LN) / Losing Months,
where Li = min(0,Ri)
Sharpe RatioRatio of excess return (above the risk-free rate) to standard deviation; a risk-adjusted measure of return.(M - Rfr) / Std Dev
Sortino RatioRatio of excess compounded monthly return to downside deviation; a modified risk-adjusted return accounting only for downside risk.(Compounded Monthly Return - Rfr) / Downside Dev
Clamar RatioRatio of compounded annual return to maximum drawdown; yet another measure of risk-adjusted return.Compounded Annual Return / Max DD
Formula Symbols:
R = Return
N = Number of months
M = Mean return
Rfr = Risk-free rate
VAMI = Value-Added Monthly Index = Amount in the portfolio for a given month assuming an initial investment of $1000

Example

Functionality

Please refer to Table Settings for table functionalities.




Click to access: