Re:Ditching Excel for Python in a legacy industry
by newdude116 on Thursday December 31, 2020 @05:39AM
(#25591497)
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"
Re:Ditching Excel for Python in a legacy industry
by cutler on Thursday December 31, 2020 @12:50PM
(#25595009)
The 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.
"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-pa...
https://www.washingtonpost.com/news/wonk/wp/2016/08/26/an-al...
https://www.sciencealert.com/excel-is-responsible-for-20-per...
4. Maybe. Not sure it is really an issue.