Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default How to edit MSN Stock Quotes in Excel 2007

I used MSN Stock Quotes in Excel 2002. Now I am using a copy of the same
spreadsheet in Excel 2007. How do I edit (e.g., add a new stock symbol) MSN
Stock Quotes in Excel 2007?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default How to edit MSN Stock Quotes in Excel 2007

Enter the new symbol next to where it says "Enter list of stock symbols"
Enter the ticker symbols here, separated by commas or space
--
Ray Rogers


"TDR" wrote in message
...
I used MSN Stock Quotes in Excel 2002. Now I am using a copy of the same
spreadsheet in Excel 2007. How do I edit (e.g., add a new stock symbol)
MSN
Stock Quotes in Excel 2007?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default How to edit MSN Stock Quotes in Excel 2007

Where does it say "Enter list of stock symbols"? That is, what page are you
on when you see this?



"Ray Rogers" wrote:

Enter the new symbol next to where it says "Enter list of stock symbols"
Enter the ticker symbols here, separated by commas or space
--
Ray Rogers


"TDR" wrote in message
...
I used MSN Stock Quotes in Excel 2002. Now I am using a copy of the same
spreadsheet in Excel 2007. How do I edit (e.g., add a new stock symbol)
MSN
Stock Quotes in Excel 2007?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default How to edit MSN Stock Quotes in Excel 2007

I have a suspicion that we don't have the same sheet, it's pretty obvious
where to enter stock symbols in the one I'm looking at. The first page, MSN,
row 6 starting at column C.

Ok, I just checked where I downloaded this from,
http://www.vertex42.com/ExcelTemplat...ck-quotes.html on that same
site they talk about what is maybe the sheet you have, "Another way to work
with stock quotes in Excel is to use the free MSN Money Stock Quote Add-in
for Excel versions 2002 and 2003 (and 2007).

Sorry if I've thrown you off, I hope that the above information helps.
--
Ray Rogers


"TDR" wrote in message
...
Where does it say "Enter list of stock symbols"? That is, what page are
you
on when you see this?



"Ray Rogers" wrote:

Enter the new symbol next to where it says "Enter list of stock symbols"
Enter the ticker symbols here, separated by commas or space
--
Ray Rogers


"TDR" wrote in message
...
I used MSN Stock Quotes in Excel 2002. Now I am using a copy of the
same
spreadsheet in Excel 2007. How do I edit (e.g., add a new stock
symbol)
MSN
Stock Quotes in Excel 2007?



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default How to edit MSN Stock Quotes in Excel 2007

Thanks. This looks like a new version of what I had before. I will scrap
the old one and use this one.

In Excel 2002, I would use the Excel commands:
"Data"
"Import External Data"
"Parameters"
and then edit a list of stock symbols similar to what appears on the new
template. My problem was that I could not find a similar set of commands in
Excel 2007, eventhough the old worksheet would function in Excel 2007 as long
as I did not need to change any of the stock symbols.



"Ray Rogers" wrote:

I have a suspicion that we don't have the same sheet, it's pretty obvious
where to enter stock symbols in the one I'm looking at. The first page, MSN,
row 6 starting at column C.

Ok, I just checked where I downloaded this from,
http://www.vertex42.com/ExcelTemplat...ck-quotes.html on that same
site they talk about what is maybe the sheet you have, "Another way to work
with stock quotes in Excel is to use the free MSN Money Stock Quote Add-in
for Excel versions 2002 and 2003 (and 2007).

Sorry if I've thrown you off, I hope that the above information helps.
--
Ray Rogers


"TDR" wrote in message
...
Where does it say "Enter list of stock symbols"? That is, what page are
you
on when you see this?



"Ray Rogers" wrote:

Enter the new symbol next to where it says "Enter list of stock symbols"
Enter the ticker symbols here, separated by commas or space
--
Ray Rogers


"TDR" wrote in message
...
I used MSN Stock Quotes in Excel 2002. Now I am using a copy of the
same
spreadsheet in Excel 2007. How do I edit (e.g., add a new stock
symbol)
MSN
Stock Quotes in Excel 2007?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get stock quotes in Excel 2007 Chris Excel Discussion (Misc queries) 4 May 4th 07 04:49 AM
Stock Quotes for Excel 2007 Don Excel Discussion (Misc queries) 0 February 9th 07 02:18 PM
Is there a version of MSN Money Stock Quotes for Office 2007 Trader_in_Paradise Excel Worksheet Functions 0 July 6th 06 09:33 PM
MSN Stock Quotes in Excel 2007 Beta Trader_in_Paradise Excel Discussion (Misc queries) 0 June 7th 06 09:44 PM
How do i get historical stock quotes using MSN Money Stock Quotes Ash Excel Discussion (Misc queries) 0 May 11th 06 03:26 AM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"