How is the seasonality calculated? - futures io
futures io

How is the seasonality calculated?

Discussion in Options

      Top Posters
    1. looks_one cactus363 with 1 posts (0 thanks)
    2. looks_two xplorer with 1 posts (0 thanks)
    3. looks_3 strangler with 1 posts (1 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 1,120 views
    2. thumb_up 2 thanks given
    3. group 4 followers
    1. forum 5 posts
    2. attach_file 3 attachments

Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • 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 and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

Search this Thread

How is the seasonality calculated?

(login for full post details)
  #1 (permalink)
Experience: Beginner
Platform: TDAmeritrade
Trading: Options On Futures
Posts: 42 since Aug 2017
Thanks: 4 given, 10 received

Hi folks,

Just curious how the seasonality chart is calculated? I'd like to come out with my own.
Use crude as example, if I want to calculate the seasonality of December crude oil contract. What should I do? I downloaded the Dec-2017 data, and I found the contract actually started trading from 2008.
When I calculate 5 year seasonality, should I use the last 12 month data of Dec-2017, with last 12 month data of Dec-2016/2015/2014/2013 years, or something else?

Many thanks for your technical details. I will use excel to do this work. You inputs are highly appreciated.

Best Regards

Started this thread Reply With Quote

Journal Challenge April 2021 results (now extended!):
Competing for $1800 in prizes from Jigsaw
looks_oneMaking a Living with the Microsby sstheo
(82 thanks from 13 posts)
looks_twoSalao's Journalby Salao
(25 thanks from 6 posts)
looks_3Deetee’s DAX Trading Journal (time based)by Deetee
(25 thanks from 9 posts)
looks_4Learning to Profit - A journey in algorithms and optionsby Syntax
(12 thanks from 7 posts)
looks_5Maybe a little bit different journalby Malykubo
(7 thanks from 5 posts)
Best Threads (Most Thanked)
in the last 7 days on futures io
futures io site changelog and issues/problem reporting
76 thanks
The Crude Dude Oil Trading System
73 thanks
Would You Sell Your System?
71 thanks
FIO Journal Challenge - April 2021 w/Jigsaw Trading
35 thanks
Big Mike in Ecuador
31 thanks
(login for full post details)
  #3 (permalink)
Site Moderator
London UK
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
xplorer's Avatar
Posts: 5,346 since Sep 2015
Thanks: 13,472 given, 12,922 received

Possibly @myrrdin should be able to answer this.

Reply With Quote
(login for full post details)
  #4 (permalink)
Market Wizard
Linz Austria
Experience: Advanced
Platform: Zaner360, TWS, Vantage
Broker: DeCarley, IAB, RJO
Trading: Commodities
Posts: 1,783 since Nov 2014
Thanks: 2,930 given, 2,418 received

sinpeople View Post
When I calculate 5 year seasonality, should I use the last 12 month data of Dec-2017, with last 12 month data of Dec-2016/2015/2014/2013 years, or something else?

Yes, this is how you should procede.

I do not understand why you want to develop a system that can be bought at a reasonable price, if the quality of your system is not superior. And as you ask a very basic question I doubt you are able to beat the tools of MRCI or Seasonalgo.

Best regards, Myrrdin

Reply With Quote
The following user says Thank You to myrrdin for this post:
(login for full post details)
  #5 (permalink)
Haslemere, United Kingdom
Experience: Intermediate
Platform: Sierra Charts
Broker: CQG
Trading: CL,ES,NQ,KC
Posts: 7 since Oct 2013
Thanks: 7 given, 1 received

Rather than start a new topic I shall post my question here as its along the lines of the first question.

I am creating a seasonal indicator for the Sierra charts package and need help with the calculations too. Although seasonal charts are available on line and often free, I would prefer to have it displaying on my charting package.

I managed to get the same results as the MRCI website shows on their seasonality charts and my calculations are here to be viewed. the resulting chart is almost identical to MRCI's 5year seasonality of Crude oil chart. Here it is:

However, I would like to use a calculation like the one in Trading Navigators - Seasonal Trend indicator. Its a rolling seasonal index as far as I understand so that the value at 31 December = 1st January.
Here are two examples of it:

I'd appreciate any help as to the method and perhaps of an example of getting to a seasonal calculation like this.

Reply With Quote
(login for full post details)
  #6 (permalink)
calgary canada
Posts: 1 since Feb 2019
Thanks: 0 given, 1 received

If you're serious about measuring "seasonality", you have to use regression methods. This can be done by assigning "dummy" or "binary" variables to your datapoints.

I am not going to explain what regression, dummy/binary variables, or the millions of types of seasonality because it's too broad. You can do a simple dummy regression in excel if you are only looking at monthly seasonality (excel only let's you use up to 16 variables). The method to do this is fairly easily found using google, just search "binary dummy regression excel" or something.

Unfortunately, once you get the data to reflect seasonality and run a regression, interpreting the results takes more than just google searching and will likely take a lot of digging around for useful reference guides - unless you're already familiar with stats.

Studying seasonality and not including this type of study is like taking a soap box with rusty wheels to an F1 race.

Reply With Quote
The following user says Thank You to strangler for this post:

futures io Trading Community Traders Hideout Options > How is the seasonality calculated?

Last Updated on March 10, 2019

Upcoming Webinars and Events

NinjaTrader Indicator Challenge!


Journal Challenge w/$1,800 in prizes!


Seven Trading Mistakes Solved With Smart Trading Tools w/Brannigan Barrett

Elite only

Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432,
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.
no new posts