Automatic Value Calculation

V

Vlad Zelenko

Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM', 10)],
result being the cell's value updating with a new IBM's Stock Quote every 10
seconds.

Assuming I have the Quote data available, is this possible? What are the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested in this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad
 
V

Vlad Zelenko

Thank you for the suggestion!

I guess I was not clear about what I need. My problem is updating a cell
dynamicly, not timer-driven execution of a method.

I suppose I could collect 'CurrentCell' references in an Array and update
their values based on parameter passed, but I was wondering if there is a
better way.

Thanks again.

Frank Kabel said:
Hi
have a look at the OnTime method to run a macro periodically:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Vlad Zelenko said:
Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM', 10)],
result being the cell's value updating with a new IBM's Stock Quote every 10
seconds.

Assuming I have the Quote data available, is this possible? What are the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested in this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad
Click to expand...
Click to expand...
 
F

Frank Kabel

Hi
never uses this but Excel has a feature called Web Query ('Tools -
Import External Data'). You can set a refresh for this query (Think 1
minute is the best you can do)

--
Regards
Frank Kabel
Frankfurt, Germany

Vlad Zelenko said:
Thank you for the suggestion!

I guess I was not clear about what I need. My problem is updating a cell
dynamicly, not timer-driven execution of a method.

I suppose I could collect 'CurrentCell' references in an Array and update
their values based on parameter passed, but I was wondering if there is a
better way.

Thanks again.

Frank Kabel said:
Hi
have a look at the OnTime method to run a macro periodically:
http://www.cpearson.com/excel/ontime.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Vlad Zelenko said:
Hi,

I need to write an Add-In for Excel that can provide the following
functionality:

User enters into any cell a function call like [=GetQuote('IBM', 10)],
result being the cell's value updating with a new IBM's Stock
Click to expand...
Quote
every 10
seconds.

Assuming I have the Quote data available, is this possible? What
Click to expand...
are
the
best ways to do it in Excel.

The ultimate goal is to distribute an Add-in to users interested
Click to expand...
in
this
functionality.

If possible, I do not want to depend on Cell's coordinate.

Thanks for any help.

- vlad
Click to expand...
Click to expand...
Click to expand...
 
Top