Value at Risk or VaR, a tool to master market risk, explained in clear terms with Excel model.

[@kawinjar]

Thanks for the best explanation video.

[@StachanovSolutionsServices]

You're welcome!

[@nhlanhlamsongelwa4364]

Thanks for the theory and the examples

[@StachanovSolutionsServices]

You are very welcome, thanks !

[@tJ-tz5jk]

Thank you so much.. very easy to understand

[@StachanovSolutionsServices]

You are welcome ! André Koch

[@munyanezagodfrey513]

Thanks for the great work

[@StachanovSolutionsServices]

You're welcome!

[@opciones16]

that is an excelent video!!

[@StachanovSolutionsServices]

Thank you!

[@drachenschlachter6946]

Very nice video!

[@StachanovSolutionsServices]

Thank you very much "dragon slayer". Best, André Koch

[@qujinglin4160]

Thank you for the video and explaination. However, I wonder how you set up the bin value from-8% to 13%?

[@StachanovSolutionsServices]

Hallo, next to the bin size you also need to set a realistic range for these bins. In the video I do this by using Excel's =MIN() and =MAX() functions. This way I am sure that all the delta's observed fit in between. Best, André Koch

[@Llampalleq]

Thanks for the work you did to bring us this great instructive video. Just one observation: in minute 10:24 you set the lower bin at -8%, but the delta range starts at -13%, as you did in the previous chart. Am I correct?

[@StachanovSolutionsServices]

Thanks for comment and sorry for the late reply: yes you're right! I did this to get a nice range and ignore some outliers. Best, André Koch

[@mlacorte21]

If I wanted to find the annual VAR how could I convert this number from daily to annual?

[@StachanovSolutionsServices]

Good question. Intuitively, you understand that with a longer period also the uncertainty goes up. You can calculate this using the square root rule. You multiply the one-day VaR with the square root of the number of days. So, the 9 day VaR would be: square-root of 9, which is 3, times the one-day VaR. For the year you multiply with the square root of 365. Best, André Koch

[@carenjenny9728]

Any video or explanation on Profit-at-risk (PaR) plz?

[@StachanovSolutionsServices]

No sorry, not on the list. Best, André Koch

[@Kig_Ama]

7:16 how did u colored the areas differently with excel. Can't u just provide a download link to the excel file? Video liked and subscribed.

[@Kig_Ama]

Ok u r describing it at the end of the video. Great video, liked it a lot!

[@StachanovSolutionsServices]

Actually, the two colors are two separate data ranges. Send me an email and I will share an example : [e-mail]. Best, André Koch

[@Kig_Ama]

@@StachanovSolutionsServices Ty Andree, just wrote u an e-mail.

[@Kig_Ama]

@@StachanovSolutionsServices Hi André, hope ur doin good. Did u receive my e-mail? Ty, Kig.

[@itbeat7899]

maximum you can lose with confidence level 95% (arbirary set) with short time line (24 hr for example, as bank assume it can sell in financial market). deltaprice equals natural log of todays price over yesterdays price. look at frequency of those deltaprice.

[@StachanovSolutionsServices]

Yep. The 95% is just to give you an idea. Twenty years ago or so this was a common threshold, nowadays it is more like 99% and up. Indeed the 24 hours is under the assumption that you can always sell your portfolio on the market. It is understood that this might be more difficult in times of a financial crisis. Have you seen the movie "Margin Call" ? The movie is a popular big picture movie on the 2008/9 financial crisis, however, there are some interesting discussions on VaR in this movie. Just google "Margin call" & "VaR" and you will find them. Best, André Koch

[@peterfarina2688]

@@StachanovSolutionsServices I absolutely love "Margin Call." It's as accurate a description of the MBS/CDO implosion as possible. Even Ramesh Shah from "upstairs" would agree.

[@aichamarzougui1545]

First of all, thank you for the explanation it's very helpful. However I got confused from 6:45 to 7:25 , it says that 475 of cases are covered by the Var and 25 are not, then it proceeds to say that the orange area is covered by the VaR and the blue area is not, but then it says that 25 observations are in the blue tail (uncovered) and 450 are in the orange area (covered). isn't the 450 mentioned supposed to be 475? or there's something I don't get? I'm confused

[@StachanovSolutionsServices]

Thanks Aicha for your comment, and you are completely right. It should be 475. Let me see whether we can change this. All the best, André Koch

[@indira4947]

Are those techniques being used world wide?

[@StachanovSolutionsServices]

Yes, that is the case. Keep in mind that what is shown here is a simplified model that just shows the principle behind VaR. During the financial crisis of 2008/9 there was much criticism on the use of VaR. The famous risk guru, Nassim Taleb, opposed the use of VaR. Best, André

[@gokulvisweswaran1205]

Is it possible to get the Excel sheet?

[@StachanovSolutionsServices]

Yes, please send me an email [e-mail] Best, André

[@StachanovSolutionsServices]

Change of plans: I will upload it here: www.stachanov.com/en/downloads It will be there in 15 minutes. Best, André Koch

[@Im-Assmaa]

Thank you for the video. I have a question. How can I compute the quantiles for a specific p, using Rankit-cleveland method? It is used to estimate the value at risk using quantile regression and I am kind of stuck. please help

[@StachanovSolutionsServices]

Sorry, I am not familiar with this Rankit-Cleveland approach, so I cannot help you. Best, André Koch

[@muayadnajm]

I request you to please explain. Measuring the credit shock and its reflection on the financial and banking safety, and that the translation in Arabic should be activated. Thank you for your patience, sir

[@StachanovSolutionsServices]

Hello Muayad Najm, see the instruction here to activate the Arabic translation: kzbin.info/www/bejne/epTcdGyudrmmsJo As for financial shock effects, I refer tot the vido on "Stress testing" kzbin.info/www/bejne/p4itm4Zri5Wciqs I hope this all helps. Best, André Koch

[@peterfarina2688]

Thank you. I do have a question-how did you generate the chart? Thanks.

[@StachanovSolutionsServices]

The chart actually consists of two charts and two data sets. See for an example: www.officetooltips.com/excel_2016/tips/how_to_add_dividers_to_the_chart.html

[@peterfarina2688]

@@StachanovSolutionsServices Thanks!!

[@StachanovSolutionsServices]

It''s a pleasure. Yes, I always show the clip form Margin Call whenever I teach about VaR. All the best, André Koch