In this example, we have a set list of stocks that we want to collect price history for: SPY, MSFT, and NUAN.
We used RPA to solve this issue and while I can’t show that solution here, I’m going to walk you through a similar solution where we will extract stock information for several stock ticker symbols. We needed to gather the permissions for each eRoom but we had no way of exporting all of the info that we needed so we would’ve had to manually enter that information into spreadsheets for over 400 eRooms. I’m currently working on a large eRooms migration and my team and I found several use cases where RPA saved us a ton of time. In fact, one of my examples is of that very thing where we accept data from a web form and watch the solution automatically fill out fields in a legacy. I’ve had several speaking engagements over the last few months where I walk the audience through how to get started with Robotic Process Automation (RPA) using Power Automate Desktop to automate manual tasks and often the first thought that people have is to use RPA for data entry.