EXCEL FORMULA FOR CALCULATION WEIGHTED AVERAGE PRICE
$16-100 HKD / hour
キャンセル
投稿日: 6年以上前
$16-100 HKD / hour
I have a investment transactions summary for whole month while there is purchase and sales transactions. I would like to get the weighted average price, but since there is in and out transaction, average cost could be simply obtained through using total amount divided by number of shares. Please help me to make a excel formula to calculate the average price by considering the out transaction
Hello.
I can do your project in less than a day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.
I have extensive experience in Excel, Coding and Data processing.