VAR CALCULATION ON EXCEL

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024

Комментарии • 42

  • @Basavaraj-pj1cx
    @Basavaraj-pj1cx 5 лет назад +17

    i have been in the field of risk management for over decade. this was an outstanding explanation

  • @CASaurabhDwivedi
    @CASaurabhDwivedi 9 дней назад

    I have spent 40 lacs on a Masters degree and this video was much much better than what my university professors teach.

  • @PankajVerma-lh2cj
    @PankajVerma-lh2cj 2 года назад +1

    This was really real world example. Really corporate oriented.

  • @ashwiiniinandesshwar3062
    @ashwiiniinandesshwar3062 5 лет назад

    Very nicely explained it everything. It will definitely help many people.

  • @manishkumartripathi1004
    @manishkumartripathi1004 Год назад +1

    Could not understand Continuous and Effective return (16:00), could you share some link to read?

  • @laiq8204
    @laiq8204 5 лет назад +1

    Sir u r doing great job god bless u

  • @mayankgupta7172
    @mayankgupta7172 3 года назад

    excellent. great work

  • @VivekGulati20
    @VivekGulati20 4 года назад +2

    I guess there's some error here. VaR doesn't denote the maximum possible loss. That would be the value of the entire portfolio. It simply denotes the value of minimum loss over a specified time horizon with expected %age.

    • @sudipa2010
      @sudipa2010 3 года назад

      I have seen this interpretation also. Could you provide some references?

    • @rohangholam8270
      @rohangholam8270 3 года назад

      Correct, the word maximum should not have been used, else rest of the explanation is perfect.

    • @danishrizwan8304
      @danishrizwan8304 2 года назад

      So there are two ways to interpret var, assuming 95% confidence level
      1) the minimum loss would be (the var number) with 5% confidence. In simple word, we are sure to the tune of 5% that the losses would be more than the var number
      2) the maximum loss would be (the var number) with 95% confidence. In simple word, we are sure to the tune of 95% that the losses would be less than the var number.

  • @devinaarastogi2420
    @devinaarastogi2420 Год назад

    Can you please make a video and explain IRS and CDS swap Value at risk calculation?

  • @aakashshah9209
    @aakashshah9209 2 года назад

    Which Var method is this ? It’s totally confusing with other methods explained in other videos.

  • @danishrizwan8304
    @danishrizwan8304 2 года назад

    How to calculate var of a portfolio containing multiple stocks?

  • @kaushalthakker1682
    @kaushalthakker1682 4 года назад

    What do I do if I want to calculate Value At Risk in an index itself? What will be the risk factor?

  • @kirankumar-jx9jv
    @kirankumar-jx9jv 5 лет назад

    Hello Mr. Agarwal , the session was sweet & simple ...!, You have taken only the Beta value how about the intercept ? Looking forward for you comments

  • @sudipa2010
    @sudipa2010 3 года назад

    Why we need to fit a regression line between index's return and stock's return or to calculate beta? Couldn't we simply check the distribution of stock's return and get the 95th percentile value? Please explain.

    • @rohangholam8270
      @rohangholam8270 3 года назад

      That would be a plain Historical VaR, here we are doing Historical Simulation, hence we are simulating the future returns using a common risk factor aka Index i.e Nifty for which we need the stocks beta and then generate the future possible returns using historical data.

  • @kanavjain5916
    @kanavjain5916 4 года назад

    Why you don't sort the values from worst to best(from - to +) before calculating Final VAR?

    • @rohangholam8270
      @rohangholam8270 3 года назад

      The formula used in Excel does that for you, even i had the same question, hence i manually sorted and calculated as well used the formula. Answer comes out to be an exact match.

  • @putisalsabila1245
    @putisalsabila1245 5 лет назад

    can you make the explanation, why u using the tata steel and nifty?

  • @AbhishekSharma-kp2zs
    @AbhishekSharma-kp2zs 4 года назад +3

    Sir, please share the excel sheet.

  • @AbhishekMishra-kq3bi
    @AbhishekMishra-kq3bi 6 лет назад +1

    Link for excel sheet is not found. Please share .

  • @kunalmansukhani6244
    @kunalmansukhani6244 6 лет назад

    Pls provide the link for the relevant excel sheet.

  • @mohit66barolia
    @mohit66barolia 6 лет назад

    Sir, I didn't find the link for excel sheet.

  • @drrahulpralhadmore7489
    @drrahulpralhadmore7489 3 года назад

    please share the excel sheet sir, u have not give link here

  • @SandeepMishra-xi3jh
    @SandeepMishra-xi3jh 5 лет назад

    Where are the excel sheets? Karan Sir.

  • @danieldutra9570
    @danieldutra9570 3 года назад

    has anyone got the excel file?

  • @nt16_10
    @nt16_10 5 лет назад

    please provide the link for excel sheet

  • @vachemeliksetyan4149
    @vachemeliksetyan4149 Год назад

    плотную кинул

  • @umangjain7934
    @umangjain7934 4 года назад

    Sir sheet?

  • @onlyequities
    @onlyequities 5 лет назад

    Which course is this ??

    • @sachin-kr1ls
      @sachin-kr1ls 5 лет назад

      Ashutosh Shah .. this ca-final elective subject Risk Management i guess ... but concept is useful in all courses of RM

    • @BhavyaGupta
      @BhavyaGupta 3 года назад

      FRM

  • @cariddhithacker6862
    @cariddhithacker6862 3 года назад

    Sir, I want this excel sheet.
    Can you please mail me?

  • @manishkeer3108
    @manishkeer3108 5 месяцев назад

    Please provide sheet or link

  • @yogishetye
    @yogishetye 5 лет назад

    Sir Plz provide the excel sheet...

  • @jayshripatil8138
    @jayshripatil8138 4 года назад

    Please share the excel

  • @ahsaniqbal5108
    @ahsaniqbal5108 2 года назад

    please share Excel file

  • @putisalsabila1245
    @putisalsabila1245 5 лет назад

    can you make the explanation, why u using the tata steel and nifty?