Find Jobs
Hire Freelancers

Visual Basic with MS Excel Expert Needed

$30-250 AUD

Closed
Posted almost 7 years ago

$30-250 AUD

Paid on delivery
The project is to create an excel temple to track portfolio positions. The template will require the use of Macros, logical formulas and lookup functions. The template is should cover the following; 1. Transaction Entry - the only sheet used to enter data. Buy, Sell, Split, Bonus, dividends etc. is recorded here. 2. Cash Management - Update cash balance automatically as per the transaction list. 3. Portfolio positions - Show the current open positions in the portfolio and the respective return metrics. 4. Historical portfolio movement - Movement of the portfolio over a period of time. I have a template that does almost 50% of these functions. I am looking for a person who can do the remaining 50%. The freelancer should be well versed in Excel and should have worked on similar projects earlier. Demo of the earlier project will be required prior shortlisting. Detailed requirement will be shared with the shortlisted professional.
Project ID: 14345933

About the project

34 proposals
Remote project
Active 7 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
34 freelancers are bidding on average $172 AUD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$150 AUD in 3 days
4.9 (339 reviews)
8.0
8.0
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$150 AUD in 3 days
4.9 (246 reviews)
7.5
7.5
User Avatar
i can do it for you quickly and exactly .
$150 AUD in 2 days
4.9 (126 reviews)
7.1
7.1
User Avatar
A proposal has not yet been provided
$150 AUD in 3 days
4.9 (355 reviews)
6.9
6.9
User Avatar
Greetings for the day!!! We have strong experience in this field. We ensure 100% Quality with On-time deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc
$40 AUD in 3 days
4.9 (69 reviews)
5.7
5.7
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 AUD in 3 days
4.8 (87 reviews)
5.7
5.7
User Avatar
Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over the website chat for further details brgds. Itay
$100 AUD in 3 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi, seems like this is a database you are woking on. I can definitely finish this in ms excel within 1 day. If you want, we can also do this in MS Access. Based on your requirement it is best to do this in MS access if you are expecting for the data to build up in a long run. Thanks and best regards, John
$200 AUD in 2 days
5.0 (16 reviews)
3.7
3.7
User Avatar
Dear sir, I am expert in data entry & excel. I am very helpful reliable to my work. I provide 100% accurate service through my hard work and dedication. Thank you so much for view our profile! Mohammad rubal
$155 AUD in 3 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Hi, I am an excel and vba specialist, You can send me the sample file and I'll tell you the max time I can finish your project. I give guarantee to my work, and afther project I will help you by free of you want to make some changes in it.
$244 AUD in 5 days
4.9 (6 reviews)
2.7
2.7
User Avatar
Hello I am windows/desktop developer have developed many applications and websites using asp.net. I can start your work immediately please explain me the scope of your requirements I can show you my demo work also please send message so I Can attach my work to you which I have developed and show you demo as well Thanks Astron
$155 AUD in 3 days
5.0 (1 review)
1.4
1.4
User Avatar
Hi, I have worked with online banking systems of HSBC in Hong Kong and with VB macros in Excel for financial accounting for a steel manufacturer in New Zealand, Your project can be done with a set of sheets in Excel, one for each purpose like Cash Position and filled with formulae and the rest done by a few VB macros. I will give you button to click on the main Excel Sheet that will run the macros without you having to get inside the macros. Some sample work I have done is displayed in my portfolio. And I can send you the samples by chat if you can kindly initiate a chat with me. I have indicated the elapsed time as 7 days. But may be reduced once I know the exact details. I am very keen to meet the deadline once I commit it. I have 100% on time delivery record. Thanks & regards, A. T. Jacob
$225 AUD in 7 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Hi, I have read your job description and understand. I'm able to do your job. I have many experience about data entry, web research, admin task, Amazon, WP admin.I have worked on my friends projects. Please review my portfolio and let me know if you are interested to working with me. I'll try my best to make you happy with my work. Thanks! Sincerely Salma Khatun
$155 AUD in 5 days
5.0 (2 reviews)
0.0
0.0
User Avatar
Hi,dear. I am a senior software developer. I have just checked your project report, I am able to perform this task with my developer team. I am looking forward to your proposal...
$155 AUD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hello, I'm verry interrested. Excel and VBA are my every day life. Plesase give me more details about that work and the deadline to perform that.
$150 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
100% o time
$222 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in Excel, I had developed similar project before like: • Developed application to track effectiveness and forecasting for the ‘Portfolios Marketing Initiatives Plan’. The app was created in Excel (VBA coding & macros) to collect data and produce on-time reports to track and facilitate decision process for all the London Life Co portfolios • Developed application to track the Portfolios Audience Mapping Project. The app was created in Excel (VBA coding & macros) to collect data and produce on-time reports to track around 100 users/initiatives by portfolios and facilitate decision process of the Marketing Delivery Team
$200 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello,   Over the last 7 years, I have worked for several clients. Joined Freelancer with over 7 years of experience in , Data entry, Linkedin Lead generation , Google Research Expert,Web scraping.  Python and Scrapping expert with 5 years of experience.  Linkedin API developer.  Using Python, Wordpress , C Programming ,  C++ Programming, Linux,PHP,MYSQL ,Java ,Javascript ,Website Design ,Graphic Design,CSS,Research,Wordpress ,Magento ,Leads ,Web Search ,Machine Learning ,HTML5 ,Linkedin ,Landing Pages ,Web Services ,Internet Research ,Angular.js ,,Data mining,,Web scrapping,Find contacts, Data Processing,  I am a highly skilled web researcher,data entry provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills.  I have successfully completed more than 100 projects ranging from web research, data entry, Internet Research, Linkedin Lead Generation, Google docs & Excel Spreadsheet creation/editing.  Regards:Nabeel
$35 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$110 AUD in 2 days
0.0 (1 review)
0.0
0.0
User Avatar
Hello! I have enough time and experiance to complete this work. You can send me your template and we'll discuss, how I can do remaining part. I have wide experiance with VBA.
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Satkhira, Bangladesh
5.0
17
Payment method verified
Member since Oct 20, 2016

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.