I recently built a financial model which will eventually automatically trigger buy and sell orders. As a way to test it with live market data, but without making actual trades, I am looking for a way to ‘log’ each ‘trigger’ which occurs throughout the day. So if trigger says ‘Buy’ it would copy the ‘Buy’ cell, the current price cell, and the time cell to a new location. When the next trigger occurs it will copy the same information, only place it below all previous logged trigger; the log is cumulative. The macro would run continously throughout the day.

Thank you.