In order to reduce the impact of outliers in daily fluctuations of financial markets, many financial products use simple or compounded averages of a given reference rate. For instance, on every business day the New York Federal Reserve Bank publishes the average rate of the Secured Overnight Financing Rate, compounded over the last 30 calendar days under the name of SOFR30.
Here, we present the methodology of compounded rates that is used by large banks such as the New York Federal Reserve Bank (compounded SOFR) and the Bank of England (compounded SONIA).
Consider a unit investment over a time period of calendar days containing business days. Let be an interest rate that is published once every business day and assume that the business day convention is such that the year has days. Then, the compounded gain over the whole interest period results to
We remark that for constant interest rates and this simplifies to the well-known compounded gain formula . However, in general, the rate factor is an integer value that accounts for being a business day or a non-business day. More precisely, if is a business day followed by non-business days, we set . For instance, if is followed by a business day, i.e., , we have . For a friday, which is usually followed by two non-business days, we would have . Now, in order to get the average interest from the compounded gain , we subtract the original investment and normalize, thus obtaining
which is the formulation of compounded rates used by the FED and the BOE amongst others.
Sources: https://www.newyorkfed.org/medialibrary/Microsites/arrc/files/2019/Users_Guide_to_SOFR.pdf https://www.bankofengland.co.uk/paper/2020/supporting-risk-free-rate-transition-through-the-provision-of-compounded-sonia
Link to API documentation: https://docs.diadata.org/documentation/api-1/api-endpoints#compounded-average
The methodology from the previous section has a special feature in that it mixes compounded and non-compounded rates. More precisely, investments are not compounded for weekends and holidays. This behaviour is reflected in the rate factor . In the Index presented below, investments are compounded over all calendar days in the respective interest period.
Consider a unit investment over a time period of calendar days. Let be an interest rate that is published once every business day and assume that the business day convention is such that the year has days. We define an interest rate such that coincides with on business days and is set to the rate of the previous business day if is a holiday or a weekend. In this straightforward manner we obtain an interest rate for all calendar days and can now set
Link to API documentation: Coming soon!