[email protected]
New Member
Hi everybody. First, sorry about my english.
I have a doubt about calculating VaR. Hope you can help me.
I´m trying to calculate VaR based on a document that i´ve read at J.P.Morgan´s website. The URL is bellow:
http://www.jpmorgan.com/tss/General/Risk_Management/1159360877242
I´m using the follow VaR formula: VaR=PortfolioValue*StandardDeviation*Z
Where:
Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147
My final result is -5.393.013,27
But in the document the final result is 4.993.012,77
So, i think it´s because i´m calculating the Relative VaR and the document uses Absolute VaR, but when I try an Absolute VaR formula my final result is 4.993.013.27.
I´m using the follow formula of Absolute VaR:
VaR=-(PortfolioExpectedReturn+Z*StandardDeviation)*PortfolioValue
Where:
Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147
ExpectedReturn = 0,40%
I know that it´s a insignificant difference, but I would like to know if everything is correct and if the document is really using Absolute VaR instead of Relative VaR.
I´m a beginner, so please be patience! lol
Thanks a lot in advance.
I have a doubt about calculating VaR. Hope you can help me.
I´m trying to calculate VaR based on a document that i´ve read at J.P.Morgan´s website. The URL is bellow:
http://www.jpmorgan.com/tss/General/Risk_Management/1159360877242
I´m using the follow VaR formula: VaR=PortfolioValue*StandardDeviation*Z
Where:
Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147
My final result is -5.393.013,27
But in the document the final result is 4.993.012,77
So, i think it´s because i´m calculating the Relative VaR and the document uses Absolute VaR, but when I try an Absolute VaR formula my final result is 4.993.013.27.
I´m using the follow formula of Absolute VaR:
VaR=-(PortfolioExpectedReturn+Z*StandardDeviation)*PortfolioValue
Where:
Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147
ExpectedReturn = 0,40%
I know that it´s a insignificant difference, but I would like to know if everything is correct and if the document is really using Absolute VaR instead of Relative VaR.
I´m a beginner, so please be patience! lol
Thanks a lot in advance.