Hi

OK, this one is beyond my skill level.

Lets say I have this data:


(i wish there were an easy way to post a table)
a_____b____ c_____ d_____ e______ f______ g_____ h_____ i
1 - 12/1--| 385 -| 15000 -| --etc--|| --etc--|| --etc--|| --etc--||
--etc--|
2 - 12/5--| 256- | 20000 -|
3 - 12/6--| 356- | 11000 -|
4 - 12/5--| -89--| -1000 --|
5 - 12/9--| 500- | 9000 ---|

Where d1:d5 e1:e5 f1:f5 and g1:g5 h1:h5 i1:i5 all have similar data.

In this case, trade 1 throguh trade 5 will have differing numbers of
days they will be open. So for each day two things have to be tracked -
current profit/loss, and current margin requirements at the close
(columns b,c, e,f, h,i) Since each trade has a different opening date,
and different numbers of days they are open, the dates in columns a,d,f
will vary, as the trades are entered vertically, but the day by day
changes in equity and margin are tracked horizontally.

the file is set up to track a trade open for up to 70 sessions (running
across) - you never know how log it is going to take! As long as a trade
is open, there has to be a record kept of the closing price for the day,
for that market , and how it affects the account, up or down. This
problem is solved.

But the hard part (aside from the hideous solution I have) is to figure
out a really straightforward, way to 'stack' the columns running
horizontally on top of each other.

Thus the data in a1:c5 gets stacked on top of d1:d5 and the same for
g1:i5

From there i can run a sort, and subtotals, and track the day to day
flow of equity and margin requirements, as one aspect to analyze and
improve perfomance. If there is a way to pull this off *without*
having to stack everything vertically that'd be great (with 70 days out
and up to 300 trades <21000 rows, 3 columns wide, the dumb way is to
refer to the cells vertically on another worksheet. but most of the
time thee might be only 10 - 30 days out for a few trades, etc, so I
dont want to have to waste so much space if I can avoid it).

Many TIA!


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=492956