Hello There,
I was just working on a project of creating a database for a relative that
have alots of clients. His company managed the shares ****tfolio of clients
and he requires the buy price of each stock in a particular client
accounts
to be weighted averaged every time there is a purchase in stock, but use
the
previous weighted average for a sold in stock.
say:
For Stock XYZ's, in A ****tfolio
1. Buy 1000 shares of XYZ @[EMAIL PROTECTED]
$2
2. Buy 1000 shares of XYZ @[EMAIL PROTECTED]
$2.50
3. Sell 500 shares of XYZ @[EMAIL PROTECTED]
$2
4. Buy 1000 shares of XYZ @[EMAIL PROTECTED]
$1
Weighted Average Price:
1. 1000 shares $2
2. 2000 shares $2.25
3. 1500 shares $2.25
4. 2500 shares $1.75
I look forward for your help. thank you very much in advanced
Sincerely
Edmund
Below are the dummies that i have created:
http://downtown.vc/7DVFQULBUV39/Shares-Example.mdb.html
