I would like to use Excel VBA to display three different sets of data onto a chart, Daily, weekly and monthly. A button and macro is assigned to each. Then the button is clicked, a macro will run and display the data from the respective columns. A moving average is to be displayed, with the interval taken from a pre-determined cell within the sheet. Additonally, the macro will also add a horizontal line on the chart, using a value in a separate pre-determined cell, also on the same sheet. Both the MA and the line will be formatted with particular colours. I have created a requirements spreadsheet which clearly explains my requiremement in more detail. It also shows the structure of the three different types of data. The weekly and montly data have multile blank rows between data in cells. The data also grows daily, weekly, monthly, so the vba needs to handle this. I expect to have to click the buttons to refresh each chart view, which should always use all data in each of the columns. Please take the time to review this, and please ask me any clarification questions you wish.
Dear Sir/Madam,
I have 4 years experience in Excel VBA programming working for companies like IBM, MSCI and Ford.
I think your requirements are quite clear so I could start working on it immediately and come back with results by this time tomorrow.
Regards,
Balint Kolosi
£100 GBP en 3 días
5,0 (121 comentarios)
7,0
7,0
21 freelancers están ofertando un promedio de £131 GBP por este trabajo
Hi,
I am good at Excel Charts 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
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
Hi there. My name is Daniel and I would be glad to help you out with this project. I think I clearly understand what you are looking to achieve. I would just like to clarify if there will be only one chart display, which will be displaying the daily, weekly or monthly data, depending on the button you click? I can guarantee an excellent job and deliver as soon as possible. Hope to hear back from you soon. Thanks
I have been developing models using Advance Excel and VBA for past 5 years with 100% client satisfaction history. This project is at my tips as I have automate so many kind of charting models in the past. Kindly contact me.
I have the expertise and experience to create a Excel file with VBA based on your requirements.
Please clarify, if the charts are dynamic selection or only a refresh of the data.
Ready to start work immediately.
Hi there,
I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement.
Over 10 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration.
Vinay
Hello Dear, I have gone through with your requirements. I have understood fully. I ll design a macro that will update charts based on data.. I can also help you with fetching data from other files, if require. I understand all the technical indicators like moving averages, RSI etc... As i have knowledge of both fields, i can perform well than others. I have also develop similar work for currencies as well which I can show you before you award me this project. Looking for your response. Best Regards
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 photoshop, 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
Dear sir,
I promise to do my best to complete your project with the skills i have to deliver it right om time,
please consider my offer and i will not let you down.
Thank you.
