A place for the discussion of automation, additive manufacturing, robotics, AI, and all the other tools we've created to enable a global paradise free of menial labor. All can share in our achievements in a world where food is produced, water is purified, and housing is constructed by machines.
Hello! I represent a research group at Georgia Tech that is seeking to gather data on corporate retraining programs in the United States. Would you mind filling out a short survey? The results are all anonymous, and we would greatly appreciate your participation. Thank you!
I recently graduated and started a job in finance, specifically in commodity trading, at a company going through a transition. I got hired as a junior trader, not a quant or a data scientist, but I have some experience with Python and it’s becoming apparent that I could make a difference in this job if I clean up the mess that is this company’s VBA- based automation.
Basically, every day/ month, there are position reports, market queries, pricing tools, forecasting models, etc that run in VBA. Some things as complex as spreadsheet models with macros that run other macros that pull huge amounts of data from web services we pay for. Some run a macro in a very complex workbook (10-20 sheets with a lot of formulaic relationships) and then publish the sheet into an email and automatically send it with Windows Task automation. The problem is that the various different processes are a clusterf* often coded by people that don’t work here anymore or pull from multiple different websites and I am not very good with VBA so this is goin to be a tall task.
I consider myself intermediate with Python because I’ve used it for data analysis so id love to click refresh and spend the next few months rebuilding everything in Python. Basically, do you guys think Python would be capable of this? How well does it interface with excel (filling external data into templates, publishing excel workbooks to emails in outlook, etc)?
Tl;dr can Python replace VBA scripts/ macros to automate the data analysis/ aggregation processes of a commodity trading firm?