Loading...

Follow Reddit - The Future is Automation on Feedspot

Continue with Google
Continue with Facebook
or

Valid
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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!

If you are an employer / decision maker: [LINK]

If you are an employee / individual contributor: [LINK]

submitted by /u/WhoIsAtlas3
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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?

submitted by /u/Dpennaa
[visit reddit] [comments]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview