Query to MSN Stock Scouter

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

  1. Manfred

    Manfred Guest

    Is it possible to create queries for MSN 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. That is, I'm not sure how to extract the numeric
    score
    from the 'special box' in which it appears.

    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 3, 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. Barney

    MSN Stock Quotes

    Barney, Aug 22, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    171
    Barney
    Aug 22, 2003
  2. JBE

    Stock Options Prices in MSN Money Stock Addin

    JBE, Feb 11, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    307
  3. nick

    Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers

    nick, Jan 2, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    607
  4. Guest

    How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel

    Guest, Feb 16, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    182
    Guest
    Feb 16, 2006
  5. Manfred

    Web Query With Multiple Stock Symbols & Stock Scouter

    Manfred, Mar 1, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    414
    Manfred
    Mar 1, 2006
Loading...

Share This Page