NexusFi: Find Your Edge


Home Menu

 





Accurate CL continuous back-adjusted chart


Discussion in Commodities

Updated
      Top Posters
    1. looks_one Fat Tails with 4 posts (10 thanks)
    2. looks_two lperepol with 2 posts (2 thanks)
    3. looks_3 Snoop with 2 posts (0 thanks)
    4. looks_4 neko333 with 2 posts (1 thanks)
    1. trending_up 11,175 views
    2. thumb_up 13 thanks given
    3. group 5 followers
    1. forum 11 posts
    2. attach_file 5 attachments




 
Search this Thread

Accurate CL continuous back-adjusted chart

  #1 (permalink)
 
neko333's Avatar
 neko333 
Hawaii
 
Experience: None
Platform: NinjaTrader
Broker: CQG
Trading: GC, CL, NG
Posts: 82 since Aug 2010
Thanks Given: 103
Thanks Received: 33

I`d like to confirm if my Daily CL back-adjusted chart is correct.

If you are POSITIVE your CL continuous adjusted chart is accurate please post an image so I can compare.

Also, really prefer its an RTH only Daily back-adjusted. If your platform does not have that option no big deal.

Been trying to confirm this way too long. Hope someone here really knows what they are doing with the CL.

Thanks for helping.

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Futures True Range Report
The Elite Circle
ZombieSqueeze
Platforms and Indicators
Deepmoney LLM
Elite Quantitative GenAI/LLM
NexusFi Journal Challenge - April 2024
Feedback and Announcements
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
 
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
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
Battlestations: Show us your trading desks!
26 thanks
The Program
18 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


Hi neko333,

I am afraid that your question cannot be answered. There is no correct way to backadjust futures. There are only various methods to backadjustment, and which you take really depends on what you want to use it for.

Rollover

Rollover date is the date, when you want to exit your position of the old front month contract and enter a position of the following liquid contract. For financial futures, rollover dates are more or less fixed by the exchange, for commodities that are physically traded this is not the case. So the optimum rollover date needs to be selected by the trader and there is no general rule.

For crude oil there are often physical shortages leading to a squeeze of old shorts, or oversupplies, leading to desperate longs in the old contracts who do not want to rent the storage space in Cushing, Oklahoma. For sure large traders who also have physical positions in crude play this game at their advantage.

So at a retail trader, you will want to run away early from the old contract, and not runing the risk that your position goes against you with increasing cost for rolling it.

Data

There is no rule that the offsets are calculated on rollover date. This works fine for financial futures, but is not necessarily wise for crude oil. So what are the options to build continous contracts? You can either

- backadjust them
- forwardadjust them (rather unusual)
- continously adjust the price series over time (perpetual)

The backadjusted contract is possibly the best solution to simulate real trading and backtesting. The backadjustment simulates the rolling over of your position, so in a backtest you would just need to add the transaction cost and slippage for a round turn. A perpetual contract would distort your backtesting, as it ignores the rollover cost.

A correct backadjusting for CL does not exist, as there are several options available. What you can do, is to find out, how other well reputated data vendors tackle this problem. Let us try.


Data Vendors

CSI Data

They do not make the decision for you. Up to you to select what you like. You can select roll trigger (openinterest, volume, both open interest and volume, date, days before expiration)

[COLOR=#810081]Unfair Advantage[/COLOR]

CQG

Same approach as CSI Data.

Pinnacle Data

They roll CL on the 11th of the month prior to delivery month. This is prior to volume rollover. By choosing an early date they avoid the erroneous volatility during the last days. Source is here: PINNACLE DATA PRODUCTS - Continuously Linked Commodity [AUTOLINK]Contracts[/AUTOLINK] - CLC Database

Nadex

This is a private company offering products similar to CFDs. I am not recommending them here, but just want to point to their rollover schedule.

https://www.nadex.com/content/files/futures_schedule_20100317.pdf


Rule of Thumb

Rollover is on the 5th business day prior to the 25th calendar day of each month.

Attached Thumbnails
Accurate CL continuous back-adjusted chart-backadjusting-futures.pdf  
Reply With Quote
  #4 (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

This is an article showing the real problem of WTI rollover. The choice of the delivery loaction in Cushing Oklahoma leads to a significant distortion in the prices of the front month contracts.

[COLOR=#0000ff]http://ftalphaville.ft.com/blog/2008/12/08/50144/profiting-from-a-contango-not-so-easy/[/COLOR]
FT Alphaville Rollover, rollover WTI
FT Alphaville It’s all about Cushing

(1) Usually Cushing is full and cannot take delivery. That means that the longs are pressed to get rid of their contracts. This nearly always creates a significant contango situation between the front month and the following month. If you compare the roll returns between WTI and Brent, the difference was -22% in 2009.

(2) Occasionally there is a shortage in Cushing - mostly due to technical reasons such as pipeline maintenance - and then there is an awful short squeeze.

To summarize: CL is a stupid and useless contract that should have been replaced since long.


Backadjusting CL

If you backadjust CL, you will have this distortion built into your contract. Because of that permanent contango situation for the front month, the offsets are oversized, and if you go back long enough, you may even find negative prices in your contract. So a longer term trader would better not backadjust the contracts, but use perpetuals.

The situation also affects long only investments funds. As they have to bear the negative return on rollovers, the return of the funds will be ways below the increase in commodities prices. Some of the funds already use back months instead of the front month to minimize the impact of the Cushing Contango.

For a short term trader, this is no problem. If you only need the current and the last contract's data, you can easily use the backadjusted contract with the standard offset that compensates for the contango.


I attach another document for your information that compares the ICE and NYMEX crude oil contracts from a very subjective point of view.

Attached Thumbnails
Accurate CL continuous back-adjusted chart-4122_4064_ice_presentation.pdf  
Reply With Quote
Thanked by:
  #5 (permalink)
 
neko333's Avatar
 neko333 
Hawaii
 
Experience: None
Platform: NinjaTrader
Broker: CQG
Trading: GC, CL, NG
Posts: 82 since Aug 2010
Thanks Given: 103
Thanks Received: 33

Jeez, what a nightmare. Thanks for more explanations Fat Tails. I`ve only been day trading the CL but I still need an accurate composite chart and now I understand why everyones usually looks so different.

