 |
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.
|
T59.atmn
