Is this possible?
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Is this possible?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have in a sheet in the range A1:A2500 the symbols of several stocks from the Nasdaq.
    Now I want a macro that link the follows:

    When I click on a symbol,the macro goes automatickly to the website http://finance.yahoo.com

    Can a macro do this link?
    Thanks.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    Try using a hyperlink instead. Right-click on the cell/text you want the link to be activated from and in the address bar type the address of the site.
    Will

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 11:00, willlobb wrote:
    Hi,
    Try using a hyperlink instead. Right-click on the cell/text you want the link to be activated from and in the address bar type the address of the site.
    Will
    Great,that works.But is there also a possibility to add the symbol in the adress of the homepage.For example:

    http://finance.yahoo.com/q?s=MSFT&d=v1

    so I don't have to type every time the symbol.Thanks in advance

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    not sure about that one, sorry.
    Will

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Why not create a web query which will refresh your figures without having to go to each individual website?
    Tom

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 11:19, TsTom wrote:
    Hi
    Why not create a web query which will refresh your figures without having to go to each individual website?
    Tom
    What do you mean with a web query and how to make it?I never heard about it.
    Have you any information?
    Many thanks

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Symbol Last Trade Change Volume
    MSFT 2:10pm 55.851 -0.479 -0.85% 22,575,800

    I'm assuming that is the only information you really need from the website.

    You can create a web query based upon the URL & the symbol you provided.

    The query will return the information you choose and update at a frequency you choose as well.

    For instance:
    Column A

    A1 Contains the symbol MSFT
    B1 Could have Last Trade Time
    C1 Volume
    D1 Price
    E1 ect....

    This query would refresh the information periodically on your spreadsheet without having to visit each individual website.

    Is that what you are wanting to do??
    Tom

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have to go.
    If you'd like...
    E-Mail me the main URL and the list
    of symbols and I will create a very simple web query.
    Please note the values you want the query to retrieve from each website.
    Gotta Go
    TsTom@hotmail.com
    Tom

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-04 11:30, TsTom wrote:
    Symbol Last Trade Change Volume
    MSFT 2:10pm 55.851 -0.479 -0.85% 22,575,800

    I'm assuming that is the only information you really need from the website.

    You can create a web query based upon the URL & the symbol you provided.

    The query will return the information you choose and update at a frequency you choose as well.

    For instance:
    Column A

    A1 Contains the symbol MSFT
    B1 Could have Last Trade Time
    C1 Volume
    D1 Price
    E1 ect....

    This query would refresh the information periodically on your spreadsheet without having to visit each individual website.

    Is that what you are wanting to do??
    Tom
    I still not know ho to make this web query and how this query refresh this information.
    Sorry.

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
  •  

 

 
DMCA.com