Excel; Stock Quotes; Smart Tags: doesn't always recognize symbol.

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

Goto xltraders (a yahoo group) and download free files there. Look for
author donalb36
http://groups.yahoo.com/group/xltraders/
Symbol Name Date Time last open high low Prev Cl Volume
AKS A K STEEL HLDG CO 2/21/2006 11:09am 11.26 11.26 11.44 11.07 11.19
535700
AVT AVNET INC 2/21/2006 11:10am 25.7 25.95 25.96 25.59 25.9 512900
AWE AWE N/A 7:50pm 0 N/A N/A N/A N/A N/A
BNI BURLINGTN N SANTE 2/21/2006 11:09am 80.63 80.65 80.82 80.4 80.35
452000
IBM INTL BUSINESS MAC 2/21/2006 11:09am 80.39 80.1 80.48 79.97 80.71
2128900
CSCO CISCO SYS INC 2/21/2006 11:15am 19.69 19.71 19.9 19.58 19.86
18912412
T AT&T INC. 2/21/2006 11:10am 28.25 28.25 28.47 28.16 28.28 4291900
X UNITED STATES STE 2/21/2006 11:09am 55.83 55.2 56.37 55.11 55.1
806300
FE FIRSTENERGY CP 2/21/2006 11:10am 50.13 50.22 50.86 49.99 49.9
585200
DELL DELL INC 2/21/2006 11:15am 30.09 30.15 30.23 29.91 30.38 9774879
QAVIF.X QQQQ Sep 2006 32. N/A N/A 0 0 0 0 0 0

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Sled" <Sled@discussions.microsoft.com> wrote in message
news:DA880683-B9DC-42C6-B3B0-290820E9F98B@microsoft.com...
> 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
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>