I need an excel expert

Færdiggjort Opslået 3 år siden Betalt ved levering
Færdiggjort Betalt ved levering

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.

Excel VBA Python

Projekt ID: #29471487

Om projektet

13 bud Remote projekt Aktiv 3 år siden

Tildelt til:

kingqueen369

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 Flere

$775 HKD på 1 dag
(57 bedømmelser)
5.8

13 freelancere byder i gennemsnit $1041 timen for dette job

CrazyProger

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 Flere

$2000 HKD in 3 dage
(26 bedømmelser)
6.0
suryanshsingh55

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, Flere

$500 HKD in 2 dage
(107 bedømmelser)
6.1
hsh564cf84accd96

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 Flere

$900 HKD in 7 dage
(22 bedømmelser)
5.0
finecodervw

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 Flere

$1000 HKD in 2 dage
(13 bedømmelser)
4.6
statmadegreat18

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 Flere

$1120 HKD in 7 dage
(11 bedømmelser)
4.5
JohnnyZhu

Hi. I have review the detail description of the project, it can be done by using excel VBA or excel power query. I have over 10 years IT experience and now working in Macau. Please feel free to chat for more detail. Flere

$1000 HKD in 7 dage
(3 bedømmelser)
2.8
narsim3128

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 Flere

$1000 HKD in 3 dage
(3 bedømmelser)
3.5
rajaram122

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 Flere

$1000 HKD in 10 dage
(0 bedømmelser)
0.0
Wanngming

==== Able to start work right away ==== Hi, there I have read your job specification very carefully. I have rich experiences in data processing Excel VBA. As a talented and skillful VBA developer, I am 100% sure to co Flere

$500 HKD på 1 dag
(0 bedømmelser)
0.7
Bipin8422931982

I want advance excel as well as vba I can do automation as per your requirement please share much detail

$240 HKD på 1 dag
(0 bedømmelser)
0.0