I need an excel expert
$240-2000 HKD
Pago na entrega
The tool should be able to look from a list of trades (each of them have a quantity / price / time stamp etc) then easily compute the total quantity and the average price.
User would then input a target price.
If prices are equal then nothing to do, if prices are different then the role of the tool will be to find both the minimum amount of transactions where we have to change the price AND the one price that we have to replace transactions with so that the average price for the total is equal to target price.
Constraint on price : the target price as to be the same for all transactions within a certain range, range to be defined by user.
Constraint on Quantity : the quantity should be a multiple of a certain number defined by user (ie 100/200/500/1000 etc)
The tool in the end should provide the list of transactions to remove and the price we should replace them with.
ID do Projeto: #29471487
Sobre o projeto
Concedido a:
Hi, Greetings! ✅checked your project details : I need an excel expert ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and want to be discussion . I have a 5+ years of exp Mais
13 freelancers estão ofertando em média $1041 nesse trabalho
Hello. I am very interested in your project. As a senior Python developer, I am very familiar with Python and I mastered Excel VBA skills. I'm looking forward to hearing from you to discuss this in more detail. Kin Mais
hello sir/madam i have rich experience in coding in python . i have made ton of prgrams like this before. i can make you a automated script to do all these calculations automatically. i can make you a well commented, Mais
We will do your Python work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in p Mais
Hi, As I understand you need Excel VBA to automation the calculations related to Qty, price, time stamp etc. A sample would help. I am well versed with Excel VBA for automation and can help on this. Looking forward Mais
Hello, I have read the requirements of your project and I can achieve this with python. I am a data scientist with working experience in web scrapping, data processing, data analysis, text classification, anomaly detec Mais
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed pr Mais
Hi, Software Engineer with 4.8 years of experience in financial services using Excel VBA, Access VBA, python and JavaScript. Expertise on Excel automation Desktop automation Outlook automation PowerPoint automation Mais
I want advance excel as well as vba I can do automation as per your requirement please share much detail
