Is this possible?

[verluc]

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.

 

[willlobb]

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

 

[verluc]

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

 

[willlobb]

not sure about that one, sorry.
Will

 

[Legacy 98055]

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

 

[verluc]

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

 

[Legacy 98055]

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

 

[Legacy 98055]

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

 

[verluc]

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.