9 Replies Latest reply on Aug 15, 2018 1:22 AM by Ombir Rathee

    Stock Analysis : Which Stock performed best/worst ?

    Ombir Rathee

      Hello Experts,

       

      This is my first post so please bear with me.

       

      I have stock market data of two exchange NASDAQ and NYSE for period 1998-2017.

       

      This data includes:

       

      1. Monthly average price (USD)

      2. Monthly average market cap (in Millions USD)

      3. Sector information

       

      Based on Data, I would like to answer below questions during financial crisis of 2007–2009 also known as the global financial crisis and the 2008 financial crisis.

       

      1. Which stocks and/or sectors performed the worst during the financial crisis? 

      2. Were there any stocks that performed well ? 

       

      Please help me with some view to answer above question. I have intermediate Tableau knowledge but couldn't able to start with this problem.

       

      Any help is greatly appreciated. Workbook Attached.

       

      Thanks,

      Ombir