- Joined
- 8/21/17
- Messages
- 25
- Points
- 13
Thank you
Here is the MS Stuff spreadsheet many have asked about. I usually go through this in my classes. Please do not ask me to annotate it or provide additional details.
I'm sure you know more than you realize you do. Mathematical/statistical wisdom, IMHO, is understanding the boundaries of your knowledge, knowing how to frame a problem, and knowing when to call in an expert.This thread is a reminder of how little I know, even after a decade in the industry. Thanks for sharing!!
This thread is worth!This thread is a reminder of how little I know, even after a decade in the industry. Thanks for sharing!!
Here's some stuff on gold:Commodities
Thanks. What a surprise to see you comment on the video that this was posted.This is the VaR calc extracted from the "MC Stuff" lecture I gave at MIT.
It's VBA embedded in the spreadsheet. Similar algorithms can be seen in:Professsor can you please tell me what add in was used to calculate the Eigenvalues and Eigenvectors for the covariance matric. I can't seem to replicate the steps on my excel spreadsheet
ThanksIt's VBA embedded in the spreadsheet. Similar algorithms can be seen in:
FreeVBCode code snippet: A Function That Computes the Eigenvalues and Eigenvectors For a Real Symmetric Matrix
YoichiroUrita/Math
YoichiroUrita/Math
Some clearly are, but most are pretty general in nature; a gaussian copula now was calculated the same way in 1990. That said, I am considering doing a "culling" of these.I wonder if the resources are still not outdated.
The approach is basically the same. The tricky part is the way the BIS wants it reported. In addition to the ES using a full datatset, you must also do en ES with a limited dataset, and a "worst case" ES, historically. In addition, there are somewhat complex liquidity adjustments to be made. I expect to see a lot from Big 4 and other consulting firms on actual implementation.@Ken Abbott
Any new reading on VaR being phased out and replaced by Expected Shortfall (ES)?
When will MFE programs update their curriculum to focus less on VaR?