2019 Week 13: Can you create a dynamic view of historical DATA prices?

This week were taking a look at Tableau Stock prices using candlestick charts. So whats different about this? The dates aggregate at differet levels depending on the number of candlesticks! This challenge is not easy so there are 2 achievement levels. You can make this chart using either a gantt chart or by unioning the data to itself. I’d recommend the latter.

Challenge

Click to view on Tableau Public

Requirements

Intermediate

• Format: 800px by 800px
• Create a candlestick chart with two stick that dynamically changes date based on the date ranges selected.
  • If there are more than 20 months of dates: aggregate to month.
  • If there are less than 20 months of dates but more than 15 weeks of dates: aggregate to week
  • If there are less than 15 weeks of dates: aggregate to days
• For the “background” candlestick: the high point should be the highest high from the dynamic date period; the low point should be the lowest low from the dynamic date period.
• For the “foreground” candlestick: two values should be the open of the first date of the dynamic date period and the close of the last day of the dynamic date period.
• Add color to show whether the final close price is higher or lower than the first open price.
• To filter the data create two parameters: One that selects a date in the center of a time period and another that helps you select dates prior to and after the center date. (ex: selecting a value of 7 for 2019-March-23 will filter from 2019-March-20 to 2019-March-27)
• Match tooltips and formatting

Advanced

• Add a second chart that shows the entirety of the data but uses reference lines to suggest the range of data showing above it.
• Use rounded corners on your candlesticks.

Dataset

This week uses Tableau stock prices.  You can get it here at data.world

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.