| Solution |
| 1. | Record a new web recorder task |
- Click on Tools->Web Recorder.
- Enter the starting URL for e.g. finance.yahoo.com
- Type in the list of stock quotes and click on GO.
- Go to Summary View so that you can see the closing prices of your stocks in tabular format.
|
| 2. | Extract the prices of your stocks |
- Click on 'Extract Table' button from the toolbar in the bottom right-corner and click on the Table
that displays the open and closing price of your first stock. You can optionally save the tabular data to a csv file.
- Do the same for all of your stocks.
- Stop the Recording and Save it.
|
| 3. | Save the prices to variable |
- After every Extract Table command is executed, you can use System Variable command, $Table Column(index)$ to extract the row data of the Table.
- To store extracted values, go to Tools->Variable Manager and create 4 new variables of type 'value'. msft-open, msft-close, ibm-open and ibm-close.
- Edit your recorded task and insert the commands as show in Screenshot 1
to assign the value of the closing price to variables.
|
| 4. | Email the extracted prices. |
- Insert a Send E-mail command that sends all the variables holding the
opening and closing prices of the stocks Screenshot 2
- The Complete Task would like as show in Screenshot 3
|
| 5 | Schedule the task |
- Select the task in the main Automation Anywhere window and click on Schedule Tab.
- Specify the schedule options such that your task runs Daily before the stock market opens and after it closes.
|
| |
| When you run this task, it launches the website finance.yahoo.com and displays
the stock prices summary and extracts the opening and closing prices and emails them. |
Automation Anywhere - The Automation Software
