3 ms·
From the submitted link: "The desire to price increasingly complex deals with increasingly large datasets" Bingo! Most people use Excel when they actually sho
by newdude116 6y ago
From the submitted link:
"The desire to price increasingly complex deals with increasingly large datasets"
Bingo! Most people use Excel when they actually should use a database. I am sure you can use Excel with a database like MS Access, but then again, who does?
To your arguments:
1. " and good luck getting I.T. to support Docker on Windows desktops." Yah. Great experience to work with Excel on Linux.
2. You can always link compiled code for stuff that needs to be fast. But in the end most people wont use neither python nor Excel for HFT
3. " it's relatively easy to figure out what a mangled and convoluted formula is doing"
https://www.sciencemag.org/news/2016/08/one-five-genetics-papers-contains-errors-thanks-microsoft-excel https://www.sciencemag.org/news/2016/08/one-five-genetics-pa...
https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-papers-contain-excel-errors/ https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-al...
https://www.sciencealert.com/excel-is-responsible-for-20-percent-of-errors-in-genetic-scientific-papers https://www.sciencealert.com/excel-is-responsible-for-20-per...
4. Maybe. Not sure it is really an issue.
- cutler 6y agoThe case for using a database with Excel is at least as strong as for using Python or C# to model Excel data. There are excellent free adapters for MySQL and PostgreSQL.