top of page
Search

Candle-Stick Chart For Stock Analysis

Advanced Tableau Visualizations


Data

Data is obtained from Yahoo Finance. Data is then downloaded in CSV format.




1. Connect to Data:

  • You'll need AMD stock price data in a format supported by Tableau ( CSV).

2. Data Structure:

  • Ensure your data has the following fields (consider renaming them for clarity):

  • Date: Daily date for the stock price (format: Date)

  • Open: Opening price for the day (Number)

  • High: Highest price of the day (Number)

  • Low: Lowest price of the day (Number)

  • Close: Closing price for the day (Number)

3. Building the Chart:

  • Drag the "Date" field onto the Columns shelf. Change the level of detail to "Exact Date" (discrete).

  • Drag "High" field to the Rows shelf and choose "AVG(High)" as the aggregation.

  • Drag "Low" field to the Rows shelf and choose "AVG(Low)" as the aggregation.

  • Drag "Open" field to Detail on Marks card.

  • Drag "Close" field to Detail on the Marks card.

4. Creating the Candlestick:

  • Right-click on the axis with "AVG(Low)" and select "Dual Axis."

  • Drag "AVG(High)" to the right axis.

  • Optional: Synchronize the axes by right-clicking on the top axis and selecting "Synchronize Axis."

5. Color Coding:

  • Click on the Color mark on the Marks card.

  • Choose "IF AVG([Close]) > AVG([Open]) THEN 'Green' ELSE 'Red' END" as the color formula. This will color the body of the candlestick green if the closing price is higher than the opening price and red otherwise.

6. Size and Shape:

  • Adjust the size of the bars representing the high-low range using the "Size" option in the Marks card.

  • Change the mark type to "Line" in the mark card. This creates the candlestick body.

7. Slicer for AMD:

  • Drag "Company" (or the field containing "AMD") to the Filters shelf.

  • Change the filter type to "Single Value" to allow the selection of just AMD.

8. Customizations:

  • we can further customize the chart by adding labels, formatting axes, including titles, and adjusting gridlines.

9. Aesthetics:

  • In the Dashboard change the background to an image or a solid color. Give proper headings and salutations.






The process for creating a candlestick chart with a slicer for Veranda stock prices in Tableau is very similar to the one for AMD. Here's a breakdown with slight adjustments:

1. Connect to Data:

  • Ensure you have Veranda's stock price data in a supported format (CSV). 

2. Data Structure:

  • Verify your data has the same fields as mentioned previously:

  • Date (format: Date)

  • Open (Number)

  • High (Number)

  • Low (Number)

  • Close (Number)

3. Building the Chart:

  • Follow steps 3 and 4 from the AMD instructions, dragging the respective fields onto the Rows and Columns shelves and changing aggregation types as needed.

4. Creating the Candlestick:

  • Follow steps 5 and 6 from the AMD instructions to create the dual axis, color code the candlesticks based on open and closed prices, and adjust the size and shape for the candlestick body.

5. Slicer for Veranda:

  • Drag the field containing Veranda's stock data (e.g., "Symbol", "Company") to the Filters shelf.

  • Change the filter type to "Single Value" to allow the selection of only Veranda.

6. Customizations:

  • Follow step 8 from the AMD instructions to customize the chart with labels, axes formatting, titles, and gridlines.

Important Note:

  • Since Yahoo Finance doesn't offer Veranda's data, you'll need to find an alternative source. Consider financial news websites that provide free historical data or explore paid data providers for more comprehensive datasets.

By following these steps and acquiring Veranda's stock price data, you can create a candlestick chart with a slicer specifically for Veranda in Tableau. Remember to adjust field names based on your data source.




Comments

bottom of page