Find Jobs
Hire Freelancers

Write me an Excel VBA project.

$250-750 CAD

完了済み
投稿日: 約4年前

$250-750 CAD

完了時にお支払い
I am an 83 year young retired aeronautical engineer. Used to program in Excel VBA, but have forgotten it all. I have an Excel (2016) worksheet as follows: A. Variable number of rows B. First column is company name (text) C. Second column is Ticker Symbol (Canadian or US markets) D. Third column is yield on today's price ( number in "[login to view URL]%" format) I imported this from another Excel file E. Fourth column is current price (number in "$[login to view URL]" format. Also imported I want a VBA control button that will generate an XY scatter plot with the yield on the vertical axis and the current price on the horizontal axis. Then I want something like a combobox that will let me select a ticker symbol from column 2 and highlight the associated point on the scatter chart. There should be no data labels on the scatter chart because with 100 plus points it will get very cluttered. A data label from column 2 only on the selected (combobox selection) would be nice. As a further development, the ability to select two or more tickers to compare would be a valuable option. I would like access to the final VBA code, in case I want to make minor changes, if I can recover my memory of VBA by examining your code. In addition to yield versus price, there are other important parameters that we will include in a later expansion. Yield versus time to Call Date; Rest value Versus price. etc. Please respond, so I can choose my stocks wisely.
プロジェクト ID: 23960655

プロジェクトについて

