Average Cost
Definition: a method to calculate the price of assets bought or acquired by dividing their price against the number of assets owned.
Formula: Average cost = (average cost before buying * quantity before buying + newly bought price * newly bought quantity) ÷ holding quantity after buying
Currently the average cost method only supports stocks, options, CBBCs & warrants. Futures are not supported by the average cost method.
First In First Out (FIFO)
Definition: First In First Out or "FIFO" is a cost accounting method in which the value of assets purchased or acquired first are deducted first when these are sold.
Diluted Cost
Definition:The Diluted Cost is a cost calculation method that distributes the profit and loss of each transaction during the holding period against the cost of the position. The increase or reduction of the position will affect the diluted cost of the stock. The profits or losses accrued when selling the stock may increase or decrease the Diluted Cost price of the position.
Formula: Diluted cost = (total amount bought during the holding period - total amount sold during the holding period) ÷ number of holdings
Profit & Loss (P&L)
Definition: The total profit and loss of a current position is not affected by the different cost calculation methods mentioned above. The profit and loss of a position can be categorised as realized or unrealized under the Average Cost method & FIFO.
Average Price, Price
Definition: The average price of a position is calculated considering only the transaction price, ignoring any transaction costs.
Under Average Cost method, the realized and unrealized profit and loss are calculated based on the average price of a position. Transaction costs are categorized into the realized profit and loss once they incur.
Holding Cost, Cost
Definition: The holding cost is calculated based on the transacted price, including transaction costs incurred when buying and selling that stock. FIFO & the Diluted Cost method adopt the holding cost to calculate the profit and loss. The position cost may differ depending on the cost calculation method used.
Examples:
The following examples demonstrate how the profit and loss, the average purchase price and the holding cost are calculated under the three different cost calculation methods.
Day |
Action |
# of Shares |
Closing Price |
Transaction Fees |
Day 1 |
Buy |
100 Shares APPL |
$170 |
$1.99 |
Day 2 |
Buy |
100 Shares APPL |
$175 |
$1.99 |
Day 3 |
Sell |
50 Shares APPL |
$181 |
$1.99 |
Note: Assuming that all transactions take place at the end of the day (i.e. Orders are executed at closing price)
- Average Price
Day 1 Ave. Price=$170
Day 2 Ave. Price=(170*100+175*100)/200=$172.5
Day 3 Ave. Price remains unchanged at $172.5 as no buy transaction took place on day 3. The sale transaction does not affect average price under average cost method.
Day 1 Holding Cost= (170*100+1.99)/100=$170.02
Day 2 Holding Cost= (170.02*100+175*100+1.99)/200=$172.52
Day 3 Holding Cost= (172.52*150+1.99)/150=$172.53
Realized P&L= (181-172.5)*50-1.99-1.99-1.99=419.03
Unrealized P&L= (181-172.5)*150=1275
P&L= 419.03+1275=1694.03
- FIFO
Day 1 Holding Cost= (170*100+1.99)/100=$170.02
Day 2 Holding Cost= (170*100+175*100+1.99+1.99)/200=$172.52
Day 3 Holding Cost=(170*(100-50)+175*100+1.99/2+1.99)/(200-50)=$173.35
Realized P&L= (181-170.02)*50-1.99=547.01
Unrealized P&L= (181-173.35)*150=1147.02
P&L= 547.01+1147.02=1694.03
- Diluted Cost
Day 1 Holding Cost=(170*100+1.99)/100=$170.02
Day 2 Holding Cost=(170*100+175*100+1.99+1.99)/200=$172.52
Day 3 Holding Cost= ((170*100+175*100-181*50)+(1.99+1.99+1.99))/(200-50)=$169.71
P&L= 181*200-(100*170+100*175)-(1.99+1.99+1.99)=1694.03
The cost is for reference only. It may be calculated inaccurately when corporate action or position transfer takes place, but cost errors have no impact on your account total assets.