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.