NexusFi: Find Your Edge


Home Menu

 





Properly calculate the return of different roll strategies


Discussion in Commodities

Updated
    1. trending_up 1,409 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread

Properly calculate the return of different roll strategies

  #1 (permalink)
thenoob
Maastricht/Netherlands
 
Posts: 2 since Jan 2015
Thanks Given: 0
Thanks Received: 0

I am interested in calculating the effect of the roll return using different roll strategies. In specific I want to mimic a long-only futures investments. I have historical data for several agricultural commodities. In order to compare the returns of the different roll strategies I created ratio back-adjusted time series using the following formula's.

Ratio adjustment = (Price new contract - Price old contract)/(Price old contract)
Adjusted prices = (all old futures * ratio adjustment) + Prices new contract

Since I use historical data ranging from the 80's to the end of 2014 there are multiple rolls. For every I make these adjustments (iterative process). So the latest contract is not adjusted while the first contract is adjusted tens of times (depending on the roll strategy). I want to know what the return of the various roll strategies are. Hence, I am not interested in the prices of the futures contracts itself (I realize that these get distorted by the ratio adjustment). Furthermore, since futures are traded on margin I will take a more academic approach and make the assumption that the futures are fully collateralized. Meaning that a 'x' dollar amount is invested in T-bills, where x is equal to the price of the futures contract. Hence I calculate the return of the roll strategies as follows:

Return = (new adjustment price - old adjustment price)/(old adjustment price) - (t-bill interest earned on amount x) * 100

However, I think I am making a mistake since the return on a soybean position is extraordinary. Somewhere in the 600% (when I do not consider the t-bill interest earned) over a time period from 1997 to 2014 when rolling on the last trading day. What am I missing? How should I calculate and compare the performance of the different roll strategies if this approach is wrong?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Deepmoney LLM
Elite Quantitative GenAI/LLM
Exit Strategy
NinjaTrader
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
38 thanks
NexusFi site changelog and issues/problem reporting
27 thanks
GFIs1 1 DAX trade per day journal
18 thanks
The Program
18 thanks
  #3 (permalink)
 
treydog999's Avatar
 treydog999 
seoul, Korea
 
Experience: Intermediate
Platform: Multicharts
Broker: CQG, DTN IQfeed
Trading: YM 6E
Posts: 897 since Jul 2012
Thanks Given: 291
Thanks Received: 1,039



thenoob View Post
I am interested in calculating the effect of the roll return using different roll strategies. In specific I want to mimic a long-only futures investments. I have historical data for several agricultural commodities. In order to compare the returns of the different roll strategies I created ratio back-adjusted time series using the following formula's.

Ratio adjustment = (Price new contract - Price old contract)/(Price old contract)
Adjusted prices = (all old futures * ratio adjustment) + Prices new contract

Since I use historical data ranging from the 80's to the end of 2014 there are multiple rolls. For every I make these adjustments (iterative process). So the latest contract is not adjusted while the first contract is adjusted tens of times (depending on the roll strategy). I want to know what the return of the various roll strategies are. Hence, I am not interested in the prices of the futures contracts itself (I realize that these get distorted by the ratio adjustment). Furthermore, since futures are traded on margin I will take a more academic approach and make the assumption that the futures are fully collateralized. Meaning that a 'x' dollar amount is invested in T-bills, where x is equal to the price of the futures contract. Hence I calculate the return of the roll strategies as follows:

Return = (new adjustment price - old adjustment price)/(old adjustment price) - (t-bill interest earned on amount x) * 100

However, I think I am making a mistake since the return on a soybean position is extraordinary. Somewhere in the 600% (when I do not consider the t-bill interest earned) over a time period from 1997 to 2014 when rolling on the last trading day. What am I missing? How should I calculate and compare the performance of the different roll strategies if this approach is wrong?

I do not think you can calculate returns on back adjusted contracts. Anything that uses a ratio or divides on a back adjusted contract just gets screwy. So you are right to think something is up.

Reply With Quote




Last Updated on January 24, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts