Business School

QBUS6830

Financial Time Series and Forecasting

Semester 1, 2020

Group Assignment

The Group Assignment will contribute 40% towards your final grade and is to be

completed in groups of 3-5 students. The due date is Monday 25th May, by 5pm AEST

via online Turnitin submission in Canvas. You will be penalised 20% for each 24-hour

period it is late. Submissions after Monday 25th May, by 5pm AEST will be penalised

instantly as if it was one day late (i.e. 20%).

Determining Your Dataset

There are 3 variations to this group assignment. Each group number can either be Type 1,

Type 2 or Type 3. Use this to determine which variation of the assignment your group will

use, and therefore what your group number is.

Let X be the sum of the last digit of each group members student ID.

If you have 3 people in your group, then if X is:

0 - 9 → Type 1

10 - 18 → Type 2

19 – 27 → Type 3

If you have 4 people in your group, then if X is:

0 – 12 → Type 1

13 – 24 → Type 2

25 – 36 → Type 3

If you have 5 people in your group, then if X is:

0 – 15 → Type 1

16 – 30 → Type 2

31 – 45 → Type 3

Submission Requirements

The assignment consists submission of 6 parts; Cover sheet, a Written Report, Excel

questions, a MATLAB code file, group Meeting Minutes, and a Peer Assessment forms

(collated from all members into one file).

QBUS6830, Financial Time Series and Forecasting

The cover sheet outlines all your group members, their names and signatures. I have

created an example of what your cover sheet should include. Feel free to use this one or

create one on your own.

In the Written Report, you should provide your answers to all questions below with the title

“Written Report submission questions”. The written report has a limit of 20-pages maximum.

Only one student should submit per group.

Each group must also answer the questions listed within the Excel file. Do NOT submit an

excel file. Simply create a neat tables into your PDF submission which has all of the

questions, and the excel answers. Your group’s questions can be found in the spreadsheet

“Data and Questions” of “GA1 - Data and Qs.xlsx” and “GA2 - Data and Qs.xlsx”. A template

has been provided for your excel answers on the second spreadsheet of the file which is

called “Excel Answer Sheet”.

For the MATLAB code file submission, please submit the code used to produce all your

outputs for both the Written Report and the Excel file submission as a “.m” file.

A template for the group Meeting Minutes will be placed on Canvas and should have entries

for at least 4 group meetings.

Finally, the Peer Assessment Form, requires each group member to assess the

contributions of their fellow group members and will be used to adjust marks in the case

where student contribution differs significantly across group members. Each member of the

group must create their own Peer Assessment form, and these should be collated and then

also submitted.

One person will submit all files for all group members. Only one submission will be accepted

per group. This person is responsible for submitting all the files listed above. Do NOT submit

multiple files. You must only submit one file (zipped) which has all the relevant assignment

files inside of it. If you submit multiple files, your assignment will not be considered “sent”

until all of your files are zipped and within 1 single file.

IMPORTANT:

Submission links will become available in Canvas a week before the due date. Note that the

Written Report will be submitted via Turnitin, the university’s anti-plagiarism software.

QBUS6830, Financial Time Series and Forecasting

Group Assignment Part 0

List your group members, along with their student ID. Calculate X, and therefore which

assignment variation you will be using.

QBUS6830, Financial Time Series and Forecasting

Group Assignment Part I

Obtaining Data and Excel Questions

For this assignment you will need to download the file “GA1 - Data and Qs.xlsx”. The file

can be found in Canvas by clicking on ‘Assignments’ on the left-hand menu and then clicking

on ‘Group Assignment Part I’. Once you have downloaded the file, enter your group number

in cell ‘B1’ of the first spreadsheet and this will populate the data set and the group-specific

questions for your group. Note the data are based on actual asset and market return series,

however, the dates have been artificially changed for the assignment. Question 1 –

Principle Components and Factor Analyses

Data on the percentage simple returns of 5 assets are provided in the file “GA1 - Data and

Qs.xlsx” for each group in columns D to J of spreadsheet “Data and Questions”.

Principle Components analysis

Conduct a Principle Components analysis on the covariance matrix, , of the 5 Asset simple

return series.

(7 marks) Written Report submission questions

a) (5 marks) Present the results of your analysis in a table and describe the Principle

