Index One's Solutions Overview
  • 👋Welcome to Index One's Solutions Overview
  • Overview
    • 💡What we do
    • ✨Our Features
  • Product Guides
    • 🛠️Index Construction
      • 📪Universe, Weighting and Specifications
      • 📪Drag functionality
      • 📪Index Universe
      • 📪How to upload a custom basket
      • 📪How to build an index
      • 📪How to use custom code to build an index
    • 🛠️Index Maintenance
      • 📪Rebalancing a basket index
      • 📪Set up delivery of a tracker file or weighting file
      • 📪Download index values from a live index page
      • 📪Set up S3 data retrieval
    • 📎Reference Data
      • ⚙️Attributes and Filters
      • 📍Symbol Mapping
      • 🌏Country Codes
      • 🔢Formulas and Calculations
    • 🔗Integrations
      • 📪How to embed index data on your website
      • 📪How to integrate index data on Alphathena
Powered by GitBook
On this page
  • Volatility
  • Sharpe ratio
  • Definitions of Variables
  • Sortino ratio
  • Definitions of Variables
  • Maximum Drawdown
  • Rate of return
  • Annualized Return
  • Definitions of Variables
  1. Product Guides
  2. Reference Data

Formulas and Calculations

How does Index One calculate volatility, sharpe ratio, sortino ratio, max drawdowns and returns?

PreviousCountry CodesNextIntegrations

Last updated 6 months ago

Volatility

The volatility of daily log returns is calculated as the standard deviation of the log returns. Volatility is "annualized" unless specified otherwise. Number of trading days for the index is typically 252.

𝜎=1n−1∑t=2n(ln⁡(PtPt−1)−μR)2𝜎=\sqrt{\tfrac{1}{n-1}\displaystyle\sum_{t=2}^n(\ln(\tfrac{P_t}{P_t-1})-\mu_R)^2}𝜎=n−11​t=2∑n​(ln(Pt​−1Pt​​)−μR​)2​

Where:

  • σ = Volatility (standard deviation of log returns).

  • Pt = Index value on day t.

  • Rt=ln⁡(Pt/Pt−1) = Log return on day t.

  • μR​ = Mean of the log returns.

  • n = Total number of days.

  • Annualized Volatility (𝜎annual):

𝜎annual=N.𝜎daily𝜎annual=\sqrt{N}.𝜎daily𝜎annual=N​.𝜎daily

Where:

  • 𝜎annual = Annualized volatility.

  • N = Number of trading days in a year.

  • 𝜎daily = Standard deviation of daily log returns.


Sharpe ratio

The Sharpe Ratio measures the excess return (above a risk-free rate) per unit of risk (volatility) for an investment.

For the Sharpe ratio, we assume the risk-free return is zero.

Definitions of Variables

  • Average Daily Log Return (R‾): The mean of the daily log returns is:

  • Risk-Free Rate (Rf): The daily risk-free rate is a constant, typically derived from annualized rates (e.g., from treasury bonds) and converted to a daily equivalent.

  • Volatility (σ): The annualized standard deviation of the daily log returns, refer to the Volatility definition for further details.


Sortino ratio

The Sortino ratio evaluates the risk-adjusted return of an investment, portfolio, or strategy.

For the Sortino ratio, we assume the risk-free return is zero.

Definitions of Variables

  • Risk-Free Return (Rf): The daily risk-free rate is a constant, typically derived from annualized rates (e.g., from treasury bonds) and converted to a daily equivalent.

  • Mean Daily Log Return (R‾): The average daily log return is:

  • Downside Deviation (σD): The downside deviation measures the variability of returns that fall below the Risk-Free Rate. It is calculated as:


Maximum Drawdown

Maximum Drawdown (MDD) measures the largest peak-to-trough decline in a portfolio's value over a given period, expressed as a percentage.

Given a sequence of daily index values P1, P2, ... Pt (where t represents the day or index number), the maximum drawdown is calculated as:

Where:

  • Pt: Value of the index at time t.

  • T: Total number of time periods.

  • max_1≤i≤tPi: The highest value of the index observed from the beginning of the period up to time t.

  • (P_t-max_1≤i≤tPi)/(max_1≤i≤tPi): The relative drawdown at time t, which is the percentage loss from the highest value observed up to time t.


Rate of return

The return measures the percentage change in the value of an investment over a given period. For daily index values, the return is calculated using the initial and final index values.

Where:

  • P1​: The initial index value (on the first day of the period).

  • Pn: The final index value (on the last day of the period).


Annualized Return

The annualized return converts the total return over a period into an equivalent yearly return, assuming compounding. It helps to compare returns over different time periods.

Definitions of Variables

  • Return: The total return over the entire period, calculated as:

  • T: The total number of days in the period.

  • 365: The number of days in a year, used for annualization.

S=R‾−Rf𝜎S = \tfrac{\overline{R}-R_f}{𝜎}S=𝜎R−Rf​​
R‾=1n−1∑t=2nln(PtPt−1)\overline{R}=\tfrac{1}{n-1}\displaystyle\sum_{t=2}^nln(\tfrac{P_t}{P_t-1})R=n−11​t=2∑n​ln(Pt​−1Pt​​)
S=R‾−Rf𝜎DS = \tfrac{\overline{R}-R_f}{𝜎_D}S=𝜎D​R−Rf​​
R‾=1n−1∑t=2nRt\overline{R}= \tfrac{1}{n-1}\displaystyle\sum_{t=2}^nR_tR=n−11​t=2∑n​Rt​
𝜎D=1n−1∑t=2mmax(0,Rf−Rt)2𝜎_D=\sqrt{\tfrac{1}{n-1}\displaystyle\sum_{t=2}^mmax(0,R_f-R_t)^2}𝜎D​=n−11​t=2∑m​max(0,Rf​−Rt​)2​
MDD=1≤t≤Tmax(Pt−maxt≤i≤tPimaxt≤i≤tPi)MDD = _{1\leq{t}\leq{T}}^{max}(\tfrac{P_t-max_{t\leq{i}\leq{t}}P_i}{max_{t\leq{i}\leq{t}}P_i})MDD=1≤t≤Tmax​(maxt≤i≤t​Pi​Pt​−maxt≤i≤t​Pi​​)
Return=PnP1−1Return=\tfrac{P_n}{P_1}-1Return=P1​Pn​​−1
AnnualizedReturns=(1+Return)365T−1AnnualizedReturns=(1+Return)^\tfrac{365}{T}-1AnnualizedReturns=(1+Return)T365​−1
Return=PnP1−1Return=\tfrac{P_n}{P_1}-1Return=P1​Pn​​−1
📎
🔢