Create a script that will loop through all the stocks for one year and output the following information. CHALLENGES Your solution will also be able to return the stock with the “Greatest % increase”, “Greatest % decrease” and “Greatest total volume”. The solution will look as follows (attachment). Make the appropriate adjustments to your VBA script that will allow it to run on every worksheet, i.e., every year, just by running the VBA script once. Other Considerations Use the sheet alphabetical_testing.xlsx (attachment 4) while developing your code. This data set is smaller and will allow you to test faster. Your code should run on this file in less than 3-5 minutes. Make sure that the script acts the same on each sheet. The joy of VBA is to take the tediousness out of repetitive task and run over and over again with a click of the button. Submission To submit please upload the following to Github: A screen shot for each year of your results on the Multi Year Stock Data. VBA Scripts as separate files.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |