4 ms·
I used Excel professionally for 20+ years as a quant in major banks. Mostly as a front end to mathematical models in C++. Always been amazed how a 40 years old
by dmaevsky 6y ago
I used Excel professionally for 20+ years as a quant in major banks. Mostly as a front end to mathematical models in C++. Always been amazed how a 40 years old UX paradigm is still being used virtually unchanged in modern systems.
Spreadsheets are truly ubiquitous in the financial industry, and for 20 years I've been struggling with exactly the same issues mentioned in the article and in other comments here.
The problem is that neither Excel, nor most alternatives treat a spreadsheet as code that it essentially is. And being code, it needs to
- be source control friendly
- be testable
- have business logic (formulas) decoupled from presentation
Only then one can seriously consider using a spreadsheet as part of any production grade system.
For the past couple of years I've been working on https://ellx.io https://ellx.io - a platform for visual reactive programming and a new generation spreadsheet/notebook designed to solve exactly this pain point.
Here are some examples of what you can do with it:
[1] https://ellx.io/dmaevsky/monte-carlo https://ellx.io/dmaevsky/monte-carlo
[2] https://ellx.io/matyunya/tensorflowjs-simple-demo https://ellx.io/matyunya/tensorflowjs-simple-demo
[3] https://ellx.io/ellx-hub/plot https://ellx.io/ellx-hub/plot