Calculate the rolling standard deviation

Assignment Help Risk Management
Reference no: EM13824342

1. Calculate the 99%/10day Value at Risk for an investment In the market index using a' sample standard deviation.

• Calculate the rolling standard deviation for a sample of 21 days, e.g., using days 1-21, 2-22...

• Project standard deviation from 1D to 10D period using the additivity of variance σ10D = √10 x σt2 and scale an average daily return as μ10D = μ x 10, where p is a mean of all data.

• Calculate Value at Risk as follows:

VaR = μ10D + σ10D x Factor

where Factor is a percentile of the Standard Normal Distribution that 'cuts' 1% on the tail.

2. Calculate the 99%/10 day Value at Risk for an investment in the market index using a GARCH-filtered standard deviation. An example of GARCH calculation is provided in the ARCH Lecture.

• Assume a GARCH(1,1) model has been estimated from the long-term data as follows:

σt2 = 0.000001 + 0.047μ2t-1 + 0.9466σ2t-1

where ω = 0.000001, a = 0.047, and β = 0.9466.

• Set the initial value of σ02 equal to the variance for the whole dataset. 'Then, recursively use the past variance and return from the row above to set up a GARCH calculation.

• Use GARCH-filtered standard deviation to calculate Val according to f. Remember to scale.

3. Calculate the percentage of VaR breaches for each measure. Are the breaches independent in time of the level of volatility?

• VaR Is fixed at time t and compared to the realised return at time t + 10. A breach occurs when a realised 10-day index return In (St+10/St) is below the VaR quantity (negative scale).

• 20/08/2009 is the first day on which VaR computation. Is available for both. VaRSD and VaRGARCH. Total number of comparisons is N = 978. Number of breaches divided by number of comparisons will give the percentage of breaches.

• Optionally, calculate the conditional probability of breach in VaR for the next period, given that a breach was observed for the previous period.

Methodology Note: In Excel, use 1F() function to compare.

The question about VaR breaches being an iid process can be answered either by a visual analysis (location-dispersion, Q-Q plot) or more formal statistical testing of Normality, autocorrelation, or Poisson process fit.

Think about the application of techniques that you are familiar with.

Attachment:- Data.xlsx

Reference no: EM13824342

Questions Cloud

Explain the benefits and the problems derived from hub : Your essay response must be a minimum of 200 words in length, not counting references listed at the end or repeating of the question. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying..
Question about mergers and acquisitions : The question belongs to Accounting and it discusses about a multiple choice question about mergers and acquisitions
What types of methods support the mission of the agency : What types of programming and methods support the mission of the agency? The staff of the agency. Why are certain staff members needed?
Form of standard contract-terms-conditions : H. Golightly is a professional football player who has played for the Toronto Mercenaries ("Mercs") for the past 3 football seasons. The Toronto Mercs are a member of the Eastern Conference of the Trans-Canada Football League. Golightly lives in t..
Calculate the rolling standard deviation : Calculate the rolling standard deviation for a sample of 21 days, e.g., using days 1-21, 2-22 - Calculate Value at Risk - calculate the conditional probability of breach in VaR for the next period, given that a breach was observed for the previous p..
Special feature of service blueprints : Special Feature Of Service Blueprints
How many pounds of material are used in the current period : For the current period, Kayenta Company’s manufacturing operations yield a $4,000 unfavourable price variance on its direct materials usage. The actual price per pound of material is $78; the standard price is $77.50. How many pounds of material are ..
Problem-misrepresentation by car hiring company : West was 17 years of age & obtained his driver's license. He went to Drive-Yourself Ltd., showed his license, and signed for the hiring of a car. The Drive-Yourself clerk did not notice West's age as being under 18, the minimum age required by the..
How much overhead cost is allocated to order filling act : How much overhead cost is allocated to the Order Filling activity cost pool under activity-based costing

Reviews

Write a Review

Risk Management Questions & Answers

  Programming and operating functions

How is the separation of the programming and operating functions accomplished in a properly functioning IT environment and explain the subdivisions of information systems management, and discuss how they apply to this situation.

  Discuss advantages of a digital presence

The student will research and analyze the implications of an effective and professional social media presence to include the following.

  What is the risk from systems engineering perspectives

Your teams sensitivity analysis and recommendations based on the risk factor calculated for your assumption - What is the RISK from Systems Engineering perspectives if we want to become the Agent and distributer in the UAE

  The role of the risk management

The role of the risk management topic in health care organizations.

  Microsoft''s risk management approach

Concentrate this module's area of research on "Microsoft's risk management approach." Write a 1-2 pages APA style paper, describing each of the four phases in the security risk management process.

  Economic failure from a risk management

What was the economic failure from a Risk management prospective which caused the company to file for bankruptcy, and need aid from the government?

  Compute the dollar value of the futures contract notional

compute the dollar value of the futures contract notional and the number of contracts to buy/sell for optimal protection

  What role does it play for global cash management

Describe the network of ABN AMRO Bank in India and what role does it play for global cash management?

  What profit or loss would the investment banker

What profit or loss would the investment banker incur if the issue sold to the public at an average price of $25 per share and what profit or loss would the investment banker incur if the issue were sold to the public at an average price of $15 p..

  What diagramming techniques will you use to explore risks

What risk identification techniques will you utilize, and why do you believe that these will work best for your Key Assignment project? What diagramming techniques will you use to fully explore specific types of risks?

  Describe the delphi technique used to identify risks

Describe the Delphi technique used to identify risks and infer on types of projects where this technique is most accurate. Examine the four (4) types of risk response (i.e., avoidance, acceptance, transference, and mitigation) and determine the app..

  Use the internal rate of return to select the best projects

Use the internal rate of return (IRR) approach to select the best group of projects and use the net present value (NPV) approach to select the best group of projects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd