3 ms·
I was on a trading floor 2 weeks ago and every trader workstation I saw had an Excel session running. Of course they were also running bank approved production
by keithalewis 4y ago
I was on a trading floor 2 weeks ago and every trader workstation I saw had an Excel session running. Of course they were also running bank approved production systems, but every one of those have an Export to Excel option. Traders like control and don't like to be held hostage to IT groups that "take too long" to write code.
Microsoft has been piling tons of money into Excel in recent years to make it even more useful. Dynamic arrays are a game changer and they have recently released a slew of new array functions to leverage off of that.
The ancient C SDK is still supported to enable adding functions that can call C/C++/Fortran code. I wrote a library to make that simple: https://github.com/xlladdins/xll https://github.com/xlladdins/xll.