Excel VBA program required
$2-8 USD / heure
I will make payment on hourly scheme ONLY through the website. No direct payments will be made including through paypal or some other similar option.
The data can contain upto 4000 rows and has two columns – date and value.
Input date I1 has to be validated and the user should be prompted to enter the date in the range or exit the program without crashing.
First purchase of quantity I2 will be made on date I1.
If the price on any date in the range subsequent to I1 satisfies the annual profit condition the program should display such date along with the gross total purchase price and the gross total notional value. In this case I4 and I5 will not be used at all.
In case the price does not meet this profit percentage condition (I3), then the program will check for prices to find out the first date when it is less by I5 percent. If this condition is found an additional purchase of I2*I4 is made thus reducing the average procurement price. Taking the purchase cost on different dates, the condition if profit percentage is met will be checked on the following dates. If met then the program should display such date along with the gross total purchase price and the gross total notional value. At this stage I2 will be updated as I2*I4.
The above cycle follows till either the date when the profit percentage condition is displayed or there is a deadlock. Deadlock happens when the price neither raises adequately to meet the profit percentage condition or there is no opportunity to buy comes based on I5. If deadlock occurs then the program should display “Deadlock” and end after user presses the OK button.
I have attached a rough flowchart with this. Please go through the same and respond soon.
You should accept all these inputs in a form and the result should also be displayed in a form of msgbox.
Nº du projet : #17830158
À propos du projet
Décerné à:
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and I have held several senior level positions during my professional career spanning over 15+ years. I have around 5 years Plus
12 freelances font une offre moyenne de 5 $/heure pour ce travail
Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel VBA program required. I've delivered more than 400 + projects in the last 5 years and this makes me very confiden Plus
Hello there, as an expert in excel and VBA, i can help you to such a script in excel as you have specified. Please contact me and let us talk more about your project. Thanks
Completion as soon as possible Completion as soon as possible Completion as soon as possible Completion as soon as possible
I am a VBA expert with 6+ years of expertise in Excel, Work and Outlook VBA macros and integration across applications. I am very much clear about the requirement and I consider myself apt for this requirement. I will Plus
I am vba developer in american express. I am expert in vba/macro, advance excel, ms access and sql. I have more than 6 years of experience. I am doing this kind of work for many years that's why you can aspect quality Plus
Hi there, I have experience in excel VBA coding to clean and analyse data, i have worked on research projects with both primary and secondary data.
Tengo experiencia en todos los elementos de Office, el Excel es de los más completos, puedo ayudarle.
I have more than 3 years experience in vba code / C / C ++ / python I have more staffs that can meet short-term projects