I`m just going to give up the good ole CL and stick with the ES/TF at this point. I know my composites are spot on there. Our of curiosity what are your day trade markets of choice?

Started this thread Reply With Quote
  #6 (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


neko333 View Post
Jeez, what a nightmare. Thanks for more explanations Fat Tails. I`ve only been day trading the CL but I still need an accurate composite chart and now I understand why everyones usually looks so different.

I`m just going to give up the good ole CL and stick with the ES/TF at this point. I know my composites are spot on there. Our of curiosity what are your day trade markets of choice?


To answer your question: My favourites are TF, 6E and FDAX.

Every market has its own character driven by the behaviour of specialists, and CL is a particular story. You would want to pay attention to supply/demand situation of the physical market, to the US-$ Index, inventories and EIA reports, the European Session. I am working through some of the methods used by floor traders right now.

CL is extremely volatile, at least you get a lot of volatility for your commissions.

Reply With Quote
Thanked by:
  #7 (permalink)
 
davidfa's Avatar
 davidfa 
Barcelona / Spain
 
Experience: Intermediate
Platform: NT
Broker: ZenFire
Trading: CL
Posts: 118 since Feb 2010
Thanks Given: 366
Thanks Received: 148


neko333 View Post
I`d like to confirm if my Daily CL back-adjusted chart is correct.

If you are POSITIVE your CL continuous adjusted chart is accurate please post an image so I can compare.

Also, really prefer its an RTH only Daily back-adjusted. If your platform does not have that option no big deal.

Been trying to confirm this way too long. Hope someone here really knows what they are doing with the CL.

Thanks for helping.

Hi neko333,
I do use a backadjusted version of CL continuous contract available from spanish site www.visualchart.com
In fact u have to locally install the free software, have a free end-of-day connection login and then connect and you can export historical chart data to text.
After that, the structure of the exported file has to be changed to suit NT needs, replacing the separator char and deleting 3 columns of data. Then you have a ready to import up to date historical file for NT.
Don't know about the backadjusting details nor rollover process used for that.

It suits my needs for bigger timeframe charting. Attached is the text file with continuous CL historical daily data from year 2000.
Let us know any comparison results with other sources.

Attached Files
Elite Membership required to download: CL ##-##.zip
Visit my NexusFi Trade Journal 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

I have used VisualChart IV, but since they switched to VisualChart V I have more or less abandoned. Still have it installed, but rarely use it, because it is the user unfriendliest charting program that I have ever encountered.

Below you can see a backadjusted chart created with NinjaTrader / Kinetick and a continous CL chart created with Visual Chart.

Backadjusted (NinjaTrader)

CL is monthly rolled, and because of the notorious Cushing contango the old contracts are artificially raised to match the new front month at rollover date.

Advantage: The chart reflects exactly your trading results, so it can be used for backtesting, if you assume that you roll your position - if any - on rollover date. Also it leaves the proportion of all the moves intact, so it can be used for Fibonacci analysis.

Inconvenient: You cannot read from this chart the absolute levels of support and resistance.

Perpetual (VisualChart)

I believe that the chart from VisualChart shows a perpetual futures contract, which is pro-rata taken from several contracts.

Advantage: The chart correctly identifies support and resistance levels. You also can apply trendline and some indicators to analyze it. It best reflects the price action of the underlying commodity.

Inconvenient: Perpetual contracts are not tradeable, that is they do not reflect trading results. In particular if you had a long position over the last 8 months you would have needed to roll it 8 times, if you were holding your position in the front month. The merge backadjusted chart correctly shows the losses for the longs or the profits of the shorts, although crude was rangbound during this period. No fun for long only funds. I guess some of these have switched to back months or physical positions now, to reduce their rollover cost.

Attached Thumbnails
Click image for larger version

Name:	CL BackAdjusted Chart.jpg
Views:	352
Size:	104.6 KB
ID:	19504   Click image for larger version

Name:	CL Perpetual Chart.jpg
Views:	358
Size:	231.5 KB
ID:	19505  
Reply With Quote
  #9 (permalink)
 
Snoop's Avatar
 Snoop 
Toronto, Ontario
 
Experience: Advanced
Platform: NinjaTrader, Multicharts
Broker: IB, IQfeed
Trading: ES, CL
Posts: 203 since Oct 2009
Thanks Given: 135
Thanks Received: 165

I'm looking at purchasing historical futures data - specifically looking for deep history on CL, HG and the grains.

I see pinnacle and CSI offer similar packages. Does anyone have experience or preference for one service over the other?

Reply With Quote
  #10 (permalink)
lperepol
Castlegar, B.C. Canada
 
Posts: 3 since Nov 2010
Thanks Given: 0
Thanks Received: 4



Snoop View Post
I'm looking at purchasing historical futures data - specifically looking for deep history on CL, HG and the grains.

I see pinnacle and CSI offer similar packages. Does anyone have experience or preference for one service over the other?

I use both CSI and CRB. I prefer CRB. However, CRB does not have as many back adjusting options as CSI.

Reply With Quote
Thanked by:




Last Updated on November 18, 2010


© 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