Here is the simple AFL code to compute the 10 year rolling returns for any script. Generally Rolling Returns are computed for 3yr, 5yr, 10yr period. Rolling Returns are basically a performance measure of fund/index/stock over a period of time. Above chart shows current 10 year rolling returns of Nifty at 7.47%.
Rolling Returns are nothing but computation of Historical CAGR. Formula for calculation of CAGR is shown below.
CAGR = [(Ending Price ÷ Beginning Price)^1/n] – 1
where CAGR – Compound Annual Growth Rate
where “n” is the number of time periods (10 years for this example)
Note : To Compute 10 Year Rolling Returns historical data of 10+ years adjusted to split/bonus is required in case of stocks.
Here is the AFL code to compute 10 Year Rolling Returns. Code is designed to adapt to multiple timeframes like Daily, Weekly, Monthly however it is recommended to use weekly/monthly for better accuracy.
Amibroker AFL Code – 10 Year Rolling Returns
Related Readings and Observations
Absolute Monthly and Yearly Profit/Loss Table – Amibroker AFL Code while back-testing by default Amibroker provides Profit Table in Compounded percentage terms. However the profit table can be customized according to ones requirement. Rather than doing a […]- Introduction to Backtesting a Trading System using Amibroker Backtesting is a simple process which helps a trader to evaluate his trading ideas and provides information about how good the trading system performs on the given historical dataset. It […]
- Kalman Filter and Unscented Kalman Filter AFL in Amibroker using Python ComServer In the last tutorial we explored Kalman filter and how to build kalman filter using pykalman python library. In this section we will be dealing with python com server to integrate […]
- Supertrend Multi Timeframe Based Trading System – Amibroker AFL Code Here is the first prototype from Marketcalls which demonstrates multi-timeframe based trading system which compares two timeframes (5min and hourly in this case) and takes a trade decision […]
- Hull ROAR – Rate of Annual Return Amibroker AFL Code Hull ROAR indicator helps in identifying the fastest raising shares and filters it out of the fastest rising shares. Hull ROAR is the brainchild of Alan Hull (author of active investing). […]
- First 1 Hour Cumulative Volume Scanner – Amibroker Exploration AFL Code Here is the simple prototype for finding first 1 hour cumulative volume for a given script. This helps one to visualize how the volume in the first 1 hour compare to previous trading days.
i added in ami formula but blank chart… why ?
Make sure you have 10 years+ historical data to get 10 Years rolling returns.
i’m using amibroker 4.80 & have data sinse 2003.
but getting error in Afl program writer ” Ln: 2, Col: 8 : error 30. Syntax error”
It is recommended to test with 5.5 version or above as some of the functions in the afl might not be compatible with older versions.