Interesting Clive,
This coding you posted, I asseme this the Excel Macro coding?
Suppose I try to implement that on a current spread, would this automatically freeze all the columns A to Z above the current date, like the blue section I had in the example?
In an actual test I have the dates like this:
1-2-10
2-2-10
3-2-10. . .This is the last date that was actively "treated"(Trade or no Trade). Every row above this must “freeze” as during this day I could still change my mind before executing the order. Then I have to wait till the order is executed before I freeze the executed Trade. Only when the next row has a later date should 3-2-10 ( or whatever higher date I change it too) be frozen.
Does your code example do that?
3-2-10 . . . these are dummy dates which are changed to real dates as they arrive.
3-2-10
3-2-10
3-2-10
3-2-10
Etc.
I could avoid this by entering a new row every time I enter a new date but that is time consuming as I have to alter various cell numbers when I add rows. So I have a set of Dummy Rows that carry all the same data.. . saves me time that way.
When I change to using the Excel Macro I would have arrange it so that every time I needed a new data row this would occur automatically and the changes in other cells as well. . . .this is a complete redesign. . .not for today!
I might have to hire a professional Excel Programmer to do all that.
Thanks Clive,I got the message.
I have enough info to chew on for a while and to think about it if I am going to do all this. At the moment this is a bridge to far. . I want to freeze only a set of selected rows and leave the rest of the rows with past dates up to the resent active for parameter optimisation.
For a while I do not need new suggestions.