Find Jobs
Hire Freelancers

Macro coding for excel

£20-250 GBP

Terminado
Publicado hace más de 5 años

£20-250 GBP

Pagado a la entrega
In the first instance I would like to be able to insert a new column between column I and H which calculates the amount of points difference between to 2 values as highlighted in red (F2 and F4). This is replicated down the sheet every 3 lines as 3 lines represents one transaction (in yellow), buy/sell then modify then close. Then I need something that would allow me to do filters on the data on an ad hoc basis eg: search for all trades opened between specific times (column c would either say buy or sell for the opening of a trade) search for all trades with a point number above "X" (new column above)
ID del proyecto: 18237518

Información sobre el proyecto

40 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hey? How are you? I have reviewed "Macro coding for excel" .I have good skills for these (C++ Programming, Data Entry, Data Processing, Excel, Visual Basic). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
£140 GBP en 1 día
4,8 (103 comentarios)
6,0
6,0
40 freelancers están ofertando un promedio de £129 GBP por este trabajo
Avatar del usuario
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in C++ Programming, Data Entry, Data Processing, Excel, Visual Basic. Please ping me for more discussion.
£210 GBP en 3 días
4,9 (453 comentarios)
8,3
8,3
Avatar del usuario
Dear Employer, I have ready your Artur sample file. I completely understand your requirement. You want a column between current Col I and H which will tell you the differece between Close and Buy of each transacrtion. Also you want to filter out data on the basis of may be dates or the new column or any other column. I will give the macro wherein you can feed the values and you will get the results. Please give me an opportunity. I am an expert and my reviews will testify that :) Do give me a chance!! :) Thanks and Regards, Ash
£166 GBP en 5 días
5,0 (251 comentarios)
8,1
8,1
Avatar del usuario
Hello, I’m an Excel VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.
£150 GBP en 3 días
5,0 (482 comentarios)
8,0
8,0
Avatar del usuario
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£167 GBP en 7 días
4,9 (179 comentarios)
7,8
7,8
Avatar del usuario
Dear client I can certainly help you in this project. I am an expert vba developer and I have done many succesful project sin the past. I would like to discuss the work with you. Please contact me. Roy
£120 GBP en 3 días
4,9 (462 comentarios)
7,3
7,3
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
£150 GBP en 3 días
5,0 (310 comentarios)
7,3
7,3
Avatar del usuario
Hi Do you want to see a sample of your project on creating codes in Excel for adding columns and carry out some calculations completed before you award the project. You can consider it professionally done in less than 24 hrs. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
£150 GBP en 3 días
4,9 (68 comentarios)
6,9
6,9
Avatar del usuario
I am Chartered Management Accountant as well as CPA-Australia having 7 years of professional experience in creating databases and MS Excel macros. I can help you with the macros as required. Please contact us so that we may proceed accordingly. Cheers, AHK
£200 GBP en 3 días
5,0 (164 comentarios)
6,7
6,7
Avatar del usuario
Hi there, I am an Excel expert with over 17 years of experience and I specialize in automating tasks for my clients using advanced functions, formulas, algorithms and macros. All of your specifications make perfect sense and I would love the opportunity to create a macro which ensures that all of the specific tasks are automated and completed with the push of a button to activate the macro. A few questions for you: 1. Are you obtaining the existing raw data from a different source and pasting it into Excel? How often are you refreshing your data? 2. Regarding the searching of trades between a specific time - would that be between 2 dates? Basically I would set up the file in such a way that when you paste your fresh raw data it would run the macro which would create the new column required along with the calculation to determine point difference and also set up the search ability that you have listed. I have a few portfolio items on my Freelancer home profile if you want to take a look, and I have a more detailed file with numerous screen shots of my work as well – I can send it over for your review if you’d like. Hopefully I can hear more and we can work together! Thanks either way for reading my proposal and best of luck, Shaun
£150 GBP en 3 días
5,0 (93 comentarios)
6,6
6,6
Avatar del usuario
I am proficient with Microsoft excel and macro/VBA development, I can definitely write the macro to provide the calculation and filtering as depicted in your description,. If you are interested feel free to message me, I am available to start your project immediately Looking forward to chat further and work on your project. .
£100 GBP en 3 días
5,0 (131 comentarios)
6,7
6,7
Avatar del usuario
I have downloaded the Excel file and I am sure that I can get this done, I have few questions that I would like to discuss with you
£111 GBP en 2 días
4,7 (104 comentarios)
6,7
6,7
Avatar del usuario
Hi Nice to meet you. I have plenty experience of Excel VBA. Last my works is get news from twitter and economic calendar. Then fill cells and calculate some data. I can show my works and also ready to do your task. Let me know if you are interested in me. Regards.
£150 GBP en 3 días
4,8 (70 comentarios)
6,3
6,3
Avatar del usuario
Hello, I am Excel and VBA expert. I can do this project. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
£170 GBP en 7 días
5,0 (98 comentarios)
6,2
6,2
Avatar del usuario
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
£155 GBP en 3 días
4,6 (104 comentarios)
6,3
6,3
Avatar del usuario
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I have excellent knowledge and experience of conditional formatting, manipulating columns and rows. I can create vba macro to automate all the process which you described. 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 GBP en 3 días
4,8 (121 comentarios)
6,0
6,0
Avatar del usuario
Hi Good Day! A serious freelancer here! I can help you to complete this project in 2-3 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
£40 GBP en 2 días
4,7 (74 comentarios)
5,5
5,5
Avatar del usuario
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
£150 GBP en 3 días
4,9 (32 comentarios)
5,3
5,3
Avatar del usuario
Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ waiting your answer Regards
£50 GBP en 1 día
4,9 (82 comentarios)
5,0
5,0
Avatar del usuario
Hi, I write the macro which can do the first part as you said (meaning, inserting a new column (between H and I) and calculating the difference between two values of sell/buy and closed), send me message,and I will send you the file and check if its what you wanted, then I will continue for writing the rest of the code.
£100 GBP en 3 días
5,0 (14 comentarios)
5,1
5,1
Avatar del usuario
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
£150 GBP en 3 días
4,9 (25 comentarios)
4,9
4,9

Sobre este cliente

Bandera de UNITED KINGDOM
Stoke-on-Trent, United Kingdom
5,0
1
Forma de pago verificada
Miembro desde nov 26, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.