Homework H11

The Tesla Trades - Part II

FinCalc

Learning Goal

Learn how to automate the data cleaning and compute financial metrics.

Task

This is the second and final part of "the Tesla trades." Download the Lemonney data and Transform the figures in Euros into Dollars, and the European dates into the US format. Finally compute the daily cagr, to be reported to Ms. Tradewell.

Criteria/Requirements

Your work must satisfy the following requirements

  • Everything from the previous homework must work
  • Three new buttons transform figures, dates, and compute the daily cagr according to the formula seen in class
  • After each button, a messagebox informs the user of the results.

Hints and Tips

  • Part II does not require DB access (= you may use the big Shumway lab).
  •  The $ numbers converted from Euros in the video are slightly off. When I shot the video I used a lesser precision for the exchange rate. Ignore the converted $ numbers in the video.