Stock-Prices-v1.2.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Stock-Prices-v1.2.ipynb","provenance":[{"file_id":"1DmVVYighbSo9uSkfm2o1sJVuOcWzLB80","timestamp":1653635400143},{"file_id":"1wEsmeaxOCEMLWUzGjT4ifDZCwUBSjrLd","timestamp":1653594134875}],"collapsed_sections":[],"authorship_tag":"ABX9TyMaZ0l5bYmQK740dpgJh6cY"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"},"accelerator":"TPU"},"cells":[{"cell_type":"code","source":["# !pip install aiohttp\n","# !pip install nest-asyncio"],"metadata":{"id":"7qeHb2grGZh-","executionInfo":{"status":"ok","timestamp":1653649536464,"user_tz":-120,"elapsed":202,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":1,"outputs":[]},{"cell_type":"code","source":["import aiohttp\n","import asyncio\n","import pandas as pd\n","\n","import nest_asyncio\n","nest_asyncio.apply()"],"metadata":{"id":"RpPC2EZLGZWD","executionInfo":{"status":"ok","timestamp":1653649827198,"user_tz":-120,"elapsed":218,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":6,"outputs":[]},{"cell_type":"code","execution_count":7,"metadata":{"id":"qMNPLV8-FZrp","executionInfo":{"status":"ok","timestamp":1653649828794,"user_tz":-120,"elapsed":257,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"outputs":[],"source":["def get_price_history(ticker, data):\n","    df = pd.read_html(data, header=0, index_col=0, parse_dates=True)[0][\"Close\"]\n","    df.dropna(inplace=True)\n","    df.rename(ticker, inplace=True)\n","    return df"]},{"cell_type":"code","source":["async def get_response(ticker, session):\n","    url = f\"http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t={ticker}&pd=max\"\n","    async with session.get(url) as response:\n","        data = await response.text()\n","        return get_price_history(ticker, data)"],"metadata":{"id":"cIy9ohvgeHS3","executionInfo":{"status":"ok","timestamp":1653649829837,"user_tz":-120,"elapsed":206,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":8,"outputs":[]},{"cell_type":"code","source":["async def main(tickers):\n","    async with aiohttp.ClientSession() as session:\n","        return pd.concat(\n","            await asyncio.gather(*[\n","                                   asyncio.create_task(get_response(ticker, session))\n","                                   for ticker in tickers\n","                                   ]),\n","            axis=1\n","            ).sort_index(ascending=False)"],"metadata":{"id":"ODEzBRaDezyT","executionInfo":{"status":"ok","timestamp":1653649831021,"user_tz":-120,"elapsed":300,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":9,"outputs":[]},{"cell_type":"code","source":["tickers = [\n","           \"AAPL\", \"MSFT\", \"AMZN\", \"GOOGL\", \"FB\", \"INTC\", \"AMD\", \"MU\", \"IBM\", \"HPQ\",\n","           \"COST\", \"LOW\", \"TGT\", \"WMT\", \"HD\", \"BBY\", \"HON\", \"KO\", \"PEP\", \"MCD\",\n","           \"XOM\", \"CVX\", \"MA\", \"V\", \"PYPL\", \"CAT\", \"DE\", \"MMM\", \"TJX\", \"WM\",\n","           \"UNH\", \"ABBV\", \"ABT\", \"AMGN\", \"MRK\", \"PFE\", \"LLY\", \"TMO\", \"BMY\", \"PG\",\n","           \"JNJ\", \"CL\", \"NKE\"\n","           ]\n","\n","asyncio.run(main(tickers)).to_csv(\"value-portfolio-stock-prices.csv\")"],"metadata":{"id":"ggIHMm1cfqNn","executionInfo":{"status":"ok","timestamp":1653649844577,"user_tz":-120,"elapsed":11604,"user":{"displayName":"Evgeny Zorin","userId":"06960824921814317938"}}},"execution_count":10,"outputs":[]}]}