Extracting vital information related to top performing shares

Extracting vital information related to top performing shares

Use Case Description

Had created a BOT which extracts vital information related to top performing companies, by referring to 2 websites 1) Stock Exchange website 2) Depository website. The steps in short are as follows

  1. Go to the website for stock exchange
  2. Extract the daily csv file having the results related to all the scrips for current day
  3. Read the file and add the data in Database
  4. Query the database and extract the data related to top 5 scrips having highest closing balance
  5. Add the data to another file
  6. Read the ISIN from the new file having top 5 records
  7. Go the website for Depository and get the company names for the ISINs
  8. Populate the company names in front of each record (In the top 5 records file)

AS-IS WORKFLOW, TO-BE WORKFLOW

To Be Flow.pdf

Other information about the use case

Industry categories for this use case: Finance

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio, UiPath Assistant, UiPath Orchestrator

Other applications that were used: Excel, MS SQL Server

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency