Closed

EXCEL FORMULA FOR CALCULATION WEIGHTED AVERAGE PRICE

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

Skills: Accounting, Data Processing, Excel, Mathematics, Visual Basic

See more: weighted average of percentages, weighted average formula in excel, weighted average excel pivot table, weighted average formula for inventory, weighted average formula statistics, how to calculate weighted grades in excel, excel weighted average if, calculate weighted average calculator, price list excel formula, excel formula max drawdown calculation, excel vba weighted average example files, weighted average stress range, formula distance calculation excel 2010, excel earthwork volume calculation, excel max drawdown calculation, excel employee lateness calculation, excel formula nett price, excel safety stock calculation, weighted average projected actual excel, ms excel critical path calculation

About the Employer:
( 0 reviews ) r, Hong Kong

Project ID: #15942848

76 freelancers are bidding on average $160 for this job

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering More

$270 HKD in 1 day
(640 Reviews)
8.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$240 HKD in 1 day
(285 Reviews)
7.2
SBITServices

Hello , I have read your project description and understood your requirement. I am an excel Expert can write formulas and develop application.I can complete task within time with 100% [login to view URL] are very responsible t More

$120 HKD in 1 day
(389 Reviews)
7.3
hdlong66

Hello, You need an excel formula to calculate the average price by the out transactions. I'm ready to start immediately. Best regards, Hoang

$120 HKD in 1 day
(132 Reviews)
6.8
ksriniravi

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

$120 HKD in 1 day
(166 Reviews)
6.7
avinav606lx

Hi there, I can write the VBA script quickly. I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

$290 HKD in 1 day
(172 Reviews)
6.5
dvcontact

Hi, I have read very carefully your project details about making an Excel formula to calculate the average price by considering the out transaction. I am absolutely sure that I can do the project very well. You wi More

$175 HKD in 1 day
(36 Reviews)
5.7
sourabhg98

Hey! This is Sourabh from New Delhi, India. I am an advanced Excel VBA programmer currently at the post of forum expert at [login to view URL] I read the description of your project and would like to offer my services for More

$169 HKD in 1 day
(82 Reviews)
5.3
tferreira67

Hi there, I believe to be a perfect fit to help you with your WEIGHTED AVERAGE PRICE formula if you are looking for professional work. Please find below my relevant experience and qualifications for your review: More

$240 HKD in 1 day
(19 Reviews)
5.5
younus15

Hello. I can do your project in less than an hour 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 e More

$200 HKD in 1 day
(90 Reviews)
5.6
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$150 HKD in 1 day
(27 Reviews)
5.2
AkilaArun

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.

$85 HKD in 1 day
(37 Reviews)
5.0
nadimvicky

My work is to prepare design calculation in excel.I have good knowledge of excel and I am good in mathematics.

$120 HKD in 1 day
(15 Reviews)
5.0
aubrey03

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.

$240 HKD in 1 day
(55 Reviews)
5.1
caprateekr

I can make the excel formula to calculate the average price Message me so that we can discuss further. Thanks

$115 HKD in 2 days
(34 Reviews)
5.1
crypthne

I have extensive knowledges in MS Access and Excel, especially in VBA. I'm sure can work and finish this project as requested.

$120 HKD in 1 day
(22 Reviews)
4.4
rajafaizan

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

$174 HKD in 1 day
(32 Reviews)
4.6
$105 HKD in 1 day
(14 Reviews)
3.9
NeetuSinghal

I have created lots of automated excel dashboard in last 9 years which shows customized reports, using graphs etc.

$240 HKD in 1 day
(14 Reviews)
4.1
afenache

Hi, I have over five years experience in using Excel at an advanced level (formulas, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and produc More

$100 HKD in 1 day
(11 Reviews)
3.9