Saturday, July 9, 2011

What is Average Price in Citiseconline's Portfolio?

Recently, I tried to compute the average price column as shown in my portfolio by using the sales price of the shares. Unfortunately, I did not come up with the correct figures. I have used all the mathematical equation I know but all of them were futile.


Action
Stock Code
Market Price
Ave. Price
% Gain/Loss
BUY SELL
15.9000
15.0918
5.36%
BUY SELL
60.7000
62.8556
-3.43%
BUY SELL
11.0600
8.9262
23.90%
BUY SELL
214.8000
213.5281
0.60%
BUY SELL
3.1800
3.1794
0.02%



So I asked the helpdesk of Citsec to provide the computation of the Ave. Price column. The customer service replied quickly to my queries and explained this Ave. Price column.


All the while, I thought the computation is based on selling price but when I received the e-mail from Citisec, the computation is based on cost. 


Below are data taken from my actual portfolio with Citisec. I bought ALI twice on a different date and price.


The average price computation in your portfolio shows the actual cost per share that you paid for based on your total purchase cost (including transactions charges) divided by your total number of shares.  This is a running computation, which is automatically computed by the system every time you acquire shares of the same stock.  

Below is a sample computation of your purchase and average costs:

                

   Average Cost    = (21,061.95 + 851.40) / (1,400 + 52)
                                             = 21913.35 / 1,452
                                             = 15.0918

By the way, I want o thank Citisec for their superb customer service. It really helps for us investors who are just starting to venture in the stock market.

No comments:

Post a Comment