NexusFi: Find Your Edge


Home Menu

 





Calculating Ratio-Adjusted Data (RAD)


Discussion in Commodities

Updated
      Top Posters
    1. looks_one Fat Tails with 6 posts (4 thanks)
    2. looks_two whipsaw with 4 posts (0 thanks)
    3. looks_3 OKshunalTrader with 3 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 7,165 views
    2. thumb_up 5 thanks given
    3. group 4 followers
    1. forum 14 posts
    2. attach_file 0 attachments




 
Search this Thread

Calculating Ratio-Adjusted Data (RAD)

  #1 (permalink)
 
OKshunalTrader's Avatar
 OKshunalTrader 
Bakersfield, CA USA
 
Experience: Intermediate
Platform: Sierra Chart
Trading: Bonds, YM
Posts: 271 since Sep 2013
Thanks Given: 255
Thanks Received: 146

In his Book, Trading Strategies That Work, Thomas Stridsman recommends Ratio-Adjusted Data (RAD) for Commodity Futures. I can see where it may be important, especially in commodities that have appreciated over time and when using data from many years back. I am starting to work some of my own examples to investigate his methods.
His formula is:
cinew = ciold * (1 + (C – c)/C)

where:
cinew = The new price i bars ago
ciold = The old price i bars ago
C = The close of the new contract on the day of the roll
c = The close of the old contract on the day of the roll

Unless I am doing something wrong, I was expecting the adjusted new closing price to coincide with the old closing price. Otherwise there will be an inherent discontinuity, albeit a small one.

Why would I not just use:

cinew = ciold * C/c
?

Also, are the OPEN, HIGH, and LOW also adjusted using the CLOSE rather than their respective New OPEN, HIGH, and LOW values?

Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Exit Strategy
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
ZombieSqueeze
Platforms and Indicators
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #3 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102


With the terminology used by Thomas Stridsman

c = close of the old contract
C = close of the new contract
gap = C - c

The idea of both backadjusted and ratio-adjusted data is to eliminate the gap by adjusting the old contract to the level of the new contract. As you have correctly noticed this is not achieved with the formula put forward in the book by Thomas Stridsman.

I think that it is a simple typo, because if you replace the denominator "C" (upper case) with "c" (lower case), the formula becomes

cinew = ciold * (1 + (C – c)/c) = ciold * (C / c)

which would be correct and match your suggestion.

For open, high and low the same ratio is used. Otherwise you would create artificial gaps on your chart between two consecutive bars.

Ratio-adjusted data is very unusual. I have never used it. Also I would prefer a perpetual contract to ratio adjusted data, as the ratio adjusting does not solve the major problem of backadjusted contracts, which is that they diverge from real price, if you go far back in the future. Moreover ratio adjusted data cannot be used for backtesting, whereas simple backadjusted data is fit for this purpose.

Reply With Quote
Thanked by:
  #4 (permalink)
 
OKshunalTrader's Avatar
 OKshunalTrader 
Bakersfield, CA USA
 
Experience: Intermediate
Platform: Sierra Chart
Trading: Bonds, YM
Posts: 271 since Sep 2013
Thanks Given: 255
Thanks Received: 146

Thank-you for your response. I am sure you are right about the typo. I did look for an errata from McGraw-Hill but could not find one. It helps to have confirmation.


Fat Tails View Post

Ratio-adjusted data is very unusual. I have never used it. Also I would prefer a perpetual contract to ratio adjusted data, as the ratio adjusting does not solve the major problem of backadjusted contracts, which is that they diverge from real price, if you go far back in the future. Moreover ratio adjusted data cannot be used for backtesting, whereas simple backadjusted data is fit for this purpose.

I am glad you responded with the above also. I believe I have read one of your previous posts stating Ratio-adjusted data could not be used for backtesting. While I am not the authority, Stridsman argues that Point-adjusted data is okay for backtesting if you want to see how much you would have gained (lost) trading you system in the past. However, if you want to see how you system would fare in today's dollars, systems should be tested using percentages and multiplied by today's dollar value. He argues correcting to today's dollars is more appropriate.

However, as I write this I think the same thing can be accomplished by outputting in percentages (without proportioning) then converting to today's dollars for especially for contracts that have had considerable appreciation. (NT7 has that option). The sum of the gaps will be minimal compared to say the upward bias of an index over the years.

Thanks again, and I would appreciate any more of your thoughts.

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #5 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102


