Hi Terry - Thanks for the response. On 5/3/07, TerryJ <[EMAIL PROTECTED]> wrote:
Mark Knecht wrote: >
<SNIP>
> > 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.
<SNIP>
I've never used either tool, but Data >Filter and Data >DataPilot spring to mind.
Thanks. I'll start by checking those out over the weekend and hopefully report back one way or the other.
What is the criterion for deciding the page to which a particular row is copied?
Old stock date sold == New stock date purchased
Is there a column which contains that criterion?
Not specifically. Maybe I can somehow create one?
What is the reason for separating transactions that way?
To investigate the statistics of smaller groups to see how they compare to the group as a whole. I'm looking at back testing stock trading strategies. Assume I buy a basket of 3 stocks on Monday. This creates 3 stock world lines which I'll show like this (A) (B) (C) Some go up, some stay flat, others go down. Somewhere along the line I sell one stock on Thursday and using that money I buy a new stock. The world lines now look like this: (A) (B) - (D) (C) The following week two stocks sell and are replaced: (A) (B) - (D) - (E) (C) - (F) Over time it could look like this: (A) - (K) -(L) (B) - (D) - (E) - (G) -(H) - (M) (C) - (F) - (I) - (N) Most of the time stocks sell because they get week or don't perform well for some other reason. Sometimes all stocks sell due to a market changing event. You don't know which will sell and you don't know when. Only that when one sells it is immediately replaced by another.
Presumably you cannot simply extract the first row to the first sheet, the second to the second and so on because sales and purchases do not occur in that sequence - i.e. 8 purchases followed by 8 sales, or vice versa.
The first 8 purchases are the first lines in each of the 8 sheets but after that it happens in what ever order certain stocks sell in. In terms of creating the new lines it doesn't matter which stock goes into which world line - only that it is added to one line and not duplicated somewhere.
It sounds like a headache requiring counting of sales, purchases and sheets but I imagine scripting could achieve what you want.
It does sound like a headache. (Maybe that explains mine!) ;-) Thanks for your interest! Cheers, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
