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

Подписаться 6 тыс.

Просмотров 42 тыс.

50% 1

Value at Risk or VaR is a risk management tool banks use to manage their exposure to market risk. In the video we explain what VaR is and how you can calculate VaR yourself using historical price data. We show how to calculate Value at Risk with the help of a clear Excel example. The example follows the historical method using Yahoo finance data.
Good luck! André Koch
Stachanov Solutions & Services
Excel,Model,VaR,Value at Risk,André Koch,Stachanov,market risk,Basel Accord,Mercursim,Bank capital,stock market,Risk management,Risk analysis,bank capital,Capital buffer;Bank regulation;Basel treaty;Basel accord;regulatory capital, economic capital,ECAP,stock price, historical method, Yahoo, bank regulation,percentile,simulation

Опубликовано:

15 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 43

@kawinjar Год назад

Thanks for the best explanation video.

@StachanovSolutionsServices Год назад

You're welcome!

@nhlanhlamsongelwa4364 3 года назад

Thanks for the theory and the examples

@StachanovSolutionsServices 3 года назад

You are very welcome, thanks !

@tJ-tz5jk 3 года назад

Thank you so much.. very easy to understand

@StachanovSolutionsServices 3 года назад

You are welcome ! André Koch

@opciones16 8 месяцев назад

that is an excelent video!!

@StachanovSolutionsServices 8 месяцев назад

Thank you!

@Llampalleq 8 месяцев назад

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 8 месяцев назад

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

@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

@munyanezagodfrey513 3 года назад

Thanks for the great work

@StachanovSolutionsServices 3 года назад

You're welcome!

@drachenschlachter6946 2 года назад

Very nice video!

@StachanovSolutionsServices 2 года назад

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

@Kig_Ama 2 года назад

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 2 года назад

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

@StachanovSolutionsServices 2 года назад

Actually, the two colors are two separate data ranges. Send me an email and I will share an example : andre@stachanov.com. Best, André Koch

@Kig_Ama 2 года назад

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

@Kig_Ama 2 года назад

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

@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

@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é

@carenjenny9728 2 года назад

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

@StachanovSolutionsServices 2 года назад

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

@aichamarzougui1545 2 года назад

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 2 года назад

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

@gokulvisweswaran1205 Год назад

Is it possible to get the Excel sheet?

@StachanovSolutionsServices Год назад

Yes, please send me an email andre@stachanov.com 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

@peterfarina2688 2 года назад

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

@StachanovSolutionsServices 2 года назад

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 2 года назад

@@StachanovSolutionsServices Thanks!!

@StachanovSolutionsServices 2 года назад

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

@Im-Assmaa 2 года назад

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 2 года назад

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

@itbeat7899 3 года назад

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 3 года назад

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 2 года назад

@@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.

@muayadnajm 2 года назад

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 2 года назад

Hello Muayad Najm, see the instruction here to activate the Arabic translation: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DcyC9xATsz8.html As for financial shock effects, I refer tot the vido on "Stress testing" ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qWJjS5V0iTI.html I hope this all helps. Best, André Koch

2:09

Risk Weighted Assets RWA under Basel 2: clear explanation with an Excel exercise and exemple

Просмотров 16 тыс.