Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Web Query

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Guys...I'm looking to add a single stock ticker to my spreadsheet. I'm working in Excel 2000, so I'm guessing the option to use is the "Data---> Get External Data---> New Web Query..." The thing is, I navigate to the site I want that contains the ticker, and then when I go to specify which table it is, I have no clue, even after looking at the html code. Anyone know how to identify the name of a table, such as in my case? Or, if anyone has any other ideas/advice as to how to accomplish my objective other than this way, please do not hesitate to clue me in! Thanks...

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help topic for "Get data from a Web source". Look specifically at the Notes section.

    What web site are you trying to use?

    [ This Message was edited by: Mark W. on 2002-02-26 12:43 ]

  3. #3
    Guest

    Default

    I'm fine with getting the data onto the spreadsheet...what I would like is to only list the current market price, without all the other info that is usually contained in the table containing this. For example, usually the table containing the current price also has opening price, # of shares, volumes, change in price, etc. I only want to have the current market price appear in my sheet, and I don't know how to only bring this value into excel...any ideas?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Send the url of the page that the ticker is on and maybe someone will be able to extract just that for you or work something out.



    Regards,

    Gary Hewitt-Long

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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