Thursday, July 28, 2005
Trick 3 - Variation on a theme
Reiner came up with a nice variation on Trick 2.
We have a spreadsheet that is orthogonal. However, in the first column, in this case we have a trade id.
The trick makes it neat to add a new trade. The event when something is entered in the sheet is there. When a new ISIN is added, the formulas from the row above are copied down automatically.
The alternative is running lots of nasty macros.
We have a spreadsheet that is orthogonal. However, in the first column, in this case we have a trade id.
The trick makes it neat to add a new trade. The event when something is entered in the sheet is there. When a new ISIN is added, the formulas from the row above are copied down automatically.
The alternative is running lots of nasty macros.
Subscribe to Posts [Atom]