Write me an Excel VBA project.
$250-750 CAD
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.
Projektin tunnus: #23960655
Tietoa projektista
Myönnetty käyttäjälle:
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]
48 freelanceria on tarjonnut keskimäärin $373 tähän työhön
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ää
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.
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ää
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ää
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ää
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ää
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ää
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ää
I can help you get this done. I have skills in Visual Basic, Data Processing, Excel, Visual Basic for Apps
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ää
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ää
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ää
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!
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ää
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ää