Automation Anywhere Call: 1-888-484-3535   

 
Automation AnywhereWeb 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.


T59.atmn

Note: Save the .atmn file in My Documents -> Automation Anywhere -> Automation Anywhere -> My Tasks

Solutions
Record a new task

  • Click on Tools->Web Recorder.
  • Enter the starting URL for e.g. finance.yahoo.com
  • Type in the stock quote for e.g. MSFT and click on GO.





Screenshot 1



Screenshot 2



Screenshot 3




Screenshot 4



Screenshot 5



Screenshot 6
Extract the prices of your stocks

  • Click on 'Extract Data' button from the toolbar in the bottom right-corner and click on the open or closing price of your first stock. Screenshot0.
  • You can save the extracted data into any user variable say $ClosingPrice$ or $OpeningPrice$. Screenshot1.
  • Do the same for all the data you need to extract.
  • Stop the Recording and Save it.
Create Stock Quotes List

  • Open the recorded task in Task Editor from Tools-> Task Editor.
  • Open Variable Manager tab located on right side of editor.
  • Double-click on my-list-variable and add the list of stock quotes
  • Save the list by clicking on ‘Save’ button in ‘Edit Variable’ dialog. Screenshot2.
Edit your task to get prices for list of stock quotes and log them in a text file

  • Insert ‘Loop for List Variable my-list-variable’ and place the commands that extract the prices into this loop block. You can find loop command under ‘Conditions/Loop’ command category.
  • Double click on command that types the stock quote value and replace the actual value i.e. MSFT with variable, $my-list-variable$ and save the command. Screenshot3.
  • Insert ‘Log to file’ command to log opening and closing price of each stock quote. You can find ‘Log to file’ command under ‘Program/Files/Windows’ command category.
Email the extracted prices

  • Insert a Send E-mail command that sends the text file holding the opening and closing prices of the stocks as an attachment. You can find ‘Send Email’ command under ‘Internet’ command category. Screenshot4.
  • See the entire task in Screenshot5.
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.
How to run the task:

  • In case you do not have Automation Anywhere installed, please download and install it from, http://www.automationanywhere.com/download/freeTrial.htm
  • Save T59.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks
  • Copy Data.xls under C:\
  • Launch Automation Anywhere and from Task List select T59.atmn and click on RUN button to run the task.

When you run this task, it launches the website finance.yahoo.com, extracts the opening and closing prices for list of stock quotes and emails them.
Buy Now Free Trial

Next Steps
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

25,000+ Customers
25,000+ Customers
Customer list | Case Studies

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 FacebookTwitterAutomation Anywhere Blog © Automation Anywhere 2010 Privacy Policy
Web Data Extraction Pattern Matching Automation Anywhere Free Trial