Using NAG with Excel for quant development and quant analysis
Many of our users call NAG from Microsoft Excel®. We have updated examples to link to the latest library versions and added new examples (including Nearest Correlation Matrix (NCM) with the k-factor structure) of some of the latest routines.
There are also examples to help new users learn how to make the best use of NAG from Excel. Take a look at all the examples at http://www.nag.co.uk/numeric/nagandexcel.asp
Learn how to maximize Excel’s potential with the NAG Library One of the major benefits of the NAG Library is its inherent flexibility; it can be used by programmers developing in traditional languages, or by users of modern…
Hi all Excel users!
I have recently posted a short piece on nonlinear least-squares optimization in Excel on our Blog: http://blog.nag.com/2012/02/how-to-solve-nlls-problem-using-sqp.html
Has anyone tried solving this type of problem in Excel? Has anyone stumbled upon RtlMoveMemory and got annoyed with using it?
NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!