Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add-ins, insert stock quotes | Excel Worksheet Functions | |||
Stock Quotes | Excel Worksheet Functions | |||
Insert stock quotes | Excel Worksheet Functions | |||
How do i get historical stock quotes using MSN Money Stock Quotes | Excel Discussion (Misc queries) | |||
How can I insert stock quotes in excel (not through msn)? | Excel Worksheet Functions |