Suoritettu

Excel VBA program required

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.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: networking vba excel database program, excel vba program front end example, simple excel vba open external program, excel vba programming for dummies, vba excel pdf, vba excel 2016, vba excel download, useful vba codes for excel, vba language, excel vba programming pdf, vba excel examples, free examples finance function excel vba cost price, pricing custom excel vba inventory control program, excel vba starting external program, open external program excel vba, sample excel vba database program, excel vba program network multi user, excel vba run external program, program excel vba price google finance, excel vba program

Tietoa työnantajasta:
( 0 arvostelua ) Hyderabad, India

Projektin tunnus: #17830158

Myönnetty käyttäjälle:

schandraindya

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 Lisää

$2 USD / tunti
(0 Arvostelua)
0.0

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

schoudhary1553

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 Lisää

$10 USD / tunti
(259 arvostelua)
7.5
supper5guy

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

$8 USD / tunti
(64 arvostelua)
5.2
hamzah65

Completion as soon as possible Completion as soon as possible Completion as soon as possible Completion as soon as possible

$5 USD / tunti
(0 arvostelua)
0.0
$5 USD / tunti
(0 arvostelua)
0.0
mohakbhatia4

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 Lisää

$5 USD / tunti
(0 arvostelua)
0.0
vakash628444

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 Lisää

$2 USD / tunti
(0 arvostelua)
0.0
shashikumarnd

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.

$4 USD / tunti
(0 arvostelua)
0.0
atllezaguilar

Tengo experiencia en todos los elementos de Office, el Excel es de los más completos, puedo ayudarle.

$6 USD / tunti
(0 arvostelua)
0.0
bhsriram

I work in power plant and good experience of data analysis and excel vba. It will be quite helpful in quick completion Relevant Skills and Experience Good experience on macros vba and excel formulates. And good at com Lisää

$4 USD / tunti
(0 arvostelua)
0.0
$4 USD / tunti
(0 arvostelua)
0.0
huynhchinh1812

I have more than 3 years experience in vba code / C / C ++ / python I have more staffs that can meet short-term projects

$7 USD / tunti
(0 arvostelua)
0.0