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