Hello,

I am new to this forum and also to VBA coding. In general, I would describe myself as an excel novice working toward intermediate. My interest in excel has risen due to the fact that I am learning how to trade currencies and I am in the process of setting up a worksheet to monitor my trades, risk per trade, performance etc. In doing so I have come across a hurdle that I am not sure how to resolve. Therefore, I will describe what I am trying to achieve in the hope that one of you may be able to offer some assistance:

A section of my spreadsheet imports information such as opening prices and closing prices from proprietary trading software via a DDE data feed. In turn, I make numerous calculations on these values. The issue that I have, is that at 00:00:00 broker time, the server switches to the next trading day. What I would like to be able to do is run a macro to copy and paste a range of fixed variable cells and paste special, values only, of a range of cells containing either formula or DDE imports to a separate worksheet in the same work book. I would like this macro to run when the time (which is also a DDE import: format: ='MT4'|TIME!GBPUSD) is equal to 23:58:00.

This would then give me a hardcopy of all of the values just prior to the end of the days trading.

I hope that I have clearly explained my question and look forward to any help that you can give.

Regards

Oneday