I have a spreadsheet that receives live stock market data.? The spreadsheet captures my buys and sells on the day and then sums the Profit and Loss is one cell.
I want to take a snapshot of that P and L cell on a 5, 10 or 15 minute interval and record the P and L and the time? to a text file or to another excel sheet.?
This will allow me to create a histogram of the P and L to see if there is an optimum time to close the trades. The time interval should be adjustable by the user.