need a table to tell what stocks we currently hold

[GoogleCodeExporter]

perhaps

holdings
 Column  |          Type          | Modifiers 
---------+------------------------+-----------
 pfid    | integer                | not null
 symb    | character varying(10)  | not null
 avgprice| numeric(9,2)           | not null
 volume  | numeric(12,0)          | not null

so that it's easier to work out what's currently in the portfolio.

Original issue reported on code.google.com by peter.st...@1ab.ltd.uk on 30 Jan 2010 at 6:21

[GoogleCodeExporter]

either that or we need to sum the stocks by symbol in the trades table which 
could
get slow.

An interesting challenge in the sql though

Original comment by peter.st...@1ab.ltd.uk on 31 Jan 2010 at 9:11

[GoogleCodeExporter]

need a holdings table with the details in it.

Same layout at trades but with a 'hid' not a 'trid'

Original comment by peter.st...@1ab.ltd.uk on 1 Feb 2010 at 8:48

[GoogleCodeExporter]

This issue was closed by revision r134.

Original comment by peter.st...@1ab.ltd.uk on 1 Feb 2010 at 8:57

• Changed state: Fixed