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

Kemahiran: Excel, Excel Macros, Excel VBA

Lihat lagi: 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

Tentang Majikan:
( 35 ulasan ) beijing, China

ID Projek: #19975020

Dianugerahkan kepada:


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 dalam sehari
(339 Ulasan)

29 pekerja bebas membida secara purata $38 untuk pekerjaan ini


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 Lagi

$30 AUD dalam 2 hari
(191 Ulasan)

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 Lagi

$250 AUD dalam sehari
(78 Ulasan)

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 Lagi

$25 AUD dalam sehari
(130 Ulasan)

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 Lagi

$30 AUD dalam sehari
(108 Ulasan)

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

$30 AUD dalam sehari
(101 Ulasan)

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 dalam sehari
(88 Ulasan)

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 Lagi

$30 AUD dalam sehari
(48 Ulasan)

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 Lagi

$100 AUD dalam 2 hari
(19 Ulasan)

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 Lagi

$30 AUD dalam sehari
(7 Ulasan)

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 dalam 2 hari
(4 Ulasan)

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 Lagi

$30 AUD dalam sehari
(5 Ulasan)

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 dalam sehari
(1 Ulasan)

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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)

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 dalam sehari
(0 Ulasan)

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 Lagi

$35 AUD dalam sehari
(0 Ulasan)

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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)

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 Lagi

$25 AUD dalam sehari
(0 Ulasan)

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 Lagi

$30 AUD dalam sehari
(0 Ulasan)

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 dalam sehari
(0 Ulasan)

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 Lagi

$20 AUD dalam 5 hari
(0 Ulasan)