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
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