Re: Stock Quotes in Excel 2008

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 5/1/08 1:45 AM, in article ee899fc.4@xxxxxxxxxxxxxxxxxxxxxxx,
"Walter_Ryan@xxxxxxxxxxxxxxxx" <Walter_Ryan@xxxxxxxxxxxxxxxx> wrote:

Bob:
In the help and support file "How to create Web query files on page 3 there
is an Example 3 that addresses the single stock quote query:
If I have 10 stocks in my portfolio Excel sheet, do I have to write 1 query
with 10 symbols or 10 separate queries?
As it must be obvious I have never utilized this Web query file logic before
and it appears very intimidating. Let's assume I own MSN, IBM, and GG.
What would the 4 lines of the entire query look like?
Also, is there a particular reference book that you would recommend that would
teach me, in a simple way, how to construct a query and where it should be
placed in the Excel spreadsheet to make it effective in addressing all the
above 3 stocks in the spreadsheet that had their symbol called out in the
file?
Things were much easier when I was using Excel 2003 and msn.quote. The syntax
was simple, was cell contained and the placement was not in question.
I really appreciate your help. Thank you!
You should be able to separate the stock symbols with a comma, and retrieve
data for any number of stocks. The best way to do this is on a separate
sheet in the workbook, as the query will retrieve a bunch of stuff for each
symbol. On the main sheet, you can link to the required values on the query
sheet. There are several sample queries in the Queries folder in the Office
folder in the Microsoft Office 2008 folder in applications.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.

Relevant Pages

  • Re: Stock Quotes in Excel 2008
    ... In the help and support file "How to create Web query files on page 3 there ... If I have 10 stocks in my portfolio Excel sheet, do I have to write 1 query ... There are several sample queries in the Queries folder in the Office ...
    (microsoft.public.mac.office.excel)
  • Re: Manual control of link updating for downloaded quotes?
    ... You did get me up and running with your 'query' instructions. ... I also like your idea of using a seperate sheet to bring in the raw data ... to go to the CSV file, ... via a macro), copy the data I want, and close it. ...
    (microsoft.public.excel.misc)
  • Re: Export to an already setup excel spreadsheet where columns<>
    ... Add an additional sheet to the workbook that you will use only for receiving ... Then, I just select the data in my query, by column, copy it, and then ... go into the excel sheet and select the first couple or three cells under the ... the spreadsheet seems to be 'protected' and I have NO idea what ...
    (microsoft.public.access.externaldata)
  • Re: Export to an already setup excel spreadsheet where columns<>
    ... Add an additional sheet to the workbook that you will use only for receiving ... Then, I just select the data in my query, by column, copy it, and then ... go into the excel sheet and select the first couple or three cells under the ... the spreadsheet seems to be 'protected' and I have NO idea what ...
    (microsoft.public.access.externaldata)
  • Re: Export to an already setup excel spreadsheet where columns<>
    ... To unprotect the sheet you can, oddly enough, just copy the whole thing ... Then, I just select the data in my query, by column, copy it, and then ... go into the excel sheet and select the first couple or three cells under the ... the spreadsheet seems to be 'protected' and I have NO idea what ...
    (microsoft.public.access.externaldata)