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.