How to Calculate Daily & Annual Sharpe in Excel

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

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

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

    Excellent explanation of a complex topic! Many thanks. Can you please make a separate video on the calculation of the Sharpe ratio of the Option strategy?

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

      please subscribe my channel, I can cover a lot of topic. including calculation of the Sharpe ratio of the Option strategy

  • @aedu777
    @aedu777 3 года назад +2

    I was confused till now,, thank you very much!!

  • @bwsfca
    @bwsfca Год назад +4

    On your Daily calculation you are removing 5% daily rather than (SQRT(252)*.05). Your sharpe should be higher on the daily. Meaning the risk free rate is not a daily return, its an anuual return.

  • @farzanabegum5387
    @farzanabegum5387 2 года назад +1

    How are you calculating return?
    Can you plz explain how did u get those values under return column

  • @aryankulshreshtha5236
    @aryankulshreshtha5236 2 года назад +3

    Please make a video on Max drawdown, Hit-ratio. Thanks!

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

      already done, please check in my channel

  • @purpleheart5671
    @purpleheart5671 8 месяцев назад +2

    How you conclude that risk free is 5%

  • @annabaumbach6660
    @annabaumbach6660 3 года назад +1

    absolutely life-saving, thank you very much !

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

    Also,
    on 7:57
    Why did you use Sqrt 252 and not Sqrt (252/60)

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

    video is blurry