際際滷

際際滷Share a Scribd company logo
Continuous Future Series
Construction
Quant Team
Ruchi Agri-Trading
Singapore
May 03, 2013
Why Continuous Future Series?
 We require a continuous historical price series for
analysis or back-testing of trading strategies.
 One difficulty with the futures historical data is
associated with splicing contracts together at
contract boundaries.
 The results of any analysis will depend on the
method we choose to construct the data series.
Different types of Continuous Series
 Constant Month Series (S Nov1, etc.)
 Constant Distance / Rolling Nearby / N-th
Nearest Contract Series (S 1, BO2, etc.)
 Time to maturity weighted Series (Risk Metrics
linear interpolation approach)
 Volume/OI weighted Series
Next Nearby/Rolling Nearby
13.6
13.8
14
14.2
14.4
14.6
14.8
15
15.2
Next Nearby Series
S.X2
S.F3
Next.Nearby
Time to Maturity Weighted Series
(RiskMetrics Method)
An Example: Time to Maturity
Weighted Series
Dates
Contract Expiration
Number of Days to
Expiration
Weights (%) Actual Contract Prices
CMF
Price
NB1 1m CMF NB2 NB1
1m
CMF
NB2 爍燹材`爻 爍燹材`爻 燹酌ゞ燿燿 燹酌´燿燿 燹酌/燿燿 燹酌燿燿
2011-
07-11
07-14 08-10 08-12 3 30 32 0.10 0.90 13.5250 13.4650 13.4450 13.4710
2011-
07-12
07-14 08-11 08-12 2 30 31 0.07 0.93 13.6650 13.5550 13.5500 13.5623
2011-
07-13
07-14 08-12 08-12 1 30 30 0.03 0.97 13.8700 13.7475 13.7475 13.7516
2011-
07-14
07-14 08-15 08-12 0 30 29 0.00 1.00 13.9050 13.8200 13.7975 13.8200
2011-
07-15
08-12 08-15 09-14 28 30 61 0.93 0.07 - 13.8575 13.8300 13.8557
2011-
07-18
08-12 08-17 09-14 25 30 58 0.83 0.17 - 13.8550 13.8225 13.8496
Time to Maturity Weighted Series
13.5
14
14.5
15
15.5
16
Constant Distance Weighted Series
S.X2
S.F3
Weighted
Comparison - Different Methods
0
20000
40000
60000
80000
100000
120000
140000
7
8
9
10
11
12
13
14
15
16
1/8/2008 1/9/2008 1/10/2008 1/11/2008 1/12/2008
Comparion b/w Weighted/Unweighted/Generic Bloomberg Series
Nearby(Actual)
Weighted
Generic S1
VOLUME
Comparison - Different Methods
-3
-2.5
-2
-1.5
-1
-0.5
0
0.5
1
2/1/2008 2/3/2008 2/5/2008 2/7/2008 2/9/2008 2/11/2008
Difference b/w Weighted Series & Generic BBG Series
BBG Generic - Weighted
Comparison - Return Distributions
Next Nearby Weighted
Std Dev 0.018 0.016
Skewness -0.905 -0.331
Kurtosis 20.612 4.860
Comparison - Different Methods
Method Strengths Weaknesses
Nth Nearest contract No data adjustment. Represents
actual values for todays market.
Gaps in historical data.
Weighted Series Smoothens in data series. Good
for statistical research.
Non-tradable price
representations.
Constant Month
Series
Offers a long period of time in
historical data on an annualized
basis without adjusting the data.
Small Open Interest/volume
periods

More Related Content

Similar to Presentation continuous series (20)

