import stock prices

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron Patterson - 03 May 2008 21:48 GMT

I keep trying to import an individual stock price to a single cell but the
Data/Import External Data/New Web Query system seems to only allow me to
only import a whole table which of course changes my whole spread sheet.
Any suggestions on how to just import only the current stock price to a
single cell?
Ron Patterson

Reply to this Message

Don Guillett - 03 May 2008 23:50 GMT

Import to another sheet and use a macro or indirect formula to import to
where desired. Look here.
goto
xltraders-subscribe@yahoogroups.com
and look in the files section. There are several free files.
I have a couple of free files under author donalb36

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I keep trying to import an individual stock price to a single cell but the
>Data/Import External Data/New Web Query system seems to only allow me to
>only import a whole table which of course changes my whole spread sheet.
> Any suggestions on how to just import only the current stock price to a
> single cell?
> Ron Patterson

Reply to this Message

Ron Patterson - 04 May 2008 19:14 GMT

Thanks for the effort Don, but macros and indirect formulas are way over
this user's head. I am lost already.
And I tried to go to xltraders-subscribe@yahoogroups.com but it is an email
address apparently, not a web page.

Any other suggestions?

Thanks,
Ron

> Import to another sheet and use a macro or indirect formula to import to
> where desired. Look here.
[quoted text clipped - 9 lines]
>> single cell?
>> Ron Patterson

Reply to this Message

Don Guillett - 04 May 2008 19:51 GMT

Here is the web site but you will have to subscribe to get any free files.
http://tech.groups.yahoo.com/group/xltraders/files/
You may send your workbook to me at the address below to have a look.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Thanks for the effort Don, but macros and indirect formulas are way over
> this user's head. I am lost already.
[quoted text clipped - 20 lines]
>>> single cell?
>>> Ron Patterson

Reply to this Message

Jim Cone - 05 May 2008 02:54 GMT

Try Smart Tags - xl2002 and later I believe.
To find out how...
Enter "Smart Tags" in the help window and choose... "Get a stock quote"

Signature

Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Ron Patterson"
<a.baba@mindspring.com>
wrote in message
I keep trying to import an individual stock price to a single cell but the
Data/Import External Data/New Web Query system seems to only allow me to
only import a whole table which of course changes my whole spread sheet.
Any suggestions on how to just import only the current stock price to a
single cell?
Ron Patterson

Reply to this Message