{"id":30246,"date":"2022-03-03T11:33:28","date_gmt":"2022-03-03T16:33:28","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=30246"},"modified":"2022-03-03T11:33:32","modified_gmt":"2022-03-03T16:33:32","slug":"stock-recommendations-did-they-survive-the-pandemic","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/stock-recommendations-did-they-survive-the-pandemic\/","title":{"rendered":"Stock Recommendations: Did they Survive the Pandemic?"},"content":{"rendered":"\n
\"\"
Dashboard in Tableau<\/figcaption><\/figure>\n\n\n\n
\n
Tableau Dashboard<\/a><\/div>\n<\/div>\n\n\n\n

Introduction<\/span><\/strong><\/h2>\n\n\n\n

When finance professionals were making long-term investment recommendations in 2017, they had no knowledge that a worldwide pandemic would strike. None of their recommendations took into account what effect this could potentially have on the market. This dashboard looks at 9 tech stock companies that were highly recommended prior to the pandemic and sees how they have performed from February of 2017 to February of 2022 and gives an example of how a randomized portfolio of these stocks would have performed.\u00a0<\/p>\n\n\n\n

Questions being asked:<\/strong><\/p>\n\n\n\n

  1. Did stock recommendations from 2017 hold true despite a pandemic for tech companies?<\/li>
  2. Would a randomized portfolio result as a gain or a loss?\u00a0<\/li>
  3. Where are the major highs and lows across the stocks and what can we learn from them?<\/li><\/ol>\n\n\n\n

    Inspirations<\/span><\/strong><\/h2>\n\n\n\n

    For my visualization, I was inspired by other Tableau dashboards that focused primarily on personal portfolios or funds.\u00a0<\/p>\n\n\n\n

    GSMF Portfolio Performance (Jun2020 – Sep 2020)<\/strong><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    https:\/\/public.tableau.com\/views\/Portfolioperformancesample\/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link<\/a><\/p>\n\n\n\n

    This dashboard showcases the performance of a student-managed fund by utilizing bar graphs and a treemap. The treemap looked like it would be representing how much the fund had invested in each sector, however, it actually was actually covering the % of return from the sectors. The numbers appear off size-wise as the -.07 return of the health care industry is bigger than the consumer discretionary sector with 12.23. The coloration of the red and green didn’t represent + or – return, on the graph a 2% return showed up in red as well. Despite the sizing and coloration flaws of this graph it inspired me to create a treemap for my design in which a portfolio based on cost is represented by a treemap.\u00a0<\/p>\n\n\n\n

    This dashboard was also missing any sort of over-time comparison to see how they arrived at their return rates. Although these are displayed in bar graphs the viewer doesn\u2019t know if Best\/Worst performers contain all stocks held or if these are a representation of the top 5 and bottom 5. The comparison of the S&P 500 on this dashboard felt as though it would be better as a line graph, that way a view could see over time how the fund performed against the S&P 500 rather than just at the end. Seeing the lack of time storytelling on this dashboard inspired me to include a representation of the stock performance, the volume traded, and the portfolio\u2019s performance over time.\u00a0<\/p>\n\n\n\n

    Materials<\/span><\/strong><\/h2>\n\n\n\n

    Data Visualization:<\/strong> Tableau<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In order to create this dashboard, I utilized Tableau Public<\/a>. This is a free platform used to create data visualizations to share online.\u00a0<\/p>\n\n\n\n

    Datasets: <\/strong>Yahoo Finance<\/p>\n\n\n\n

    Yahoo Finance <\/a>Historical Data from 2\/16\/17-2\/16\/22 for Stocks: <\/p>\n\n\n\n

    APPL, MSFT, TSLA,NVDA, PYPL, MU, GOOGL, CRM, & AMZN <\/p>\n\n\n\n

    Portfolio Creation:<\/strong> Random Number Generator<\/p>\n\n\n\n

    The portfolio was created by generating # of shares in each of the ten stocks using a random number generator that could select a number from 50 to 500<\/em><\/strong>. <\/p>\n\n\n\n

    Stock Recommendation Sources:<\/strong> News\/Finance Related Blogs<\/p>\n\n\n\n

    In order to represent a wide variety of recommendations, I sourced the stocks selected from an array of different articles. These articles focused on evaluating the company’s overall performance in recent times, as well as their opinions\/predictions of how the company\u2019s stock would perform in the future.\u00a0<\/p>\n\n\n\n

    https:\/\/www.thestreet.com\/investing\/stocks\/best-performing-tech-stocks-of-2017-14432299<\/a><\/p>\n\n\n\n

    https:\/\/www.fool.com\/investing\/2017\/06\/22\/top-performing-tech-stocks-of-2017.aspx<\/a><\/p>\n\n\n\n

    https:\/\/www.marketwatch.com\/story\/6-tech-stocks-that-could-move-big-on-earnings-2017-01-21<\/a><\/p>\n\n\n\n

    https:\/\/evannex.com\/blogs\/news\/could-tesla-be-the-top-stock-pick-for-2017-video<\/a><\/p>\n\n\n\n

    https:\/\/www.cnbc.com\/2017\/01\/18\/jpmorgan-makes-salesforce-a-top-pick-for-2017-as-an-artificial-intelligence-play.html<\/a><\/p>\n\n\n\n

    https:\/\/www.fool.com\/investing\/2017\/01\/30\/3-reasons-amazoncom-is-taking-over-the-world.aspx<\/a><\/p>\n\n\n\n

    Results and Interpretation<\/span><\/strong><\/h2>\n\n\n\n

    Movement of the Stocks<\/strong><\/p>\n\n\n\n

    The main movement in these selected technology stocks occurred from March 2020 onward. Up until then, the stocks were climbing slowly, but steadily. Some analysts say that this is due to the number of people who began to trade more actively over the pandemic, due to having more time on their hands.\u00a0<\/p>\n\n\n\n

    This shows as well that although the stocks faced set back in March of 2020, the pandemic ended up being the time in which they all grew the most. As seen here some grew more than others.<\/p>\n\n\n\n

    Volatility<\/strong><\/p>\n\n\n\n

    Although the top performers’ Amazon, Google, and Tesla have performed well over this time period, their rapid growth hasn\u2019t reached a plateau. They are growth stocks, but riskier to invest in. The graph shows that they take the biggest drops, but also the largest gains on the recovery side. This chart can show which tech stocks may be better if interested in investing in growth or value stocks.\u00a0<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Active Trading<\/strong><\/p>\n\n\n\n

    Despite Apple being amongst the bottom 2 growth-wise, the stock was consistently the most popularly traded from 2017 to 2022. March of 2020 was its highest volume, perhaps representing the many who were selling off in fear of the future. The other stocks show similar trends and return to the pre-pandemic volume by 2021.\u00a0<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    The Portfolio\u2019s Performance<\/strong><\/p>\n\n\n\n

    The portfolio performed with an overall gain (each individual stock was a gain as well).\u00a0 Top performers correlate with the stock’s individual performance, as well as with the portion of the portfolio that the stock makes up based on cost. In this randomized portfolio, the shares worked out to produce large overall gains of $727,226 from an investment of $210,313. The ending value of the portfolio was $937,539. This is an extremely high return for 5 years.\u00a0<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Reflection & Future directions<\/span><\/strong><\/h2>\n\n\n\n

    This was an exciting project to take on for my first experience using Tableau. I enjoyed learning about all of the different features and playing around with the system to figure out how to create what I wanted on the dashboard. The experience was very positive overall. <\/p>\n\n\n\n

    Moving forward with the experiment I would like to look at the possible impact that inflation has on these gains to assess how well the stocks truly performed. This is more important to assess for the stocks that didn\u2019t have much movement, as this could be more of a loss than a gain, even though at the moment, not accounting for inflation all stocks ended up gaining in value. <\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction When finance professionals were making long-term investment recommendations in 2017, they had no knowledge that a worldwide pandemic would strike. None of their recommendations took into account what effect this could potentially have on the market. This dashboard looks at 9 tech stock companies that were highly recommended prior to the pandemic and sees…<\/p>\n","protected":false},"author":3964,"featured_media":30267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[340,149],"tags":[],"coauthors":[1752],"class_list":["post-30246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2022\/03\/Screen-Shot-2022-03-03-at-11.08.16-AM.png?fit=2788%2C1478&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-7RQ","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/30246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/3964"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=30246"}],"version-history":[{"count":2,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/30246\/revisions"}],"predecessor-version":[{"id":30268,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/30246\/revisions\/30268"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/30267"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=30246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=30246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=30246"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=30246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}