Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to insert Stock quotes from Web?

HI Folks,

I need to insert a current stock price into a single cell of an Excel
worksheet. When I go to Data Get External Data Run Saved Query MSN
Money Stock quotes, the whole web page gets inserted. There's another
way somone suggested using smart tags (I think it only works on
Windows), but with smart tags the stock ticker is inserted with the
price. I want to put the current stock price and only the current stock
price in a targeted cell. And I would like to be able to refresh with
current data easily. Is there a fairly easy way to do so? Could someone
tell me how step by step? Would much appreciate.

PS: I use a MAC at home with OS10.3.9, and EXCEL 2004. I have Windows
at work, but prefer to use my MAC at home for stock research.

Thanks,
~Arizona

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add-ins, insert stock quotes JMM Excel Worksheet Functions 0 June 23rd 07 04:28 PM
Stock Quotes mman493 Excel Worksheet Functions 0 May 2nd 07 07:30 PM
Insert stock quotes Shooter Excel Worksheet Functions 1 February 6th 07 06:22 PM
How do i get historical stock quotes using MSN Money Stock Quotes Ash Excel Discussion (Misc queries) 0 May 11th 06 03:26 AM
How can I insert stock quotes in excel (not through msn)? dkersten Excel Worksheet Functions 2 March 13th 06 02:30 PM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"