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" 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

Bob -
Thanks so much for your help. I'll go there and try my hand at queries.
Walt
.

Relevant Pages

  • Re: more dimensional method like a query...
    ... > First i have stocks, ... If the stocks live in a SQL RDBMS, you should attempt to meet the ... If it's a collection in memory, the simplest thing is to iterate ... document and use an implementation of XQuery to query the collection, ...
    (comp.object)
  • Re: Using expression in Query to limit table date used.
    ... I buy several stocks, hold them for four weeks then sell ... month is a period and has a unique number assigned by the autonumber field. ... >>I am trying to identify an expression that I can use in a query to limit ... Each line of monthly data has a unique number ...
    (microsoft.public.access.queries)
  • 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 ...
    (microsoft.public.mac.office.excel)
  • RE:help please
    ... date, time, stocks name, price ... what is the command (or query languange) to get the ... aggregate query, in Ms acces but can it be done in SQL ...
    (microsoft.public.sqlserver.mseq)
  • Historical Share Price query
    ... I've got a MSN Money query in Excel that allows me to query a bunch of stocks at once to get the CURRENT share price. ...
    (microsoft.public.excel.misc)