Matrix math functions like the following are available in Excel:
With such functions, one can perform calculations from EasyLanguage (linked to Excel via XLInputs.dll) as follows:
- Pass values to Excel with XLO.Num functions
- Trigger a calculation with XLO.CalcSheet, XLO.CalcRngA1 or XLO.CalcRngRC
- Retrieve results with XLI.NumRep functions
XLInputs is sold here: https://shop.qclsolutions.com/XLInputs-101.htm
If you need EasyLanguage and a demonstration setup to perform custom calculations, rates are very reasonable.
