LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Excel; Stock Quotes; Smart Tags: doesn't always recognize symb

I was explaining that T is THE symbol. I just used yahoo finance but you can
use an excel query to get the data from yahoo.

--
Don Guillett
SalesAid Software

"Sled" wrote in message
...
You lost me on that one Don. Are you using the Smart Tag or other software
to
get Stock Quotes?

"Don Guillett" wrote:

T is the stock symbol for AT&T
AT&T INC. (NYSE:T) Delayed quote data

Last Trade: 28.19
Trade Time: 10:23AM ET
Change: 0.09 (0.32%)
Prev Close: 28.28
Open: 28.25
Bid: N/A
Ask: N/A
1y Target Est: 28.41

Day's Range: 28.16 - 28.47
52wk Range: 21.79 - 28.82
Volume: 2,580,800
Avg Vol (3m): 13,921,000
Market Cap: 92.50B
P/E (ttm): 19.91
EPS (ttm): 1.42
Div & Yield: 1.33 (4.70%)


1d 5d 3m 6m 1y 2y 5y max

Real-time charts for T. Free Trial


--
Don Guillett
SalesAid Software

"David McRitchie" wrote in message
...
Not familiar with that but perhaps you have an extra character
=LEN(A2) should be 1 for a symbol of "T"
if it is not perhaps you might use TrimALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
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

"Sled" wrote in message
...
Having problems with the Smart Tag recognizing Stock Symbols.
Sometimes
it
does and sometimes it doesn't. Like "T" for AT&T it doesn't recognize
it
but
"MSFT" it does. It'd be nice if I could format a cell for a Smart Tag.

It's a nice feature, I like it.

thanks












 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
How do I get real time stock quotes to my excel worksheet? walter Excel Discussion (Misc queries) 1 January 8th 05 12:01 AM
Stock Quotes in Excel 2003 David B. Excel Discussion (Misc queries) 0 December 1st 04 08:41 PM
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 Ian Ripsher Excel Discussion (Misc queries) 0 November 26th 04 08:43 PM


All times are GMT +1. The time now is 04:36 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"