hit counter question

[Bob Chapman]

I need a hit counter on Excel 2003 which counts the number of times a
condition is met. This spreadsheet DDEs to RediPlus (trading software).
The DDE fields would be "last price" and "day high price". When last = day
high, I have it flash a green conditional format. What I would like to do
is to not only flash green but also count the number of times last = day
high. For example,

A1 = DDE link to "last price" of IBM (constantly changing)
B1 = DDE link to "day high price" of IBM (changes only when a new high is
made otherwise stays the same)

C1 = alert if they equal (IBM is making a new high) - flashes green via
condiitional format

I would like to put a hit counter in C1 that only increases when last = day
high

Seems simple, but I just can't get it to work

Thanks
Bob

 

[Frank Kabel]

Hi
have a look at
http://www.mcgimpsey.com/excel/accumulator.html
for creating an accumulator (you may use a different event, e.g.
worksheet_calculate instead of worksheet_change)

P.S.: also please don't multipost as this scatters your answers and
create additional effort for all who answer to your questions

 

[Paul Robinson]

Hi
Occurs to me that this may not work with a DDE link, but might require
a manual change of the cell value.
You might need to add the relevant code after the link changes the
values in A1 and B1. Do you have access to that code so that it can be
edited?
Paul