Smart Tags and Stock Quotes
 

Hi,

I have a few questions regarding a custom smart tag that I am developing.
My client has a number of stock feeds in various formats. He would like a
smart tag in Excel to recognize custom symbols and then have an action
available to get the latest price from the web. I have created a class
library that implements the necessary interfaces (ISmartTagAction,
ISmartTagAction2, ISmartTagRecognizer, ISmartTagRecognizer2). The solution
works fine, but he would like the option to have the action performed
automatically once the text is recognized as a valid symbol as opposed to
manually clicking on the smart tag action for each stock quote. Does anyone
have any idea of how to do this? I am having trouble finding out how to
obtain a reference to the current Excel worksheet from Recognize2 method in
my Recognizer class. Also, he would like the option of having this action
performed based on the name of the file. For example, if the name of the
file contains the name of a stock feed, then the recognizer should go to work
and pull the latest price from the web for all valid symbols in the
worksheet. However, if he is working with another Excel file which happens
to contain a stock symbol, the action should be disabled.

Any help on this would be appreciated. Also, I would be interested to know
if anyone has any ideas of how I could accomplish these requirements using
another method instead of a smart tag.

Brian