Faculty of Engineering & Technology , Gurukula Kangri University , Haridwar
Faculty of Engineering & Technology , Gurukula Kangri University , HaridwarFaculty of Engineering & Technology , Gurukula Kangri University , Haridwar
Faculty of Engineering & Technology , Gurukula Kangri University , Haridwar
ashwini kumar
Forecasting_Quantitative Forecasting.ppt
Forecasting_Quantitative Forecasting.pptForecasting_Quantitative Forecasting.ppt
Forecasting_Quantitative Forecasting.ppt
RituparnaDas584083
Project Portfolio Francois Bourcier
Project Portfolio Francois BourcierProject Portfolio Francois Bourcier
Project Portfolio Francois Bourcier
Francois Bourcier
Forecasting Techniques
Forecasting TechniquesForecasting Techniques
Forecasting Techniques
guest865c0e0c
Forecasting Techniques
Forecasting TechniquesForecasting Techniques
Forecasting Techniques
Anand Subramaniam
293749024-Reliability-Growth.ppt
293749024-Reliability-Growth.ppt293749024-Reliability-Growth.ppt
293749024-Reliability-Growth.ppt
SreekanthMylavarapu1
Forecasting.ppt
Forecasting.pptForecasting.ppt
Forecasting.ppt
DrMahmoudElmarhoumy
Product Design Forecasting Techniquesision.ppt
Product Design Forecasting Techniquesision.pptProduct Design Forecasting Techniquesision.ppt
Product Design Forecasting Techniquesision.ppt
avidc1000
Advanced Econometrics L7-8.pptx
Advanced Econometrics L7-8.pptxAdvanced Econometrics L7-8.pptx
Advanced Econometrics L7-8.pptx
akashayosha
Wikifolio Analyse
Wikifolio AnalyseWikifolio Analyse
Wikifolio Analyse
Christopher Helm
IRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET- Shock Absorber Testing using FFT Analyzer with DewesoftIRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET Journal
IRJET- Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET- 	  Reliability Analysis of CFST Columns by using Form and Latin Hyperc...IRJET- 	  Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET- Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET Journal
Time series
Time seriesTime series
Time series
VNRacademy
introduction to forecasting in operations management Chapter 3.ppt
introduction to forecasting in operations management  Chapter 3.pptintroduction to forecasting in operations management  Chapter 3.ppt
introduction to forecasting in operations management Chapter 3.ppt
syedalirazakazmi16
Webcast Presentation CPFL Energia_3Q14
Webcast Presentation CPFL Energia_3Q14Webcast Presentation CPFL Energia_3Q14
Webcast Presentation CPFL Energia_3Q14
CPFL RI
30120140504002
3012014050400230120140504002
30120140504002
IAEME Publication
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
IAEME Publication
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docxEngineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
SALU18
Philip Mather
Philip MatherPhilip Mather
Philip Mather
Philip Mather
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET Journal
Faculty of Engineering & Technology , Gurukula Kangri University , Haridwar
Faculty of Engineering & Technology , Gurukula Kangri University , HaridwarFaculty of Engineering & Technology , Gurukula Kangri University , Haridwar
Faculty of Engineering & Technology , Gurukula Kangri University , Haridwar
ashwini kumar
Forecasting_Quantitative Forecasting.ppt
Forecasting_Quantitative Forecasting.pptForecasting_Quantitative Forecasting.ppt
Forecasting_Quantitative Forecasting.ppt
RituparnaDas584083
Project Portfolio Francois Bourcier
Project Portfolio Francois BourcierProject Portfolio Francois Bourcier
Project Portfolio Francois Bourcier
Francois Bourcier
Forecasting Techniques
Forecasting TechniquesForecasting Techniques
Forecasting Techniques
guest865c0e0c
293749024-Reliability-Growth.ppt
293749024-Reliability-Growth.ppt293749024-Reliability-Growth.ppt
293749024-Reliability-Growth.ppt
SreekanthMylavarapu1
Product Design Forecasting Techniquesision.ppt
Product Design Forecasting Techniquesision.pptProduct Design Forecasting Techniquesision.ppt
Product Design Forecasting Techniquesision.ppt
avidc1000
Advanced Econometrics L7-8.pptx
Advanced Econometrics L7-8.pptxAdvanced Econometrics L7-8.pptx
Advanced Econometrics L7-8.pptx
akashayosha
IRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET- Shock Absorber Testing using FFT Analyzer with DewesoftIRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET- Shock Absorber Testing using FFT Analyzer with Dewesoft
IRJET Journal
IRJET- Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET- 	  Reliability Analysis of CFST Columns by using Form and Latin Hyperc...IRJET- 	  Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET- Reliability Analysis of CFST Columns by using Form and Latin Hyperc...
IRJET Journal
Time series
Time seriesTime series
Time series
VNRacademy
introduction to forecasting in operations management Chapter 3.ppt
introduction to forecasting in operations management  Chapter 3.pptintroduction to forecasting in operations management  Chapter 3.ppt
introduction to forecasting in operations management Chapter 3.ppt
syedalirazakazmi16
Webcast Presentation CPFL Energia_3Q14
Webcast Presentation CPFL Energia_3Q14Webcast Presentation CPFL Energia_3Q14
Webcast Presentation CPFL Energia_3Q14
CPFL RI
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
THE ANALYSIS OF SOME FACTORS FOR THE OPTIMIZATION OF CYLINDRICAL GEAR TRANSMI...
IAEME Publication
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docxEngineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
Engineering Science WorksheetsTENSILE TESTER KIT ES6TE.docx
SALU18
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET- Geotechnical Investigation of Different Soil Samples using Regression ...
IRJET Journal

