+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Smart Tag Stock Quotes?

  1. #1
    Registered User
    Join Date
    08-07-2008
    Location
    California
    Posts
    8

    Smart Tag Stock Quotes?

    Is it possible to use the Smart Tag feature in Excel 2007 to reference one cell that has a stock ticker in it and then:
    1. Populate a cell with the company name
    2. Populate a different cell with the closing price of the stock?

    ie,
    Cell A2 has the Ticker symbol
    Cell A3 will get the Company name
    Call A4 will get the closing price

    It seems that you have to accept a lot more information when using this feature.

    Any ideas?

    Thank you,
    Barney

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    Use the Smart Tag feature to pull the data into Excel on a scrap sheet, then use references to draw the data from there onto your formatted sheet to look the way you want/prefer.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-04-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    stock quotes in excel

    Hello,

    you can also use Financial Link for Excel to load updating stock quotes, financial statements, estimates, price histories into Excel. Easy-to-use formulas to load the data and also wizards to help you creating the formulas.

    More detailed information here:

    http://www.xlconsulting.net/flink.php

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1