48個の提案
リモートプロジェクト
アクティブ 4年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
$350 CAD 2日以内
4.9 (146 レビュー)
6.2
6.2
この仕事に48人のフリーランサーが、平均$373 CADで入札しています
ユーザーアバター
Hello, I can help you with your project - Write me an Excel VBA project. I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. 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. Kinds Regards, Sandeep
$500 CAD 10日以内
4.9 (358 レビュー)
8.0
8.0
ユーザーアバター
Dear Employer, I have carefully read all the points of your job and have also checked the sheet. Its really nice to know that you already have understanding on Excel. Please message me, I will do the job for you. Thanks and Regards, Ash
$500 CAD 7日以内
5.0 (195 レビュー)
7.7
7.7
ユーザーアバター
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$500 CAD 3日以内
4.9 (358 レビュー)
7.5
7.5
ユーザーアバター
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will create a scatter chart and highlight some parts of it. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $450* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I will deliver the file open coded for you. I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 350 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$450 CAD 5日以内
4.9 (253 レビュー)
7.5
7.5
ユーザーアバター
Greetings! I worked in Aerospace Industry myself ( worked for Honeywell close to a decade). In Project description, I think points D and E are swapped (Third column should be current price and Fourth column should be Yield). I have reviewed your requirements and thoroughly understand the same. I can come up with a solution for the specified requirements. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$250 CAD 2日以内
5.0 (208 レビュー)
6.9
6.9
ユーザーアバター
Hello "old master", my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 250 projects successfully completed here. I would love to help you recover your memory by reading the code that i can write for you. Together we can create a tool that is 100% useful to your purpose of correctly selecting your stocks. Contact me to discuss the details. Best regards
$400 CAD 7日以内
4.9 (247 レビュー)
7.0
7.0
ユーザーアバター
Dear sir I will build you vba that will select the data on the basis of dropdown and changes with it for graph. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. would you like to discuss the project with me?
$500 CAD 1日以内
4.8 (90 レビュー)
6.5
6.5
ユーザーアバター
Hi, Would you like to see a quick demo of an Excel VBA code written for your worksheet before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. 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. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$500 CAD 5日以内
4.9 (55 レビュー)
6.5
6.5
ユーザーアバター
Hello there, I am an expert in Excel and have created numerous stock market related excel spreadsheets. I reviewed the file you attached and also saw the requirement description and can create a macro based setup that will allow you to select one or more stocks and highlight the data point on the chart as required. Please send a message to me and I will get going right away. I have an excellent track record of delivery here on Freelancer and can assure you of excellent quality work. Look forward to hear from you. Best Regards, Rishi (Automyze Consulting)
$350 CAD 7日以内
4.9 (136 レビュー)
6.6
6.6
ユーザーアバター
Hi, Keen to work on this project. Please suggest suitable time to discuss further on this. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 20 years of experience to my credit. 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
$300 CAD 3日以内
4.9 (97 レビュー)
6.0
6.0
ユーザーアバター
I am full time freelancer with postgraduate having more than 6 years of experience in advanced excel based tools, VBA automation, Graphs & Charts, MS Word automation, dynamic dashboards, web application, web dashboards, google spreadsheets, google scripting, financial modeling, and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young and Landmark Group also. You can get your work done here with highest quality at lowest price. No payment required in advance, please pay me once the job is 100% complete. . Please initiate a chat so we can discuss on this as I may have some questions. Looking forward to work with you
$250 CAD 3日以内
4.9 (40 レビュー)
5.6
5.6
ユーザーアバター
Hi there, I am an Australian-based software developer who studied Aerospace Project Management through University of Manitoba...small world! I have looked at your detailed requirements and can easily write a VBA code that will achieve the auto-updating of your scatter chart. I will also provide significant comments in my code to enable you to follow-along and re-learn what you may have forgotten. Just so you have an idea of my skillset, I have been involved in flight test for many years and have often used VBA macros to sort, filter and display test data in various graphical forms. I have also been writing my own financial applications in both VBA and python to assist with share investment management, etc. I look forward to hearing from you and would be happy to explain anything further via Private Message if you have any follow-up questions.
$250 CAD 2日以内
5.0 (17 レビュー)
4.8
4.8
ユーザーアバター
I can help you get this done. I have skills in Visual Basic, Data Processing, Excel, Visual Basic for Apps
$500 CAD 7日以内
4.8 (13 レビュー)
4.3
4.3
ユーザーアバター
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA/SQL: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of details. Regards, Sergey
$300 CAD 3日以内
4.9 (11 レビュー)
4.5
4.5
ユーザーアバター
Hi Sir, I have good experience with Excel VBA and can give you the solution you need. You will be able to pick couple of stock tickers from the table on the left and they will appear in a different color in the chart. Warm regards. Reuben
$250 CAD 1日以内
5.0 (11 レビュー)
4.1
4.1
ユーザーアバター
Hello sir, Thank you very much for a very well elicited requirements. I can do this task. More specifically I will build a tool in Excel VBA on which: - there will be a VBA control button that will generate an XY scatter plot with the yield on the vertical axis and the current price on the horizontal axis - there wil be a combobox that will allow you to select a ticker symbol and highlight the associated point on the scatter chart and show their data labels. Finally. I will deliver the excel file having vba code. Looking Forward,
$250 CAD 5日以内
5.0 (15 レビュー)
4.3
4.3
ユーザーアバター
I can do the job! About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$300 CAD 2日以内
5.0 (21 レビュー)
4.2
4.2
ユーザーアバター
Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros on a daily basis. I will be able to assist you on this project. Please contact me for more information. Thank you!
$400 CAD 5日以内
5.0 (10 レビュー)
4.0
4.0
ユーザーアバター
Whether the number of rows will be constant or dynamic? Do you mind if this data is converted to Table? Finally, how do you import the data from another Excel file? Is it manually done or via some macro? Hi i am Senior VBA expert. As 19+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$500 CAD 4日以内
5.0 (18 レビュー)
3.9
3.9
ユーザーアバター
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this quickly due to my experience with VBA. I will start right away and complete it within a day. If interested, we can discuss this further on chat.
$250 CAD 1日以内
4.9 (12 レビュー)
4.1
4.1

クライアントについて

CANADAのフラグ
East Selkirk, Canada
0.0
0
お支払い方法確認済み
メンバー登録日:2月 17, 2020

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。