4 ms·
Worked for a company whose automated options trading system was an.... excel spreadsheet. Every now and then I would need to RDP to a machine to RDP into anothe
by chaps 2y ago
Worked for a company whose automated options trading system was an.... excel spreadsheet. Every now and then I would need to RDP to a machine to RDP into another machine to restart it. Pain. So much pain.
- actionablefiber 2y agoI think it's important to think of Excel as a tool for modelling reality and not a tool for changing it. IMO Excel should not be producing data feeds that other tools expect real time access to, nor should it make API calls that mutate state on other platforms.
- goodlinks 2y agoCheeky response.. It would take a 1 year project and 5 devs to replace what one finance person created in a day. Then when it didnt work complain the SME got the requirements wrong. Im being silly but as a dev i hate the hate for excel, though i know from years of experience that its also a nightmare.
- mp05 2y agoI'm sure they were glad they had you to fix their problems!
- worewood 2y agoAt that point why not code something using the Interop APIs to programatically interface with the spreadsheet? It's a PITA to code but it works.
- throwaway2037 2y agoWhat year?