Excel PivotTable Case Study: Analyzing Stock Market Data

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 17

  • @alexrosen8762
    @alexrosen8762 7 лет назад +1

    Great! I like how clear it becomes even without using secondary charts

  • @AkaExcel
    @AkaExcel 7 лет назад +3

    Excel Maven, Thank You for Useful video! and i have 1 question, where we can download draft data and train ourselves?

    • @ExcelMaven
      @ExcelMaven  7 лет назад

      Click the link to the full course in the video description. Once you enroll you'll be able to access all of the datasets and project files shown in the demos!

  • @ranjitjojo
    @ranjitjojo 3 года назад

    Simple yet powerful

  • @Just_Adu_It
    @Just_Adu_It 3 года назад

    Great video. I do not have the course, but I was able to follow everything except for the date. How can I add an auto-updated Date for historical price purposes? Without having to refresh the data every time you open the client.

  • @gogutzy
    @gogutzy 3 года назад

    very interesting. thanks!

  • @rj6297
    @rj6297 4 года назад +1

    Thanks for this. May I ask where did you get the 29k-entry data set for this exercise? Did you compile it yourself or did you import it from somewhere?

    • @ExcelMaven
      @ExcelMaven  4 года назад +1

      I believe this was sourced from Kaggle.com/datasets -- check it out!

  • @santoshtandukar
    @santoshtandukar 3 года назад

    Hi, Can we create Stock Chart with such Pivot Table?

  • @gadnziramakenga3203
    @gadnziramakenga3203 7 месяцев назад

    EXCELLENT

  • @jtlav9671
    @jtlav9671 2 года назад

    Well done

  • @Pilantravis
    @Pilantravis 6 лет назад +4

    How do you get a unique sample data for 500 companies all together in one chart?

    • @johnsonjay552
      @johnsonjay552 5 лет назад

      you will get it in index in your country stock market

    • @ldhighlights7661
      @ldhighlights7661 3 года назад

      yahoo finance, historical data, download

  • @lalitgiga5953
    @lalitgiga5953 7 лет назад +1

    can you explain all this thing using google sheets Plz...