Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Sorting Problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Link Problem | Links and Linking in Excel | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
Problem Sorting | New Users to Excel | |||
An instant sorting problem | Excel Worksheet Functions | |||
Sorting problem | Excel Worksheet Functions |