components found. Do they have a relevant or useful interpretation?

b) (2 marks) How many components would you choose. Justify your answer.

(5 marks) Excel file submission questions

Answer Q1a-Q1e in the excel file (see spreadsheet “Data and Questions” column R).

Factor Analysis

5 Asset simple returns series are provided in the excel file for each group. Estimate factor

analyses on the 5 asset simple return series using m factors where m = 1, 2, …, 5.

(6 marks) Written Report submission questions

c) (3 marks) For the 2-factor model for your group’s assets. Present the results of your

analysis in a table and describe the Principle components found. Do they have a

relevant or useful interpretation? Justify your answer.

d) (3 marks) How many factors would you choose to include in your factor model? Justify

your answer.

(6 marks) Excel file submission questions

Answer Q1f-Q1k in the excel file. (see spreadsheet “Data and Questions” column R).

Question 2 – Time series models and forecasting

Data on the percentage log returns of two assets, as well as the market index, are provided

in the file “GA1 - Data and Qs.xlsx” for each group in columns L to P of spreadsheet “Data

and Questions”.

QBUS6830, Financial Time Series and Forecasting

In question 2 you will be required to use various forecasting methods, assess their accuracy,

and use the forecasts to create portfolios in a dynamic portfolio optimization problem. Each

group will be assigned 5 forecast methods (see spreadsheet “Data and Questions”, cells

R21:R25) and should estimate suitable forecasting models for your two assets’ percentage

log return data, using the in-sample data only. You are then required to generate moving

origin horizon 1 forecasts for each observation in your forecast sample for your group’s 5

methods. Use an expanding data window for your in-sample and you should update your

model estimates daily. Each group’s in-sample and forecast sample is provided in the

spreadsheet “Data and Questions” in cells R18:R19.

Next, you should generate dynamic portfolio weights based on your group’s portfolio

strategies (see Excel file, spreadsheet “Data and Questions”, cells R39:R43) and the

forecast models mentioned above. Dynamic portfolios must be created for each combination

of forecast model and portfolio strategy (i.e. 5×5 = 25 in total). The portfolio weights must be

updated daily. Once the task is completed you are required answer the questions below.

(10 marks) Written Report submission questions

(a) (5 marks) Present the forecast accuracy measures RMSE and MAD for all forecasting

strategies in a table and discuss the performance of the different forecasting

approaches.

(b) (5 marks) Present the returns and standard deviations for all forecasting model and

portfolio strategy combinations. Discuss the performance of the various combinations

of models and strategies.

(c) (20 marks) Excel file submission questions. Answer Q2a-Q2t in the excel file

(spreadsheet “Data and Questions” column R).

QBUS6830, Financial Time Series and Forecasting

Group Assignment Part II

Obtaining Data and Excel Questions

For this assignment you will need to download the file “GA2 - Data and Qs.xlsx”. The file

can be found in Canvas by clicking on ‘Assignments’ on the left-hand menu and then clicking

on ‘Group Assignment Part II’. Once you have downloaded the file, enter your group number

in cell ‘B1’ of the first spreadsheet and this will populate the data set and the group-specific

questions for your group.

Question 3 - Volatility Modelling and Risk estimation

In this assignment you are required to build a range of models for forecasting market risk.

Data on the Open, Low, High, Close, and percentage log returns, for a single asset are

provided in the file “GA2 - Data and Qs.xlsx” for each group in columns F:J of spreadsheet

“Data and Questions”. All cell references in what follows refer to the aforementioned

spreadsheet. Each group is assigned 5 volatility forecast models/methods (see cells L3:L7)

and must estimate forecasting models for their percentage log return series on the in-sample

data utilising information criteria where stated. Each group’s in-sample and forecast sample

periods are provided in the cells L10:L11.

For all your volatility models, examine the accuracy of 1-period ahead volatility forecasts by

comparing them to two volatility proxies across your forecast sample using MAD and RMSE.

Note that once you have chosen models based on your in-sample period you should use

the same models for all of your forecast periods. For example, if you use information criteria

to determine model 2 is an ARCH(3) model based on your in-sample data, then you should

use the ARCH(3) model for all of your model 2 forecasts. The proxies your group must use

are provided in cell L14. Use a fixed-size rolling window approach for generating these

