NexusFi: Find Your Edge


Home Menu

 





Problems with CL back-adjusted data


Discussion in Commodities

Updated
    1. trending_up 4,363 views
    2. thumb_up 6 thanks given
    3. group 2 followers
    1. forum 5 posts
    2. attach_file 0 attachments




 
Search this Thread

Problems with CL back-adjusted data

  #1 (permalink)
jjsshh
Helsinki, Finland
 
Posts: 23 since Dec 2013
Thanks Given: 14
Thanks Received: 4

Hello,
I'm using MC with IQfeed. I have had really bad problems with back-adjusted data for CL (QCL#C). I devenloped a daily system for CL and out-of sample results were significant. After I started to paper trade it I found out that the back adjusment does some crazy stuff for systems signals.

System gave me some signals in first month and the result were poor. After rollover and adjustment the system changed those historical signals and somehow those signals were much better. After couple of days i reloaded the data and again those signals were changed and back-testing result were totally different from the previous ones. The system works well in not back adjusted data but of course rollover caps are not included in it.

Does anyone else have similar problems and is there any solutions for this? Also do you prefer using back or nor back-adjusted data when trading commodities?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
What broker to use for trading palladium futures
Commodities
How to apply profiles
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
REcommedations for programming help
Sierra Chart
 
  #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,103



jjsshh View Post
Hello,
I'm using MC with IQfeed. I have had really bad problems with back-adjusted data for CL (QCL#C). I devenloped a daily system for CL and out-of sample results were significant. After I started to paper trade it I found out that the back adjusment does some crazy stuff for systems signals.

System gave me some signals in first month and the result were poor. After rollover and adjustment the system changed those historical signals and somehow those signals were much better. After couple of days i reloaded the data and again those signals were changed and back-testing result were totally different from the previous ones. The system works well in not back adjusted data but of course rollover caps are not included in it.

Does anyone else have similar problems and is there any solutions for this? Also do you prefer using back or nor back-adjusted data when trading commodities?

Please check whether your data is

- a continuous (perpetual) crude oil futures contract
- a backadjusted crude oil futures contract

With a backadjusted contract, the signals should not change (see exception below) and remain the same after rollover. With a continuous futures contract all pastsignals will be typically false.

Exception: Your trading system should only be based on relative prices (moving averages, oscillators, etc.) but not take into account absolute prices (such as round numbers). If it is based on absolute price, past signals will be false for both continuous and backadjusted data.

Reply With Quote
Thanked by:
  #4 (permalink)
jjsshh
Helsinki, Finland
 
Posts: 23 since Dec 2013
Thanks Given: 14
Thanks Received: 4

Thanks for your fast response,

Hopefully I get this right. I'm sure that my system is only using relative prices even thought rules are pretty complex. Also system is working similar as it was couple months ago with non back-adjusted data.

Now when I'm saying non back-adjusted data i'm referring IQfeed's continuous future contract QCL#. The back-adjusted continuous contract is QCL#C and that is the problem. I have found that IQfeed is doing the rollover adjustment as I though by adjusting previous month to the newest and in 2008 prices for this ticker were about 190 at the highest point ( i found out some of your older posts where you had found similar prices for merge back-adjusted data.) The problem should not be that either if I understand have understood something right.

Can you correct if I'm wrong:
1) continous non back-adjusted contract is just contract which doesn't adjust anything. Caps are where they should be and the price is always the price that the current contract was traded.

2)This is the thought one. Continuous(perpetual) contract is something that i don't really get even thought you explained it briefly in the earlier discussion. Hopefully this is not the same as 1).

3) back-adjusted continuous contract adjusts previous contracts values to the new one so the cap is eliminated.

This is really new topic for me and I haven't find similar problems with my earlier systems for instruments like NQ and ES. I think this is common for some commodities due to the physical delivering(bigger rollover caps).

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,103


jjsshh View Post
Thanks for your fast response,

Hopefully I get this right. I'm sure that my system is only using relative prices even thought rules are pretty complex. Also system is working similar as it was couple months ago with non back-adjusted data.

Now when I'm saying non back-adjusted data i'm referring IQfeed's continuous future contract QCL#. The back-adjusted continuous contract is QCL#C and that is the problem. I have found that IQfeed is doing the rollover adjustment as I though by adjusting previous month to the newest and in 2008 prices for this ticker were about 190 at the highest point ( i found out some of your older posts where you had found similar prices for merge back-adjusted data.) The problem should not be that either if I understand have understood something right.

Correct. The backadjusted contract should show prices as high as 190 for CL in 2008. This is due to the Cushing contango, which made it much more expensive for long-only funds to roll WTI futures compared to Brent futures.


jjsshh View Post
1) continous non back-adjusted contract is just contract which doesn't adjust anything. Caps are where they should be and the price is always the price that the current contract was traded.

There are 3 types of contracts:

- non-backadjusted: single month contracts with rollover gap on rollover day
- backajdusted: single month contracts with rollover gap removed, prior contracts aligned to current front month contract
- perpetual (continuous) contracts: typically prices calculated as a weighted average of two consecutive contracts, with a continuous adjustment of the weighting factor


jjsshh View Post
2)This is the thought one. Continuous(perpetual) contract is something that i don't really get even thought you explained it briefly in the earlier discussion. Hopefully this is not the same as 1).

For more information on perpetuals, read paper per link below:




jjsshh View Post
3) back-adjusted continuous contract adjusts previous contracts values to the new one so the cap is eliminated.

Correct. "The (rollover) gap is eliminated".

Reply With Quote
  #6 (permalink)
jjsshh
Helsinki, Finland
 
Posts: 23 since Dec 2013
Thanks Given: 14
Thanks Received: 4

Thanks for clarifying those things.

Reply With Quote




Last Updated on December 29, 2013


© 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