Wednesday, December 01, 2010 7:47:23 PM
That's as Fuzzy as it gets!
I's so cute & hilarious. . .you good people keep trying to solve a problem that is already no longer a problem. This vicious circle has no gap in it to stop the viciousness
I do not want to SAVE the rows "above" a certain date! I want to FREEZE the functions on a certain date. . . Now this need a clarification in order to prevent more confusion:
above a certain date does not mean a higher or later date but an earlier date! It refers to the dates in the line above a certain date. . .could be any date in the future. . .BUT of course I can not go to the future to freeze the functions I want to freeze. . .I am not Michel Fox. . .all I can say now that certain date is quite uncertain as yet!
So after that uncertain date has become certain, all the functions in the rows above are to be frozen. . .made inactive. . . carved in stone if you will, but all the values must remain accessible as they are part of the Portfolio make-up, because many columns contain amounts that are added-up from the first date on the spread sheet to the current date.
Here is an example for you:
The light blue section in the spread is to be frozen. In principle not all cells in the blue are sensitive to the date, price and operational parameters. But if I can freeze all these cells in one simple statement in the Excel Management Files then I have what I want. All the values in the blue section are to be treated as fixed numbers that are part of the Portfolio history, and of course they should remain there were they are.
In principle once I have this process of freezing the way I want it I could freeze the old lines every day or after a week if I had not looked at the stock market for 1 week. The essence of this objective is that I would operate my Excel as if it were a DataBase program.
In my Windows Vortex Program these blue values are automatically frozen in the DataBase, so I can change all the operational parameters any time I want to and only the future DataSets are calculated on the basis of the new parameters.
I have not used Excel Macro’s for about 10 years or more, so I had completely forgotten about that possibility. Maybe it will work in an Excel Macro.
Regards,
I's so cute & hilarious. . .you good people keep trying to solve a problem that is already no longer a problem. This vicious circle has no gap in it to stop the viciousness
I do not want to SAVE the rows "above" a certain date! I want to FREEZE the functions on a certain date. . . Now this need a clarification in order to prevent more confusion:
above a certain date does not mean a higher or later date but an earlier date! It refers to the dates in the line above a certain date. . .could be any date in the future. . .BUT of course I can not go to the future to freeze the functions I want to freeze. . .I am not Michel Fox. . .all I can say now that certain date is quite uncertain as yet!
So after that uncertain date has become certain, all the functions in the rows above are to be frozen. . .made inactive. . . carved in stone if you will, but all the values must remain accessible as they are part of the Portfolio make-up, because many columns contain amounts that are added-up from the first date on the spread sheet to the current date.
Here is an example for you:
The light blue section in the spread is to be frozen. In principle not all cells in the blue are sensitive to the date, price and operational parameters. But if I can freeze all these cells in one simple statement in the Excel Management Files then I have what I want. All the values in the blue section are to be treated as fixed numbers that are part of the Portfolio history, and of course they should remain there were they are.
In principle once I have this process of freezing the way I want it I could freeze the old lines every day or after a week if I had not looked at the stock market for 1 week. The essence of this objective is that I would operate my Excel as if it were a DataBase program.
In my Windows Vortex Program these blue values are automatically frozen in the DataBase, so I can change all the operational parameters any time I want to and only the future DataSets are calculated on the basis of the new parameters.
I have not used Excel Macro’s for about 10 years or more, so I had completely forgotten about that possibility. Maybe it will work in an Excel Macro.
Regards,
Conrad Winkelman
What is Vortex AIMing? Look for my Vortex Discussion Forum:
http://investorshub.advfn.com/boards/board.asp?board_id=1341
Join the InvestorsHub Community
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