OKshunalTrader View Post
Thank-you for your response. I am sure you are right about the typo. I did look for an errata from McGraw-Hill but could not find one. It helps to have confirmation.



I am glad you responded with the above also. I believe I have read one of your previous posts stating Ratio-adjusted data could not be used for backtesting. While I am not the authority, Stridsman argues that Point-adjusted data is okay for backtesting if you want to see how much you would have gained (lost) trading you system in the past. However, if you want to see how you system would fare in today's dollars, systems should be tested using percentages and multiplied by today's dollar value. He argues correcting to today's dollars is more appropriate.

However, as I write this I think the same thing can be accomplished by outputting in percentages (without proportioning) then converting to today's dollars for especially for contracts that have had considerable appreciation. (NT7 has that option). The sum of the gaps will be minimal compared to say the upward bias of an index over the years.

Thanks again, and I would appreciate any more of your thoughts.

Ratioadjusted and perpetual contracts falsify the outcome of individual trades. This cannot be corrected afterwards, therefore you will never obtain an accurate backtest.

Standard backadjusted data does not modify the outcome of any single trade and takes into account the rollover gain / loss without the spread. Non-adjusted data is best for backtesting, but you need to close out every position on rollover date and reenter a position for the new front month.

If you make an analysis of historical trades in terms of returns and not in terms of absolute gains, then those results can be applied to today's markets.

Reply With Quote
Thanked by:
  #6 (permalink)
 
OKshunalTrader's Avatar
 OKshunalTrader 
Bakersfield, CA USA
 
Experience: Intermediate
Platform: Sierra Chart
Trading: Bonds, YM
Posts: 271 since Sep 2013
Thanks Given: 255
Thanks Received: 146

Thanks for the details. I found the thread below where you patiently continued to answer similar questions.

continuous contract in NT7 /merge policy / rollover
Old February 12th, 2011, 09:39 AM
https://nexusfi.com/newreply.php?do=newreply&noquote=1&p=378420

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #7 (permalink)
whipsaw
Phoenix, AZ/USA
 
Posts: 4 since Nov 2009
Thanks Given: 0
Thanks Received: 0

I use ratio-adjusted because I am interested in knowing the average % gain/loss of my trades and translating them into today's dollars. With a RAD backtest the profit factor, average trade % gain/loss, and other ratios are accurate. I could care less about the dollars made, because as Stridsman points out the sequence of trades will not occur in the same order as in the back test again.

Reply With Quote
  #8 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102


whipsaw View Post
I use ratio-adjusted because I am interested in knowing the average % gain/loss of my trades and translating them into today's dollars. With a RAD backtest the profit factor, average trade % gain/loss, and other ratios are accurate. I could care less about the dollars made, because as Stridsman points out the sequence of trades will not occur in the same order as in the back test again.

You cannot calculate the exact average gain/loss from ratio-adjusted data. All ratios are more or less inaccurate. The reason is that returns are either skewed to the upside or downside with ratio-adjusted data.

Which data ist best used depends on the time frame. As a short term trader, it is best to use backadjusted or non-adjsuted data (the latter needs separate accounting for rollover gaps). As a long term investor perpetual contract data is best.

I do not see how ratio-adjusted data can improve the backtest, as all results are distorted.

Reply With Quote
  #9 (permalink)
whipsaw
Phoenix, AZ/USA
 
Posts: 4 since Nov 2009
Thanks Given: 0
Thanks Received: 0

I'm sorry I don't understand what you mean when you say "You cannot calculate the exact average gain/loss from ratio-adjusted data. All ratios are more or less inaccurate". Why not? I thought that is the whole point of RAD contracts? They maintain the percent difference between the contracts at rollover, not the point differences.

To be clear I'm talking about the RAD contracts from Pinnacle Data.

Reply With Quote
  #10 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,102



whipsaw View Post
I'm sorry I don't understand what you mean when you say "You cannot calculate the exact average gain/loss from ratio-adjusted data. All ratios are more or less inaccurate". Why not? I thought that is the whole point of RAD contracts? They maintain the percent difference between the contracts at rollover, not the point differences.

To be clear I'm talking about the RAD contracts from Pinnacle Data.


@whipsaw: Then let us calculate your ratios with both standard backadjusted and ratio-adjusted data and discuss the outcome! It is enough to perform the calculation for a single trade that covers several contracts.

-> Would you have a sample trade that we can discuss?

-> Which ratios do you wish to calculate?

Reply With Quote




Last Updated on February 20, 2014


© 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