Sentiment trading.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Algo Trading là gì? Ứng dụng Algo Trading trong phân tích tâm lí thị trường"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*Các khái niệm về <strong>Algo Trading (giao dịch thuật toán)</strong> và <strong>Quantitative Trading (giao dịch định lượng)</strong> đã rất phát triển trên thế giới. Nhưng, các khái niệm này lại còn khá mới ở Việt Nam.\n",
    "Bài viết này nói về một khía cạnh nhỏ của Algo Trading và áp dụng một thư viện phổ thông trên thế giới vào dự báo đầu tư.*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<strong>Giao dịch thuật toán ([Algorithmic Trading](https://en.wikipedia.org/wiki/Algorithmic_trading))</strong> là qui trình áp dụng các thuật toán Machine Learning để thiết lập các giao dịch tự động hoặc đưa ra khuyến nghị giao dịch. (trước trước khi Machine Learning trở nên mạnh mẽ, Algo trading định nghĩa là áp dụng chuỗi các quy tắc tự động trong đầu tư) \n",
    "\n",
    "Trong thế kỷ 21, giao dịch thuật toán (Algorithmic Trading) thu hút được sự quan tâm chung của cả trader khối bán lẻ lẫn tổ chức. Nó được sử dụng rộng rãi bởi các ngân hàng đầu tư, quỹ hưu trí, quỹ tương hỗ và quỹ đầu cơ. Algorithmic Trading có thể thực hiện một lệnh lớn hơn hoặc thực hiện các giao dịch nhanh đến mức con người không kịp phản ứng. \n",
    "\n",
    "Một nghiên cứu vào năm 2019 cho thấy khoảng 92% giao dịch trên thị trường Forex được thực hiện bởi các thuật toán giao dịch chứ không phải con người. (Source: Wikipedia [Algorithmic Trading](https://en.wikipedia.org/wiki/Algorithmic_trading))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Biểu đồ gia tăng khối lượng giao dịch bằng Algo Trading trên thị trường"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAywAAAGaCAYAAADtgsfcAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAEtvSURBVHhe7d2/bvNYf/1tn8kcxTQ+hUHwnsJURvpp07xNbiBIYQRIk95In8LdU6dNG7hKmS5noJ+3SNrbW0sUKVHLe9GfC1iYua0/5qIokl9Lsh8OAAAAANApBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBhYAAAAA3WJgAQAAANAtBpZw//M//3P4z//8z8N///d/j1/5eVgH+1EeyykAvMo+9G9/+9sx//Vf/zV+9WfheHI91h3uiYElWNk5PDw8fKQcZNL827/92+Hv/u7vDv/wD/9w1U4uYR3c2vGnKI9d/Vi2QwvrEbiP//3f/z0+r+rnX0l5zv0kezimfhfWHe6NgaUT5adZ9ZO95D/+4z/GS7X0HUT5SUy9/P/8z/88XrJc7+tgi45LlZOL+nstTS/rrCxHvVz1wOJcj07lOV73qvP3f//3x8f0p/6kGz7l+aS2wSXPs/Z5W1K22zIELVGeA+UHEfXtv+v5nXhMbfchS36Y0/bcYh+Tfj6C/jGwdEL9dKvsxOek7yAunYSWA17pNEXpfR04T7TPnXRcynedHLTKY1cvV3lsJ3sdWOpOcyn7gqUngFi278CgrKt2WyvrrJwIL1l39W3rLHmOtvvvOt+xvX/H8eTWbbX9YeeSV8X+/d///ctt/u///m+85Hrp5yPoHwNLB8rOon6i15n7yUf6DqL0nga1cpBsu5Y+db/6BHbS+zq41HFL1w4s5eDVg7nH27keneq+l1J6b3Fi8RMs2Xdg0J7wrn1u1bdtc2l7bU+c63zHY/Ydx5MtttX69iWXlH3JdN2yX93Cd6w7/CwMLB2oX9KtdyQlcz8t2fsOYsmOnJ3kp3JyUNZHnfaEoLxS0V6nF1scuNPUfUtq5cSx3R/0Mlz27iduS9e6dV3Vty1vY6z/fWl/XF+3fZfBdzxm5XvWy+A4nmyxrbZvB557W1i5rL5uOSZs4TvWHX4WBpYO1Dv5ckLS7rjPWbODKNedsval9nKbcvJU7n/p7cv1atPL3u3Xi/I19ZO4JTvy8rX6OvU6KJeVf5cd9KWf9Kn7Lrc7t8xFuc+yXsoO/9I6KfdxaRmmgWP6npeuv8SSdThpL5t7zIry9Wm7KOtqzXZVblvWW/3YLFnW8rVz6+Xc9aflW7o+y22mrOl0jbpvSassd315GWDmTH3L41L+/5L2Opce8+La7XS6zbXLVkz3cenxLNep19vS73fL9jxl7TZTbrNmvVxS7mPqsWR5rllXtfq25VXe+pXecmw7pyzjdL2yXa9Zjrrj0seqvT+1rZf/r5ehXK6U681tf+Xyctslj+ma3ufU67Jk7gcb7WdeLvVYui2Vy+v7VeuuXGfu+5XL5vqry8rjPy2fUu6zdFhynK6V+1v6GMKDgeWblSdQ/SQvT77yxKq/Vp4wSnkS1ddTO4h253Qu6rZzL9eXA1FZ1lbbp2jvZ9pptNedftKzZJmn66p1UJar/cn0dFlLLW+57/b25d/149D+RKtEvWf7XMda2aGeezuXus81Suf6/tSOd81jVm6vuk85t11M5h6buWWdW49q+ctjtXQbmNzyXLlWe9/Kkuuce66WdaC2uTWP+eTa7XSLZVv6eK7ZdxS3bs/32L+eWy+XnLu/EtWjfb6pzJ1cTurrl+2gPFb119rtaFL/YK4se7s87b7q2sdqzbZevkf99UvbV/s4rXlM126rl9S3K9/vnLKepuudezvY2m2pmFt37WOgepWv1deptxv1GJbrt/uE8u9rjtO1NY8hvPTRDzb1TmvayZSDRP1EKU865dLO9dzJhUp72/ZVnnOpdw5Fu0xqp1yuo647LcOS5Z6u295HvTNWaXc47e3ndtQl5fZz36PdGZ7rOCk74nan26Ys07XK96vva1r3tXYZzz1m7XY5l/pgMykHOXXdKe16qJd1bj22ly15DFu3PFdu0d63Mned8phc2n5KymNaW/qYT67ZTrdatjWP55p9x63b87XbzLXrZc41++sly19vA+fU15/2f/XXVI923ZfvM7evuuWxarenuW29vW79uLX7r/IYTq55TNdsq0u0J+dLhje1L9zq2F8v+9xlk7nHv7391sfp4h7PS2yLgeWb1U+q+oDf7jTKk6k1txNof8pVLivXLzux+nuWJ2h58tY7t3ZHWq5fnqTlPtTOrF62dplUph3RueUvO5v66yrTjnbu+6kDQn2QKc7dvlzv0o67rBe1U6wPmOc6TtrvUe6vbAfl4DPtPNXOdany/er7n9Z9bW4dTinXqa9XbxMl7bpWQ3Z7MJi2PbUOS+plbZexXo9zy79kG7jluXKr+vuWtNoTjLI8tbpfWb562dtta267VCnXmVyznd5j2S49ntfuO9Zuz1vtX9esl3PaZa27tPdXMu2vL62rer3OqW9TlqWoT57V/ZTlmy6ftumyvNPXSso6mdzyWNW3PZfpe7XXLfdftCez5f/rx+aax3TNtrpEu03W5xOTer2XtOcV125Lxbl1V8xdNilfq68zPSZFe/spZV2r5apTOpS0X2+fW9c8hvBiYPlG5YlQPwnqg1q7M1M7rrmdQH3AaHdc9fctT8xau0zlidoq91dfp+zQJmrHUr7HtPOZ/lvMLX8xtwObqO83HTSL9kBTUu9s1O3rA165bnt5Sf3TpXpdl9Q95jq2B5h6uSfTweJa167Dc49ZeezVfRT1QaHdrtqu7XbVblMl9fdpl3FuHZes2Qaufa5sYbrvKa32QFkvX/tcrbfJSd372ufpNdvp1su25vEslmz3xbXb81b71zXrRWnvb+3+uli6rs6pbzs9Tu02U5azVq/baXkuLce1j1W5TX2/03Wm+6rvs73utE23z8P6Nrc+preu/1p9P2WdtOoe7bZy67Z0bt0Vc5dN5tZDe/uSLY/TWz8vcR8MLN+ofvK3O9lyUJ4uK1E7j7mdQDlwqK9P6tvV2h1SvdOYzC1bu0ylV3syMZlb/mJuBzZp70Otp7Jzqa9T38+S29frsqTdmbU7y7rHXMd2XZ9bT7e4Zh3OPWZz2vVUa7u2JzBFe0CZe5zm1vHabeDa58oW6vsuKd+/pKyv+gBZUv5dnnuTdp0qdbfy/5M1j/k12+mWy7b28SyWbPeX1MtXUqsvW7PN3LJelPb+VM9Lx5Jb11V923p566+X5Zy0J4fT9nTLcsw9VuV+6svWHpPaba3d/9/6mG6xrU7afWjds90O2h+C3rotqXU3mbtsMrce2ttvfZze+nmJ+9CPDCzqE5J6hz4pT8rp8pL6ZKWY2wnUO672yVWeyPXtau2T/px22SbtMs39JOLSTmxuBza5dB9Fe4Cs72fJ7dvlUOrL65/8zN3/uXW4pWvW4dxjVisHgHLbKXN9lmxXc8vaLmO9Hucum8xtA9c+V7ZQ3/eltAfgep2Wn6aW3m3qnzyXTNp1NveYX7Odbrls5bqtucezKLeZu1xZsz1vsX9du16U+v7mrjvXpXzP+rIl66pW37ZeF+3J86T+elmuyZrlWPNYlcvry9Yck9r7Ve90uPUxLZfXl5VluFa77dVd23dttOcTt25L7borvSZzl03m1sM1t1fqy+vj9NbPS9wHa/2btAfc8oQoT8o67dTf7iznnsTtjqs8Ocv3LDuwelCqDzBFfZv6YNI6t3ObW6bWpeuWf9eXl+u3lny/9jr1/Sy5fbscSn15vU7n7r/+evs4bGWrdTgpB7l2uzyXWr3Nnduu5pZ1bhmXLH97nfq+r32ubKH+vudSlqf+SelEXfdSJkvW2aS+3tJ1UN9maSa3Pp7F3LZUu3Z73mL/ujRz6utds78ulq6rc+rb1n3bdVT+XdRfq49pl5bj2seq3VbmtvX2uvVjWVKf5E7qy5emduv6b9X3VU6yJ/U2oLaV+nZbH/uXPAZz6+Ga2yv15fW2Wn99aeDHWv8mS3e8ddqdyKUncfsTgTZlZ9yeCNWXb73Tal26brsDqndgkyXfr71OfT9Lbt8uh1JfXu8I5+6//np9my1ttQ6LcsLQHsDnUqu/fm67mlvWuWVcsvztder7Lq55rmyh/T5l2UvKiVy7jK32tpeydp1N6ust3U7r2yzJ2mW79HiW28xdXtyyPRe37l+XZO5xKerrXrO/Lpasqzn1bdvto16/5bK5n/LPLcctj1W7rcyt0/a6ZQBtH+cymNbqy5ak/f63rv9WGarq+5u2wfpr7Q8/i/pyBpb5qO+P+9OPKu5uzc63Tn0AnHsS1wcGdWAtO7X6YDFpr3vOuest2bFMLl233QHVO7DJku/XXqe+nyW3b5dDqS+vd4Rz9790Xd9iq3VYtAfC9qB37kBWzF02mVvWuWVcsvztder7vva5soX2e61RTiqm282dYChL1tnkmu303ss293gWc9vS5Jbt+dpt5pb1oix9bOaut2RdzalvW+/7ivYHc/VytNedW45bHqt2W5nb1tV126+VY3ft1sf01vXfal/ZKuuq/Zr72L/kMZhbD9fcXqkvr7e/rZ+XuI/zWyXupt15lCdIefKotDuH+j2pc0/ieiCanvjlv/VOQGkPDOr6ZWdXX6cs52RumVqXrtvugNSyLPl+7XXq+1ly+3Y5lPrypeujXK++rF6u2i0ny1utw6L9aWmr7VNbsl3NrY+5ZVyy/O116vu+9rkyWXPdVr1MJWu063SNsrz1bc895sU12+m9l629TrtM5TZzlxe3bM9b7V9vdev+uliyrubUt23vu33rc53pLWKTueW45bEq91NfNretn7tuO3iV9T659TG9df0r9f2V84t6Gc+dkN+6Lc2t5/aysj5b7WNYf/+5+56061GpL6+X/dbHEB48Mt9gzZOj3eGXAWYy9ySuv16+X7lunXPqnxyWqJ1bu/z1gWdumVqXrtvugNqfqhVLvl97nbr/ktu3y6HUly/diV9a1+XgUO6rvr+12mWvu0+WrIOivo5aprmf0F3q2m5TJUsfpyXL316nvu/662ueK0V9IlX+f636e5es0a5TdRIwaXuUf9e3PfeYF9dsp/detvY67X2U29SXl+Vp1Zev3Z7rr9+yf12zXpRLj00xt78u2nW15PvW6tuq9Vg/R+q05paj/vrax6rcT33Z3LY+d922x7R8tz6mS7bVtdT+dMq5+791W7q0nuvLyrqs3y1SHtP68pJ6XV2676Jdj0p9+Vb7K/isO0JiE/UTQ+18W+2Ocnqizz2J1Q6gTblf9cRvv1/5d9lRlSdxe2Bod2pLdiyTS9dVP50rverlXvL92uuUf0+W3L58rb6OUl9eP6aX7r9d1yXl9mW91v++VrvsdffJknVQtNtUuV65bTloqR4ttV1Nj2f99Sn1ss4t45Llb69T33fbS6UsY3u/5XnYXq++3yXa26/Vrruy3ZTlnFKet9N16mVbss5q6jG6tJ3ec9na69S3L5bsO9rHvXy93M+S7fnabaa4dr2c095f+ffS/XVRvmd9nSXfs1bftt0GirIc9XVKyvK15pbjlseqXK++rNz2nLnrzv3w8JbHdMm2ulZZL+19TqlfCW21Pcq/l25Ll9ZzuX59+aXU62nJY1i+Vl9HqS9vt9VbHkN4rD9C4ibtjmTJT1PaHf70trBLT+L2CXgu7RO3nIgtuW25Tv1TkmLJjmWy5LrnlmO67pL7aK9T/j1Zcvvytfo6Sn15vT4v3b86WLUpj/+12mWvu0+WrIOivV6b9oDUmjuIlrTbeb2sc8u4ZPnb69T3XVzzXFEDS/t8uKS9/VpLn6slS9encs12es9la69T336ydt/R5tL2fM02U1y7Xs5Zen/lOmr7LOujvt6S71mrb9t2LdS2U77WmluOWx6r9rZz2/ql65Z+9eXTsfjWx/TcbeeW9RJ1f2U9zbllW7q07i7tQ67d/0/K1+rrKPXl935eYnvrj5C4Sf2kKk+OuZ92TNon6/REK0+w+uv18FN+GjB9vf1JQfurN0vaA0i57/o+6pTbnjuJnlum1pLrluu0P9kpmZZ36X3U1yn/niy5ffnadHnprtTrs143S+6/PL7tAbdkbj0vVS97Sd19smQZJ2W9t9tOybSc07/PrSf1E9Hy7+l71o/10sdpyfK316nv+5bnSv24XToZUOr7PrfOLildzj1XS8o6rT/7VixZZ61rttN7LVt7nfLvVvna3L6juHZ7vuf+tUStlzlz9zf3+BRl/dbXV+tyTt21LINSPw7tupxcWo5rH6tyP/X157b1S9ctx+t6GervNfcYlMw9puW2l7bVtcp6ae+v7H8vmetR+s491+vrqvV8bv8/9awvK/c3WXLf9fZTPy61+v5Vj7nuJWufl9gWA8sOtT/Jrp/4k7KDqK9TDrTnlBOVOt+hdPjO7+9QDobfvZ6XqpdzydDdqm//nbZ4rpTbqNt9h3q9llzz2Fxy7XZa36bkHsumLNl3rFmue+9fb10v7f3tTd3NtQ2tVS/jmuVcsq061R22XKZ73OfW6mUs6XVb+0kYWHaoHBzrg6XSHnTLv4GfhucK1mKbAQA/BpYdag+o5SXO8hO/6ScF5fL6pdFzL58Ce8dzBWuxzQCAHwPLDpWXLusD5qXw0z/8VDxXsBbbDAD4MbDsVDmozn14rKR86KyX994D34XnCtZimwEALwaWH2B6q0IdAKd4rmAtthkAuD8GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0K1VA8vr08Ph4eEzj89v4yWDt+fHL5c/PL2OlwAAAAC4RXsu/vD4fKjPxk/Oxcekn5IvHliGFfR0+Oj7+vRlBQwr6PHwOcO8Hp7KSmJoAQAAAG5yci4uzrWP5+PNELMHywaWt+fDo5jOjivuuFKGFda+4jIMNfUQAwAAAGCdt8Pz45l3N1UDCgOLGDyGV1XeJ70zl58bdAAAAAAs9/lCwWQYYniFZXJm8PgYWM6+kjK88sLAAgAAANxifAvY8Zx7/P9mOBnOzct1PnPyDqhACz/DMk5waqpbMLDsYUUBAAAA32saWkrUuXdj/Mx5+rn44g/df11BQ56eykrY7hWWl5eXwz/+4z+e5J/+6Z/k1wkhhBBCCPkJ+euP347n37//+fXfD7//eXLdOn/+/n6d3/44/CUuu3fKuf0WVgwspz7eJ3fnz7CUwgAAANiXS7+mV/7A/Cd+1ODcOfWCX3D18RGO8d+JbhhY6t9WoN/6tdUKYmABAADYl8u/pnc416xP0odzywVvhdqb2RcH5tfH6Yf181w5sJx+puVkoxsnwS3eM8fAAgAAsCf1D74/fbx7Z/z3qXUfN9iPdpgbfD3/Luu0GV7Gz7Ckr691H7ovK2qKaN6+rLfVB3wYWAAAAPbl9Cf/4/nm3Nn1Rh83yHT69rh2uBtegaqvs49Xo276DIsLAwsAAMDeTCfg5aR6/P/ZV1dO3+GDn4GBBQAAAN+kftVAvRrQvKrAsPIjMbAAAADAbnr70vT2ro+3M82932snf1cE6zCwAAAAwOuGX9O7h996hXUYWAAAAOB1w6/pvfybxLA3DCwAAAAwGz+b0rzE8uXX9B6Hl+bv+Y2vzPCWsJ+FgQUAAGBD7Z95UK8GnPz62R/5e3qbD9SXNOvq9Nf0/tRfafyzMbAAAABs5MsrBEenryQMJ+H12570qw0ABgwsAAAAm1jy19uH4eTkLU0LPmwO/FQMLAAAABu5+NfbZz9sztudAIWBBQAAYDPT5zLKUDL+fz3AnH0lZbguAwtwioEFAABgU9PQMg0u45eLCwMLv/0KOMXAAgAAsJHpt1p9vgNs/C1X0xd4hQUz/r///2/fkt4xsAAAAGzh3OdQ6iGFz7BghhomHOkdAwsAAMAWZoeR6ev6rV/DKzHNH0nEj6OGCUd6x8ACAACwifGzK83LJO3fZjn5Wy3jqyt8fgVqmHCkdwwsAAAAm6k/cD9G/KX79q/hM6ygUMOEI71jYAEAAAA6oIYJR3rHwAIAAAB0QA0TjvSOgQUAAAB3o06QHUmkejjSOwYWAAAA3I06QXYkkerhSO8YWAAAAHA36gTZkUSqhyO9Y2ABAADA3agTZEcSqR6O9G7VwNL+Cr721/QNf/SounyjP9fKwAIAwDcY/z7Il2P7lOoc4OT4P4a/2o5CnSA7kkj1cKR3iweWkz9y1PxxpGFnVf91V/3Hk67BwAIAQC9O/1L78RxA/K0RoFAnyI4kUj0c6d3CgeXt8Px4+keNPndQpzuvo9enZoi5DgMLAACdEMd2BhbMUSfIjiRSPRzp3bpXWL7sjIYh5vgKyvElYzGYjC8l3/oiCwMLAAA9qI79FQYWzFEnyI4kUj0c6d2Kz7CMb/E6Dibj/087p7OvpAzXY2ABAGAHzvwgcnhbeDlH+MzJuy7wY6kTZEcSqR6O9G7Vh+4/h5aSakC5MLAs3Wm9vLwch5M2v379kl8nhBBCiC9//v5+/P/tj8Nf4rIv+fP347nCb3/8pS8nPyrqBNkRtSy9R/VwRC3LFinn9ltYPLBMPz2Zfqry8dOU8gVeYQEAYOfW/RDy9K3k+6FO+BxJpbo4kkj1cKR3ywaWc59FmQaVVz7DAgDAng0/qKx/W+i8tddPok74HEmlujiSSPVwpHcrBpZzA0n5uv6py1Y7KwYWAAC+k/6w/RxeYdk+qVQXRxKpHo70buFbwsbPrjQ7qvpvs5z8nZbx1ZUtPnTHwAIAwDc6+9bvogwzzWXH69/+DoteqRM+R1KpLo4kUj0c6d2KD92PQ0ud5icnw9Dyma1+QwgDCwAA32V8dWXm1ZKPz7V+5Nxwsw/qhM+RVKqLI4lUD0d6t2Jg+T4MLAAAoBfqhM+RVKqLI4lUD0d6x8ACAACwgjrhcySV6uJIItXDkd4xsAAAAKygTvgcSaW6OJJI9XCkdwwsAAAAK6gTPkdSqS6OJFI9HOkdAwsAAMAK6oTPkVSqiyOJVA9HesfAAgAAsII64XMkleriSCLVw5HeMbAAAACsoE74HEmlujiSSPVwpHcMLAAAACuoEz5HUqkujiRSPRzpHQMLAADACuqEz5FUqosjiVQPR3rHwAIAALCCOuFzJJXq4kgi1cOR3jGwAAAArKBO+BxJpbo4kkj1cKR3DCwAAECexDiSSPVwJJXq4kgi1cOR3jGwAAAAeRLjSCLVw5FUqosjiVQPR3rHwAIAAORJjCOJVA9HUqkujiRSPRzpHQMLAACQJzGOJFI9HEmlujiSSPVwpHcMLAAAQJ7EOJJI9XAkleriSCLVw5HeMbAAAAB5EuNIItXDkVSqiyOJVA9HesfAAgAA5EmMI4lUD0dSqS6OJFI9HOkdAwsAAJAnMY4kUj0cSaW6OJJI9XCkdwwsAABAnsQ4kkj1cCSV6uJIItXDkd4xsAAAAHkS40gi1cORVKqLI4lUD0d6x8ACAADkSYwjiVQPR1KpLo4kUj0c6d2ygeXt+fD48HB4UHl8Prx9XO3x62VPr+Mlt2FgAQDgvtRJjCOJVA9HUqkujiRSPRzp3Q2vsLwent6HksfnYVwZhpXHw/jPd8PlWwwtDCwAANyXOolxJJHq4Ugq1cWRRKqHI727fmB5faoGlK/Dy4cv17keAwsAAPelTmIcSaR6OJJKdXEkkerhSO+uHFjeDs+P1asnx7eMicFkfCvZrS+yMLAAAHBf6iTGkUSqhyOpVBdHEqkejvTuuoGlHUTOvpIyvPLCwAIAQN/USYwjiVQPR1KpLo4kUj0c6d1VA8vr08OXD9tfGlhO3iq2EgMLAAD3pU5iHEmkejiSSnVxJJHq4UjvrhhYxBCy0SssLy8vx+Gkza9fv+TXCSGEELJN1EmMI2pZeo/q4YhaloSoLo6oZek9qocjalm2SDm338LqgWX4bWBP76NIhc+wAAAQTZ3EOJJI9XAkleriSCLVw5HerRxYmg/bf9Bv/ZLDzRUYWAAAuC91EuNIItXDkVSqiyOJVA9HerduYJn5NcXHz7XUw8n46sqtn18pGFgAALgvdRLjSCLVw5FUqosjiVQPR3q3YmAZX12pP2zfGIaWz2wxrBQMLAAA3Jc6iXEkkerhSCrVxZFEqocjvbviQ/d+DCwAANyXOolxJJHq4Ugq1cWRRKqHI71jYAEAAPIkxpFEqocjqVQXRxKpHo70joEFAADIkxhHEqkejqRSXRxJpHo40jsGFgAAIE9iHEmkejiSSnVxJJHq4UjvGFgAAIA8iXEkkerhSCrVxZFEqocjvWNgAQAA8iTGkUSqhyOpVBdHEqkejvSOgQUA8GO1v46//cPIwx9APn/5nqiTGEcSqR6OpFJdHEmkejjSOwYWAMAPdPlviw3DSv3Hkl8PTzseWtRJjCOJVA9HUqkujiRSPRzpHQMLAODHOQ4jM8PKNJyc/AHk16dmiNkPdRLjSCLVw5FUqosjiVQPR3rHwAIA+GGGV1dOhpHa2/PhUQ0mx68/HPb4Ios6iXEkkerhSCrVxZFEqocjvWNgAQD8MOOrJ09Px+Hj8zMqT++XjM6+kjLcloFluyRSPRxJpbo4kkj1cKR3DCwAgB9m/CzKl7eEjZ9pmYaWCwPL7KszodRJjCOJVA9HUqkujiRSPRzpHQMLAOCHWfD5FF5hsSWR6uFIKtXFkUSqhyO9Y2ABAPwwZwaW+vMpfIbFlkSqhyOpVBdHEqkejvSOgQUA8MOMb/9qp47jqyrT51j0UDP8quPqsy47ok5iHEmkejiSSnVxJJHq4UjvGFgAAD/PcTipXykZBpR6iBn+qGQ1nIyvruzx8yuFOolxJJHq4Ugq1cWRRKqHI71jYAEA/EjtX7FXg0j7l/D3OqwU6iTGkUSqhyOpVBdHEqkejvSOgQUAAMiTGEcSqR6OpFJdHEmkejjSOwYWAAAgT2IcSaR6OJJKdXEkkerhSO8YWAAAgDyJcSSR6uFIKtXFkUSqhyO9Y2ABAADyJMaRRKqHI6lUF0cSqR6O9I6BBQAAyJMYRxKpHo6kUl0cSaR6ONI7BhYAACBPYhxJpHo4kkp1cSSR6uFI71YPLO2veKx/Z337KyJP/ijXlRhYAAC4L3US40gi1cORVKqLI4lUD0d6t2JgGf8y8OPz+/+dGoaVx8Pnr6g//SNc12JgAQDgvtRJjCOJVA9HUqkujiRSPRzp3eKB5TiQnBlWpuHk5A9qHf+ScD3EXIeBBQCA+1InMY4kUj0cSaW6OJJI9XCkdwsHluHVlbN/4fft+fCoBpPj1x8Ot77IwsACAMB9qZMYRxKpHo6kUl0cSaR6ONK7hQPL+ArK09NxAPn8nMrT+yXl4nOvpAy3Y2ABAKBv6iTGkUSqhyOpVBdHEqkejvRu1cDy9S1h42daytByYWA5+8pM4+Xl5TictPn165f8OiGEEEK2iTqJcUQtS+9RPRxRy5IQ1cURtSy9R/VwRC3LFinn9ltY9wpLO3hMg8ozr7AAAPqjDsyOJFI9HEmkejiSSnVxJJHq4UjvbhtYps+oPPMZFgBAf9SB2ZFEqocjiVQPR1KpLo4kUj0c6d2qD92f/Iri4yss5XMseqAZftXx+DmXGzCwAACuoQ7MjiRSPRxJpHo4kkp1cSSR6uFI7xYOLO+Ow0n9askwpExDzPAHJavhZHx1ZennV+YwsAAArqEOzI4kUj0cSaR6OJJKdXEkkerhSO+WDyzv2r9k3w4j7V/B32JYKRhYAADXUAdmRxKpHo4kUj0cSaW6OJJI9XCkd6sGlu/CwAIAuIY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71jYAEA7JY6MDuSSPVwJJHq4Ugq1cWRRKqHI71bPLC8PT8eHh4eTvL0Ol7h3cl16gtvwMACACu9Po374qdDvSdesi/fE3VgdiSR6uFIItXDkVSqiyOJVA9HerduYHl8PryN/24NB8HHw/PHFV4PT+VAuMFRkIEFANYY9r+Pj2W/LAaWmX353qgDsyOJVA9HEqkejqRSXRxJpHo40ruNBpbx4Pg5rQyOP+Grh5jrMLAAwHKvT8MPi4YfJDGwfEcSqR6OJFI9HEmlujiSSPVwpHfbDCxvz4dHNZgcv377Ww0YWABgoWp/zMDCwX8N1cORRKqHI6lUF0cSqR6O9O6mz7B8vKJy9pWU4ZUXBhYAcHg7PD9+7pvPDizn9uU7pA7MjiRSPRxJpHo4kkp1cSSR6uFI7xYPLCfGD3QeD3QXBpZbD4YMLACwwHFf/DmgqIHlRL0v3yF1YHYkkerhSCLVw5FUqosjiVQPR3p3/cDy7vg+6fLWgo1eYXl5eTkOJ21+/folv04IIWTKn4ff3/e3v//5+bW//vjtfd/8++HPL9c7zZ+/v+/Lf/vj8Je4LD3qwOyIWpbeo3o4opal96gejqhlSYjq4ohalt6jejiilmWLlHP7Ldw0sHz89I7PsADA9xpfKTmXuVdQFr0SE0odmB1JpHo4kkj1cCSV6uJIItXDkd5t8wrLmbd+bXUQZGABgPWW7oM/9+X7ow7MjiRSPRxJpHo4kkp1cSSR6uFI7xYOLOWDnM0rKONP86ZXT44HvPrAOL66ssX7ohlYAGC904Hl8r58b9SB2ZFEqocjiVQPR1KpLo4kUj0c6d3iV1iGA9/n2wvUZ1aGoeUzW32Ik4EFANZTr7As2ZfviTowO5JI9XAkkerhSCrVxZFEqocjvbvpLWEuDCwAgGuoA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYAwG6pA7MjiVQPRxKpHo6kUl0cSaR6ONI7BhYACKIONI6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbAAQBB1oHEkleriSCLVw5FEqocjqVQXRxKpHo70joEFAIKoA40jqVQXRxKpHo4kUj0cSaW6OJJI9XCkdwwsABBEHWgcSaW6OJJI9XAkkerhSCrVxZFEqocjvWNgAYAg6kDjSCrVxZFEqocjiVQPR1KpLo4kUj0c6R0DCwAEUQcaR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWAAgiDrQOJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwAIAQdSBxpFUqosjiVQPRxKpHo6kUl0cSaR6ONI7BhYACKIONI6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbAAQBB1oHEkleriSCLVw5FEqocjqVQXRxKpHo70joEFAIKoA40jqVQXRxKpHo4kUj0cSaW6OJJI9XCkd9cNLK9Ph4eHh/c8HV7HLxVvz4/j18c81Zdej4EFAAbqQONIKtXFkUSqhyOJVA9HUqkujiRSPRzp3RUDy+vh6X0YeXwsw8nnwDIMK4+H57fxC+P1thhaGFgAYKAONI6kUl0cSaR6OJJI9XAkleriSCLVw5HerR5YXp+GIWQYUKaBZRxiPqeVwfGVmHqIuQ4DCwAM1IHGkVSqiyOJVA9HEqkejqRSXRxJpHo40rt1A8vb8+FxHEC+DCzV1784fv3hcOuLLAwsADBQBxpHUqkujiRSPRxJpHo4kkp1cSSR6uFI71YMLG+H58fPV1G+DCxnX0kZXnlhYAGAbagDjSOpVBdHEqkejiRSPRxJpbo4kkj1cKR3yweW41DSfmZl2cBy8laxM15eXo7DSZtfv37JrxNCyE+LOtA4opYlIaqLI2pZeo/q4Yhalt6jejiiliUhqosjall6j+rhiFqWLVLO7bewcGA5faWEV1gAwE8daBxJpbo4kkj1cCSR6uFIKtXFkUSqhyO9WzawHAeS6tcVN3l8euIzLABgoA40jqRSXRxJpHo4kkj1cCSV6uJIItXDkd6t+9B9ZclvCft6nesxsADAQB1oHEmlujiSSPVwJJHq4Ugq1cWRRKqHI73baGApL8KUV1uq4WR8dWXp51fmMLAAwEAdaBxJpbo4kkj1cCSR6uFIKtXFkUSqhyO922xgKYahpXqr2AbDSsHAAgADdaBxJJXq4kgi1cORRKqHI6lUF0cSqR6O9O7qgcWJgQUABupA40gq1cWRRKqHI4lUD0dSqS6OJFI9HOkdAwsABFEHGkdSqS6OJFI9HEmkejiSSnVxJJHq4UjvGFgAIIg60DiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6x8ACAEHUgcaRVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYWAAiiDjSOpFJdHEmkejiSSPVwJJXq4kgi1cOR3jGwAEAQdaBxJJXq4kgi1cORRKqHI6lUF0cSqR6O9I6BBUDHhj9KW/+69Cfxl2iHX7NeXU9daSfUgcaRVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYWAJ16Ozw/fh1QhsHk8VD/iafTr41Dzk6HFnWgcSSV6uJIItXDkUSqhyOpVBdHEqkejvSOgQVAkGEY+ZxFhn+f/JHa16eTwWYv1IHGkVSqiyOJVA9HEqkejqRSXRxJpHo40jsGFgA53p4Pj/XAcvy3GEza6+2IOtA4kkp1cSSR6uFIItXDkVSqiyOJVA9HesfAAiDE8Baxh8fn9/8bnX0lpX0lZj/UgcaRVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYWAB1rPnRfDyvFhYHl5K1iO6AONI6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbAAyHEcUKpBhFdYbEmlujiSSPVwJJHq4Ugq1cWRRKqHI71jYAEQ5fWpeqWFz7DYkkp1cSSR6uFIItXDkVSqiyOJVA9HesfAAiDK8dcYf7w1TL/1a/hVx0/vl+6POtA4kkp1cSSR6uFIItXDkVSqiyOJVA9HesfAAqBPx1dJmqFjfOWkHlCOr7jU1xPX2RN1oHEkleriSCLVw5FEqocjqVQXRxKpHo70joEFQLdO/oL9e9TbvIah5TN7HVYKdaBxJJXq4kgi1cORRKqHI6lUF0cSqR6O9I6BBQCCqAONI6lUF0cSqR6OJFI9HEmlujiSSPVwpHcMLAAQRB1oHEmlujiSSPVwJJHq4Ugq1cWRRKqHI71jYAGAIOpA40gq1cWRRKqHI4lUD0dSqS6OJFI9HOkdAwsABFEHGkdSqS6OJFI9HEmkejiSSnVxJJHq4UjvGFgAIIg60DiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6t2JgGf7eQf2beNrf1nPyG302+qttDCwAMFAHGkdSqS6OJFI9HEmkejiSSnVxJJHq4UjvFg4sb4fnx68DyjCcfP6F6fbfHwPOBkMLAwv2pR3+T/9Su/p1viUb/QwAwdSBxpFUqosjiVQPRxKpHo6kUl0cSaR6ONK7G94SNpx0DSdQ+q9NH16f3k+yTk/G1mJgwX60w//w7/avsh8Hlo+/5g58UgcaR1KpLo4kUj0cSaR6OJJKdXEkkerhSO+uH1jGvyZ9PPE6/r8YTOrr3ICBBbt2HOy/Pk8YWHCOOtA4kkp1cSSR6uFIItXDkVSqiyOJVA9HenflwDL+VHg6oTr7Skr9Ksz1GFiwa2LgZ2DBOepA40gq1cWRRKqHI4lUD0dSqS6OJFI9HOnd9R+6r0+mLgwsJ28VW4mBBXs2fF5FvCWsfr5t8DzCPqgDjSOpVBdHEqkejiRSPRxJpbo4kkj1cKR3178lbHwby/EkaqNXWF5eXo7DSZtfv37JrxOSnz8Pv78/R3774y9xWZU/fz8+3y5ej+w+6kDjiFqWhKgujqhl6T2qhyNqWXqP6uGIWpaEqC6OqGXpPaqHI2pZtkg5t9/CDR+6L3PK+EoLn2EBrtC8tfKCj+fb+O89UTtPRxKpHo6kUl0cSaR6OJJI9XAkleriSCLVw5He3TSwfL7PXr/1S73V5RoMLNij4wCy4vmx1fOpR2rn6Ugi1cORVKqLI4lUD0cSqR6OpFJdHEmkejjSu2UDy/GVkuZEaXz1ZBpSTk6+mstvwcCCvRmGD/U2yvN4hWX7JFI9HEmlujiSSPVwJJHq4Ugq1cWRRKqHI71b/AqL+hBw+1avYWj5zFYfEmZgwZ5cHlbKW8Way8WvPt4TtfN0JJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOndTW8Jc2FgwX40v22vTvXqyekPCNa9GpNG7TwdSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwALg26mdpyOJVA9HUqkujiRSPRxJpHo4kkp1cSSR6uFI7xhYAHw7tfN0JJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOkdAwuAb6d2no4kUj0cSaW6OJJI9XAkkerhSCrVxZFEqocjvWNgAfDt1M7TkUSqhyOpVBdHEqkejiRSPRxJpbo4kkj1cKR3DCwAvp3aeTqSSPVwJJXq4kgi1cORRKqHI6lUF0cSqR6O9I6BBRtpf/uV/q1WJ7/9aq+/pxerqJ2nI4lUD0dSqS6OJFI9HEmkejiSSnVxJJHq4UjvGFiwgfJ3Q+q/ETL8u/2r7Kd/f2Qcchhafjy183QkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6R0DC+7j5A8dDsPJyR8TPV5v339jBJepnacjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWHAfb8+Hx3oQaf89OX59v3/BHcuonacjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWHAXw9u/qreEnX0lZXjlhYHlZ1M7T0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3jGw4A7E278uDCwnbxXDj6J2no4kUj0cSaW6OJJI9XAkkerhSCrVxZFEqocjvWNgwcbGD9w/Pr//X+WHvcKidgauJFI9HEmkejiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6x8CCTb0+nf52sKMf9hkWtTNwJZHq4Ugi1cORVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYWbOb01xbX9Fu/Tj7rshNqZ+BKItXDkUSqhyOpVBdHEqkejiRSPRxJpbo4kkj1cKR3DCzYxPywMjh59WV8dWWPn19ROwNXEqkejiRSPRxJpbo4kkj1cCSR6uFIKtXFkUSqhyO9Y2DBBoZXT778BfspzWdZhqHlM3v9sL3aGbiSSPVwJJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOkdAwtwB2pn4Eoi1cORRKqHI6lUF0cSqR6OJFI9HEmlujiSSPVwpHcMLMAdqJ2BK4lUD0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3jGwAHegdgauJFI9HEmkejiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6x8AC3IHaGbiSSPVwJJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOkdAwtwB2pn4Eoi1cORRKqHI6lUF0cSqR6OJFI9HEmlujiSSPVwpHcMLMAdqJ2BK4lUD0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3q0YWNpfXXv6NzeGv8VRXWejP1/+rQPL+LdCVJeTvmP29lfbsZ7aGbiSSPVwJJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOndwoHl7fD8WJ+ID/+u/wjg6R8OHAecDc7ev2tg+TKQnBtYmr8zAhRqZ+BKItXDkUSqhyOpVBdHEqkejiRSPRxJpbo4kkj1cKR3178l7PWpejVhGE5O/gjg8Trzf/18iW8ZWKp+xz92yMCCFdTOwJVEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO+uH1iOb5Uah5H6/2vj26lufZHluz/DwsCCtdTOwJVEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO+uHliGt0uNbwk7+0rK8MrLrgeW9351Tl5lwo+kdgauJFI9HEmkejiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6d+XA0rwF7MLAcutJfK8Dy4nxbWQMLVA7A1cSqR6OJFI9HEmlujiSSPVwJJHq4Ugq1cWRRKqHI727YmAZP3BfvxVqo1dYXl5ejsNJm1+/fsmvu/Ln7+99f/9TXtbmeN3f/jj8JS5Lj9rAHVHL0ntUD1fU8vQe1cMRtSy9R/VwRC1LQlQXR9Sy9B7VwxG1LL1H9XBELUtCVBdH1LL0HtXDEbUsW6Sc229h9cByfLWh+u1gRz/0MyzKl7fK7YzawB1JpHq4kkj1cCSR6uFIKtXFkUSqhyOJVA9HUqkujiRSPRzp3aqBZTgZX/7Wr61O3pMGluN1d/pBfLWBO5JI9XAlkerhSCLVw5FUqosjiVQPRxKpHo6kUl0cSaR6ONK7xQPL+WFlcPLKy/jqyhaf5+hzYClvjWvWR/WrkPdIbeCOJFI9XEmkejiSSPVwJJXq4kgi1cORRKqHI6lUF0cSqR6O9G7hwDK8glL/NqyPVK8mDEPLZ7b68Pm3DCzj8HGaz6Hs9LeEnR/o9kBt4I4kUj1cSaR6OJJI9XAkleriSCLVw5FEqocjqVQXRxKpHo707ooP3ft99yssGKgN3JFEqocriVQPRxKpHo6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbBgMbWBO5JI9XAlkerhSCLVw5FUqosjiVQPRxKpHo6kUl0cSaR6ONI7BhYspjZwRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwILF1AbuSCLVw5VEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWLCY2sAdSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6R0DCxZTG7gjiVQPVxKpHo4kUj0cSaW6OJJI9XAkkerhSCrVxZFEqocjvWNgwWJqA3ckkerhSiLVw5FEqocjqVQXRxKpHo4kUj0cSaW6OJJI9XCkdwwsWExt4I4kUj1cSaR6OJJI9XAkleriSCLVw5FEqocjqVQXRxKpHo70joEFi6kN3JFEqocriVQPRxKpHo6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbBgMbWBO5JI9XAlkerhSCLVw5FUqosjiVQPRxKpHo6kUl0cSaR6ONI7BhYspjZwRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwILF1AbuSCLVw5VEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO9+/MCiHjRHEqkejiRSPVxJpHo4kkj1cCSV6uJIItXDkUSqhyOpVBdHEqkejvSOgUU8aI4kUj0cSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6R0Di3jQHEmkejiSSPVwJZHq4Ugi1cORVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYW8aA5kkj1cCSR6uFKItXDkUSqhyOpVBdHEqkejiRSPRxJpbo4kkj1cKR3DCziQXMkkerhSCLVw5VEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWMSD5kgi1cORRKqHK4lUD0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3jGwiAfNkUSqhyOJVA9XEqkejiRSPRxJpbo4kkj1cCSR6uFIKtXFkUSqhyO9Y2ARD5ojiVQPRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwCIeNEcSqR6OJFI9XEmkejiSSPVwJJXq4kgi1cORRKqHI6lUF0cSqR6O9I6BRTxojiRSPRxJpHq4kkj1cCSR6uFIKtXFkUSqhyOJVA9HUqkujiRSPRzpHQOLeNAcSaR6OJJI9XAlkerhSCLVw5FUqosjiVQPRxKpHo6kUl0cSaR6ONK79QPL2/Ph8eHh8PD0On7h09vz4+GhXDZFXOcaDCx9UD0cSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6d2qgeXLQNIMI8Nlj4fnt/ELh9fD00ZDCwNLH1QPRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3q3fGB5fToOKmX+eH1qB5FhOHn8nFYGx9vUQ8x1GFj6oHo4kkj1cCWR6uFIItXDkVSqiyOJVA9HEqkejqRSXRxJpHo40rurPsNyMrAc3yYmBpPx7WO3vsjCwNIH1cORRKqHK4lUD0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3m0zsJx9JWV45YWB5TSJVA9HEqkeriRSPRxJpHo4kkp1cSSR6uFIItXDkVSqiyOJVA9HemcZWE7eKnbGy8vLcThp8+vXL/n1LaIeNEfUsvQe1cMRtSy9R/VwRS1P71E9HFHL0ntUD0fUsiREdXFELUvvUT0cUcvSe1QPR9SyJER1cUQtS+9RPRxRy7JFyrn9FniFRTxojiRSPRxJpHq4kkj1cCSR6uFIKtXFkUSqhyOJVA9HUqkujiRSPRzpHZ9hEQ+aI4lUD0cSqR6uJFI9HEmkejiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6t83AcuatX8OvOn56v/Q2DCx9UD0cSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6d1GA8v4tXo4GV9dWfr5lTkMLH1QPRxJpHq4kkj1cCSR6uFIKtXFkUSqhyOJVA9HUqkujiRSPRzp3fKBZfw7LKf5HFKGoeUzWwwrBQNLH1QPRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3p31SssbgwsfVA9HEmkeriSSPVwJJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOkdA4t40BxJpHo4kkj1cCWR6uFIItXDkVSqiyOJVA9HEqkejqRSXRxJpHo40jsGFvGgOZJI9XAkkerhSiLVw5FEqocjqVQXRxKpHo4kUj0cSaW6OJJI9XCkdwws4kFzJJHq4Ugi1cOVRKqHI4lUD0dSqS6OJFI9HEmkejiSSnVxJJHq4UjvGFjEg+ZIItXDkUSqhyuJVA9HEqkejqRSXRxJpHo4kkj1cCSV6uJIItXDkd4xsIgHzZFEqocjiVQPVxKpHo4kUj0cSaW6OJJI9XAkkerhSCrVxZFEqocjvWNgEQ+aI4lUD0cSqR6uJFI9HEmkejiSSnVxJJHq4Ugi1cORVKqLI4lUD0d6x8AiHjRHEqkejiRSPVxJpHo4kkj1cCSV6uJIItXDkUSqhyOpVBdHEqkejvSOgUU8aI4kUj0cSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6R0Di3jQHEmkejiSSPVwJZHq4Ugi1cORVKqLI4lUD0cSqR6OpFJdHEmkejjSOwYW8aA5kkj1cCSR6uFKItXDkUSqhyOpVBdHEqkejiRSPRxJpbo4kkj1cKR3DCziQXMkkerhSCLVw5VEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO8YWMSD5kgi1cORRKqHK4lUD0cSqR6OpFJdHEmkejiSSPVwJJXq4kgi1cOR3jGwiAfNkUSqhyOJVA9XEqkejiRSPRxJpbo4kkj1cCSR6uFIKtXFkUSqhyO9Y2ARD5ojiVQPRxKpHq4kUj0cSaR6OJJKdXEkkerhSCLVw5FUqosjiVQPR3rHwCIeNEcSqR6OJFI9XEmkejiSSPVwJJXq4kgi1cORRKqHI6lUF0cSqR6O9I6BRTxojiRSPRxJpHq4kkj1cCSR6uFIKtXFkUSqhyOJVA9HUqkujiRSPRzpHQOLeNAcSaR6OJJI9XAlkerhSCLVw5FUqosjiVQPRxKpHo6kUl0cSaR6ONI7BhbxoDmSSPVwJJHq4Uoi1cORRKqHI6lUF0cSqR6OJFI9HEmlujiSSPVwpHcMLOJBcySR6uFIItXDlUSqhyOJVA9HUqkujiRSPRxJpHo4kkp1cSSR6uFI7xhYxIPmSCLVw5FEqocriVQPRxKpHo6kUl0cSaR6OJJI9XAkleriSCLVw5HeMbCIB82RRKqHI4lUD1cSqR6OJFI9HEmlujiSSPVwJJHq4Ugq1cWRRKqHI73bdGB5e348PDw8fObpdbzkNgwsfVA9HEmkeriSSPVwJJHq4Ugq1cWRRKqHI4lUD0dSqS6OJFI9HOndZgPLMKw8Hp7fxi8cXg9PGw0tDCx9UD0cSaR6uJJI9XAkkerhSCrVxZFEqocjiVQPR1KpLo4kUj0c6d1GA8swnDx+TiuD16dmiLkOA0sfVA9HEqkeriRSPRxJpHo4kkp1cSSR6uFIItXDkVSqiyOJVA9HerfNwPL2fHhUg8nx6w+HW19kYWDpg+rhSCLVw5VEqocjiVQPR1KpLo4kUj0cSaR6OJJKdXEkkerhSO+2GVjOvpIyvPLCwHKaRKqHI4lUD1cSqR6OJFI9HEmlujiSSPVwJJHq4Ugq1cWRRKqHI72zDCwnbxVbiYGlD6qHI4lUD1cSqR6OJFI9HEmlujiSSPVwJJHq4Ugq1cWRRKqHI73r6hWWl5eX43DS5tevX/LrhBBCCCGEkD7zL//yL+NZ/m1+/GdY9oZ1tRzrah3W13Ksq+VYV+uwvpZjXS3HulqH9bXcVutqm4HlzFu/hl91/PR+6W3YMJZjXS3HulqH9bUc62o51tU6rK/lWFfLsa7WYX0tt9W62mhgKe8KK38sshpOxldXbv38SsGGsRzrajnW1Tqsr+VYV8uxrtZhfS3HulqOdbUO62u5rdbVZgNLMQwtn9liWCnYMJZjXS3HulqH9bUc62o51tU6rK/lWFfLsa7WYX0tt9W62nRguZd//dd/Hf8Pl7CulmNdrcP6Wo51tRzrah3W13Ksq+VYV+uwvpbbal1FDCwAAAAAfiYGFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADdYmABAAAA0C0GFgAAAADd+uEDy+vh6eHh8PCRx8Pz23jR6O35sbr8PU+v4yWf5q/Tfo+Hg7iLAI51VXl9Gq/z9P6dE91/fZ1cNiZv+/JtW69P1eVnrtO3O6+rt+fDY/31Oo/Ph+ZbBfBsWyfbFevq7HXadfXYfpMI26yro+k5d8W6zOFZX0eXLu+eY11d/h49+sEDy9vh+bE+uRv+XZ8gDxtF/UCOD3L14M9fp/0e6voJHOuqNnz98bFcP3Fg8ayv4+WRJ0Y117Y13m/0+nKtq9Zwed6JpWd9DSfg9X7q0vrs0Tetq/EHU1GraqN1VQzXK7c9d9nl++ifZ30Vly7vn2NdXf4eveItYbUvO89hIzg5SB+vM20sS67TGm7TbFt57riujge19zsennD9P4kWucP6Oq6f+IFFYF0td4d1dWLusjSbr6/hYN9evovtbet19Tr8tHe4v0/H/f2PW1fTv4fbTMe8TwvvI9Xm6+vdpctT3WNdtb58j34xsNSOL5+ND3r9/7XxJbbjA7vkOq25y5LU3ZeshyXX+fj3cL1dDSx1/yXrYsF1dnsSvvm60ieVu7D5uhr//WH86dvpBZnusL5OT7h3ss62XlfP+vJd7OfXrqvGyUnlFfcRZev11djVwHLndXV07n47w8BS+bLjbCfWD8OEe3z8l1zni/FAtoOTzPusq68nlnsaWO6xvob7fN+equzhpHz7dTX89/Hp6bhT/1xf+dvWfZ6HlZkDYaL7rK/h/4frjf/PPr4yXuc4sJxuS1++T6jV66pxclJ5xX0k2Xx9NfY0sNx7XRUpz0EGlg/DA/5xwndhwzheb8l1xv//OEnaxU/E77Sujtf5fNLs4UA2uNP6ah1vc+ayGPdYV8/H/8qfgkdvX/dYV18vOB7sdrHPKu65voZ/D/t5df0091hXr+IHdj/0edhYO7Co+8hxh/XV2M/Acv91NXfb3jCwHIlXPi5sGMfHf8l1WsfbZGwc2r3W1ek628fAYty23mWfYN532zp5zp29XQLHdnVmvUW63/oa9lOf6276d+4J0z23reH/h8FuyNNTuV3qfv7KddVYO7DEblr3Wl+NfQwsjnUlvkfHGFjeHR/Qdoe55L2CS64jHL9fyAbSutu6Oh60yn3rpJ40ubet5CHvfutq2JmfbEMX1mXPHNvVfl7hvOP6OvM2p/dv+P79xO0CfMs+66cdDxvH+6kvuHJd9u5u66tx6fIEjnUlv0fHfvzAMhyUxQbw/hCqk5yvB/El1zmVuoN2r6tL67F37vVVHHdAbFtHn9cZf4rU7rSPJ5V529d919XkzDoLdNf1NXsCob5n3+66rsZ/fzVsZ+1tEty2rr46Pam8Zl327b7r66tLl/fOsa7Of49+/eiB5dIDdnyg641gnGLrjWX2Osf/bzYicR8J7r6uhLknYe/uv77Kgb65/+MJeN5P3yzb1sm6GXb8aQc12/Mw+BWC2v3Xl96OTm4TwLZtfch6O0pti3VVO17/0jZ04T565lhftUuX98yxri59j1794IFlPNCoVDvQYeP4jNoo5q4zbBhfL897HnnWVWtYd9UTM8Z3bVt5OyDXuira9TW37fXJta5yTyS/cq0v8X3i1p1jXY3bVXVZ5knlRutq/CHKaT6PeUvWd/9M62vB+uyfY10t+x494jMsAAAAALrFwAIAAACgWwwsAAAAALrFwAIAAACgWwwsAAAAALrFwAIAAACgWwwsAAAAALrFwAIAAACgWwwsAAAAALrFwAIAAACgWwwsAAAAALrFwAIAAACgWwwsAAAAADp1OPw/brhOYL/7ydIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<IPython.core.display.Image object>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import IPython\n",
    "url = 'https://upload.wikimedia.org/wikipedia/commons/5/51/Algorithmic_Trading._Percentage_of_Market_Volume.png'\n",
    "IPython.display.Image(url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Nền tảng bài viết dựa trên áp dụng thư viện VADER vào Sentiment Analysis\n",
    "\n",
    "<strong>Ý tưởng của bài viết là gì? </strong>\n",
    "\n",
    "Ý tưởng: Crawling tin tức liên quan đến đầu tư Vàng trên một trang tổng hợp các nguồn báo, sau đó áp dụng thư viện `VADER` được tích hợp sẵn trong toolkit xử lí ngôn ngữ tự nhiên `nltk` để dự báo tâm lí thị trường lên giá Vàng.\n",
    "\n",
    "<strong>Sentiment Analysis là gì? </strong>\n",
    "\n",
    "Sentiment Analysis là quá trình 'tính toán' xác định xem nội dung bài viết là tích cực, tiêu cực hay trung lập.\n",
    "\n",
    "Trong kinh doanh: Các công ty sử dụng nó để tìm hiều thái độ mọi người phản ứng với các chiến dịch hoặc buổi ra mắt sản phẩm của họ và tại sao người tiêu dùng không mua một số sản phẩm. (như phân tích cảm xúc trong bình luận mua hàng trên `TIKI` chẳng hạn)\n",
    "\n",
    "Trong lĩnh vực chính trị: nó được sử dụng để theo dõi quan điểm chính trị, để phát hiện sự nhất quán và không nhất quán giữa các tuyên bố và hành động ở cấp chính phủ. Nó cũng có thể được sử dụng để dự đoán kết quả bầu cử! .\n",
    "\n",
    "Trong khuôn khổ bài viết này sẽ giới thiệu Sentiment Analysis ứng dụng trong phân tích cảm xúc tin tức & ứng dụng vào đầu tư.\n",
    "\n",
    "<strong>Thư viện `VADER` là gì? </strong>\n",
    "\n",
    "Đọc thêm về VADER Sentiment Analysis: https://blog.quantinsti.com/vader-sentiment/\n",
    "\n",
    "VADER (Valence Aware Dictionary and sEntiment Reasoner) là một thuật toán phân tích trạng thái cảm xúc thể hiện trên nội dung bài viết. Vader có mã nguồn mở theo MIT License.\n",
    "\n",
    "<strong>Vì sao không áp dụng lên chứng khoán Việt Nam, cụ thể một mã cổ phiếu nào đó? </strong>\n",
    "\n",
    "Bởi vì thư viện VADER được train trên dữ liệu tiếng anh, nếu muốn build công cụ tương tự phải thiết lập lại Sentiment Analysis cho các tin tức tiếng việt. Hi vọng sẽ trình bày trong một bài viết khác\n",
    "\n",
    "<strong>Quy trình thực hiện như thế nào? </strong>\n",
    "\n",
    "1. Crawling dữ liệu bằng thư viện phổ thông `BeautifulSoup` \n",
    "2. Trích xuất thông tin\n",
    "3. applied VADER\n",
    "\n",
    "<strong>Sử dụng nguồn data nào trong bài viết? </strong>\n",
    "\n",
    "Nguồn data dùng trong bài viết: https://finviz.com/\n",
    "\n",
    "FINVIZ là một platform tổng hợp thông tin thị trường chứng khoán thế giới, khá tương đồng các platform như FinTrade tại Việt Nam. Platform cung cấp các data cổ phiếu , ngoại hối và hợp đồng tương lai như: tin tức, các công cụ trực quan biểu đồ, theo dõi danh mục đầu tư, và các loại tool filter khác ..."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### PHASE 1: Crawling dữ liệu tin tức"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from urllib.request import urlopen, Request\n",
    "from bs4 import BeautifulSoup\n",
    "import os\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "from nltk.sentiment.vader import SentimentIntensityAnalyzer\n",
    "finwiz_url = 'https://finviz.com/quote.ashx?t='"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "news_tables = {}\n",
    "tickers = ['GOLD']\n",
    "for ticker in tickers:\n",
    "    url = finwiz_url + ticker\n",
    "    req = Request(url=url,headers={'user-agent': 'my-app/0.0.1'}) \n",
    "    response = urlopen(req) \n",
    "    html = BeautifulSoup(response)\n",
    "    news_table = html.find(id='news-table')\n",
    "    news_tables[ticker] = news_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dec-13-20 01:08AM    -  How Much Of Barrick Gold Corporation (TSE:ABX) Do Institutions Own?\n",
      "Dec-08-20 01:43PM    -  Gold Price Pans For A Bottom As Coronavirus Vaccines Near, But This Is Key\n",
      "Dec-07-20 10:40PM    -  Why Shares of Barrick Gold Plunged 13% in November\n",
      "10:49AM    -  Is Barrick (GOLD) A Good Stock To Buy Now?\n",
      "Dec-05-20 11:32AM    -  Why Is Barrick Gold (GOLD) Down 19.9% Since Last Earnings Report?\n",
      "Dec-03-20 12:11AM    -  12 Best Silver Stocks to Buy Now\n",
      "Dec-01-20 12:44PM    -  A death cross is slowly forming in gold prices, even as futures rise Tuesday\n",
      "08:41AM    -  Rising Gold Prices Aid Royal Gold (RGLD) Amid Coronavirus Woes\n",
      "Nov-30-20 01:51PM    -  Loncor Reports Multiple Gold Intercepts in First Hole at its Flagship Adumbi Deposit\n",
      "Nov-27-20 02:42PM    -  3 Dividend Gold Stocks\n",
      "Nov-26-20 10:00AM    -  Barrick listed again in Dow Jones Sustainability Index\n",
      "Nov-25-20 03:59PM    -  Gold prices snap 2-session skid on Thanksgiving eve, but head for weekly loss\n",
      "Nov-24-20 08:37AM    -  PPG Industries' (PPG) Brand Introduces Anti-Bacterial Paint\n",
      "08:36AM    -  Eastman (EMN) Teams With Gruppo Maip for Automotive Materials\n",
      "07:57AM    -  Gold prices tumble further,  on the verge of breaking below 200-day moving average\n",
      "05:48AM    -  Celanese (CE) Up 57% in 6 Months: What's Driving the Stock?\n",
      "Nov-23-20 02:33PM    -  Gold prices fall by the most in 2 weeks as vaccine progress slams precious metals\n",
      "08:30AM    -  Loncor Provides Exploration Update on Barrick Joint Venture\n",
      "Nov-20-20 03:00PM    -  5 Warren Buffett Stocks To Buy For Under $25\n",
      "08:45AM    -  Barrick Gold, Hyatt Hotels, L Brands, Halliburton Co and Workday highlighted as Zacks Bull and Bear of the Day\n",
      "08:44AM    -  Celanese (CE) Unveils POM ECO-B to Support Renewable Content\n",
      "07:23AM    -  What Makes Koppers (KOP) a Solid Investment Option Right Now\n",
      "06:36AM    -  Bull of the Day: Barrick Gold (GOLD)\n",
      "Nov-19-20 09:05AM    -  Univar (UNVR) to Distribute Evergrain's Plant-Based Portfolio\n",
      "09:02AM    -  Mosaic (MOS) Declares October Sales Volumes & Revenues\n",
      "08:36AM    -  Gold Miner ETFs Discover Key Chart Support\n",
      "08:10AM    -  GrowGeneration (GRWG) Hits 52-Week High, Can the Run Continue?\n",
      "07:44AM    -  Quaker Chemical (KWR) Stock Up 29% in 3 Months: Here's Why\n",
      "07:15AM    -  Shopify, Barrick Join Exclusive Canada Club With Big Cash Hoards\n",
      "Nov-18-20 09:44AM    -  Cabot (CBT) Introduces New Black Masterbatch Formulation\n",
      "09:36AM    -  Nucor (NUE) Inks Deal in Texas for Sustainable Production\n"
     ]
    }
   ],
   "source": [
    "amzn = news_tables['GOLD']\n",
    "amzn_tr = amzn.findAll('tr')\n",
    "for i, table_row in enumerate(amzn_tr):\n",
    "    a_text = table_row.a.text\n",
    "    td_text = table_row.td.text\n",
    "    print(td_text,' - ',a_text)\n",
    "    if i == 30:\n",
    "        break"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### PHASE 2: Tách thời gian & content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "parsed_news = []\n",
    "for file_name, news_table in news_tables.items():\n",
    "    for x in news_table.findAll('tr'):\n",
    "        text = x.a.get_text() \n",
    "        date_scrape = x.td.text.split()\n",
    "        if len(date_scrape) == 1:\n",
    "            time = date_scrape[0] \n",
    "        else:\n",
    "            date = date_scrape[0]\n",
    "            time = date_scrape[1]\n",
    "        ticker = file_name.split('_')[0]\n",
    "        parsed_news.append([ticker, date, time, text])  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[nltk_data] Downloading package vader_lexicon to C:\\Users\\Hieu\n",
      "[nltk_data]     Le\\AppData\\Roaming\\nltk_data...\n",
      "[nltk_data]   Package vader_lexicon is already up-to-date!\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import nltk\n",
    "nltk.download('vader_lexicon')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### PHASE 3: Applied thư viện VADER\n",
    "\n",
    "The VADER library có 4 feature được giải thích như sau:\n",
    "1. `pos`: Xác xuất tích cực của thị trường (positive)\n",
    "2. `neu`: Xác xuất trung tính của thị trường (neutral)\n",
    "3. `neg`: Xác xuất tiêu cực của thị trường (negative)\n",
    "4. `compound`: Chuẩn hóa điểm kết hợp của pos - neg - neu, có thang điểm từ -1 đến 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ticker</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>headline</th>\n",
       "      <th>neg</th>\n",
       "      <th>neu</th>\n",
       "      <th>pos</th>\n",
       "      <th>compound</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-13</td>\n",
       "      <td>01:08AM</td>\n",
       "      <td>How Much Of Barrick Gold Corporation (TSE:ABX)...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-08</td>\n",
       "      <td>01:43PM</td>\n",
       "      <td>Gold Price Pans For A Bottom As Coronavirus Va...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-07</td>\n",
       "      <td>10:40PM</td>\n",
       "      <td>Why Shares of Barrick Gold Plunged 13% in Nove...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.784</td>\n",
       "      <td>0.216</td>\n",
       "      <td>0.2960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-07</td>\n",
       "      <td>10:49AM</td>\n",
       "      <td>Is Barrick (GOLD) A Good Stock To Buy Now?</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.707</td>\n",
       "      <td>0.293</td>\n",
       "      <td>0.4404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-05</td>\n",
       "      <td>11:32AM</td>\n",
       "      <td>Why Is Barrick Gold (GOLD) Down 19.9% Since La...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-03</td>\n",
       "      <td>12:11AM</td>\n",
       "      <td>12 Best Silver Stocks to Buy Now</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.588</td>\n",
       "      <td>0.412</td>\n",
       "      <td>0.6369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>12:44PM</td>\n",
       "      <td>A death cross is slowly forming in gold prices...</td>\n",
       "      <td>0.245</td>\n",
       "      <td>0.755</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-12-01</td>\n",
       "      <td>08:41AM</td>\n",
       "      <td>Rising Gold Prices Aid Royal Gold (RGLD) Amid ...</td>\n",
       "      <td>0.244</td>\n",
       "      <td>0.756</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-11-30</td>\n",
       "      <td>01:51PM</td>\n",
       "      <td>Loncor Reports Multiple Gold Intercepts in Fir...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.896</td>\n",
       "      <td>0.104</td>\n",
       "      <td>0.1027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>GOLD</td>\n",
       "      <td>2020-11-27</td>\n",
       "      <td>02:42PM</td>\n",
       "      <td>3 Dividend Gold Stocks</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  ticker        date     time  \\\n",
       "0   GOLD  2020-12-13  01:08AM   \n",
       "1   GOLD  2020-12-08  01:43PM   \n",
       "2   GOLD  2020-12-07  10:40PM   \n",
       "3   GOLD  2020-12-07  10:49AM   \n",
       "4   GOLD  2020-12-05  11:32AM   \n",
       "5   GOLD  2020-12-03  12:11AM   \n",
       "6   GOLD  2020-12-01  12:44PM   \n",
       "7   GOLD  2020-12-01  08:41AM   \n",
       "8   GOLD  2020-11-30  01:51PM   \n",
       "9   GOLD  2020-11-27  02:42PM   \n",
       "\n",
       "                                            headline    neg    neu    pos  \\\n",
       "0  How Much Of Barrick Gold Corporation (TSE:ABX)...  0.000  1.000  0.000   \n",
       "1  Gold Price Pans For A Bottom As Coronavirus Va...  0.000  1.000  0.000   \n",
       "2  Why Shares of Barrick Gold Plunged 13% in Nove...  0.000  0.784  0.216   \n",
       "3         Is Barrick (GOLD) A Good Stock To Buy Now?  0.000  0.707  0.293   \n",
       "4  Why Is Barrick Gold (GOLD) Down 19.9% Since La...  0.000  1.000  0.000   \n",
       "5                   12 Best Silver Stocks to Buy Now  0.000  0.588  0.412   \n",
       "6  A death cross is slowly forming in gold prices...  0.245  0.755  0.000   \n",
       "7  Rising Gold Prices Aid Royal Gold (RGLD) Amid ...  0.244  0.756  0.000   \n",
       "8  Loncor Reports Multiple Gold Intercepts in Fir...  0.000  0.896  0.104   \n",
       "9                             3 Dividend Gold Stocks  0.000  1.000  0.000   \n",
       "\n",
       "   compound  \n",
       "0    0.0000  \n",
       "1    0.0000  \n",
       "2    0.2960  \n",
       "3    0.4404  \n",
       "4    0.0000  \n",
       "5    0.6369  \n",
       "6   -0.5994  \n",
       "7   -0.4404  \n",
       "8    0.1027  \n",
       "9    0.0000  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vader = SentimentIntensityAnalyzer()\n",
    "columns = ['ticker', 'date', 'time', 'headline']\n",
    "parsed_and_scored_news = pd.DataFrame(parsed_news, columns=columns)\n",
    "scores = parsed_and_scored_news['headline'].apply(vader.polarity_scores).tolist()\n",
    "scores_df = pd.DataFrame(scores)\n",
    "parsed_and_scored_news = parsed_and_scored_news.join(scores_df, rsuffix='_right')\n",
    "parsed_and_scored_news['date'] = pd.to_datetime(parsed_and_scored_news.date).dt.date\n",
    "parsed_and_scored_news.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Trực quan kết quả phân tích tâm lí thị trường"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3IAAAGzCAYAAABq/CXZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3df5SkBX3n+89XfgR0ZkEBR8KgENdsAkGjTNRoTGaMHlSiYK56jYiQu8pyIm4UjLLJPbtkk71Bct3j5krkEuOix7izUXORFRI0mvFn3EUURUSUNagjyK9VnOFHIvK9f3QBbdszA91V3fNUvV7n9KHqeZ6q99PdU1X95akf1d0BAABgOB6y2jsAAADAg2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOgKlWVS+tqv9eVbdX1U2j079VVTVa/7Sq+mhVbauq26rqv1XVEfMuv7Gqtu7gui+oqn8aXXZbVX2pqv6oqvZbqe8PgNlkkANgalXVGUn+U5I/TvKoJOuSnJrk6Un2rqpfTPKhJB9I8pNJDk/yhSSfqqqfeoCZc7p7bZKDkvxmkqeOLv+wcX4vADBfdfdq7wMAjN3oqNj1SV7R3e/fwTafSHJld//WguV/neTm7n5FVW1M8u7uXr/I5S9IsrW7/895y9Ym+WqS/9Ddbx3X9wMA8zkiB8C0+sUkP5G5o20/pqoemuRpSd67yOq/TPLspUS7e1uSDyd5xlIuDwAPhEEOgGl1YJJbuvvuexdU1aer6ntVdWeSDZl7HLxhkcveMLr8Ul2f5BHLuDwA7JRBDoBpdWuSA6tqz3sXdPfTunv/0bq1Se5JcvAilz04yS3LaB+S5H8t4/IAsFMGOQCm1d8n+cckx+1g/e2jbV68yLqXJPnIUqJVtSbJs5J8YimXB4AHYs9dbwIAw9Pd36uq30/yp6OPGvibJHckeXySe99R8swkl1bVV5L858w9Lp6RudfX/cL866uqfRYk/nHB+p9I8nNJ3pTku6PrA4CJcEQOgKnV3eckOT3JG5LclOTGJP9vkjcm+XR3fzLJMUl+PXOvi/tGkicm+aXu/tq8qzokyZ0Lvh47WveGqtqWuadSvivJ5Ume1t23T/a7A2CW+fgBAACAgXFEDgAAYGAMcgAAAANjkAMAABgYgxwAAMDA7NYfP3DggQf2YYcdtqTL3n777XnYwx626w0nQFtbW1tbW1tbW1tbexztyy+//JbuPujHVnT3bvt19NFH91L93d/93ZIvu1za2tra2tra2tra2trjaCf5bC8yK3lqJQAAwMAY5AAAAAbGIAcAADAwu/WbnQAAALPhBz/4QbZu3Zq77rpr7Ne933775eqrrx779Y6zvc8++2T9+vXZa6+9HtD1GuQAAIBVt3Xr1qxduzaHHXZYqmqs171t27asXbt2rNc5znZ359Zbb83WrVtz+OGHP6Dr9dRKAABg1d1111054IADxj7EDUFV5YADDnhQRyMNcgAAwG5hFoe4ez3Y790gBwAAMDBeIwcAAOx2Djvz4rFe33VnH7vLbW688ca87nWvy2c+85k8/OEPz9577503vOENeeELX5hPfvKTOf300/P9738/SXL66afnlFNOSZKcddZZWbNmTV7/+tf/yPXtscceOfLII/PDH/4we+65Z0466aS89rWvzUMesvzjaQY5AABg5nV3jj/++Jx00kl5z3vekyT5xje+kYsuuijf+c538rKXvSwXXnhhnvSkJ+WWW27JMccck0MOOSTHHrvjAXHffffNpz71qaxduzY33XRTXvayl+W2227L7//+7y97fz21EgAAmHkf/ehHs/fee+fUU0+9b9ljHvOYvOY1r8m5556bk08+OU960pOSJAceeGDOOeecnH322Q/4+h/5yEfm/PPPz1vf+tZ097L31yAHAADMvKuuuuq+QW2xdUcfffSPLNuwYUOuuuqqB9X4qZ/6qdxzzz256aablryf9/LUSgAAgAVe/epX55Of/GT23nvvrF+/ftF3lVzKu2yO42hcYpADAICx2tWbdJxx1N05eSfbPJA35WD8jjzyyLz//e+/7/y5556bW265JRs2bMgxxxyTz372s3nBC15w3/rLL788RxxxxINqfP3rX88ee+yRRz7ykcveX0+tBAAAZt4zn/nM3HXXXXnb295237I77rgjydzRuQsuuCBXXHFFkuTWW2/NG9/4xrzhDW94wNd/880359RTT81pp502ls/Lc0QOAADY7YzzyOS2bdt2uU1V5cILL8zrXve6nHPOOTnooIPysIc9LG9605ty8MEH593vfnde9apXZdu2benuvPa1r83zn//8+y7/h3/4h3nLW95y3/mtW7fmzjvvzNOf/vT7Pn7gxBNPzOmnnz6W78kgBwAAkOTggw/O5s2bF133y7/8y7nssssWXXfWWWflrLPO+rHlP/zhD7Nt27asXbt2nLuZxFMrAQAABscgBwAAMDBjGeSq6jlVdU1VXVtVZ+5gm41VdUVVXVVVHxtHFwAAmB7jemv+IXqw3/uyB7mq2iPJuUmem+SIJL9RVUcs2Gb/JH+a5AXdfWSSFy+3CwAATI999tknt95660wOc92dW2+9Nfvss88Dvsw43uzkyUmu7e6vJ0lVbU5yXJIvz9vmZUn+qru/OdrR5X+UOQAAMDXWr1+frVu35uabbx77dd91110PakhajfY+++yT9evXP+DrHccgd0iSb807vzXJUxZs89NJ9qqqLUnWJvlP3f2uMbQBAIApsNdee+Xwww+fyHVv2bIlT3ziEydy3avVruUeuqyqFyc5prtfOTp/YpInd/dr5m3z1iQbkvxqkn2T/H2SY7v7q4tc3ylJTkmSdevWHb2jt//cle3bt2fNmjVLuuxyaWtra2tra2trz277ym/fttP16/ZNbrxzx+uPOmS/Me/R/ab1Zz7N7U2bNl3e3RsWLh/HEbmtSQ6dd359kusX2eaW7r49ye1V9fEkT0jyY4Ncd5+f5Pwk2bBhQ2/cuHFJO7Vly5Ys9bLLpa2tra2tra2tPbvtk8+8eKfrzzjq7rz5yh3/GX7dCRvHvEf3m9af+Sy2x/GulZcleVxVHV5Veyd5aZKLFmzzgSTPqKo9q+qhmXvq5dVjaAMAAMycZR+R6+67q+q0JJcm2SPJO7r7qqo6dbT+vO6+uqr+JskXk9yT5O3d/aXltgEAAGbROJ5ame6+JMklC5adt+D8Hyf543H0AAAAZtlYPhAcAACAlWOQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICB2XO1dwAAWFmHnXnxTtefcdTdOXkn21x39rHj3iUAHiRH5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMzFgGuap6TlVdU1XXVtWZO9nuF6rqh1X1onF0AQAAZtGyB7mq2iPJuUmem+SIJL9RVUfsYLs3Jbl0uU0AAIBZNo4jck9Ocm13f727/ynJ5iTHLbLda5K8P8lNY2gCAADMrOru5V3B3NMkn9PdrxydPzHJU7r7tHnbHJLkPUmemeTPk3ywu9+3g+s7JckpSbJu3bqjN2/evKT92r59e9asWbOkyy6Xtra2trb27ty+8tu37XT9un2TG+/c8fqjDtlvzHt0v2n9mWvPVtttTHuc7U2bNl3e3RsWLt9zWXs1pxZZtnA6fEuSN3b3D6sW23zeBbvPT3J+kmzYsKE3bty4pJ3asmVLlnrZ5dLW1tbW1t6d2yefefFO159x1N1585U7/hPhuhM2jnmP7jetP3Pt2Wq7jWmvRHscg9zWJIfOO78+yfULttmQZPNoiDswyfOq6u7uvnAMfQAAgJkyjkHusiSPq6rDk3w7yUuTvGz+Bt19+L2nq+qCzD210hAHAACwBMse5Lr77qo6LXPvRrlHknd091VVdepo/XnLbQAAAHC/cRyRS3dfkuSSBcsWHeC6++RxNAEAAGbVWD4QHAAAgJVjkAMAABiYsTy1EgAAmG2HPYCPXdjZRzNcd/ax496lqeaIHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAAzOWQa6qnlNV11TVtVV15iLrT6iqL46+Pl1VTxhHFwAAYBYte5Crqj2SnJvkuUmOSPIbVXXEgs3+IcmvdPfjk/xBkvOX2wUAAJhV4zgi9+Qk13b317v7n5JsTnLc/A26+9Pd/d3R2c8kWT+GLgAAwEyq7l7eFVS9KMlzuvuVo/MnJnlKd5+2g+1fn+Rn7t1+kfWnJDklSdatW3f05s2bl7Rf27dvz5o1a5Z02V258tu37XT9un2TG+/c8fqjDtlvzHt0v0l+36vZ9jPX1tbWHh/3qdrabmOTMKvf96TbmzZtury7Nyxcvuey9mpOLbJs0emwqjYl+ZdJfmlHV9bd52f01MsNGzb0xo0bl7RTW7ZsyVIvuysnn3nxTtefcdTdefOVO/7RXnfCxjHv0f0m+X2vZtvPXFtbW3t83Kdqa7uNTcKsft+r1R7HILc1yaHzzq9Pcv3Cjarq8UnenuS53X3rGLoAU+WwB/AAuLMHyevOPnbcuwQA7KbG8Rq5y5I8rqoOr6q9k7w0yUXzN6iqRyf5qyQndvdXx9AEAACYWcs+Itfdd1fVaUkuTbJHknd091VVdepo/XlJ/m2SA5L8aVUlyd2LPc8TAACAXRvHUyvT3ZckuWTBsvPmnX5lkkXf3AQAAIAHZywfCA4AAMDKMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYPZc7R0AgNVy2JkX73T9GUfdnZN3ss11Zx877l0CgAfEETkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBjvWgkAq8A7ZgKwHI7IAQAADIwjcrAb83/sARgyj2MwOYMd5NwxAAAAs8pTKwEAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGJjBfo4cML18TiQAwM45IgcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGB4IPjA9KZqX4twYAsPtyRA4AAGBgHJEDwBFYABgYR+QAAAAGxiAHAAAwMGMZ5KrqOVV1TVVdW1VnLrK+qupPRuu/WFVPGkcXAABgFi17kKuqPZKcm+S5SY5I8htVdcSCzZ6b5HGjr1OSvG25XQAAgFk1jiNyT05ybXd/vbv/KcnmJMct2Oa4JO/qOZ9Jsn9VHTyGNgAAwMyp7l7eFVS9KMlzuvuVo/MnJnlKd582b5sPJjm7uz85Ov+RJG/s7s8ucn2nZO6oXdatW3f05s2bl7Rf27dvz5o1a5Z02eXSnq72ld++bafr1+2b3Hjnjtcfdch+Y96j+03rz1xbW1t7Etyfz1bb71t7WtqbNm26vLs3LFw+jo8fqEWWLZwOH8g2cwu7z09yfpJs2LChN27cuKSd2rJlS5Z62eXSnq72zt5yPZl7W/Y3X7njm9J1J2wc8x7db1p/5tra2tqT4P58ttp+39rT3h7HUyu3Jjl03vn1Sa5fwjYAAAA8AOMY5C5L8riqOryq9k7y0iQXLdjmoiSvGL175VOT3NbdN4yhDQAAMHOW/dTK7r67qk5LcmmSPZK8o7uvqqpTR+vPS3JJkucluTbJHUl+c7ldAACAWTWO18iluy/J3LA2f9l58053klePowUAADDrxvKB4AAAAKwcgxwAAMDAGOQAAAAGxiAHAAAwMGN5sxOYZtedfexO12/ZsmWiHxoKAAALOSIHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAANjkAMAABgYgxwAAMDAGOQAAAAGxiAHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAANjkAMAABgYgxwAAMDAGOQAAAAGxiAHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAANjkAMAABgYgxwAAMDAGOQAAAAGxiAHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAANjkAMAABgYgxwAAMDAGOQAAAAGxiAHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAANjkAMAABiYZQ1yVfWIqvpwVX1t9N+HL7LNoVX1d1V1dVVdVVW/vZwmAADArFvuEbkzk3ykux+X5COj8wvdneSM7v7ZJE9N8uqqOmKZXQAAgJm13EHuuCTvHJ1+Z5LjF27Q3Td09+dGp7cluTrJIcvsAgAAzKzq7qVfuOp73b3/vPPf7e4fe3rlvPWHJfl4kp/r7u/vYJtTkpySJOvWrTt68+bNS9q37du3Z82aNUu67HJpa2tra2tr737tK799207Xr9s3ufHOHa8/6pD9xrxH95vWn/lqtv2+taelvWnTpsu7e8PC5Xvu6oJV9bdJHrXIqt97MDtQVWuSvD/Ja3c0xCVJd5+f5Pwk2bBhQ2/cuPHBZO6zZcuWLPWyy6Wtra2tra29+7VPPvPina4/46i78+Yrd/yn0XUnbBzzHt1vWn/mq9n2+9ae9vYuB7nuftaO1lXVjVV1cHffUFUHJ7lpB9vtlbkh7i+6+6+WvLcAAAAs+zVyFyU5aXT6pCQfWLhBVVWSP09ydXf/x2X2AAAAZt5yB7mzkzy7qr6W5Nmj86mqn6yqS0bbPD3JiUmeWVVXjL6et8wuAADAzNrlUyt3prtvTfKriyy/PsnzRqc/maSW0wEAAOB+yz0iBwAAwAozyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAzMsga5qnpEVX24qr42+u/Dd7LtHlX1+ar64HKaAAAAs265R+TOTPKR7n5cko+Mzu/Ibye5epk9AACAmbfcQe64JO8cnX5nkuMX26iq1ic5Nsnbl9kDAACYedXdS79w1fe6e/9557/b3T/29Mqqel+SP0qyNsnru/vXdnKdpyQ5JUnWrVt39ObNm5e0b9u3b8+aNWuWdNnl0tbW1tbW1t792ld++7adrl+3b3LjnTtef9Qh+415j+43rT/z1Wz7fWtPS3vTpk2Xd/eGhcv33NUFq+pvkzxqkVW/90DCVfVrSW7q7surauOutu/u85OcnyQbNmzojRt3eZFFbdmyJUu97HJpa2tra2tr737tk8+8eKfrzzjq7rz5yh3/aXTdCRvHvEf3m9af+Wq2/b61p729y0Guu5+1o3VVdWNVHdzdN1TVwUluWmSzpyd5QVU9L8k+Sf5ZVb27u1++5L0GAACYYct9jdxFSU4anT4pyQcWbtDd/6a713f3YUlemuSjhjgAAIClW+4gd3aSZ1fV15I8e3Q+VfWTVXXJcncOAACAH7fLp1buTHffmuRXF1l+fZLnLbJ8S5Ity2kCAADMuuUekQMAAGCFGeQAAAAGxiAHAAAwMAY5AACAgTHIAQAADIxBDgAAYGAMcgAAAAOzrM+RAwAYiuvOPnan67ds2ZLrTti4MjsDsEyOyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAyMQQ4AAGBgDHIAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAzMnqu9AwAAMG7XnX3sTtdv2bIl152wcWV2BibAETkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMAY5AAAAAbGIAcAADAwBjkAAICBMcgBAAAMjEEOAABgYAxyAAAAA2OQAwAAGBiDHAAAwMBUd6/2PuxQVd2c5BtLvPiBSW4Z4+5oa2tra2tra2tra2uvdPsx3X3QwoW79SC3HFX12e7eoK2tra2tra2tra2tPW1tT60EAAAYGIMcAADAwEzzIHe+tra2tra2tra2trb2NLan9jVyAAAA02qaj8gBAABMJYMcAADAwBjkAAAABsYgBwAAMDB7rvYOTEpV/V/d/bur0D08yROTfLm7vzLh1qOT3NTdd1VVJTk5yZOSfDnJn3X33RNsvyDJh7r7rkk1dtFfk+Q5SQ5NcneSr432554VaO83ah+SpJNcn+TS7v7epNs72adnd/eHJ9z4Z0kO6u7/uWD547v7ixNuPypJuvs7VXVQkmckuaa7r5pkdwf7siL3LTN++/7lJDd29zVV9UtJnprk6u6+eAXaM3nfMou3sUW6Hr9XwAw/hu4Wt7EV/ne+2v/WVvOxZEV+31PxrpVV9ScLFyU5Mcm7kqS7//UE2xd29/Gj08cleUuSLUmeluSPuvuCCba/lOTJ3X1HVb0pyWOTXJjkmUnS3f/HBNt3Jrk9yV8n+S+ZuxP+4aR6C9ovSfI7Sb6QZFOST2fu6PJRSU7o7isn2H5Fkn+X5ENJvj1avD7Js5P8fne/a1LtXezXN7v70RO8/pdk7t/2TUn2SnJyd182Wve57n7SBNv/KsmZmbtdvylzf/BcleTpSc7p7j+fYHs171tm9fb9liRPztz/aLw0ya+O9uNXkny+u39ngu2ZvG+Z4duYx++Vv33P6mPoat7GVvPf+aw+lqzc77u7B/+VZGuSdyd5RZKTRl8333t6wu3Pzzv96SSHj04fmOQLE25/ed7py5M8ZN75Sbc/n+ThSV6V5CNJbkxyXpJfWYHf9xeTPHTez/nS0enHJ/n0hNvXJNl/keUPT/LVCbcv2sHXf0ty+4TbVyQ5eHT6yUm+kuTX7/23MOH2lUkemuSAJNuTPGrez/yKCbdX875lVm/fV2Xuwe+hSb4777a+V5IvTbg9q/cts3ob8/i98rfvWX0MXc3b2Gr+O5/Vx5IV+31Py1MrfzbJH2TuUP3vdPe3q+rfdfc7V6A9/5Dmnt39D0nS3bdU1aSfivOtqnpmd380yXWZeyrQN6rqgAl3k6S7+7tJ/izJn40OIb8kydlVtb67D51gu5LcOTp9e5JHjnboi6On/01S5Ud/5/e6Z7Rukp6R5OWZu1NYuE9PnnB7j+6+IUm6+39U1aYkH6yq9Vn85zFOP+juO5LcUVX/s7u/M9qP71bVpNured8yq7fv7u6ed/957+/4nkz+dd2zet8yq7cxj9+r8/g9i4+hq3kbW81/57P6WLJiv++pGOS6e1uS11bV0UneXVUXZ+XeyOUJVfX9zN0R/ERVParnng+7d5I9Jtx+ZZJ3VdVZSW5LckVV3ft/P06fcPtH7nBH/0j/JMmfVNVjJty+JMnfVNXHkjw3yXuTpKoesXC/JuA/JPlcVX0oybdGyx6duaeF/MGE259Jckd3f2zhiqq6ZsLtbVX12B69Pq67b6iqjZl7KtCRE27fU1V7dfcPkhx778Kq2icTvp2v8n3LrN6+L66qTyTZJ8nbk/xlVX0mc0+H+fiE27N63zKrtzGP31nx2/esPoau2m0sq/vvfFYfS1bs9z0Vr5Gbr6oqyW8l+cXufvkq7sf+SX62u/9+BVo/m+SnMzeYb01yWU/4hflVtbG7t0yysYv+85IckbmnBXx4tOwhSfbq7n+ccPvhSY7J3Au1K3M/80tH/9dpKlXVEzL31JNrFyzfK8lLuvsvJth+dJLre8GL/6vqkMzdxv52Uu0FvVW5b5nR2/cvZu7/pn6mqh6b5IVJvpnkfSvwvc/cfcvoNnbD6I+O+ctn4ja2yH54/J5sfxYfQ3eL29iC9sT/ne8G/9ZW5bFkJf9umcZB7hG5/1CutjYAwH1m9e8W7en7W3EqPkeuqh5dVZur6uYk/z3JZVV102jZYdpT275ppdu72K+JvaOdtrb2dLer6tDRfdgnqup3R0e77113obb2lLR/pqr+uqourqrHVtUFVfW9qvofo6OTk2zvDn+3aPtbcayPJVPxGrkk/zVzb6d6Qo/e1rSq9kjy4iSbM/e5Edray1ZVv76jVUkeNamutrb2dLeTvCPJ+zP3Op5/meRjVfX87r41yaRfS6KtvVLt85P8cZI1ST6a5I1JfjPJryV5a+beIn5SZvLvFu3p/ltxKp5aWVVf6+7HPdh12tpLaP8gyV9k8XfdelF3r9XW1tZeQvuK7v75eedfnuTfJHlBkvf2ZD+rUVt7pdqf7+4njk5f293/fN66SX8m6az+3aK98u0VeyyZliNyl1fVnyZ5Z+5/F6RDM/c5NJ/X1h6jLyb5v7v7SwtXVNWztLW1tZdor6rap7vvSpLufndVfSdzH2T7MG3tKWnPf5fE/7hg3WbmyjEAAAc6SURBVN4Tbs/q3y3aU/y34rQckds7c08POC4/+i5IFyX580m+05j2zLWfkeQb3f3NRdZt6O7Pamtray+h/bokn+sFb41eVU9Mck53P1tbewra/yrJX3T39gXL/3mS07r7tRNsz+rfLdpT/LfiVAxyAAAAs2Qq3rVyMVX1OW1tbW1tbW1tbW1t7WlsT+0gl/zop8lra2tra2tra2tra2tPS3uaB7mLtbW1tbW1tbW1tbW1p7HtNXIAAAADM81H5JIkNeZPUNfW1tbW1tbW1h5Wu6oOrarNVfWJqvrdqtpr3roLtbWH2J6Kz5GrFfwEdW1tbW1tbW1t7WG1k7wjyfuTfCZzb0v/sap6fnffmuQx2tpDbE/FIJfkv2bHn6C+j7a2tra2tra29ky3D+ru80anX1NVL0/y8ap6wQ72R1t792939+C/klye5Od2sO5b2tra2tra2traM92+Ksk+C5Y9K8m1SW7Q1h5ie1peI/faJN/fwboXamtra2tra2trz3T77UmeMn9Bd/9tkhcn+ZK29hDb3rUSAABgYKbliNwOVdW/1dbW1tbW1tbW1tbWnqb21B+Rq6pvdvejtbW1tbW1tbW1tbW1p6U9Fe9aWVU7er51JdlXW1tbW1tbW1tbW1t7mtpTMcgl+V6SX+juGxeuqKpvaWtra2tra2tra2trT1N7Wl4j967s+AP23qOtra2tra2tra2trT1N7al/jRwAAMC0mZYjcj+mqs7S1tbW1tbW1tbW1taexvbUDnJJXqCtra2tra2tra2trT2N7Wke5EpbW1tbW1tbW1tbW3sa21P7Grmqekh336Otra2tra2tra2trT1t7akZ5KrqmCTHJzkkSSe5PskHuvtvtLW1tbW1tbW1tbW1p6k9FYNcVb0lyU9n7u0+t44Wr0/yiiRf6+7f1tbW1tbW1tbW1tbWnpb2tAxyX+3un15keSX5anc/TltbW1tbW1tbW1tbe1ra0/JmJ3dV1ZMXWf4LSe7S1tbW1tbW1tbW1taepvae47yyVXRykrdV1drcfwjz0CTfH63T1tbW1tbW1tbW1taemvZUPLXyXlX1qMy9qLCSbO3u72hra2tra2tra2tra09be9oGub26+wcLlh3Y3bdoa2tra2tra2tra2tPS3sqXiNXVZuqamuS66vqQ1V12LzVH9LW1tbW1tbW1tbW1p6qdncP/ivJZUmOHJ1+UZKvJXnq6PzntbW1tbW1tbW1tbW1p6k9sW9iJb+SfGHB+SOTXJPkhUk+p62tra2tra2tra2tPU3tiX0TK/mV5LNJHrVg2fokVyTZpq2tra2tra2tra2tPU3tiX0TK/mV5FlJnrDI8v2T/J62tra2tra2tra2tvY0tafqXSsBAABmwbS8a+V+VXV2VX2lqm4dfV09Wra/tra2tra2tra2trb2NLWnYpBL8pdJvptkY3cf0N0HJNk0WvZebW1tbW1tbW1tbW3taWpPxVMrq+qa7v4XD3adtra2tra2tra2trb2ENvTckTuG1X1hqpad++CqlpXVW9M8i1tbW1tbW1tbW1tbe1pak/LIPe/Jzkgyceq6rtV9b+SbEnyiCQv0dbW1tbW1tbW1tbWnqr2uN7+crW/kvxM5t7uc82C5c/R1tbW1tbW1tbW1taepvZEv4mV+kryrzP3iekXJrkuyXHz1k3609u1tbW1tbW1tbW1tbVXtD2xb2Ilv5JcmdHEm+SwzH2i+m+Pzn9eW1tbW1tbW1tbW1t7mtp7Zjrs0d3bk6S7r6uqjUneV1WPSVLa2tra2tra2tra2trT1J6WNzv5TlX9/L1nRj+8X0tyYJKjtLW1tbW1tbW1tbW1p6k9LZ8jtz7J3d39nUXWPb27P6Wtra2tra2tra2trT0t7akY5AAAAGbJtDy1EgAAYGYY5AAAAAbGIAfATKuqs6rq9TtZf3xVHbGS+wQAu2KQA4CdOz6JQQ6A3Yo3OwFg5lTV7yV5RZJvJbk5yeVJbktySpK9k1yb5MQkP5/kg6N1tyX530ZXcW6Sg5LckeRV3f2Vldx/ADDIATBTquroJBckeUqSPZN8Lsl5Sf5zd9862uYPk9zY3f9PVV2Q5IPd/b7Ruo8kObW7v1ZVT0nyR939zJX/TgCYZXuu9g4AwAp7RpL/r7vvSJKqumi0/OdGA9z+SdYkuXThBatqTZKnJXlvVd27+CcmvscAsIBBDoBZtNjTUS5Icnx3f6GqTk6ycZFtHpLke93985PbNQDYNW92AsCs+XiSF1bVvlW1NsnzR8vXJrmhqvZKcsK87beN1qW7v5/kH6rqxUlSc56wcrsOAHO8Rg6AmTPvzU6+kWRrki8nuT3JG0bLrkyytrtPrqqnJ/mzJP+Y5EVJ7knytiQHJ9kryebu/vcr/k0AMNMMcgAAAAPjqZUAAAADY5ADAAAYGIMcAADAwBjkAAAABsYgBwAAMDAGOQAAgIExyAEAAAzM/w+cL4Q3Ftu0rQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1080x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.rcParams['figure.figsize'] = [15, 6]\n",
    "mean_scores = parsed_and_scored_news.groupby(['ticker','date']).mean()\n",
    "mean_scores = mean_scores.unstack()\n",
    "mean_scores = mean_scores.xs('compound', axis=\"columns\").transpose()\n",
    "mean_scores.plot(kind = 'bar',subplots=True)\n",
    "plt.grid()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}