I want to show a real time stock quote in a cell

heilesen · Mar 16th, 2002, 09:22 AM

I would like to display a realtime stock quote in a cell.

Anne Troy · Mar 16th, 2002, 09:42 AM

I think we'll need a little more information than that. Where are you going to get the quote from?

heilesen · Mar 16th, 2002, 09:54 AM

http://www.nyse.com/marketinfo/marke...m=ge&links=%23

I would like to get the quote off of a web page such as the link above.

To make a long story short. I would like to have an excel spreadsheet monitor my stocks if they reach above a limit they will run a macro to exicute a "sell" the same would go for purchasing.

rpwagner · Mar 16th, 2002, 10:25 AM

If you use Qcharts, they have a qlink that can do just that

Mar 16th, 2002, 09:42 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	I think we'll need a little more information than that. Where are you going to get the quote from? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 16th, 2002, 09:22 AM	#1
heilesen New Member Join Date: Mar 2002 Posts: 4	I would like to display a realtime stock quote in a cell.

Mar 16th, 2002, 09:54 AM	#3
heilesen New Member Join Date: Mar 2002 Posts: 4	http://www.nyse.com/marketinfo/marke...m=ge&links=%23 I would like to get the quote off of a web page such as the link above. To make a long story short. I would like to have an excel spreadsheet monitor my stocks if they reach above a limit they will run a macro to exicute a "sell" the same would go for purchasing.

Mar 16th, 2002, 10:25 AM	#4
rpwagner New Member Join Date: Feb 2002 Location: Robert P. Wagner Posts: 22	If you use Qcharts, they have a qlink that can do just that