Skip to main content

Used transaction effects

Standard transaction types are located in the attached Excel document:

transaction_types_20220104.xlsx

Effect in UI

Values in database / UI

Cash effect

1 = Add -1 = Reduce

Net effect

1 = Add -1 = Reduce

Amount effect

1 = Add -1 = Reduce

Return effect

1 = Add -1 = Reduce

Realized profit effect

1 = Realize profits/losses

2 = Realize profits/losses indirectly

3 = Realize profits/losses by closing open position

Purchase price effect

0 = No effect

-1 = Reduce

1 = Add

2 = Keep original purchase price

3 = Keep original purchase time

Purchase price profit effect

0 = No effect

1 = Unrealized profit

2 = Realizes negative purchase lots

Market value effect

1 = Add -1 = Reduce

FIFO

1 = Add -1 = Reduce

Ratio effect

1 = Relative effect on amount and unit price

Security 2

-1 = Based on another security

1 = Removes 2nd security

2 = Removes 2nd security entirely

Group

1 = Yes - same

Tax effect

1 = Add -1 = Reduce

Tax effect 2

1 = Add -1 = Reduce

Cost effect 1

1 = Add -1 = Reduce

Cost effect 2

1 = Add -1 = Reduce

Paid in capital effect

0 = No effect

1 = Adds paid in capital

-1 = Reduces paid in capital

Commitment type

0 = Not defined

1 = Price

2 = Amount

Commitment effect

1 = Add

-1 = Reduce

Distribution effect

0 = No effect

1 = Adds distribution

-1 = Reduces distribution