Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
2. how to interpret them
They can be interpreted in many different ways. For example the chart you are linking shows the 18-30-42 fly (which is 12 month fly) versus the 18-42 spread. The 18-42 spread is a measure of curve steepness, but a curve's shape isn't linear, it's normally* logarithmic (for contango and -logarithmic for backwardation). As such this chart is showing that the butterfly was a lot cheaper than it had been historically given the current value of 18-42
* The forward curve is currently a rare M shape.
3. and sourcing the data?
I use Morningstar's Commodity Data Excel Add-In. Not cheap but makes analysis like this very easy.
All I need is the name of a textbook, a paper or author, or a hint
All done in excel. If you plot the forward curve/spread curve/fly curve etc, you'll quickly see some quirks in the shape of the curve. Then just dig deeper looking for statistical anomalies. It's a lot of manual work, especially if your data isn't in a friendly format, which is why I have a lot of this automated.
I just use settlement data. I'd be careful using T&S as it's rare that all the legs will trade at the same time. I used to do analysis of spreads/flys/structures vs time (days to expiry in this case) AND structure vs structure seperately. Now most of my analysis is multidimensional where I'm looking at "structure vs structure vs time". I find 'R' very useful for that.
I read through the thread on the weekend and learnt quite a lot about crude and trading the curve. There's still a lot of gaps in my understanding but thats' ok..
I guess the most important question is: what is roughly the largest draw-down for a singe trade in ticks/cents before you decide to exit? ... or roughly how far bellow the scatter-plot or curve would you exit?
What do i get from this?
a) 1 month less volatile than 3 month and 3 month less than 6 month etc
b) for the same type of spread (comparing 6 month Dec calendars between 17,18 and 19), farther you go out, its less volatile i.e 2018 less volatile than 2017 (which is this year)
Note: for the 12 month calendars Z0 is higher vol.. something gonna happen then?? he he .. time to sleep
Can u not do multidimensional regression analysis with excel or is it just better in R
So if u have excel sheets automated with data coming in, though u can visualize comparitve curves I would think to truly identity an anamolies u have to do the regression and see the outliers either just structure or add in the time factor as well for each curve I.e. Calendars then flys then doubled flys to then see which type and month u want to trade
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,057 since Dec 2013
Thanks Given: 4,409
Thanks Received: 10,225
I don't have a hard rule for that. There's several things I do that are very different than most here. I don't manage individual trades, I manage everything on a portfolio process, and when it comes to mean reversion systems like this, the further you get from the mean (the more the trade goes against you) the more you add to your position. The biggest thing I do to control risk is to make sure I'm trading things that have time to revert to normality, and to avoid positions where fundamentals could make the market do something I was not expecting. Most of my models/portfolio's do have a risk scaling factor though, so by adjusting that factor I can decrease (or increase) my position sizing.
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,057 since Dec 2013
Thanks Given: 4,409
Thanks Received: 10,225
Std deviation of what? Absolute prices or price changes? (Textbooks will tell you to use log changes but that doesn't work with spreads where prices can and do go negative.)
While I agree with you, I would offer a word of warning that if your looking at settlements in months 48(ish) and back they can be 'stale' for lack of a better word. As an extreme example the z24/z25 spread settled -45 last night (and has done for several months) despite the quoted market being -78/-55 for several weeks. This is because settlements back there appear to only get updated when a trades happen.
Yes easy to do in Excel as well. Once you have your data source, and your model setup, it's easier to run multiple different scenario's in R, where as in Excel you would have to set your data up every time.
I analyze historical prices and build models which I then run against real time prices, so I'm not actually running real time regressions.
As we go farther and farther, i think exchange spread volume is very thin to non existent
Reason i did this is to ask a few questions
a) As we create our model do we need to include exchange prices where available and then include synthetic prices after that so we can get more data points.
B) Columns for the spreadsheet:
we know for calendars it will be 2 contracts per year x say 5 years = 10 columns for calendars
For flys would it be
m17/z17-z17/m18
then
z17/m18-m18/z18
then
m18/z18-z18/m19
then
z18/m19-m19/z19
Then we can
a) graph the structure of the calendars vs structure of the flys vs structure of the outrights (leave double flys out for now)
b) Do the same as above but comparing change between today and yesterday
c) Take the last 100 days of data for each column and run a scatter plot for
(i) All the calendars vs time
(ii) All the flys vs time
(iii) All the calendars and flys vs time.. hmm - does this make sense?
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,057 since Dec 2013
Thanks Given: 4,409
Thanks Received: 10,225
Not sure when the attachment was taken but liquidity is higher than that.
As I've said before ZM or MZ front 6 spreads have liquidity, and ZZ front 4 or 5. Outside of that it's very illiquid.
I build z curve first. Then build a Z and M curve next.
It's difficult to build, and also impossible to trade at value, a monthly curve past the prompt 24.
Here is the Crude spreads for 21 days (bar close value)
1. First few columns are outrights.
2. Columns labeled 1 through 7 are calendars - to show column 1 and 2 are the same (difference is prob how the software calculates last from exchange symbol vs the spread bid/ask) - curve chart below
3. 12 month flys and curve below