Hi Don,

How would I go about using an Excel Query? Do you have an example?
Thanks

"Don Guillett" wrote:

> 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
> dguillett1@austin.rr.com
> "Sled" <Sled@discussions.microsoft.com> wrote in message
> news:27FF1B20-750D-4F28-BCA8-EFF50A03B121@microsoft.com...
> > 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
> >> dguillett1@austin.rr.com
> >> "David McRitchie" <dmcritchie_xlmvp@verizon.net> wrote in message
> >> news:eGf6vwvNGHA.2884@TK2MSFTNGP12.phx.gbl...
> >> > 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" <Sled@discussions.microsoft.com> wrote in message
> >> > news:D9AA0C13-F6DF-457B-A52A-1E9FA711E52D@microsoft.com...
> >> >> 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
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>
>