Using Monte Carlo simulation to calculate Value At Risk

  • Thread starter Deimantas
  • Start date
  • #1
Deimantas
41
0

Homework Statement


Calculate 5-day 1% Value at Risk of a portfolio using Monte Carlo simulation.

Homework Equations




The Attempt at a Solution


I've found an article explaining how to perform Monte Carlo simulation on portfolio returns therefore calculating the Value At Risk (pdf attachment). I've followed all the instructions and implemented it in Excel (zip attachment).
There are 3 main methods to estimate the VaR of a portfolio - historical simulation, parametric approach and Monte Carlo simulation. Historical simulation gives 5-day VaR=566.59, parametric approach gives 5-day VaR=486.92, and here Monte Carlo simulation gives 5-day VaR equaling around 360. I doubt the Monte Carlo result is accurate (seems way too low). I'm afraid there might be some errors in my excel implementation. I'd appreciate it if someone could kindly help me spot them.
 

Attachments

  • Anybody can do Value at Risk_ A Teaching Study using Parametric C.pdf
    357.1 KB · Views: 686
  • montecarlos.zip
    2.7 MB · Views: 683

Answers and Replies

  • #2
18,823
8,996
Thanks for the post! This is an automated courtesy bump. Sorry you aren't generating responses at the moment. Do you have any further information, come to any new conclusions or is it possible to reword the post?
 

Suggested for: Using Monte Carlo simulation to calculate Value At Risk

Replies
0
Views
639
Replies
16
Views
348
  • Last Post
Replies
1
Views
652
Replies
1
Views
239
Replies
12
Views
558
Replies
26
Views
971
  • Last Post
Replies
25
Views
493
Replies
18
Views
757
Replies
2
Views
301
Top