I am currently working on a Excel spreadsheet that is connected to an API. The stockmarket data updates in excel every 1 second. What I want to try and do is record the stock price every 5 minutes so i can review the data at a later stage. What is the best way to go about this, any feedback appreciated.