I need VBA for excel.
I have 6 columns; Date, Time, Open, High, Low, Close, Vol
All I need to do is find the;
1. MAX value from column D (High)
2. MIN value from column E (Low)
FOR every hour and day from column A (Date)
So I also need Open value from column C from the first minute of each hour
Open Price, Max Price, Min Price for every hour of every day and move this result into another sheet in sequential order by date/time.
Here is a screenshot for an easier understanding.
[login to view URL]
And here is the link to the file:
[login to view URL]
BTW, column A which has all the dates is not in 'date' format for some reason.
It is shown in [login to view URL] but in plain general form.
I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 81 works on Freelancer where majority of the works I got all 5 star rating and the employer was extremely happy with my work. I believe I can do a fantastic work for you if you provide me the opportunity.
About me:
I am a Business (BBA) Graduate with major in FINANCE and MARKETING along with 4 years of experience in Sales, Marketing and Copy writing. Currently I am working for a Multinational Telecommunication Company in the Marketing and Analysis Department as an Assistant Manager.
My profound academic knowledge along with my professional experience will significantly help to deliver the best work and therefore see a completely satisfied 'YOU'
Thanks