Yahoo Finance Major World Indices Yahoo Finance
Use Case Description
Step 1: Open browser and launch - Major World Indices - Yahoo Finance Major World Indices Yahoo Finance See the complete list of world stock indexes with points and percentage change, volume, intraday highs and lows, 52 week range, and day,( Link: World Stock Indexes: prices, charts, percent change, volume, and news - Yahoo Finance )
Step 2: Extract the table from the webpage as an excel file
Step 3: If the downloaded file is in CSV format, convert it to XLSX format.
Step 4: Query the records using excel as database. Consider only the first four columns .
Step 5: Remove “^” from Symbol column
Step 6: Remove “.” from Name column
Step 7: If the value in Change column is negative, then append " (Negative)" to the corresponding Name column value
Step 8: Save the excel as “youremail_FinYahoo_Day_Mon th_Year.xlsx”
AS-IS WORKFLOW, TO-BE WORKFLOW
-
Other information about the use case
Industry categories for this use case: Finance, Information Technology and Services, Manufacturing, Marketing Sales, Banking
Skill level required: Intermediate
UiPath Products that were used: UiPath Studio, UiPath Assistant, UiPath Orchestrator
Other applications that were used: Excel, Browser
Other resources: -
What is the top ROI driver for this use case?: Accelerate growth and operational efficiency