Web Query With Multiple Stock Symbols & Stock Scouter

Discussion in 'Microsoft Excel Worksheet Functions' started by Manfred, Mar 1, 2006.

  1. Manfred

    Manfred Guest

    I have a couple of questions about Web querying with Excel. First, is it
    possible to create queries for Stock Scouter rankings on a column of stock
    symbols consisting of, say, 100 stock symbols?

    The link to Microsoft's basic html link to obtain a Stock Scouter rank is
    shown below, with the symbol for Microsoft (symbol=MSFT) as shown at the end
    of the link:

    http://moneycentral.msn.com/investor/srs/srsmain.asp?Symbol=msft

    So, I'm hoping to use the above link for a single column of about 100
    symbols, which will change weekly, on a spreadsheet, with the accompanying
    Stock Scouter score queried and displayed in an accompanying column. The
    two confusing (for me) problems I have with this objective are:

    1) The symbols for the single column will change weekly, and it would be
    useful if Excel could accomodate the change.
    2) I don't quite understand how to use the HTML link above in context of the
    changing symbols and what gets displayed in each cell. All I'm interested
    in obtaining is the numeric score for each symbol without any additional
    information from the page.

    If this is possible to do with Excel, can instructions be posted for a
    technophobe on how to do this?

    Thank you for any assistance.
     
    Manfred, Mar 1, 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. Guest

    Smart Tags and Stock Symbols

    Guest, Jan 5, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    269
    Guest
    Feb 13, 2006
  2. Guest

    How do I get the symbols for Unit Trusts for MSN Money Stock Quot

    Guest, Feb 15, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    595
    Steve1154
    Feb 15, 2006
  3. Bohica

    Scoring/Ranking 2 Columns of Stock Symbols

    Bohica, Feb 28, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    7
    Views:
    222
    Manfred
    Mar 1, 2006
  4. Manfred

    Query to MSN Stock Scouter

    Manfred, Mar 3, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    536
    Manfred
    Mar 3, 2006
  5. Jean

    do I get Excel 2008 to recognize ALL stock symbols?

    Jean, Feb 6, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    261
    Don Guillett
    Feb 6, 2008
Loading...

Share This Page