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
79 freelancers are bidding on average $161 for this job
Greetings! I can help with formula to average only OUT transactions . Being a full time freelancer working full time on Excel projects, I work on such tasks on a daily basis. Have a Great Day! Srinivasan
Hi, I will provide you excel sheet formula as per you requirement. I have experience in this field. I will delivered it asap. let's chat with me. Thank You
I am an Excel expert specializing in creating complex formulas. I am familiar with most of the Excel functions and I can even create VB codes if necessary.
Hi, I am interested in working on this task. Can get this done within an hour if you can share the details. Would like to discuss few points and can get on to the task right away and complete.