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
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
29 freelancere byder i gennemsnit $38 på dette job
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.
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
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?
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.