Automation Anywhere Call: 1-888-484-3535   

 
Web Data Extraction
  Home > Product > Solutions > Web Data Extraction > T59  
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.
Automation Anywhere

Next Steps
Buy Now Buy now
Download Free Trial Download free trial
Compare versions Compare versions
Watch a flash demo Watch a flash demo
Contact me Contact me
Ask the Expert Ask the Expert
Request live demo Request live demo

Call 1-888-484-3535

Our Customers
ibounce

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 >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark © Tethys Solutions 2008 Privacy Policy
Web Data Extraction (structured) Web Data Extraction Automation Anywhere Free Trial