Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
otisx
 
Posts: n/a
Default Smart tags for financial symbols

Why do smart tags only recognize 3 characters for financial symbols? I have
tried two characters, four characters and five characters, all valid stock or
mutual fund symbols. None of them are marked with smart tags, only the 3
character symbols.
  #2   Report Post  
otisx
 
Posts: n/a
Default

I found the answer in another part of the forum. In order to fully use
financial symbols with smart tags, you need an add-in. Why doesn't Microsoft
mention this in their discussion of smart tags? Just a rhetorical question.

"Excel_Geek" wrote:


You can download the Excel 2003/2002 Add-in: MSN Money Stock Quotes:

http://tinyurl.com/dw948

This won't automatically create a smart tag for GM, for example. But
you can use the "Insert Stock Quotes" function on the newly installed
toolbar to create a quote for GM, which will drop that quote onto the
sheet where you specify. Then you can copy and paste the cell with
"GM" in it (now with a smart tag) to where ever else you might need it,
and the smart tag will go with it.


--
Excel_Geek


--
otisx


"otisx" wrote:

Why do smart tags only recognize 3 characters for financial symbols? I have
tried two characters, four characters and five characters, all valid stock or
mutual fund symbols. None of them are marked with smart tags, only the 3
character symbols.

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
smart tags Tom_in_Jersey Excel Discussion (Misc queries) 2 August 29th 05 09:56 PM
Adding Smart Tags to an unrecognized cell reference SauveC Excel Discussion (Misc queries) 3 February 12th 05 02:01 AM
Recognize more stock ticker symbols? Bob Excel Discussion (Misc queries) 2 January 26th 05 05:29 AM
Smart Tag in Excel does not recognize some stock symbols Chambersteacher Excel Discussion (Misc queries) 0 January 20th 05 11:13 PM
Using Smart Tags with Grouped WorkSheets Tim Excel Discussion (Misc queries) 0 December 13th 04 01:47 AM


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