Hi. Only one comment, interlineated.
Mark Knecht wrote: > > Hi Terry - Thanks for the response. > > On 5/3/07, TerryJ <[EMAIL PROTECTED]> wrote: >> >> >> >> Mark Knecht wrote: >> > > <SNIP> >> > >> > <snip> > >> What is the criterion for deciding the page to which a particular row >> is copied? > > Old stock date sold == New stock date purchased > > Sorry, I don't know the significance of ==. You would not necessarily make the new purchase on the same day as the sale, would you? I would think that the next purchase, not already extracted, following a sale would go on the same sheet. You could do that with scripting; I don't know about other tools. There may be more than one sale followed by a purchase, another sale and other purchases. >> 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. > >> <snip> > Thanks for your interest! > > Cheers, > Mark > > -- View this message in context: http://www.nabble.com/scalc---Extracting-certain-rows---is-it-possible-tf3688428.html#a10333108 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
