• Click on Tools->Web Recorder.
• Type in http://www.smartmoney.com/ and click on Start
• Select a ticker symbol for e.g. 'MIDSX' in the search box and click on search button.
• When the mutual fund snapshot opens, click on 'Extract Table' button from the toolbar that appears on the bottom right corner.
• Click on the table that shows Total Returns and capture it. Screenshot 1
• Specify the .csv file to store the extracted information for e.g. C:\Funds.csv
• Stop Recording and Save the task.

• Using Variable Manager, create a variable called 'MyFunds' of type List.
• Specify to read the values from a text file.
• Specify the path of the text file as C:\Funds.txt.
• Specify the list of mutual funds values in the text file as shown in Screenshot 2

• The recorded task will extract the information for one ticker symbol.
• To make your task extract the information for the list of mutual funds you will need to modify the recorded task.
• Select the task and click on 'Edit' to open it in editor.
• Insert a Loop for List around the recorded action.
• Double-click the second line where you see your ticker symbol being typed and replace the ticker symbol MIDSX with the list variable $MyFunds$.
• If you did not close the browser as part of recording then insert a Close Browser command before the End Loop.
• The modified task will look as shown in Screenshot 3

Tip:

• After every Extract Table command is executed, you can use System Variable command, $Table Column(index)$ to extract the row data of the Table when the task runs.
• Using this System Variable you can also transfer the extracted data to any other application in any format you require

How to find which index to use in System Variable $Table Column$?

• While recording, when you click on the Extract Table and capture a table, it will ask you for a csv file name.
• Specify a valid filename.
• Run the recorded task once. It will generate the csv file.
• Open the csv file in Excel and find out which column your data is in and that is the index you need to use.

• Select the task in the main Automation Anywhere window and click on Schedule Tab.
• Specify the schedule options such that your task runs Daily at your desired time.