Help needed to build the followinbg use case in uipath

Help Studio
, , ,
1

Hi,

Can someone help with the creation of the following use case in UiPath studio? Thanks!

The Task

We want to share information about the most advanced and declined stocks with an internal user over email.
General Notes
• There should be two separate automations dispatcher and performer.
• The performer should use the RE framework.
• All user accounts/emails should be configurable.
• Please specify all assets to be set up and their values. If credentials, please do not share.
• Put the two automations/folders into a single zip file to send on.
• Use any packages from the Official, Marketplace, or Microsoft visual studio offline packages.
• Please consider code/activity structure and readability.
Step 1: Get the most advanced + declined stocks

  1. Navigate to https://www.nasdaq.com/market-activity/stocks
  2. Read all the data from the table ‘Most Advanced + Declined’
    a.
  3. Store each row with data as a queue item to be processed by the second automation.
  4. Add a single stock to the queue where the ‘Symbol’ does not exist… e.g.
    a. Symbol: AB67
    Step 2: Perform the reporting task
    For each queue item perform the following tasks. For each task please set sub-status on the queue item to a relevant value.
  5. Using the ‘Find a Symbol’ functionality find the symbol
  6. Navigate to ‘Historical Quotes’ on the left menu
    a. Extract the data for 6 months (6M)
    b.
  7. Export this data to a CSV file including all the fields on the table, with the additional columns and changes:
    a. For the existing Date column please output it as DD/MM/YYYY. E.g. 31/01/2021.
    b. Difference: the difference between the High and Low Columns.
    c. Volume Indicator: if the volume is under 20,000,000 this column should be ‘Low’. Over 20,000,000 this value should be ‘High’.
  8. Email this data to a configurable email address
    a. For the end user in the body of the email please include the key data from the ‘Summary’ page listed under Quotes on the left-hand menu of the stock.
    i.

Exceptions
• Please handle the non-existing stock symbol that was created in the dispatcher as a Business rule exception and email a configurable user’s email with the notification.
• In the Key Data, if there is no Market Cap value (i.e. it is ‘N/A’) please treat this as a System Exception.
• Please handle any other System or business exceptions you see fit.

2

@Ruchita_Patil
where is usecase

3

Hello @Ruchita_Patil

where you are getting stuck and what help is required?

Thanks