B
bcm
Is there anything available for inserting dynamic stock quotes in Excel - other Excel versions had msn.quote.
Thanks.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Is there anything available for inserting dynamic stock quotes in Excel -
other Excel versions had msn.quote. <br><br>Thanks.
You can run a Web Query (Data/Get External Data/Run Saved Query). For
more help, see
http://support.microsoft.com/default.aspx?scid=kb;en-us;274787
S
Simon Fell
Unfortunately web queries seem to be somewhat hosed in XL08, you can create the initial one fine, but attempts to refresh the data fail with an error "selection can be a single cell only."
W
Walter_Ryan
I left a message last evening and forgot to include the request for e-mail notification of replies so I am resubmitting it.
I have been using Excel 2003 on my PC for several years and have built 4 spreadsheets that utilize the dynamic stock quotes of msn.quote.
It has worked like a champ in Excel 2003 and I had instant reports on my investments. Then I bought a mac and Office 2008 for Mac and none of them work.
Is there any progress or work being done on upgrading msn.quote to work correctly on Excel 2008 for Mac?
If so, when might we be able to download it so I can continue with my investment review.
Also, would the web queries be a temporary substitute if I closed the Excel file and then reopened it to generate another query? MSN.quote will only let you request an update about every 5 minutes so. Therefore, it would be about the same as closing and re-opening the file.
Anyone. Thanks for your help!
Walt
I have been using Excel 2003 on my PC for several years and have built 4 spreadsheets that utilize the dynamic stock quotes of msn.quote.
It has worked like a champ in Excel 2003 and I had instant reports on my investments. Then I bought a mac and Office 2008 for Mac and none of them work.
Is there any progress or work being done on upgrading msn.quote to work correctly on Excel 2008 for Mac?
If so, when might we be able to download it so I can continue with my investment review.
Also, would the web queries be a temporary substitute if I closed the Excel file and then reopened it to generate another query? MSN.quote will only let you request an update about every 5 minutes so. Therefore, it would be about the same as closing and re-opening the file.
Anyone. Thanks for your help!
Walt
B
Bob Greenblatt
I have no idea whether (or even if) MSN quotes will be made to work withI left a message last evening and forgot to include the request for e-mail
notification of replies so I am resubmitting it.
I have been using Excel 2003 on my PC for several years and have built 4
spreadsheets that utilize the dynamic stock quotes of msn.quote.
It has worked like a champ in Excel 2003 and I had instant reports on my
investments. Then I bought a mac and Office 2008 for Mac and none of them
work.
Is there any progress or work being done on upgrading msn.quote to work
correctly on Excel 2008 for Mac?
If so, when might we be able to download it so I can continue with my
investment review.
Also, would the web queries be a temporary substitute if I closed the Excel
file and then reopened it to generate another query? MSN.quote will only let
you request an update about every 5 minutes so. Therefore, it would be about
the same as closing and re-opening the file.
Anyone. Thanks for your help!
Walt
Excel 2008. But, since they are probably active-X controls, the short answer
is never. However, I use web queries for this and it works fine. You don't
need to close and reopen the sheet, just refresh the query.
W
Walter_Ryan
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!
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!
B
Bob Greenblatt
You should be able to separate the stock symbols with a comma, and retrieveBob:
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!
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.
W
Walter_Ryan
You should be able to separate the stock symbols with a comma, and retrieveBob:
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!
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 -[/QUOTE]
Thanks so much for your help. I'll go there and try my hand at queries.
Walt
W
Walter_Ryan
Bob:
Well, I tried the query route. The software I bought from Actual Tech to support the query had more complex, unfathomable and less logical instructions than what I have received from MS on this website or Excel manuals. I futilely fought their download and implementation instructions for 3 days and then complained about all the geek-speak in an e-mail and they agreed, apologized and refunded my purchase payment to my CC. They then referred me back to you.
So I'm back to square one.
There are numerous people with my same problem on the Mactopia site.
They want just the current stock price. So do I. I refer to your 3/30/2008 answer to Peter there as an example. If MS can send back the plethora of superfluous data they do on a query when all we wanted was the current price, then why in the world can't they just send back the current price?
It make no sense to me. Please tell me why.
Your answer on redesigning the sheet slightly was equally confusing to me, since I do not have your knowledge or computer skills nor do I understand the nuances of hidden sheets and linking to them. What do I redesign in my sheet? And is there some detailed written explanation of the procedures you describe somewhere?
I bought your newest 2008 Excel just as I have purchased every prior and subsequent version of it since 95. I have been a loyal MS customer with each Office upgrade. I do not understand why my significant work in preparing these 30 stock spreadsheets to my satisfaction has been relegated to the trash can because of some unknown problem the company does not choose to address. It just doesn't seem like nuclear physics to provide the option to split out and return the quote to a cell by itself instead of sending all the extra unwanted data on volume, dividends, etc., etc., etc. Please reply.
Walt
Well, I tried the query route. The software I bought from Actual Tech to support the query had more complex, unfathomable and less logical instructions than what I have received from MS on this website or Excel manuals. I futilely fought their download and implementation instructions for 3 days and then complained about all the geek-speak in an e-mail and they agreed, apologized and refunded my purchase payment to my CC. They then referred me back to you.
So I'm back to square one.
There are numerous people with my same problem on the Mactopia site.
They want just the current stock price. So do I. I refer to your 3/30/2008 answer to Peter there as an example. If MS can send back the plethora of superfluous data they do on a query when all we wanted was the current price, then why in the world can't they just send back the current price?
It make no sense to me. Please tell me why.
Your answer on redesigning the sheet slightly was equally confusing to me, since I do not have your knowledge or computer skills nor do I understand the nuances of hidden sheets and linking to them. What do I redesign in my sheet? And is there some detailed written explanation of the procedures you describe somewhere?
I bought your newest 2008 Excel just as I have purchased every prior and subsequent version of it since 95. I have been a loyal MS customer with each Office upgrade. I do not understand why my significant work in preparing these 30 stock spreadsheets to my satisfaction has been relegated to the trash can because of some unknown problem the company does not choose to address. It just doesn't seem like nuclear physics to provide the option to split out and return the quote to a cell by itself instead of sending all the extra unwanted data on volume, dividends, etc., etc., etc. Please reply.
Walt
B
Bob Greenblatt
I assume you addressing this to me. If not, I'll respond anyway. I mustBob:
Well, I tried the query route. The software I bought from Actual Tech to
support the query had more complex, unfathomable and less logical instructions
than what I have received from MS on this website or Excel manuals. I futilely
fought their download and implementation instructions for 3 days and then
complained about all the geek-speak in an e-mail and they agreed, apologized
and refunded my purchase payment to my CC. They then referred me back to you.
So I'm back to square one.
There are numerous people with my same problem on the Mactopia site.
They want just the current stock price. So do I. I refer to your 3/30/2008
answer to Peter there as an example. If MS can send back the plethora of
superfluous data they do on a query when all we wanted was the current price,
then why in the world can't they just send back the current price?
It make no sense to me. Please tell me why.
Your answer on redesigning the sheet slightly was equally confusing to me,
since I do not have your knowledge or computer skills nor do I understand the
nuances of hidden sheets and linking to them. What do I redesign in my sheet?
And is there some detailed written explanation of the procedures you describe
somewhere?
I bought your newest 2008 Excel just as I have purchased every prior and
subsequent version of it since 95. I have been a loyal MS customer with each
Office upgrade. I do not understand why my significant work in preparing these
30 stock spreadsheets to my satisfaction has been relegated to the trash can
because of some unknown problem the company does not choose to address. It
just doesn't seem like nuclear physics to provide the option to split out and
return the quote to a cell by itself instead of sending all the extra unwanted
data on volume, dividends, etc., etc., etc. Please reply.
Walt
reiterate and state that I am not a Microsoft employee, just a user like you
are. I have no idea why the query is structured this way. If you want just
the price, then use a query for another website. The fact that a bunch of
information is returned for each stock symbol is a benefit, not defect. Try
looking in help to see how to link data from one sheet to another. The quick
answer is to select the cell where you want the result. Then type an equal
sign "=" and then click on the cell in another sheet that is the source of
the data. Return your queries to that sheet, and hide it.
A
angelb
Unfortunately web queries seem to be somewhat hosed in XL08, you can create the initial one fine, but attempts to refresh the data fail with an error "selection can be a single cell only."
I am seeing this problem as well. I can create a new web query and refresh it while the document is still, but as soon I save the document, close it, and then reopen it, I can no longer refresh data with the error "selection can be a single cell only." Is this a known current problem? SP1 seems to make no difference so far.
I am seeing this problem as well. I can create a new web query and refresh it while the document is still, but as soon I save the document, close it, and then reopen it, I can no longer refresh data with the error "selection can be a single cell only." Is this a known current problem? SP1 seems to make no difference so far.
B
Bob Greenblatt
I don't know, it works fine for me. As long as the query is established,I am seeing this problem as well. I can create a new web query and refresh it
while the document is still, but as soon I save the document, close it, and
then reopen it, I can no longer refresh data with the error "selection can be
a single cell only." Is this a known current problem? SP1 seems to make no
difference so far.
refreshing it works fine. You can select any single cell which can be
anywhere on the sheet and does not have to be within the query.
A
Andy
seeing exactly the same problem, stock quote web query worked prior to
upgrade, now I have to recreate the query each time
upgrade, now I have to recreate the query each time
F
Fergal Condron
There seems to be quite a few postings about stock quotes not functioning
after the file is loaded after you save the file. I'd like to be able to
narrow down the problem to see if we can get this figured out but I cannot
reproduce what you all are seeing. If anyone who is experiencing this issue
could reply with any information that would be great?
Here's some of the info we need:
Firstly to explain in detail how you created the query, does it have any
custom parameters, does it refresh on load etc?
What file format was it saved in, xls, xlsx or some other format?
Any help would be greatly appreciated!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
after the file is loaded after you save the file. I'd like to be able to
narrow down the problem to see if we can get this figured out but I cannot
reproduce what you all are seeing. If anyone who is experiencing this issue
could reply with any information that would be great?
Here's some of the info we need:
Firstly to explain in detail how you created the query, does it have any
custom parameters, does it refresh on load etc?
What file format was it saved in, xls, xlsx or some other format?
Any help would be greatly appreciated!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
A
Ajay Sudan
I'm seeing the same thing too. I have one worksheet with two stock quotes
that works fine. I have another spreadsheet with about 10 quotes. I have to
recreate the worksheet with the stock quotes every time I want to refresh.
that works fine. I have another spreadsheet with about 10 quotes. I have to
recreate the worksheet with the stock quotes every time I want to refresh.
B
Bob Greenblatt
I'm not seeing this. I have a page with about 40 quotes and it works fineI'm seeing the same thing too. I have one worksheet with two stock quotes
that works fine. I have another spreadsheet with about 10 quotes. I have to
recreate the worksheet with the stock quotes every time I want to refresh.
before and after all the updates.
F
Fergal Condron
Hi there,
Can you provide a sample file to me so I can try and investigate further?
My email is: (e-mail address removed)
Thanks,
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
Can you provide a sample file to me so I can try and investigate further?
My email is: (e-mail address removed)
Thanks,
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.