Week #2 Homework
• Read https://www.excelfunctions.net/excel-vba-tutorial.html. Especially read all the coding examples. The objective is you can write code without looking at the tutorial.
• Understand all the codes/excel sheet mentioned in the class and can reproduce by yourself.
• (a). For the student attendant sheet example, are there any other formula/function can achieve the same functionality? Try to use other formulas to solve the problem.
(b). Write VBA code to achieve the same functionality. Add a button to the sheet. Once the button is clicked, the calculation is automatically done. The students who did not attend the class will be marked and an email list will be generated.
• Read supplementary notes about the time value of money. Write an excel file for cash flow analysis. Given a project with initial investment $X, yearly profit $Ys, discount rate R%, and the project duration N years, calculate its present value. Determine whether the project is worthy investing or not. Gain a good idea about the time value of money quantitively.
• Install R package. Instructions will be sent next week.
Optional as a preview work. Will be covered next week.
• Download the open/close/high/low prices of a stock that you are interested, draw its candlestick chart. Also draw SMA/EMA and Bollinger band indictors.
Submission
Submission is required for question 3 and 4 only. If you cannot work them out, no submission is needed.
When you submit, save the file name as hw2.YourLastName.YourFirstName.YourID.xlsm.
Submit the homework by Feb. 27 Thursday.