If you’re reliant on third party add-ons you don’t have a choice. Bloomberg and Eikon are two examples that didn’t have a good Python API back then. Even after I started to use Python more sometimes I had to script opening up Excel itself, forcing formula refresh and exporting that.
You also need to consider that average Joe at a big financial corporation knows Excel so he uses that for everything. People that know Python are more expensive.
Oh, I definitely get that the major appeal of excel is a close to non-existent barrier to entry. I mean, an elementary school kid can learn the basics(1) of using excel within a day. And yes, there are definitely programs out there that have excel as their only interface :/ I was really referring to the case where you have the option to do something “from scratch”, i.e. not relying on previously developed programs in the excel sheet.
(1) I’m aware that you can do complex stuff in excel, the point is that the barrier to entry is ridiculously low, which is a compliment.
If you’re reliant on third party add-ons you don’t have a choice. Bloomberg and Eikon are two examples that didn’t have a good Python API back then. Even after I started to use Python more sometimes I had to script opening up Excel itself, forcing formula refresh and exporting that.
You also need to consider that average Joe at a big financial corporation knows Excel so he uses that for everything. People that know Python are more expensive.
Oh, I definitely get that the major appeal of excel is a close to non-existent barrier to entry. I mean, an elementary school kid can learn the basics(1) of using excel within a day. And yes, there are definitely programs out there that have excel as their only interface :/ I was really referring to the case where you have the option to do something “from scratch”, i.e. not relying on previously developed programs in the excel sheet.
(1) I’m aware that you can do complex stuff in excel, the point is that the barrier to entry is ridiculously low, which is a compliment.