HOMEWORK: Stock Market Data
Using the PivotTable created in the Stock Market case study, complete the following:
- Create a calculated field named "Daily Spread" (High - Low), formatted as currency with two decimal places. On which date in the sample did Amazon (AMZN) see the largest price spread? (note: you may have to remove the Daily Change field)
- Sort dates oldest to newest, and conditionally format the Daily Spread field as a Color Scale, from white (lower values) to green (higher values). Since a large price spread isn't necessarily good or bad, edit the color scale to show shades from white to blue (instead of green).
- Drag in another instance of Volume, and show values as Difference From the previous date. When did Google (GOOG) see the largest day-over-day gain in trading volume? The largest drop?
Answers below (no cheating!)
- +28,353 on 10/15, -56,256 on 10/19