Đã hoàn thành

Write me an Excel VBA project.

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.

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Xử lí dữ liệu

Xem nhiều hơn: excel vba project 2007, excel vba project plan, excel vba project search engine, fun excel vba project, finalize excel vba project, 1st excel vba project, excel vba project schedule, excel vba project description, online excel vba project india, sample excel vba project, create help file excel vba project, excel vba project online work 2009, clean excel vba project, excel vba project ideas, excel vba project import, test unlock excel vba project, add reference excel vba project vbe, microsoft excel vba project organization

Về Bên Thuê:
( 0 nhận xét ) East Selkirk, Canada

ID dự án: #23960655

Được trao cho:

aubrey03

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 trong 2 ngày
(146 Đánh Giá)
6.2

48 freelancer đang chào giá trung bình $373 cho công việc này

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$555 CAD trong 3 ngày
(764 Nhận xét)
8.5
asin1987

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. Tha Thêm

$500 CAD trong 7 ngày
(195 Nhận xét)
7.7
schoudhary1553

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 Thêm

$500 CAD trong 10 ngày
(358 Nhận xét)
8.0
P0L

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 trong 3 ngày
(358 Nhận xét)
7.5
paris2785

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 Thêm

$450 CAD trong 5 ngày
(253 Nhận xét)
7.5
elqueabandona

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 memo Thêm

$400 CAD trong 7 ngày
(247 Nhận xét)
7.0
ksriniravi

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 Thêm

$250 CAD trong 2 ngày
(208 Nhận xét)
6.9
shikhamehta

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 Thêm

$350 CAD trong 7 ngày
(136 Nhận xét)
6.6
dvcontact

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 l Thêm

$500 CAD trong 5 ngày
(55 Nhận xét)
6.5
mateenbhatti94

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 Thêm

$500 CAD trong 1 ngày
(90 Nhận xét)
6.5
wsh2

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Business Information, Programming, and Database EXPERT with GURU / MENTOR level technical credentials at [login to view URL] Thêm

$504 CAD trong 7 ngày
(55 Nhận xét)
6.4
finecodervw

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 Outloo Thêm

$300 CAD trong 3 ngày
(97 Nhận xét)
6.0
bhupendrayadav

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 dashboar Thêm

$250 CAD trong 3 ngày
(40 Nhận xét)
5.6
Sercho56

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 Thêm

$250 CAD trong 2 ngày
(17 Nhận xét)
4.8
merinsinha

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 Thêm

$500 CAD trong 4 ngày
(18 Nhận xét)
3.9
MonisZafar

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 Thêm

$250 CAD trong 1 ngày
(12 Nhận xét)
4.1
qasimalikgmail

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 scatt Thêm

$250 CAD trong 5 ngày
(15 Nhận xét)
4.3
ielucerotrad1

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, Thêm

$300 CAD trong 2 ngày
(21 Nhận xét)
4.2
SergeyKyiv

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 co Thêm

$300 CAD trong 3 ngày
(11 Nhận xét)
4.5
yhleow

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 trong 5 ngày
(10 Nhận xét)
4.0