4 ms·
What's your opinion on VBA? I have successfully used it to build quite complex applications (position management in trading) and found it fast, reliable and eas
by pillefitz 5y ago
What's your opinion on VBA? I have successfully used it to build quite complex applications (position management in trading) and found it fast, reliable and easy to develop in a fraction of the time it took me to build an Electron application.. I have a really hard time going back to modern JS frameworks after having been exposed to Excel..
- starik36 5y agoIf Microsoft would update the core VB language to be a bit more modern, I bet a lot more professional developers would descend upon it. As it stands now, it’s in limbo because you can’t use it in the web version of excel.
- pjmlp 5y agoThey introduced Lambda, M Code and PowerQuery instead. I guess F# like is modern enough.
- lordnacho 5y agoI used it for the same back in 2003, so maybe my views are outdated. I think it only works because when you're on the trading desk things need to be done yesterday. For scripting a thing or two it's not terrible, but back then it wasn't so easy to split out the code for version control. Some formula for pricing this or that is gonna work in whatever language anyway and doesn't change a whole lot though. It was when I started to pull FIX connections into it that I thought maybe it's time to do things properly. Then you're suddenly in need of understanding how the execution model works. Also as soon as you need to follow a schema Excel is too soft. It's trivial for someone to just add an extra bit of info on a row that throws everything.