search

bkrajendra / trader-dss

Automatically exported from code.google.com/p/trader-dss
0 stars 0 forks source link

need a table to tell what stocks we currently hold #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
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 commented 9 years ago 
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 commented 9 years ago 
This issue was closed by revision r134.

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