Presentation continuous series

  • 1. Continuous Future Series Construction Quant Team Ruchi Agri-Trading Singapore May 03, 2013
  • 2. Why Continuous Future Series? We require a continuous historical price series for analysis or back-testing of trading strategies. One difficulty with the futures historical data is associated with splicing contracts together at contract boundaries. The results of any analysis will depend on the method we choose to construct the data series.
  • 3. Different types of Continuous Series Constant Month Series (S Nov1, etc.) Constant Distance / Rolling Nearby / N-th Nearest Contract Series (S 1, BO2, etc.) Time to maturity weighted Series (Risk Metrics linear interpolation approach) Volume/OI weighted Series
  • 5. Time to Maturity Weighted Series (RiskMetrics Method)
  • 6. An Example: Time to Maturity Weighted Series Dates Contract Expiration Number of Days to Expiration Weights (%) Actual Contract Prices CMF Price NB1 1m CMF NB2 NB1 1m CMF NB2 爍燹材`爻 爍燹材`爻 燹酌ゞ燿燿 燹酌´燿燿 燹酌/燿燿 燹酌燿燿 2011- 07-11 07-14 08-10 08-12 3 30 32 0.10 0.90 13.5250 13.4650 13.4450 13.4710 2011- 07-12 07-14 08-11 08-12 2 30 31 0.07 0.93 13.6650 13.5550 13.5500 13.5623 2011- 07-13 07-14 08-12 08-12 1 30 30 0.03 0.97 13.8700 13.7475 13.7475 13.7516 2011- 07-14 07-14 08-15 08-12 0 30 29 0.00 1.00 13.9050 13.8200 13.7975 13.8200 2011- 07-15 08-12 08-15 09-14 28 30 61 0.93 0.07 - 13.8575 13.8300 13.8557 2011- 07-18 08-12 08-17 09-14 25 30 58 0.83 0.17 - 13.8550 13.8225 13.8496
  • 7. Time to Maturity Weighted Series 13.5 14 14.5 15 15.5 16 Constant Distance Weighted Series S.X2 S.F3 Weighted
  • 8. Comparison - Different Methods 0 20000 40000 60000 80000 100000 120000 140000 7 8 9 10 11 12 13 14 15 16 1/8/2008 1/9/2008 1/10/2008 1/11/2008 1/12/2008 Comparion b/w Weighted/Unweighted/Generic Bloomberg Series Nearby(Actual) Weighted Generic S1 VOLUME
  • 9. Comparison - Different Methods -3 -2.5 -2 -1.5 -1 -0.5 0 0.5 1 2/1/2008 2/3/2008 2/5/2008 2/7/2008 2/9/2008 2/11/2008 Difference b/w Weighted Series & Generic BBG Series BBG Generic - Weighted
  • 10. Comparison - Return Distributions Next Nearby Weighted Std Dev 0.018 0.016 Skewness -0.905 -0.331 Kurtosis 20.612 4.860
  • 11. Comparison - Different Methods Method Strengths Weaknesses Nth Nearest contract No data adjustment. Represents actual values for todays market. Gaps in historical data. Weighted Series Smoothens in data series. Good for statistical research. Non-tradable price representations. Constant Month Series Offers a long period of time in historical data on an annualized basis without adjusting the data. Small Open Interest/volume periods