You are here: Home » All Software Solutions » How to extract open & close price of a stock from a webpage?

Categories

See all categories

How to extract open & close price of a stock from a webpage?

Automation Anywhere is an intelligent automation software for IT & business processes.
This month's most popular software guide you should know - How to move photos from my iPhone to my computer


1.
 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.
2.
 Extract the prices of your stocks
  • Click on 'Import 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.
3.
 Save the prices to variable
  • After every Import 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 as show in Screenshot 1 to assign the value of the closing price to variables.
4.
 Email the extracted prices.
  • Insert a Send E-mail command that sends all the variables holding the opening and closing prices of the stocks Screenshot 2
  • The Complete Task would like as show in Screenshot 3
5.
 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.

Screenshot 1:

Automation Anywhere

Screenshot 2:

Automation Anywhere

Screenshot 3:

Automation Anywhere

Related Software: Automation Anywhere -    

Recommended Essentialware
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.

Recommended Mac Software
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.

by on 22/08/2007Web Developer
Tags:Automation Anywhere, import data from excel to acess, automate complex task, intelligent automation software for it, intelligent software, automation software for business

Tips & Guides Related to How to extract open & close price of a stock from a webpage?

Rss

Software Guides

on Web Developer

See all

Top Reviews

on Web Developer

  • Adobe Flash Player - SWF Player
    Adobe Flash Player - SWF Player

    "Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."

    by Owen Wilson on Sep 7, 2009

  • Flash Gallery Builder
    Flash Gallery Builder

    "Flash Gallery Builder Reviews & Free Download"

    by Heren Watson on Jan 10, 2008

  • CoffeeCup HTML Editor
    CoffeeCup HTML Editor

    "CoffeeCup HTML Editor Reviews"

    by Dr. File Finder on Jan 29, 2008

  • SiteSpinner
    SiteSpinner

    "SiteSpinner Review & Download"

    by Dr. File Finder on Feb 23, 2008

See all