I thought the same thing when I was watching a friend do this work at 2 AM on a Friday night.
Then I realized it doesn’t cost the investment bank a single penny to ask an analyst to spend his weekend doing cut and paste work, whereas automating the process would cost something.
The analyst will still work till 3 am, but will do 3x more spreadsheets. For the same pay.
it is really not a solved problem
Reading standard financial forms isn't a solved problem?
Worked on bank to bank middleman software. There is no 'standard' form.
How complicated are those forms? It sounds like GS would pay a lot for a software that converts 95% of the data into excel spreadsheets.
Tell me about it
...guy working on doing just that
And probably the big investment firms want to keep it that way, because they can exploit humans to do this work. While their smaller competition can't.