Search results

  1. A

    Geometric Returns of negative interest rates

    Dear Mr David Kevin Dowd in his book Measuring Market Risk (2nd Edition) has mentioned the advantages of using the Geometric returns over Arithmetic returns (3rd chapter). In fact I always quote following example – Suppose an asset was trading at the prices as given below – May 15, 2017 - $50...
  2. A

    Win prizes for forum participation!!

    D Dear Ms Nicole and Mr David, Thanks a lot for this honor. I will like to accrue it for future use i.e. may be purchase of BT package in future. Regards Ashok
  3. A

    Calculating Expected Shortfall

    Dear Mr David and emilioalzamora1 Thanks a lot for your great guidance. It's true I am being greatly influenced by Kevin Dowd :). This forum helps to refine and polish our knowledge. Thanks once again. With best regards Ashok
  4. A

    Calculating Expected Shortfall

    Hi I am not sure if this will in any way help. Please refer to the attached excel for understanding why (n-1) and not 'n'. Assumptions : Assuming losses follow Normal distribution with Mean '0' and Standard Deviation =1 and we are computing 95% VaR. Hence, in Excel, you can compute VaR@95%...
  5. A

    VaR using Monte Carlo Simulation (Geometric Brownian Motion)

    Dear Berrumucho, Thanks a lot for the link. Technical document is really a worth reading at least a couple of times. It was very useful. Thanks again Regards Ashok
  6. A

    Can you please post this question on regular forum (Unfortunately I am not able to find the...

    Can you please post this question on regular forum (Unfortunately I am not able to find the question on Forum)? I can reply this question if you wish
  7. A

    VaR using Monte Carlo Simulation (Geometric Brownian Motion)

    Dear berrymucho, Thanks a lot for this valuable input. Now I have some clarity about the whole stuff. As regards point no (2), yes I use CRAN R extensively and will definitely go through the package MVN. Heartfelt thanks again. Regards Ashok
  8. A

    VaR using Monte Carlo Simulation (Geometric Brownian Motion)

    Hello Mr David, I do understand the Historical Simulation as well as Var covar method, Especially in VaR Covar mapping of multiple positions into standardized risk factors as well as application of EWMA etc also I am aware. But when it comes to Monte Carlo, I am always confused. (1) I remember...
  9. A

    Historical VaR

    Dear Mr David, Thanks a lot for an elaborate reply. Appreciate the same and your this helping nature make us feel very very connected to Bionic turtle. Thanks again Regards Ashok
  10. A

    P2.dowd.chapter 5

    Mr David This link is broken http://www.bionicturtle.com/how-to/spreadsheet/5.d.2._gaussian_copula Regards Ashok
  11. A

    Tracking error VAR

    Dear Mr David, Are these links available? http://www.bionicturtle.com/learn/article/tracking_error_7_min_video_foundation/ http://www.bionicturtle.com/premium/spreadsheet/1.a.7._simulation_tracking_error_sortino/ http://sheet.zoho.com/public/btzoho/trackingerror-v1 Regards Ashok
  12. A

    Historical VaR

    Dear Mr David, I was trying to understand the excel 0423-cholesky.xlsx. If possible, can you please clarify my following doubts please. Suppose as given in excel, we have 5 risk factors. Assuming we have (say) 251 trading days and hence 250 daily returns. For each of these 5 risk factor...
  13. A

    Historical VaR

    Dear Mr David Thanks a lot for your great help. As usual very very informative and useful excels. Regards Ashok
  14. A

    Historical VaR

    Dear Mr David, Where can I get the following excels? http://www.bionicturtle.com/how-to/spreadsheet/p1.t4.a-xls-bundle and https://www.dropbox.com/s/wb3o7f667v9g4be/8.b.2_Jorion_analytical_VaR_v2.xls Unfortunately both links are not working. I am trying to learn VaR computation using Monte...
  15. A

    Key rate hedging

    Thanks a lot Mr David. Regards Ashok
  16. A

    Key rate hedging

    Mr David, Seems this link http://www.bionicturtle.com/how-to/question/market-risk-tuckman-chapters-6-7-9-21-l2.t5/ is missing. Please do the needful. Regards Ashok
  17. A

    key rate and bucket exposures

    Thanks Ms Nicole Regards Ashok
  18. A

    key rate and bucket exposures

    Mr David Even this link (http://www.bionicturtle.com/how-to/article/2012.p2.t5.-focus-review-1st-of-8/) is also missing. Regards Ashok
  19. A

    key rate and bucket exposures

    Mr David, This link (http://www.bionicturtle.com/how-to/spreadsheet/2012.5.b.3.-key-rate-shift) is missing. Where can I find it? Ashok
  20. A

    VaR and ES

    Dear Mr David, Thanks a lot for this very very informative and prompt reply. Helped a lot to clarify few basic things. Regards Ashok
Top