Hi, I'm not sure if this sort of thing is even possible in a spreadsheet but hopefully this is the place to ask. Thanks in advance for your indulgence.
I have a spreadsheet with roughly 5000 stock trades. The basic idea of the data set is that there are always 8 stocks owned in the portfolio. On the initial date 8 stocks are purchased. Sometime later anywhere from 1 to 8 stocks are sold and an identical number of new stocks are purchased on the same date to replace them thus keeping 8 stocks in the portfolio at all times. What I would like to do is somehow create 8 new pages within this spreadsheet with each page having a unique set of trades in it. Ideally one the first 8 purchases would individually show up at the top of the new 8 pages. When a stock on any page is sold I would then have a new, unique stock added to each page. When complete the sum of the stocks on all 8 pages would equal the number of trades on the first page. It is not important which stock replaces a stock on any page. The only important thing is that every trade in the main page be represented on one of the 8 new pages, that no stock ownership dates overlap on a single page and that no single trade show up on more than one page. Is something like this even possible in Open Office Calc? I suppose if I was a programmer then it could be done in C but I'm not. Any chance of doing something like this? Thanks in advance --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
