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 |