Find Jobs
Hire Freelancers

Hire an Excel Expert

£20-250 GBP

Fermé
Publié il y a presque 7 ans

£20-250 GBP

Payé lors de la livraison
I need excel data manipulation and an VBA button built. I have two data series of stock and bond history. Date and closing prices for each. I will construct a portfolio (% allocation) of the two data series. The portfolio however needs to be rebalanced ie one data series will give greater returns then another which means the allocation between the two might start out the same but will change over time. This means that I want to push a button that runs through the data series and the every 6 months pulls the combination of the two back to the original percentage. The VBA codes needs to run into a loop and then ends as the data two data series ends
N° de projet : 14391553

Concernant le projet

40 propositions
Projet à distance
Actif à il y a 7 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
40 freelances proposent en moyenne £122 GBP pour ce travail
Avatar de l'utilisateur
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
£250 GBP en 3 jours
4,9 (339 commentaires)
8,0
8,0
Avatar de l'utilisateur
Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
£100 GBP en 3 jours
5,0 (874 commentaires)
8,0
8,0
Avatar de l'utilisateur
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet with a VBA button. 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).
£74 GBP en 1 jour
4,9 (246 commentaires)
7,5
7,5
Avatar de l'utilisateur
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA macro Sir :) i can do your project. please chat me for discuss for more detail about your project and im able to start working right now Thank You Sincerely Prameswara
£150 GBP en 3 jours
4,9 (371 commentaires)
7,2
7,2
Avatar de l'utilisateur
Hello, Instead of naive VBA, I can develop a professional .NET Excel Addin, which shall add a button on top ribbon and will let you compare the 2 data sets. Please discuss details via chat. Regards, Usman
£200 GBP en 3 jours
5,0 (87 commentaires)
7,0
7,0
Avatar de l'utilisateur
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel formulas and have a strong financial background. Furthermore, i'm working for the largest fund management company in SL and have already built lots of such dynamic portfolio constructions models for various clients. Please visit my profile to see more details, and if you are comfortable with those, lets discuss the project I assure you that I will go beyond your expectations, and look forward to hearing from you soon. Best regards Priyal
£90 GBP en 3 jours
5,0 (188 commentaires)
6,8
6,8
Avatar de l'utilisateur
Hi, I have read the project and understand your requirement. I did many work like this with my financial and excel competency. I am a highly trained on Excel and VB Macros. I did any project regarding automated yahoo finance/forex stock update dashboard . I did many project related to KPI template using Excel and so on. Kind regards, Fatima
£200 GBP en 3 jours
4,9 (136 commentaires)
6,3
6,3
Avatar de l'utilisateur
Hello Sir, Thank you for posting the project. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Thank you, and have a great day! Kinds Regards, Shafaqat Ali
£55 GBP en 2 jours
4,9 (94 commentaires)
6,1
6,1
Avatar de l'utilisateur
we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.
£77 GBP en 2 jours
5,0 (46 commentaires)
6,2
6,2
Avatar de l'utilisateur
Hi I would like to work on your project. I hope you will be fully satisfied after completing this project with me. You may view my profile to know about my expertise. I have 51 reviews with 5 Star rating. I pray and hope that you will consider me for this job and I will see a message from you soon. So what and why are you thinking? Let's discuss about your project................ -Sajib
£100 GBP en 3 jours
5,0 (64 commentaires)
5,6
5,6
Avatar de l'utilisateur
Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Design/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, Adobe packages, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£55 GBP en 3 jours
4,8 (75 commentaires)
5,9
5,9
Avatar de l'utilisateur
- Based on the Stock and Bond history the intial allocation being set to equal %. - Overtime depending on the Returns percentage between these the allocation % could increase or decrease between them. - Have expertise in Excel automation. - In Stocks knowledge on Stocks, Futures, Options(Derivatives). - Have done analysis and Portfolio consolidation (Freelancer projects) using the EOD Prices, Candlestick analysis - Identifying stock going higher from a timeperiod., having the technical flags, capex, Postive and Negative Momentum and Inflections etc. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio.
£150 GBP en 4 jours
4,7 (50 commentaires)
6,0
6,0
Avatar de l'utilisateur
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
£150 GBP en 3 jours
4,9 (89 commentaires)
6,0
6,0
Avatar de l'utilisateur
I am experienced at VBA coding and advanced functions. I have also experience with code behind a worksheet and workbook.
£150 GBP en 3 jours
5,0 (8 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£122 GBP en 3 jours
4,9 (58 commentaires)
5,4
5,4
Avatar de l'utilisateur
Hi I'm highly interested to do this work i have done similar projects thanks Syed
£80 GBP en 10 jours
4,7 (34 commentaires)
4,7
4,7
Avatar de l'utilisateur
Dear Client, Thanks for the opportunity to bid on this project. I’ve read your brief on the project and is ready to go for it. I’ve done work on Delphi programming, data gathering, data analysis, web researching, data entry and translation (English to Mandarin and vice versa) in the past for various clients and I’m also an expert on excel application developing. Please take a look at my profile and reviews, as my clients can prove I provide good services. I believe in my quality of work meets the clients’ expectations and satisfaction. My profile: https://www.freelancer.com/hireme/Gathix444 Can we discuss the project in details if you are available? I look forward to hearing from you. Kind Regards, Chun-Chieh Sung
£150 GBP en 3 jours
4,9 (17 commentaires)
3,9
3,9
Avatar de l'utilisateur
Dear, I could handle this project and can finish it in a short time !
£120 GBP en 2 jours
4,6 (14 commentaires)
3,9
3,9
Avatar de l'utilisateur
Hello, It seems that you need a simple Vba macro, not big deal. I will finish it quickly and give to you to evaluate it. I have a lot of experience with VBA. I created my first macro in 2003 and I have created hundreds of complicated macros (and thousands simple macros) since then (14 years). I love VBA, I am creating macros even when it would take less time to process data with Excel formulas :). Looking forward for your answer, Zoltan
£33 GBP en 1 jour
5,0 (6 commentaires)
3,1
3,1
Avatar de l'utilisateur
Hi, I am an excel and vba speecialist, you can send me the sample file and I'll tell you the max time I can create the file, I give guarantee to my job and will help you if you need make changes later.
£133 GBP en 3 jours
4,9 (6 commentaires)
2,7
2,7

À propos du client

Drapeau de UNITED KINGDOM
United Kingdom
5,0
1
Méthode de paiement vérifiée
Membre depuis juin 19, 2015

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.