Write me an Excel VBA project.

Suoritettu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

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.

Excel Visual Basic Visual Basic for Apps Tietojenkäsittely

Projektin tunnus: #23960655

Tietoa projektista

48 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

Myönnetty käyttäjälle:

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 2 päivässä
(146 Arvostelua)
6.2

48 freelanceria on tarjonnut keskimäärin $373 tähän työhön

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 Lisää

$500 CAD 10 päivässä
(358 arvostelua)
8.0
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 Lisää

$500 CAD 7 päivässä
(195 arvostelua)
7.7
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 3 päivässä
(358 arvostelua)
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 Lisää

$450 CAD 5 päivässä
(253 arvostelua)
7.5
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 Lisää

$250 CAD 2 päivässä
(208 arvostelua)
6.9
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 Lisää

$400 CAD 7 päivässä
(247 arvostelua)
7.0
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 Lisää

$500 CAD 1 päivässä
(90 arvostelua)
6.5
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 Lisää

$500 CAD 5 päivässä
(55 arvostelua)
6.5
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 Lisää

$350 CAD 7 päivässä
(136 arvostelua)
6.6
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 Lisää

$300 CAD 3 päivässä
(97 arvostelua)
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 Lisää

$250 CAD 3 päivässä
(40 arvostelua)
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 Lisää

$250 CAD 2 päivässä
(17 arvostelua)
4.8
doctorkendrick20

I can help you get this done. I have skills in Visual Basic, Data Processing, Excel, Visual Basic for Apps

$500 CAD 7 päivässä
(13 arvostelua)
4.3
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 Lisää

$300 CAD 3 päivässä
(11 arvostelua)
4.5
reubengi

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. Lisää

$250 CAD 1 päivässä
(11 arvostelua)
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 Lisää

$250 CAD 5 päivässä
(15 arvostelua)
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, Lisää

$300 CAD 2 päivässä
(21 arvostelua)
4.2
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 5 päivässä
(10 arvostelua)
4.0
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 Lisää

$500 CAD 4 päivässä
(18 arvostelua)
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 Lisää

$250 CAD 1 päivässä
(12 arvostelua)
4.1