forecasts updating your model estimates daily.

Finally, generate 1-period ahead Value at Risk and Expected Shortfall forecasts, at the 5%

level, for all volatility forecast models, as well as a symmetric CAViaR model, from the end

of the data series (i.e. forecasts are for the day after the last day in your forecast sample).

When estimating a CAViaR forecast for VaRt+1, you need to have an estimate of VaRt, and

to obtain the estimate for VaRt you will need an estimate of VaRt-1, and so on. You will

obviously need to initialise this forecast at some point without the use of the CAViaR. It is

common to run the model for a large number of observations prior to your final forecast so

your first estimate of VaR has little impact on the final forecast. For this reason, you should

conduct the following steps:

a) Obtain an initial 5% VaR estimate as the 5th percentile of the 1st 1000

observations.

b) Run the CAViaR model to obtain forecasts for the last 200 periods in your data

set using a moving window of size 1000 observations updating your

parameters daily. Use the sample percentile from i) to obtain the first forecast

of these 200 forecasts. From then on iteratively use the forecasts for each

successive period to obtain the forecast for the following period up until the

end of your sample.

c) Finally obtain the forecast for the next day following your sample period using

the forecast for the last day of your sample period and the most recent CAViaR

parameter estimates

d) For the model specified in cell L6:

QBUS6830, Financial Time Series and Forecasting

i) (5 marks) Provide your estimation results in a table and write down the

estimated model equations. Discuss the statistical significance and interpret

the estimated parameters. (Note: The model presented should be estimated

on the in-sample data used to create your final forecast for period 1201. For

example, if your in-sample data set is of length 1170 observations your

presented estimation results would use observations 31-1200.)

ii) (20 marks) Perform a thorough diagnostic analysis to assess the fit of the

model.

iii) (5 marks) Discuss any component(s) you might add to the model that might

potentially capture any model mis-specifications found; motivate your choices.

iv) (10 marks) Discuss the asymmetry of the fitted model.

e) (5 marks) Present and discuss the volatility forecast accuracy measures for all

your volatility models specified in cells L3:L7. (This does not include CAViaR

as it is not a model for volatility)

f) (5 marks) Present and discuss the 1- period ahead 5% VaR forecasts for all

models specified in cells L3:L7 plus the CAViAR model. (Note: you do not need

to assess the forecast’s accuracy or independence).

g) (5 marks) Present and discuss the 1-period ahead 5% ES forecasts for all

models specified in cells L3:L7. (Note: you do not need to assess the forecast’s

accuracy or independence). (This does not include CAViaR as it is not a model

for ES).

(h) (21 marks) Excel file submission questions. Answer questions a) - u) in the

excel file (spreadsheet “Data and Questions” column L, cells L17:L37).

QBUS6830, Financial Time Series and Forecasting

Some notes regarding group peer assessment

1. Your group will be required to document, using minute form, at least 4 group meetings.

Documentation should be in terms of attendance, discussion points, actions decided, tasks allocated

and/or completed by each member, etc. An example form for this will be distributed OR you may use

your own.

2. Peer assessment items are required to be handed in as part of the online submission process. If

you do not complete and hand these in, then you will lose marks individually.

3. At the end of the assignment, everyone will rate BOTH themselves and their other group members

in terms of participation and effort on the assignment. For each individual group member, the total

group mark will either be adjusted (i) downwards; or (ii) upwards; or (iii) remain the same, depending

on my academic judgement of the peer assessment items provided by each individual in each group

and reflecting each individual’s overall contribution to, and effort in, completing the assignment tasks.

3. Based on peer assessment and after having put in a reasonable effort on the group project, the

maximum amount a student can lose from their group mark is 10% of the total mark. However, an

exception to this is if a student has TRULY DONE NOTHING (or close enough to; i.e. not put even

close to a reasonable effort), in which case I will award a mark of 0.

4. If a group is concerned that one or more of their members is not contributing sufficiently to the

assignment please inform the course coordinator and provide any evidence (meeting minutes or

otherwise) to support your claim. If the concern appears valid a warning will be sent to the student(s)

and an immediate penalty of 10% will be imposed. Should the situation miraculously improve the

penalty may be removed later. Should the situation not improve, a mark of 0 is possible as discussed

above.