Performance metrics comparison

Financial Analytics in Google Sheets

David Ardia

Professor in Quantitative Methods for Finance

Sharpe and Sortino ratios

  • Benchmarking through Sharpe and Sortino ratios:

$$Sharpe\,\,ratio = \frac{m_G - r_f}{sd}\quad\quad Sortino\,\,ratio = \frac{m_G - r_f}{smd}$$

        $m_G$: the effective rate of return

        $r_f$: the risk-free rate

        $sd$: the volatility of the returns

        $smd$: the semideviation of the returns

  • You want both metrics to be higher than the ones of the benchmark
Financial Analytics in Google Sheets

Maximum drawdown

  • Drawndown: Peak-to-trough decline of the value of the investment
  • Quoted as a percentage of the peak value

Financial Analytics in Google Sheets

Capital preservation

  • Capital preservation is crucial for investors

  • A drawdown of 50% is dangerous for capital preservation!
Financial Analytics in Google Sheets

Metric of capital preservation

  • Maximum drawdown: Metric of capital preservation in your analysis

Financial Analytics in Google Sheets

Metric of capital preservation

Financial Analytics in Google Sheets

Drawdowns with Google Sheets

Financial Analytics in Google Sheets

Drawdowns with Google Sheets

Financial Analytics in Google Sheets

Drawdowns with Google Sheets

Financial Analytics in Google Sheets

Maximum drawdowns with Google Sheets

Financial Analytics in Google Sheets

It's time to practice!

Financial Analytics in Google Sheets

Preparing Video For Download...