Imagine you are a high level finance student trying to create a Basel Traffic Light graph on excel. You have the number of exceedances for the following VaR models: The normal rolling window 252 and 66 days, the EWMA (0.94), the historical simulation (not rolling window) 252 and 66 days. Can you please guide me in creating this graph on excel. Keep in mind, the models that require more than 252 days should be calculated starting from day 253 (professor's instruction). The current dates goes from newest (top) to oldest (bottom).

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
None
Imagine you are a high level finance student trying to
create a Basel Traffic Light graph on excel. You have the
number of exceedances for the following VaR models:
The normal rolling window 252 and 66 days, the EWMA
(0.94), the historical simulation (not rolling window) 252
and 66 days. Can you please guide me in creating this
graph on excel. Keep in mind, the models that require
more than 252 days should be calculated starting from
day 253 (professor's instruction). The current dates goes
from newest (top) to oldest (bottom).
Transcribed Image Text:Imagine you are a high level finance student trying to create a Basel Traffic Light graph on excel. You have the number of exceedances for the following VaR models: The normal rolling window 252 and 66 days, the EWMA (0.94), the historical simulation (not rolling window) 252 and 66 days. Can you please guide me in creating this graph on excel. Keep in mind, the models that require more than 252 days should be calculated starting from day 253 (professor's instruction). The current dates goes from newest (top) to oldest (bottom).
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education