How to insert Stock quotes from Web?

Discussion in 'Microsoft Excel Programming' started by Arizona, Nov 17, 2006.

  1. Arizona

    Arizona Guest

    HI Folks,

    I need to insert a current stock price into a single cell of an Excel
    worksheet. When I go to Data > Get External Data >Run Saved Query >MSN
    Money Stock quotes, the whole web page gets inserted. There's another
    way somone suggested using smart tags (I think it only works on
    Windows), but with smart tags the stock ticker is inserted with the
    price. I want to put the current stock price and only the current stock
    price in a targeted cell. And I would like to be able to refresh with
    current data easily. Is there a fairly easy way to do so? Could someone
    tell me how step by step? Would much appreciate.

    PS: I use a MAC at home with OS10.3.9, and EXCEL 2004. I have Windows
    at work, but prefer to use my MAC at home for stock research.

    Thanks,
    ~Arizona
     
    Arizona, Nov 17, 2006
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. DDE link update for stock quotes

    , Aug 27, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    398
  2. Guest

    Stock Quotes from web

    Guest, Aug 20, 2006, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    172
    Guest
    Aug 20, 2006
  3. Stock Quotes from Web

    , May 4, 2007, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    250
    Jon Peltier
    May 4, 2007
  4. Melwin

    Stock quotes from web site

    Melwin, Apr 28, 2008, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    124
    ryguy7272
    Apr 29, 2008
  5. Andrew P.

    Exporting to .txt converts single quotes to double quotes

    Andrew P., May 25, 2010, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    625
    Andrew P.
    May 27, 2010
Loading...

Share This Page