excel formula cost base of stock purchases and sales

I need someone who has excellent knowledge of excel formula to provide me the vba formula or similar to calculate the cost of stocks that were purchased in different quantities and prices than what they are sold at. EG. (purchased 1000 @ .50, 500@.57, 1200@.63) (sold 1075@.68, 125@.73) etc. What is the cost base of the 1075qty sold at .68 based upon the previous purchase qty and price.

It is a pretty simple job. I just cannot find the information on the internet and don'thave the time. Basically i made a bunch of crypto currency trades. Buying in different quantities at certain prices. Then i sold at different quatitiies at different prices. I need someone who knows excel formula to give me the formula for a couple of pages to calculate the actual cost base of the coins that i sold

Skills: Excel, Excel Macros, Excel VBA

See more: call web service excel formula, excel formula sheet, microsoft excel formula sheet, stock cost basis calculator with dividend reinvestment, calculate cost basis multiple stock purchases, cost basis for dummies, determining cost basis of stock sold where cost is unknown, turbotax cost basis calculator, cost basis tracking spreadsheet, cost basis formula, unable to determine cost basis of stock, check excel formula aspnet, excel revenue cost graphic, excel formula convert utm latitude, excel macro data base entry, excel formula network address range, excel formula capture data time day, accounting excel formula, free examples finance function excel vba cost price, excel formula expertise

About the Employer:
( 35 reviews ) beijing, China

Project ID: #19975020

Awarded to:


Hello Sir Im excel VBA macro and formula Expert :) i can do help you build formula or VBA script in your excel file please ping me now and im able to start working today Thank you Galih

$70 AUD in 1 day
(339 Reviews)

29 freelancers are bidding on average $38 for this job


Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel VBA formula to calculate fluctuate cost. I will charge you $30* and can More

$30 AUD in 2 days
(191 Reviews)

Hi, I develop monitoring apps by algorithms formulas and API script for traders and stockbrokers in Microsoft Excel. The modules manage their trading process and analyse the symbols (including Forex instrument & Relati More

$250 AUD in 1 day
(78 Reviews)

Hi, I have the solutions ready and tested for FIFO and LIFO methods. Please award the project and get the solutions in no time. You can see the working model here [login to view URL] Regards M More

$25 AUD in 1 day
(130 Reviews)

Hello, I am Luis and I will be glad to assist you with your project. I know Excel and Visual Basic and I can do this for you. I would like to see your file to understand better your needs then discuss everything bef More

$30 AUD in 1 day
(108 Reviews)

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at I am aware of various stock valuation techniques, I guess here you w More

$30 AUD in 1 day
(101 Reviews)

Hello there, Your base cost same like FIFO in inventory. Just buy first sell first. Please contact me. I will do this task for you in 1 hour. Thank you.

$25 AUD in 1 day
(88 Reviews)

Hi there, I understand that you require a weighted average price for your purchases in MS Excel. I am a professional having expertise in the MS Excel and can complete your task effectively and efficiently in a timely More

$30 AUD in 1 day
(48 Reviews)

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel /VBA. If you'd really like to have it just on your need , you have to pay a proper price , then I can code that easi More

$100 AUD in 2 days
(19 Reviews)

Hi, I’m a data analyst and have been working with excel for over 15 years. I specialise in report automation & complex formula building. I can fix this up for you today. I’m in front of computer & can start right aw More

$30 AUD in 1 day
(7 Reviews)

Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$25 AUD in 2 days
(4 Reviews)

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o More

$30 AUD in 1 day
(5 Reviews)

hi I have a lot of skills in processing data in excel VBA. You will get accurate and fast data. I can make your request fast.

$15 AUD in 1 day
(1 Review)

I have read your project details. I can surely accomplish the task without problems. I am expert in data-entry, data-management, online marketing and email marketing. We have a team of 5 now in Hong Kong to work closel More

$20 AUD in 7 days
(0 Reviews)

Hi, I've been working for a financial institution developping data analysis and reporting applications in Excel using VBA as well as formulas for the last 10 years. Can you let me know a bit more about your project?

$30 AUD in 1 day
(0 Reviews)

I can fulfill your requirement in no time as i have already developed a Share Trading Software for the Pakistan Stock Exchange... I have seen your file and I can make a customized VBA based user friendly Software for More

$35 AUD in 1 day
(0 Reviews)

Hi, I'm Experienced Content writer, research analyst with expertise in excel and excel VBA coding and macros Expertise in: - MS office suit (including Excel VBA Macros) - Excel automation - PowerPoint Presentation cre More

$20 AUD in 7 days
(0 Reviews)

My name is Syed Qasim I work as an Accounts Manager in a company, I have good knowledge about excel formulas and inventory management, I will do your project before the deadline and submit it to you. My Qualification More

$25 AUD in 1 day
(0 Reviews)

Hi, I can help you with your Excel requirements. I have been using Excel in various work for over 10 years. Following the example you have given, the cost per stock is 0.5707. The formula I suggest to arrive at t More

$30 AUD in 1 day
(0 Reviews)

Yes I can do it. Please give this great opportunity to me. I assure you that i will do it with my full effort and with best results and good quality. Thanks in advance.

$30 AUD in 1 day
(0 Reviews)

Hi, as a retail investor, I do understand the importance of getting the actual profit of the stock I invested. Hence, I've some experience to use excel formula to get the cost base of the stock I invested, just like th More

$20 AUD in 5 days
(0 Reviews)