need code to record values every 5 seconds

I have a spreadsheet that receives stock and option quotes in real-time via RTD ("real time data") links provided in an Excel Add-in. The quotes are then used in other calculations that constantly change throughout market trading hours. I need code that will test a given cell every five seconds and record a new value only when a new max or min has been reached. Note: I am a rank beginner at VBA.

Could this work?


Insert in a new module

Please Login or Register  to view this content.

Insert in ThisWorkbook

Please Login or Register  to view this content.

Thank you for your response! I need more than that, so let me explain further.

The value in Cell B1 is fed by an RTD link and changes every few seconds. Cell B2 contains the uppermost value that the RTD link in B1 has generated ever since the code has been running. Every five seconds I need for the code to test whether B1 > B2. If so, then change B2 = B1. If not, then B2 does not change. I do not need to save the workbook each time the code loops but rather merely change the value in B2.