Insider_Trading_Information.ipynb

{"metadata":{"orig_nbformat":4,"language_info":{"name":"python","version":"3.7.12","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kernelspec":{"name":"python3","display_name":"Python 3 (ipykernel)","language":"python"}},"nbformat_minor":5,"nbformat":4,"cells":[{"cell_type":"code","source":"import requests\nimport json\nimport pandas as pd\nimport numpy as np","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"b8213d74-85f4-40d5-a2e4-47bbcb05e33c"},{"cell_type":"code","source":"stock = 'TSLA'","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"adf3a1c8-bb40-44cb-82ce-5e18617d7190"},{"cell_type":"code","source":"r = requests.get('https://finnhub.io/api/v1/stock/insider-transactions?symbol='+stock+'&token=c6h4d7qad3ifd92ovv0g')\n","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"4e70fdca-73c1-4b38-b464-41716dd984c9"},{"cell_type":"code","source":"test = json.loads(r.text)","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"295ffea1-9112-4e9e-89e4-d719e6b6d9d9"},{"cell_type":"code","source":"df = pd.DataFrame(data=test['data'])","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"66d5ee7f-9ac6-4a50-97a4-6168ed93e52d"},{"cell_type":"code","source":"df.head()","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"7a7fe86c-4d4e-4f8e-b734-6f9c971ff337"},{"cell_type":"code","source":"# Derived attributes from the data.\ndf['dollarAmount'] = df['change']*df['transactionPrice']\ndf['insiderPortfolioChange'] = df['change']/(df['share'] - df['change'])","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"a64d9b26-9b25-4321-b472-7497807beef5"},{"cell_type":"code","source":"df.head()","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"a9003db4-2bc8-4a59-b7c4-d1591f9cf1d5"},{"cell_type":"code","source":"# print(type(df['transactionPrice'][0]))\nconditions = [\n    (df['change'] >= 0) & (df['transactionPrice'] > 0),\n    (df['change'] <= 0) & (df['transactionPrice'] > 0),\n    (df['transactionPrice'] == 0)\n]\nvalues = ['Buy', 'Sale', 'Gift']\ndf['buyOrSale'] = np.select(conditions, values)\n\nprint(df)\n\ndf.to_csv('./tesla_insider_trading.csv', index=False) ","metadata":{"trusted":true},"execution_count":null,"outputs":[],"id":"8dd67576-fa51-4b4e-b935-2b268fa8cfc7"},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[],"id":"4043a375-7696-4261-88ca-c243d7f679a2"}]}