Create Running Log when Financial Model triggers Buy / Sell Orders

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.

Hello TDWalt,

Welcome to the Forum!

In order to help you with this model, we would need to know more about your "triggers", which cells are for "Buy" and which ones for "Sell". You mention a log. Have you thought where this log would be stored - like on another worksheet or in a text file? The quickest way to answer these questions would be to see your workbook. You can add it as an attachment to your post. Remove any confidential material and remember the maximum file size is 100 KB. If you have a large Excel file you may want to zip it first.

Sincerely,
Leith Ross