| T59 - Extract stock data from a web page |
| Task Description |
Monitor the opening and closing prices of your stock portfolio and email them. This sample task uses an example from finance.yahoo.com just for illustrative purposes.
|
| Solutions |
 |
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.
|
Screenshot 1
Screenshot 2
Screenshot 3
|
 |
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.
|
 |
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 to assign the value of the closing price to variables.
|
 |
Email the extracted prices
- Insert a Send E-mail command that sends all the variables holding the opening and closing prices of the stocks
|
 |
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. |
|
 |
| We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys. |
- Jack Greenberg
|
| Read Customer Testimonies >> |
|
