Mark Knecht wrote:
>
> 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
>
>
I've never used either tool, but Data >Filter and Data >DataPilot spring to
mind. What is the criterion for deciding the page to which a particular row
is copied? Is there a column which contains that criterion? What is the
reason for separating transactions that way?
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. It
sounds like a headache requiring counting of sales, purchases and sheets but
I imagine scripting could achieve what you want.
--
View this message in context:
http://www.nabble.com/scalc---Extracting-certain-rows---is-it-possible-tf3688428.html#a10316605
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
