Find Jobs
Hire Freelancers

Excel / Visual Basic (challenging project)

£250-750 GBP

Completed
Posted about 10 years ago

£250-750 GBP

Paid on delivery
I have a fairly challenging Excel / Visual Basic project. I have attached a file that contains all the instructions. The data that I provided in the file is just for illustrative purposes. I generated these dummy variables using the random number function so they do not match up perfectly. Do not let this confuse you. The data that I have is tens of thousands of rows. So I will need you to explain how to apply the formulas that you come up with to my data. This is a complex project so only apply if you know what you are doing. I will pay only for work done. I only pay the minimum up front. There is some simple algebra involved. Any questions please ask.
Project ID: 5362229

About the project

54 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have considered the attached document and believe I can deliver on all requests. As you have laid out in your sample document, it seems your problems would need to be solved one at a time. I have addressed each below: Problem 1: Getting company name listed next to each metric. - This should prove fairly easy if “company name” is always the first metric listed for each symbol. Problem 2: Net Income (Profit Statement) or Net Income (Cash Statement) - Again, it should be fairly easy to search for the existence of “Profit Statement” or “Cash Statement” prior to the listing of each “net-income” item, and therefore classify the net income listing properly. Problem 3: Reorganizing the data. - As long as you have a list of all available metrics in the order that you want, and the metrics are each labeled the same (i.e. MARKET CAP is always MARKET CAP, and not MARKET CAPITALIZATION sometimes and MARKET CAP, other times), re-ordering the results into such the same order should not be of issue either. -Finally, once all items are re-ordered and labeled properly, the new metrics/formula lines can be added/calculated (problem 4) in their proper positions to complete the data set. To test the functionality, you could send me a small data sample, I could create a macro that outputs the sample results as requested, and if so, you can then test the macro on a full data file to see if all completes as requested on a full set of data. Will be awaiting your reply. Thanks, Shaun
£400 GBP in 10 days
5.0 (1 review)
3.4
3.4
54 freelancers are bidding on average £369 GBP for this job
User Avatar
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
£333 GBP in 10 days
5.0 (723 reviews)
8.5
8.5
User Avatar
Hello there; your 5-star excel and vba coding expert is ready to help your project. kindly check my profile and feedbacks first to have some idea about the quality of my work. I had many similar excel/vba coding tasks, all achieved with 5/5 rating and perfect feedbacks. I read your project descriptions carefully, reviewed your excel template. I exactly got what you do actually need...pls get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I agree with your payment terms (release of payment upon complete approval of the task from your side). awaiting your (+) reply to go ahead....regards,
£263 GBP in 7 days
4.9 (278 reviews)
7.8
7.8
User Avatar
VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for Real Estate program (there is a video demonstration) and feedback at https://www.freelancer.gr/u/paris2785.html I have reviewed your file and all 4 problems are straight-forward. I have set the minimum milestone (25%). I can start right away. For any questions, please let me know. Paris
£250 GBP in 5 days
4.9 (222 reviews)
7.4
7.4
User Avatar
Hi Ned. I have significant experience in dealing with up to 800,000 rows of data in Excel. In fact my current, market statical analysis project involves a bulk amount to data to be processed via VBA macros. I have looked at the sheet but it needs a little explanation. Lets discuss the project in detail so I may propose a solution. I shall not require any payment upfront. Usman.
£300 GBP in 4 days
5.0 (86 reviews)
6.9
6.9
User Avatar
Dear Sir/Madam I can help you on this perfectly I have both Advanced excel skills and financial background which definitely help you on this project. I'm working for the largest fund management company in Sri Lanka and have very good experience in advanced financial evaluations using excel functions. this is totally driven by two basic principles 1) Date entry and 2) Output ;-) You can visit my profile to see my reliability If you are comfortable, I'm happy to help you on this task I look forward to hearing from you Best regards Priyal
£500 GBP in 5 days
5.0 (188 reviews)
6.8
6.8
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
£388 GBP in 10 days
4.9 (120 reviews)
6.3
6.3
User Avatar
Hi, I have carefully gone through the examples you provided. I can process and arrange the data as per your requirement with 100% accuracy. Please can you share the complete file with me. I will process it and send it for your review. If you are satisfied with the results, you can award me the project. Please take a look at my reviews for Excel projects and consider me positively. Regards Ravi
£277 GBP in 3 days
5.0 (136 reviews)
6.3
6.3
User Avatar
I have excellent experience with Excel & VBA[10+ years]. Please check my past reviews and ratings. I assure you 100% accurate & quality job. Please provide more details so that i can give you a demo work. If you are 100% happy with my demo work then you can award me this full project . I am sincere,honest and hardworking independent freelancer . I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
£250 GBP in 3 days
4.9 (150 reviews)
5.9
5.9
User Avatar
Good day, Peace of cake! I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
£250 GBP in 5 days
5.0 (69 reviews)
6.0
6.0
User Avatar
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
£311 GBP in 4 days
4.9 (62 reviews)
5.7
5.7
User Avatar
Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, preparation of income statements,regression and price models. In my projects, I work extensively on excel. Prior to this, I finished my MBA from one of the top colleges in Asia. I am familiar and have worked on the kind of the projects, that you have posted. I believe I can do it with required quality and precision. Please revert back for any questions/clarifications. Regards! Vikas
£342 GBP in 5 days
4.9 (38 reviews)
5.6
5.6
User Avatar
Hi, I went through the problem sheet and the various problems stated in the sheet. I intend to achieve the desired result using VBA. Mentioned below is my brief profile =========================== Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
£500 GBP in 10 days
4.9 (66 reviews)
5.5
5.5
User Avatar
Hi Ned, I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based (Manchester) , a native English speaker, available on Skype and currently on UTC (Which will not surprise you as it happens). I am available now and would aim to finish in 5 days to allow plenty of time for discussion. I have done several similar projects, I am familiar with the market terminology and I can handle the inevitable random quirks in the data. I would like to do this. Please make contact. David
£325 GBP in 5 days
4.9 (33 reviews)
5.0
5.0
User Avatar
Dear sir, I am a professional for VB and excel using with formulas and like to do your project. Please hire me to give my best for your project. Thank you.
£333 GBP in 10 days
5.0 (8 reviews)
4.6
4.6
User Avatar
Greetings, I have been using Excel and Application for some 10+years and have gained extensive knowledge that would be of value to this your project. I hope my years of using MS Office (EXCEL) has allow me this opportunity in offering my experience to you on this project. If you have question please ask and I will respond shortly. I now await your response. regards Venice Brooks
£350 GBP in 3 days
4.6 (8 reviews)
4.9
4.9
User Avatar
Hello I am working with MS-Excel and VBA for the past 12 years and have completed successfully a no. of excel VBA projects through freelancer.com. I am ready to do your work and have gone through your project description and the file that you have asked for reference. This can be done by Excel VBA macro. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from my clients until the job is fully done as per their satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
£277 GBP in 7 days
5.0 (18 reviews)
4.5
4.5
User Avatar
Good day! I am interested in your project and I can get this done for you better and faster than anybody else here. I am thoroughly skilled in Excel and macro programming. So this wouldn't be an issue for me at all. I have checked the excel sheet and the 4 problems that need to be solved. I am fine with getting this done for you within the 4 days I have quoted. Btw, it would be easier if we could communicate on Skype or on phone, once the project is awarded, so I can get this done exactly the way you need. Thanks and I look forward to working with you. Best regards, Alex
£400 GBP in 4 days
5.0 (7 reviews)
4.3
4.3
User Avatar
Hello NedHulton I am an Excel VBA developer. Using VBA to fix "problem four" is quite easy: the macro is able to start at row 1, stop at every 8th row (or nth row, if you want) and generate the dividend yield formula on the fly and insert it into that cell, then carry on down the column of values. It could check the text in column A and only insert the dividend yield formula based on what the text reads (allowing the formula to occur with varying numbers of rows between them). Both of these scenarios are quite easy to do using VBA. Please contact me to discuss any questions you may have about this or to get this project completed quickly. Best regards, Brent
£250 GBP in 5 days
4.9 (24 reviews)
4.1
4.1
User Avatar
Hello! I have 8 years experience in programming. I know VB and Excel well. I can make this project for you. Everything will be done according to your requirements. I'm ready to discuss your project in detail.
£250 GBP in 7 days
5.0 (7 reviews)
3.9
3.9
User Avatar
I can do this. I am a little confused how to calculate these values Dividends Per Share and Share Price, or they will per provided? and where to put (NX + Y) value? Just a little discussion will make every thing clear i have worked on Excel Files before like the same work you need so not a issue in completing this project. Thanks
£277 GBP in 10 days
5.0 (4 reviews)
3.3
3.3

About the client

Flag of UNITED KINGDOM
EDINBURGH, United Kingdom
5.0
44
Payment method verified
Member since Jul 1, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.