bkrajendra / trader-dss

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

the portfolios table needs to be changed #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
It currently looks like this

trader=# \d portfolios
                                     Table "public.portfolios"
    Column    |          Type          |                         Modifiers

--------------+------------------------+----------------------------------------
-------------------
 pfid         | integer                | not null default
nextval('portfolios_pfid_seq'::regclass)
 name         | character varying(100) | not null
 exch         | character varying(6)   | not null
 uid          | integer                | not null
 parcel       | numeric(12,2)          | 
 start_date   | date                   | not null
 working_date | date                   | not null
Indexes:
    "portfolios_pkey" PRIMARY KEY, btree (pfid)
    "portfolios_uid_key" UNIQUE, btree (uid, exch, name)

It doesn't need the start_date in it because that's created in pf_summary
with the opening balance when the portfolio is created.

It should contain a field to tell if the stock names should be replaced
with their md5 hashes to stop you from learning them when doing practice
trading.

Original issue reported on code.google.com by peter.st...@1ab.ltd.uk on 4 Feb 2010 at 8:47

GoogleCodeExporter commented 9 years ago
and a field for the sell stop and automatically selling (or closing a short) 
when the
sell stop's been reached.

Original comment by peter.st...@1ab.ltd.uk on 4 Feb 2010 at 10:30

GoogleCodeExporter commented 9 years ago
fixed by r182

Original comment by peter.st...@1ab.ltd.uk on 5 Feb 2010 at 10:13

GoogleCodeExporter commented 9 years ago
This issue was closed by revision r182.

Original comment by peter.st...@1ab.ltd.uk on 5 Feb 2010 at 10:18