Know when cell contents change

Spikeray

New Member
Joined
Nov 13, 2002
Messages
3
I receive share market prices via a microwave decoder which feeds via DDE into an Excel spreadsheet.

What would be nice is if I could see the time of the update, so that I know whether a price is current or not. I thought that if I could get some code/function that tells me when the contents of the "price" cell changes, I could use an =IF in the cell next door to print the time.

Is this feasible? Any advice welcomed.

PS I am a bit of an idiot insofar as programming etc is concerned - have some knowledge, but no expert

Thanks
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Spikeray

New Member
Joined
Nov 13, 2002
Messages
3
Thanks! That has definite potential, but it will take my slow little mind a while to work around. Much appreciated

Spikeray
 

Spikeray

New Member
Joined
Nov 13, 2002
Messages
3
Yes, I think the Chronometer one might work - problem is that the sheets seem to base themselves on a change in price - with share prices, a number of trades can take place at one price - you will not see the time change unless the price changes.

Will eyeball the Chrono.xls - looks like it may have the answer

Thanks a ton (tonne?) for the info
 

Watch MrExcel Video

Forum statistics

Threads
1,122,860
Messages
5,598,491
Members
414,243
Latest member
Shockpulsar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top