Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stock quotes
Using excel 2003.
How can I set up a worksheet that I can download current stock prices into from off the web? Thanks, Craig |
#2
|
|||
|
|||
It will be useful to answer your query if you provide a link to such stock
prices. "Craig" wrote: Using excel 2003. How can I set up a worksheet that I can download current stock prices into from off the web? Thanks, Craig |
#3
|
|||
|
|||
Both Yahoo, and moneycentral.msn.com provide stock quotes, but when a solution
is provided it would be tied in with where they come from. If you really want to pull from a web page I'd try the moneycentral site since Microsoft might have more to gain with you getting consistent results over time with a Microsoft Product (Excel). Chip Pearson has an example on his site in the downloads, and you will have to modify it to the current layout of the webpage it obtains the quotes from. Every time they change the layout you would have to tinker with code. You can find some links on my stocks.htm page http://www.mvps.org/dmcritchie/excel/stockes.htm It would be more practical to work from a .csv file that you can also obtain rather than the web page. And using Quicken or Money would be a lot easier and would compress the stored results for each day (per day). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Martin P" wrote in message ... It will be useful to answer your query if you provide a link to such stock prices. "Craig" wrote: Using excel 2003. How can I set up a worksheet that I can download current stock prices into from off the web? Thanks, Craig |
#4
|
|||
|
|||
Hi. One way...
Data | Import External Data... | Import Data | "MSN MoneyCentral Investor Stock Quotes.iqy" On the Import Data form, click the "Parameters..." button for you stock symbols you want to track. Perhaps to start with, select the third option and select a range like A1:A10. Put the stocks you want to track in these cells. Check out the "Properties" button also for more interesting Web query options. Good luck. Any hot stock tips?? HTH. :) -- Dana DeLouis Win XP & Office 2003 "Craig" wrote in message ... Using excel 2003. How can I set up a worksheet that I can download current stock prices into from off the web? Thanks, Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSN MoneyCentral Stock Quotes support historical price look-ups | Excel Worksheet Functions | |||
msn stock quotes | Excel Discussion (Misc queries) | |||
How do I get real time stock quotes to my excel worksheet? | Excel Discussion (Misc queries) | |||
Stock Quotes in Excel 2003 | Excel Discussion (Misc queries) | |||
I need a template for stock | Excel Worksheet Functions |