{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# DFC foracst\n", "### Author: Karozis Stelios\n", "### Date: 12/4/2021\n", "### Source: https://codingandfun.com/discounted-cash-flow-with-python-valuing-a-company/" ] }, { "cell_type": "markdown", "metadata": {}, "source": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Libs import" ] }, { "cell_type": "code", "execution_count": 743, "metadata": {}, "outputs": [], "source": [ "import requests\n", "import numpy as np\n", "import pandas as pd\n", "import pandas_datareader.data as web\n", "import datetime\n", "import plotly.graph_objects as go\n", "pd.options.display.float_format = '{:,.2f}'.format" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## User inputs" ] }, { "cell_type": "code", "execution_count": 684, "metadata": {}, "outputs": [], "source": [ "y_ahead=5\n", "date_start = [2019,3,1]\n", "timeframe=0 #analysis for current year: 0, analysis for previous year: 1 etc\n", "company = 'GOOG' #'VWS.DE' #VESTAS\n", "demo = '34c9e7a6a6fcfb7b1d531f1267eac987'" ] }, { "cell_type": "code", "execution_count": 652, "metadata": {}, "outputs": [], "source": [ "IS = requests.get('https://financialmodelingprep.com/api/v3/income-statement/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "code", "execution_count": 653, "metadata": {}, "outputs": [], "source": [ "BS = requests.get('https://financialmodelingprep.com/api/v3/balance-sheet-statement/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "code", "execution_count": 654, "metadata": {}, "outputs": [], "source": [ "FR = requests.get('https://financialmodelingprep.com/api/v3/ratios/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "code", "execution_count": 655, "metadata": {}, "outputs": [], "source": [ "profile = requests.get('https://financialmodelingprep.com/api/v3/company/profile/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "code", "execution_count": 729, "metadata": {}, "outputs": [], "source": [ "historical_prices = requests.get('https://financialmodelingprep.com/api/v3/historical-price-full/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "code", "execution_count": 741, "metadata": {}, "outputs": [], "source": [ "history = requests.get('https://financialmodelingprep.com/api/v3/historical-price-full/'+company+'?apikey='+demo).json()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## FCF forecast" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Functions" ] }, { "cell_type": "code", "execution_count": 594, "metadata": {}, "outputs": [], "source": [ "def income_perc_years_ahead(IS,timeframe, y_ahead, revenue_g):\n", " #Get net income\n", " #net_income = dataframe[0]['netIncome']\n", " #get income statement as % of revenue for future predictions and forecast 5 next IS years\n", " income_statement = pd.DataFrame.from_dict(IS[timeframe],orient='index')\n", "\n", "\n", " #income_statement = income_statement[6:27]\n", " income_statement.columns = ['current_year']\n", " income_statement['as_ratio_of_revenue'] = np.nan\n", " for i in income_statement.index:\n", " try:\n", " #print(type(income_statement['current_year'][i]), income_statement['current_year'][i], type(net_income),net_income)\n", " income_statement['as_ratio_of_revenue'][i] = float(income_statement['current_year'][i]) / float(income_statement['current_year']['revenue'])\n", " except:\n", " pass\n", " \n", " \n", " for y in range(1,y_ahead+1):\n", " if y==1:\n", " cl_nm='next'+str(y)+'year'\n", " prev='current_year'\n", " else:\n", " cl_nm='next'+str(y)+'year'\n", " prev='next'+str(y-1)+'year'\n", " #print(cl_nm)\n", " income_statement[cl_nm] = np.nan\n", " #for i in income_statement.index:\n", " income_statement[cl_nm] = (income_statement[prev]['revenue'] * (1+revenue_g)) \\\n", " * income_statement['as_ratio_of_revenue'] \n", " \n", " return income_statement" ] }, { "cell_type": "code", "execution_count": 568, "metadata": {}, "outputs": [], "source": [ "def balance_perc_years_ahead(BS, timeframe, income_statement, y_ahead):\n", " #Get Balance sheet as a percentage of revenue\n", " balance_sheet = pd.DataFrame.from_dict(BS[timeframe],orient='index')\n", " balance_sheet.columns = ['current_year']\n", " balance_sheet['as_ratio_of_revenue'] = np.nan\n", " for i in balance_sheet.index:\n", " try:\n", " balance_sheet['as_ratio_of_revenue'][i] = float(balance_sheet['current_year'][i]) \\\n", " / float(income_statement['current_year']['revenue'])\n", " except:\n", " pass\n", " \n", " for y in range(1,y_ahead+1):\n", " cl_nm='next'+str(y)+'year'\n", " #print(cl_nm)\n", " balance_sheet[cl_nm] = income_statement[cl_nm]['revenue'] \\\n", " * balance_sheet['as_ratio_of_revenue'] \n", " \n", " return balance_sheet" ] }, { "cell_type": "code", "execution_count": 602, "metadata": {}, "outputs": [], "source": [ "def CF_forecast_perc_years_ahead(income_statement, balance_sheet, y_ahead):\n", " CF_forecast = {}\n", " \n", " for y in range(1,y_ahead+1):\n", " if y==1:\n", " cl_nm='next'+str(y)+'year'\n", " prev='current_year'\n", " else:\n", " cl_nm='next'+str(y)+'year'\n", " prev='next'+str(y-1)+'year'\n", " #print(cl_nm)\n", " CF_forecast[cl_nm] = {}\n", " CF_forecast[cl_nm]['netIncome'] = income_statement[cl_nm]['netIncome']\n", " CF_forecast[cl_nm]['inc_depreciation'] = income_statement[cl_nm]['depreciationAndAmortization'] - income_statement[prev]['depreciationAndAmortization']\n", " CF_forecast[cl_nm]['inc_receivables'] = balance_sheet[cl_nm]['netReceivables'] - balance_sheet[prev]['netReceivables']\n", " CF_forecast[cl_nm]['inc_inventory'] = balance_sheet[cl_nm]['inventory'] - balance_sheet[prev]['inventory']\n", " CF_forecast[cl_nm]['inc_payables'] = balance_sheet[cl_nm]['accountPayables'] - balance_sheet[prev]['accountPayables']\n", " CF_forecast[cl_nm]['CF_operations'] = CF_forecast[cl_nm]['netIncome'] + CF_forecast[cl_nm]['inc_depreciation'] + (CF_forecast[cl_nm]['inc_receivables'] * -1) + (CF_forecast[cl_nm]['inc_inventory'] *-1) + CF_forecast[cl_nm]['inc_payables']\n", " CF_forecast[cl_nm]['CAPEX'] = balance_sheet[cl_nm]['propertyPlantEquipmentNet'] - balance_sheet[prev]['propertyPlantEquipmentNet'] + income_statement[cl_nm]['depreciationAndAmortization']\n", "\n", " CF_forecast[cl_nm]['FCF'] = CF_forecast[cl_nm]['CAPEX'] + CF_forecast[cl_nm]['CF_operations']\n", " \n", " #add the forecasted cash flows into a Pandas\n", " CF_forec = pd.DataFrame.from_dict(CF_forecast,orient='columns')\n", "\n", " #add below option to format the dataframe with thousand separators\n", " #pd.options.display.float_format = '{:,.2f}'.format\n", " \n", " return CF_forec" ] }, { "cell_type": "code", "execution_count": 740, "metadata": {}, "outputs": [], "source": [ "def historical_prices(history):\n", "\n", " historical_prices = history['historical']\n", " price_data = {}\n", "\n", " for item in historical_prices:\n", " price_data[item['date']] = {}\n", " price_data[item['date']]['date'] = item['date']\n", " price_data[item['date']]['open']= item['open']\n", " price_data[item['date']]['high'] = item['high']\n", " price_data[item['date']]['low'] = item['low']\n", " price_data[item['date']]['adjClose'] = item['adjClose']\n", "\n", " price_DF = pd.DataFrame.from_dict(price_data)\n", " price_DF = price_DF.T\t\n", " fig = go.Figure(data=[go.Candlestick(x=price_DF['date'],\n", " open=price_DF['open'],\n", " high=price_DF['high'],\n", " low=price_DF['low'],\n", " close=price_DF['adjClose'])])\n", "\n", " fig.show()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Calculations" ] }, { "cell_type": "code", "execution_count": 744, "metadata": {}, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "close": [ 723.15, 708.14, 705.84, 691.02, 693.01, 698.21, 692.36, 695.7, 701.43, 711.12, 712.9, 723.18, 715.29, 713.31, 710.83, 716.49, 706.23, 706.63, 700.32, 709.74, 704.24, 720.09, 725.27, 724.12, 732.66, 735.72, 734.15, 730.4, 722.34, 716.55, 716.65, 728.28, 728.58, 719.41, 718.36, 718.27, 718.92, 710.36, 691.72, 693.71, 695.94, 697.46, 701.87, 675.22, 668.26, 680.04, 684.11, 692.1, 699.21, 694.95, 697.77, 695.36, 705.63, 715.09, 720.64, 716.98, 720.95, 719.85, 733.78, 736.96, 741.19, 738.63, 742.74, 739.77, 738.42, 741.77, 745.91, 768.79, 772.88, 771.07, 773.18, 771.61, 782.22, 781.76, 784.26, 784.68, 784.85, 783.22, 782.44, 777.14, 779.91, 777.5, 775.42, 772.15, 772.08, 769.64, 769.41, 769.54, 772.15, 769.09, 767.05, 768.78, 771.46, 780.08, 780.35, 775.32, 759.66, 769.02, 759.69, 762.49, 771.76, 768.88, 765.7, 771.41, 776.22, 787.21, 786.9, 774.21, 783.01, 781.56, 775.01, 777.29, 772.56, 776.43, 776.47, 776.86, 775.08, 785.94, 783.07, 786.14, 778.19, 778.53, 779.96, 795.26, 801.5, 796.97, 799.37, 813.11, 807.67, 799.07, 795.35, 795.37, 784.54, 783.61, 768.7, 762.13, 762.02, 782.52, 790.51, 785.31, 762.56, 754.02, 736.08, 758.49, 764.48, 771.23, 760.54, 769.2, 768.27, 760.99, 761.68, 768.24, 770.84, 758.04, 747.92, 750.5, 762.52, 759.11, 771.19, 776.42, 789.29, 789.27, 796.1, 797.07, 797.85, 790.8, 794.2, 796.42, 794.56, 791.26, 789.91, 791.55, 785.05, 782.79, 771.82, 786.14, 786.9, 794.02, 806.15, 806.65, 804.79, 807.91, 806.36, 807.88, 804.61, 806.07, 802.175, 805.02, 819.31, 823.87, 835.67, 832.15, 823.31, 802.32, 796.79, 795.695, 798.53, 801.49, 801.34, 806.97, 808.38, 809.56, 813.67, 819.24, 820.45, 818.98, 824.16, 828.07, 831.66, 830.76, 831.33, 828.64, 829.28, 823.21, 835.24, 830.63, 829.08, 827.78, 831.91, 835.37, 838.68, 843.25, 845.54, 845.62, 847.2, 848.78, 852.12, 848.4, 830.46, 829.59, 817.58, 814.43, 819.51, 820.92, 831.41, 831.5, 829.56, 838.55, 834.57, 831.41, 827.88, 824.67, 824.73, 823.35, 824.32, 823.56, 837.17, 836.82, 838.21, 841.65, 843.19, 862.76, 872.3, 871.73, 874.25, 905.96, 912.57, 916.44, 927.04, 931.66, 927.13, 934.3, 932.17, 928.78, 930.6, 932.22, 937.08, 943, 919.62, 930.24, 934.01, 941.86, 948.82, 954.96, 969.54, 971.47, 975.88, 964.86, 966.95, 975.6, 983.68, 976.57, 980.94, 983.41, 949.83, 942.9, 953.4, 950.76, 942.31, 939.78, 957.37, 950.63, 959.45, 957.09, 965.59, 952.27, 927.33, 940.49, 917.79, 908.73, 898.7, 911.71, 906.69, 918.59, 928.8, 930.09, 943.83, 947.16, 955.99, 953.42, 965.4, 970.89, 968.15, 972.92, 980.34, 950.7, 947.8, 934.09, 941.53, 930.5, 930.83, 930.39, 923.65, 927.96, 929.36, 926.79, 922.9, 907.24, 914.39, 922.67, 922.22, 926.96, 910.98, 910.67, 906.66, 924.69, 927, 921.28, 915.89, 913.81, 921.29, 929.57, 939.33, 937.34, 928.45, 927.81, 935.95, 926.5, 929.08, 932.07, 935.09, 925.11, 920.29, 915, 921.81, 931.58, 932.45, 928.53, 920.97, 924.86, 944.49, 949.5, 959.11, 953.27, 957.79, 951.68, 969.96, 978.89, 977, 972.6, 989.25, 987.83, 989.68, 992, 992.18, 992.81, 984.45, 988.2, 968.45, 970.54, 973.33, 972.56, 1019.27, 1017.11, 1016.64, 1025.5, 1025.58, 1032.48, 1025.9, 1033.33, 1039.85, 1031.26, 1028.0699, 1025.75, 1026, 1020.91, 1032.5, 1019.09, 1018.38, 1034.49, 1035.96, 1040.61, 1054.21, 1047.41, 1021.66, 1021.41, 1010.17, 998.68, 1005.15, 1018.38, 1030.9301, 1037.05, 1041.1, 1040.48, 1040.61, 1049.15, 1064.1899, 1077.14, 1070.6801, 1064.95, 1063.63, 1060.12, 1056.74, 1049.37, 1048.14, 1046.4, 1065, 1082.48, 1086.4, 1102.23, 1106.9399, 1106.26, 1102.61, 1105.52, 1122.26, 1121.76, 1131.98, 1129.79, 1137.51, 1155.8101, 1169.97, 1164.24, 1170.37, 1175.84, 1175.58, 1163.6899, 1169.9399, 1167.7, 1111.9, 1055.8, 1080.6, 1048.58, 1001.52, 1037.78, 1051.9399, 1052.1, 1069.7, 1089.52, 1094.8, 1102.46, 1111.34, 1106.63, 1126.79, 1143.75, 1118.29, 1104.73, 1069.52, 1078.92, 1090.9301, 1095.0601, 1109.64, 1126, 1160.04, 1164.5, 1138.17, 1149.49, 1149.58, 1135.73, 1099.8199, 1097.71, 1090.88, 1049.08, 1021.57, 1053.21, 1005.1, 1004.56, 1031.79, 1006.47, 1013.41, 1025.14, 1027.8101, 1007.04, 1015.45, 1031.64, 1019.97, 1032.51, 1029.27, 1037.98, 1074.16, 1072.08, 1087.7, 1072.96, 1067.45, 1019.98, 1021.18, 1040.04, 1030.05, 1017.33, 1037.3101, 1024.38, 1023.72, 1048.21, 1054.79, 1053.91, 1082.76, 1097.5699, 1098.26, 1100.2, 1079.23, 1081.77, 1078.59, 1066.36, 1079.58, 1069.73, 1079.6899, 1079.24, 1075.66, 1060.3199, 1067.8, 1084.99, 1119.5, 1139.29, 1139.66, 1136.88, 1123.86, 1120.87, 1129.99, 1139.3199, 1134.79, 1152.12, 1152.26, 1173.46, 1168.0601, 1169.84, 1157.66, 1155.48, 1124.8101, 1118.46, 1103.98, 1114.22, 1115.65, 1127.46, 1102.89, 1124.27, 1140.17, 1154.05, 1152.84, 1153.9, 1183.48, 1188.8199, 1183.86, 1198.8, 1195.88, 1186.96, 1184.91, 1205.5, 1248.08, 1263.7, 1268.33, 1238.5, 1219.74, 1217.26, 1220.01, 1226.15, 1223.71, 1224.77, 1242.22, 1245.61, 1249.1, 1237.61, 1235.01, 1242.1, 1214.38, 1206.49, 1200.96, 1207.77, 1201.62, 1207.33, 1205.38, 1220.65, 1241.8199, 1231.15, 1249.3, 1239.12, 1218.1899, 1197, 1186.48, 1171.4399, 1164.83, 1164.64, 1177.36, 1162.8199, 1175.33, 1172.53, 1156.05, 1161.22, 1171.09, 1186.87, 1166.09, 1173.37, 1184.65, 1180.49, 1194.64, 1193.47, 1195.3101, 1200.11, 1202.95, 1168.1899, 1157.35, 1148.97, 1138.8199, 1081.22, 1079.3199, 1110.08, 1092.25, 1121.28, 1115.6899, 1087.97, 1096.46, 1101.16, 1103.6899, 1050.71, 1095.5699, 1071.47, 1020.08, 1036.21, 1076.77, 1070, 1057.79, 1040.09, 1055.8101, 1093.39, 1082.4, 1066.15, 1038.63, 1036.05, 1043.66, 1064.71, 1061.49, 1020, 1025.76, 1037.61, 1023.88, 1048.62, 1044.41, 1086.23, 1088.3, 1094.4301, 1106.4301, 1050.8199, 1068.73, 1036.58, 1039.55, 1051.75, 1063.6801, 1061.9, 1042.1, 1016.53, 1028.71, 1023.01, 1009.41, 979.54, 976.22, 1039.46, 1043.88, 1037.08, 1035.61, 1045.85, 1016.06, 1070.71, 1068.39, 1076.28, 1074.66, 1070.33, 1057.1899, 1044.6899, 1077.15, 1080.97, 1089.9, 1098.26, 1070.52, 1075.5699, 1073.9, 1090.99, 1070.08, 1060.62, 1089.0601, 1116.37, 1110.75, 1132.8, 1145.99, 1115.23, 1098.71, 1095.0601, 1095.01, 1121.37, 1120.16, 1121.67, 1113.65, 1118.5601, 1113.8, 1096.97, 1110.37, 1109.4, 1115.13, 1116.05, 1119.92, 1140.99, 1147.8, 1162.03, 1157.86, 1143.3, 1142.3199, 1175.76, 1193.2, 1193.3199, 1185.55, 1184.46, 1184.26, 1198.85, 1223.97, 1231.54, 1205.5, 1193, 1184.62, 1173.02, 1168.49, 1173.3101, 1194.4301, 1200.49, 1205.92, 1215, 1207.15, 1203.84, 1197.25, 1202.16, 1204.62, 1217.87, 1221.1, 1227.13, 1236.34, 1236.37, 1248.84, 1264.55, 1256, 1263.45, 1272.1801, 1287.58, 1188.48, 1168.08, 1162.61, 1185.4, 1189.39, 1174.1, 1166.27, 1162.38, 1164.27, 1132.03, 1120.4399, 1164.21, 1178.98, 1162.3, 1138.85, 1149.63, 1151.42, 1140.77, 1133.47, 1134.15, 1116.46, 1117.95, 1103.63, 1036.23, 1053.05, 1042.22, 1044.34, 1066.04, 1080.38, 1078.72, 1077.03, 1088.77, 1085.35, 1092.5, 1103.6, 1102.33, 1111.42, 1121.88, 1115.52, 1086.35, 1079.8, 1076.01, 1080.91, 1097.95, 1111.25, 1121.58, 1131.59, 1116.35, 1124.83, 1140.48, 1144.21, 1144.9, 1150.34, 1153.58, 1146.35, 1146.33, 1130.1, 1138.0699, 1146.21, 1137.8101, 1132.12, 1250.41, 1239.41, 1225.14, 1216.6801, 1209.01, 1193.99, 1152.3199, 1169.95, 1173.99, 1204.8, 1188.01, 1174.71, 1197.27, 1164.29, 1167.26, 1177.6, 1198.45, 1182.6899, 1191.25, 1189.53, 1151.29, 1168.89, 1167.84, 1171.02, 1192.85, 1188.1, 1168.39, 1181.41, 1211.38, 1204.9301, 1204.41, 1206, 1220.17, 1234.25, 1239.5601, 1231.3, 1229.15, 1232.41, 1238.71, 1229.9301, 1234.03, 1218.76, 1246.52, 1241.39, 1225.09, 1219, 1205.1, 1176.63, 1187.83, 1209, 1207.6801, 1189.13, 1202.3101, 1208.67, 1215.45, 1217.14, 1243.01, 1243.64, 1253.0699, 1245.49, 1246.15, 1242.8, 1259.13, 1260.99, 1265.13, 1290, 1262.62, 1261.29, 1260.11, 1273.74, 1291.37, 1292.03, 1291.8, 1308.86, 1311.37, 1299.1899, 1298.8, 1298, 1311.46, 1334.87, 1320.7, 1315.46, 1303.05, 1301.35, 1295.34, 1306.6899, 1313.55, 1312.99, 1304.96, 1289.92, 1295.28, 1320.54, 1328.13, 1340.62, 1343.5601, 1344.66, 1345.02, 1350.27, 1347.83, 1361.17, 1355.12, 1352.62, 1356.04, 1349.59, 1348.84, 1343.5601, 1360.4, 1351.89, 1336.14, 1337.02, 1367.37, 1360.66, 1394.21, 1393.34, 1404.3199, 1419.83, 1429.73, 1439.23, 1430.88, 1439.2, 1451.7, 1480.39, 1484.4, 1485.95, 1486.65, 1466.71, 1433.9, 1452.5601, 1458.63, 1455.84, 1434.23, 1485.9399, 1447.0699, 1448.23, 1476.23, 1479.23, 1508.6801, 1508.79, 1518.27, 1514.66, 1520.74, 1519.67, 1526.6899, 1518.15, 1485.11, 1421.59, 1388.45, 1393.1801, 1318.09, 1339.33, 1389.11, 1341.39, 1386.52, 1319.04, 1298.41, 1215.5601, 1280.39, 1215.41, 1114.91, 1219.73, 1084.33, 1119.8, 1096.8, 1115.29, 1072.3199, 1056.62, 1134.46, 1102.49, 1161.75, 1110.71, 1146.8199, 1162.8101, 1105.62, 1120.84, 1097.88, 1186.92, 1186.51, 1210.28, 1211.45, 1217.5601, 1269.23, 1262.47, 1263.47, 1283.25, 1266.61, 1216.34, 1263.21, 1276.3101, 1279.3101, 1275.88, 1233.67, 1341.48, 1348.66, 1320.61, 1326.8, 1351.11, 1347.3, 1372.5601, 1388.37, 1403.26, 1375.74, 1349.33, 1356.13, 1373.1899, 1383.9399, 1373.485, 1406.72, 1402.8, 1410.42, 1417.02, 1417.84, 1416.73, 1428.92, 1431.8199, 1439.22, 1436.38, 1412.1801, 1438.39, 1446.61, 1456.16, 1465.85, 1403.84, 1413.1801, 1419.85, 1442.72, 1451.12, 1435.96, 1431.72, 1451.86, 1464.41, 1431.97, 1441.33, 1359.9, 1394.97, 1413.61, 1438.04, 1464.7, 1495.7, 1485.1801, 1496, 1510.99, 1541.74, 1511.34, 1520.58, 1513.64, 1518, 1515.55, 1565.72, 1558.42, 1568.49, 1515.6801, 1511.87, 1530.2, 1500.34, 1522.02, 1531.45, 1482.96, 1474.45, 1464.97, 1473.61, 1500.1, 1494.49, 1496.099976, 1480.319946, 1506.619995, 1518.449951, 1507.72998, 1517.97998, 1558.599976, 1547.530029, 1581.75, 1580.420044, 1588.199951, 1608.219971, 1652.380005, 1634.329956, 1644.410034, 1634.180054, 1660.709961, 1728.280029, 1641.839966, 1591.040039, 1532.390015, 1556.959961, 1532.02002, 1520.719971, 1519.280029, 1541.439941, 1520.900024, 1495.530029, 1459.98999, 1431.160034, 1465.459961, 1415.209961, 1428.290039, 1444.959961, 1464.52002, 1469.329956, 1469.599976, 1490.089966, 1458.420044, 1486.02002, 1453.439941, 1460.290039, 1485.930054, 1515.219971, 1569.150024, 1571.680054, 1568.079956, 1559.130005, 1573.01001, 1534.609985, 1555.930054, 1593.310059, 1615.329956, 1641, 1590.449951, 1604.26001, 1516.619995, 1567.23999, 1621.01001, 1626.030029, 1650.209961, 1749.130005, 1763.369995, 1761.75, 1763, 1740.390015, 1752.709961, 1749.839966, 1777.02002, 1781.380005, 1770.150024, 1746.780029, 1763.920044, 1742.189941, 1734.859985, 1768.880005, 1771.430054, 1793.189941, 1760.73999, 1798.099976, 1827.949951, 1826.77002, 1827.98999, 1819.47998, 1818.550049, 1784.130005, 1775.329956, 1781.77002, 1760.060059, 1767.77002, 1763, 1747.900024, 1731.01001, 1739.369995, 1723.5, 1732.380005, 1738.849976, 1776.089966, 1758.719971, 1739.52002, 1751.880005, 1728.23999, 1740.920044, 1735.290039, 1787.25, 1807.209961, 1766.719971, 1746.550049, 1754.400024, 1740.180054, 1736.189941, 1790.859985, 1886.900024, 1891.25, 1901.050049, 1899.400024, 1917.23999, 1830.790039, 1863.109985, 1835.73999, 1901.349976, 1927.51001, 2070.070068, 2062.370117, 2098, 2092.909912, 2083.51001, 2095.379883, 2095.889893, 2104.110107, 2121.899902, 2128.310059, 2117.199951, 2101.139893, 2064.879883, 2070.860107, 2095.169922, 2031.359985, 2036.859985, 2081.51001, 2075.840088, 2026.709961, 2049.090088, 2108.540039, 2024.170044, 2052.699951, 2055.030029, 2114.77002, 2061.919922, 2066.48999, 2092.52002, 2091.080078, 2036.219971, 2043.199951, 2038.589966, 2052.959961, 2045.060059, 2044.359985, 2035.550049, 2055.949951, 2055.540039, 2068.629883, 2137.75, 2225.550049, 2224.75, 2249.679932, 2265.439941, 2285.879883, 2254.790039, 2267.27002, 2254.840088, 2296.6599, 2297.76, 2302.4, 2293.63, 2293.29, 2267.92, 2315.3 ], "high": [ 723.93, 725.766, 708.98, 714.17, 697.62, 700.64, 697.84, 699.75, 702.32, 711.86, 718.71, 723.5, 724.48, 719.25, 716.662, 718.48, 721.52, 711.6, 706, 714.58, 711.478, 720.97, 727.51, 728.33, 733.936, 739.73, 737.21, 733.02, 729.49, 724.91, 721.98, 728.57, 729.54, 725.89, 725.44, 722.47, 722.98, 716.65, 708.82, 702.48, 702.77, 700.86, 701.95, 689.4, 672.3, 680.33, 687.429, 692.32, 700.65, 696.94, 701.68, 698.2, 705.71, 716.51, 722.94, 724, 722.21, 725.74, 736.13, 736.99, 742.13, 741.69, 743.24, 742.61, 741.69, 744.46, 748.65, 778.55, 780.43, 775.84, 773.21, 774.07, 783.04, 782.63, 788.94, 786.812, 789.75, 783.395, 787.49, 780.98, 780.81, 782.86, 777.1, 774.54, 776.44, 774.5, 771.89, 776.08, 774.99, 774.466, 769.09, 771.02, 773.92, 782, 782.73, 780.35, 773.245, 770.29, 766.22, 767.68, 773.8, 769.75, 774, 773.33, 777.16, 789.85, 788.93, 782.74, 785.99, 781.81, 785.8, 780.94, 776.065, 778.71, 782.07, 780.48, 779.66, 789.38, 792.28, 788.13, 781.22, 783.95, 785.85, 801.61, 804.6, 803.97, 799.5, 815.18, 816.68, 806.98, 803.49, 815.49, 796.86, 789.49, 781.65, 769.95, 770.36, 785.19, 795.633, 791.227, 791.17, 760.78, 757.85, 764.416, 766.36, 772.7, 775, 769.7, 776.96, 768.283, 765, 779.53, 778.5, 772.99, 759.85, 754, 763.9, 768.83, 771.36, 778.18, 789.43, 791.25, 804.38, 804, 803, 800.856, 797.66, 798.65, 796.676, 793.32, 792.74, 797.86, 794.23, 785.93, 782.78, 789.63, 791.34, 794.48, 807.9, 809.966, 809.13, 808.15, 807.39, 811.224, 807.14, 806.205, 809.48, 806.91, 820.87, 825.9, 835.77, 838, 841.95, 815.84, 801.25, 801.19, 802.7, 806, 801.67, 810.5, 811.84, 810.66, 815.25, 820.959, 823, 823, 824.4, 828.07, 833.45, 833.25, 832.46, 829, 830.5, 828.54, 836.255, 834.51, 831.36, 828.88, 833.41, 838.15, 842, 844.91, 848.685, 847.24, 848.63, 850.85, 853.4, 850.22, 853.5, 835.55, 822.57, 821.93, 821.63, 825.99, 832.765, 833.68, 831.64, 840.85, 835.18, 842.45, 836.39, 828.485, 829.35, 827.427, 826.66, 826.38, 837.75, 838.93, 842.22, 845.2, 843.88, 863.45, 875, 876.05, 875.4, 916.85, 915.68, 920.77, 928.1, 935.93, 934.9, 936.925, 937.5, 932, 932.53, 933.44, 938.25, 943.11, 939.333, 933.17, 937.755, 941.883, 951.467, 955.09, 972.629, 974.98, 976.2, 979.27, 971.5, 975.88, 986.91, 988.25, 983.98, 984.57, 984.5, 949.355, 959.98, 961.15, 943.339, 942.04, 959.99, 961.62, 960.1, 960.72, 966, 973.31, 948.29, 942.75, 931.26, 926.05, 913.94, 914.51, 914.944, 921.54, 930.38, 931.43, 946.3, 954.45, 956.91, 960.74, 968.04, 973.04, 975.9, 973.23, 986.2, 959.7, 955, 951.78, 943.83, 943.59, 937.447, 932.6, 932.24, 930.307, 931.7, 935.814, 925.98, 919.26, 917.78, 924.668, 926.55, 932.7, 926.86, 915.275, 913, 925.86, 929.93, 930.84, 925.555, 919.245, 923.33, 930.819, 941.98, 942.48, 937, 930.915, 936.41, 936.99, 938.38, 933.48, 937.25, 932.77, 926.49, 922.08, 922.42, 933.88, 936.53, 934.73, 926.4, 930.82, 949.9, 950.69, 959.786, 962.54, 958, 960.39, 970.91, 979.46, 985.425, 981.57, 990.71, 994.12, 997.21, 993.907, 996.44, 996.72, 988.88, 991, 989.52, 972.23, 976.09, 987.6, 1048.39, 1024.97, 1024, 1029.67, 1028.09, 1032.65, 1034.87, 1033.97, 1043.522, 1033.99, 1030.76, 1031.58, 1026.8101, 1024.09, 1035.92, 1034.42, 1022.61, 1035.11, 1039.7061, 1043.178, 1055.46, 1062.375, 1044.08, 1028.49, 1022.49, 1016.1, 1020.61, 1024.97, 1034.24, 1042.05, 1043.8, 1050.3101, 1046.665, 1058.5, 1067.62, 1078.49, 1076.84, 1073.38, 1069.33, 1064.2, 1060.12, 1058.37, 1054.75, 1049.7, 1066.9399, 1086.29, 1093.5699, 1104.25, 1111.27, 1110.5699, 1104.6, 1106.525, 1124.29, 1139.91, 1132.6, 1132.51, 1137.86, 1159.88, 1171.627, 1179.86, 1175.9399, 1175.84, 1186.89, 1176.52, 1173, 1174, 1123.0699, 1110, 1081.71, 1081.78, 1058.62, 1043.97, 1061.5, 1058.37, 1071.72, 1091.479, 1104.67, 1113.95, 1133.97, 1122.8199, 1127.28, 1143.96, 1144.04, 1127.53, 1110.12, 1081.999, 1097.1, 1101.85, 1112.22, 1127.6, 1160.8, 1177.05, 1176.76, 1158.59, 1161.08, 1155.88, 1121.99, 1105.2, 1106.3, 1082.9, 1063.36, 1055.63, 1064.839, 1024.23, 1043, 1034.8, 1020.99, 1028.718, 1042.79, 1031.42, 1039.6, 1036.28, 1031.364, 1040.6899, 1046.42, 1043.24, 1077.88, 1077.4301, 1094.165, 1092.35, 1082.72, 1057, 1032.49, 1047.98, 1049.5, 1037, 1038.47, 1040.389, 1029.675, 1048.51, 1061.6801, 1060.55, 1085.4399, 1100.4399, 1101.33, 1110.75, 1090.05, 1089.27, 1086.87, 1069.9399, 1088, 1086.59, 1080.78, 1080.47, 1082.5601, 1073.37, 1069.21, 1097.1899, 1120, 1141.89, 1145.738, 1143, 1135.8199, 1126.67, 1137.26, 1139.79, 1146.5, 1155.47, 1153.42, 1174.3101, 1171.27, 1186.286, 1177.295, 1162.4969, 1143.91, 1133.21, 1131.8361, 1122.3101, 1128.2271, 1128, 1135.8199, 1127.5, 1140.9301, 1154.67, 1159.59, 1164.29, 1184.41, 1195.417, 1191, 1203.04, 1204.5, 1200, 1196.86, 1206.49, 1266, 1265.86, 1269.771, 1273.89, 1234.916, 1227.588, 1233.47, 1229.88, 1230, 1226.088, 1251.17, 1256.5, 1255.542, 1245.6949, 1249.2729, 1245.87, 1235.24, 1226, 1209.02, 1211, 1217.26, 1211.84, 1221.28, 1221.65, 1243.09, 1242.545, 1250.66, 1253.635, 1238.66, 1212.99, 1199.01, 1186.3, 1175.26, 1174.54, 1178.6801, 1178.61, 1178.61, 1180.425, 1177.24, 1176.08, 1173.21, 1189.89, 1192.21, 1178, 1186.88, 1194.23, 1202.1, 1195.41, 1209.9, 1209.96, 1206.41, 1197.51, 1173.5, 1168, 1154.35, 1132.17, 1106.4, 1115, 1113.446, 1124.22, 1128.99, 1121.84, 1110.36, 1112.23, 1107.89, 1106.12, 1110.98, 1106.53, 1097.04, 1037.49, 1091.9399, 1083.975, 1082.975, 1058.47, 1064.345, 1095.46, 1093.27, 1075.5601, 1062.12, 1056.605, 1054.564, 1071.85, 1067, 1060.79, 1031.74, 1048.5601, 1037.59, 1049.3101, 1057.58, 1086.84, 1094.245, 1095.5699, 1124.65, 1104.42, 1071.2, 1075.26, 1048.45, 1060.6, 1081.65, 1079.76, 1062.6, 1053.15, 1049.48, 1062, 1034.22, 1024.02, 1003.54, 1040, 1043.89, 1055.5601, 1052.7, 1052.3199, 1056.98, 1070.84, 1074, 1084.5601, 1082.63, 1071.15, 1063.775, 1051.53, 1080.05, 1092.375, 1091.8, 1108.3521, 1091.51, 1084.9301, 1079.475, 1094, 1083, 1075.15, 1091, 1117.33, 1125, 1132.8, 1146.85, 1147, 1104.84, 1098.91, 1105.9449, 1125.295, 1134.73, 1128.23, 1131.67, 1121.89, 1123.41, 1111.9399, 1111.24, 1118.54, 1119.51, 1117.98, 1127.65, 1142.97, 1158.28, 1169.61, 1167.566, 1156.755, 1147.08, 1176.1899, 1200, 1200.9301, 1197.88, 1196.5699, 1190, 1200, 1227.14, 1231.79, 1230, 1206.3979, 1202.83, 1187.559, 1171.5649, 1178.99, 1196.66, 1201.35, 1216.3, 1215.67, 1216.22, 1208.6899, 1202.29, 1203.785, 1207.96, 1218.35, 1224.2, 1230.8199, 1240.5601, 1242, 1249.09, 1269, 1268.01, 1267.408, 1273.0699, 1289.27, 1192.8101, 1188.05, 1174.1899, 1186.8, 1190.85, 1190.4399, 1180.424, 1169.66, 1172.6, 1147.9399, 1140.42, 1171.33, 1188.16, 1180.15, 1146.797, 1152.708, 1158.52, 1145.973, 1149.765, 1151.587, 1129.1, 1123.13, 1109.6, 1065.5, 1056.05, 1053.55, 1047.49, 1070.92, 1092.66, 1101.99, 1080.9301, 1094.17, 1092.6899, 1099.1801, 1116.39, 1107, 1120.12, 1124.11, 1122, 1114.35, 1092.97, 1087.1, 1081, 1107.58, 1111.77, 1126.76, 1132.88, 1125.98, 1128.025, 1142.05, 1153.0699, 1147.34, 1150.8199, 1158.58, 1158.36, 1147.605, 1151.14, 1139.25, 1146.9, 1144, 1141.7, 1265.55, 1247.37, 1234.87, 1234, 1234.11, 1206.9, 1175.24, 1179.96, 1178.4449, 1205.01, 1203.88, 1184.96, 1204.78, 1182.3, 1175.84, 1182.72, 1206.99, 1196.0601, 1199, 1198.012, 1194.08, 1169.47, 1182.4, 1176.42, 1196.0601, 1198.5, 1186.89, 1183.48, 1213.04, 1212.015, 1220, 1210, 1222.6, 1241.86, 1240.88, 1239.5601, 1235, 1235.61, 1244.4399, 1243.3199, 1239.09, 1246.74, 1248.3, 1245, 1244.02, 1226, 1231.23, 1196.98, 1189.0601, 1211.4399, 1218.204, 1206.08, 1208.35, 1215, 1228.39, 1226.33, 1247.33, 1254.74, 1263.325, 1258.89, 1254.629, 1250.6, 1259.89, 1264, 1269.6, 1299.3101, 1281.59, 1269.36, 1267.67, 1274.62, 1294.13, 1298.9301, 1293.73, 1323.74, 1318, 1306.425, 1310, 1304.3, 1317, 1334.88, 1335.5291, 1327.7, 1315, 1312.59, 1308.73, 1311.3101, 1314.8, 1318.36, 1310.205, 1305.83, 1298.4611, 1325.8, 1329.358, 1344, 1359.45, 1349.975, 1351.2, 1355.775, 1353.093, 1364.6801, 1365, 1360.47, 1358.1, 1363.64, 1359.8, 1350.26, 1361.327, 1364.53, 1353, 1338, 1368.14, 1372.5, 1396.5, 1402.99, 1411.58, 1427.33, 1434.929, 1440.52, 1441.8, 1441.395, 1451.99, 1481.295, 1491.85, 1503.214, 1495.52, 1495.495, 1438.0699, 1456, 1465.4301, 1457.28, 1470.13, 1490, 1469.5, 1463.84, 1482, 1485.84, 1509.5, 1529.63, 1520.6949, 1527.1801, 1520.74, 1531.63, 1532.106, 1529.64, 1512.215, 1436.97, 1438.14, 1415.7, 1371.704, 1341.14, 1390.87, 1410.15, 1388.09, 1358.91, 1306.22, 1254.76, 1281.15, 1260.96, 1193.87, 1219.76, 1152.267, 1130.86, 1106.5, 1157.97, 1143.99, 1071.3199, 1135, 1148.9, 1169.97, 1150.67, 1151.63, 1175.3101, 1129.6899, 1126.86, 1123.54, 1194.66, 1225, 1219.0699, 1225.5699, 1220.51, 1282.0699, 1280.46, 1279, 1294.4301, 1281.6, 1254.27, 1285.613, 1293.3101, 1280.4, 1296.15, 1288.05, 1359.99, 1352.8199, 1352.0699, 1327.66, 1373.9399, 1371.12, 1377.6, 1398.76, 1416.53, 1415, 1385.4821, 1357.42, 1374.48, 1392.325, 1392, 1410.42, 1415.49, 1412.76, 1441, 1421.74, 1440.84, 1432.5699, 1437.96, 1439.61, 1446.552, 1438.96, 1445.05, 1447.99, 1468, 1474.259, 1454.475, 1437, 1424.8, 1455.02, 1460, 1451.41, 1447.8, 1452.75, 1475.941, 1475.42, 1442.9, 1433.45, 1395.6, 1418.65, 1443, 1482.95, 1506.59, 1516.8, 1505.88, 1522.72, 1543.83, 1577.132, 1522.95, 1535.33, 1518.6899, 1523.4399, 1570.29, 1586.99, 1570, 1571.87, 1517.636, 1540.97, 1526.48, 1531.252, 1537.87, 1508.95, 1490.47, 1485.5601, 1482.41, 1502.39, 1516.845, 1504.074951, 1510, 1512.385986, 1537.25, 1521.900024, 1525.609985, 1562.469971, 1573.680054, 1585.87, 1597.719971, 1614.170044, 1611.619995, 1659.219971, 1655, 1647.170044, 1647.964966, 1665.72998, 1733.180054, 1709.713989, 1645.109985, 1563.86499, 1569, 1584.081055, 1575.199951, 1564, 1559.569946, 1562, 1508.297974, 1503.003052, 1448.359985, 1469.52002, 1460.959961, 1443.708984, 1450, 1476.800049, 1476.662964, 1489.75, 1499.040039, 1483.199951, 1488.209961, 1486.76001, 1468.959961, 1490, 1516.52002, 1593.859985, 1590, 1587.68396, 1575.10498, 1581.130005, 1588.150024, 1577.5, 1618.72998, 1621.98999, 1642.359985, 1638.23999, 1606.844971, 1561.349976, 1593.709961, 1687, 1660.77002, 1661.699951, 1771.36499, 1793.640015, 1772.430054, 1818.060059, 1763, 1764.219971, 1768.27002, 1781.040039, 1799.069946, 1785, 1773.469971, 1769.589966, 1774, 1753.900024, 1771.599976, 1778.540039, 1804, 1788.064941, 1824.829956, 1835.650024, 1847.199951, 1833.160034, 1832.369995, 1821.900024, 1834.27002, 1781.310059, 1784.449951, 1797.390015, 1771.420044, 1773, 1771.784058, 1755.109985, 1740.849976, 1737.405029, 1747.98999, 1746, 1790.728027, 1792.439941, 1765.094971, 1758.930054, 1760.650024, 1747.670044, 1748, 1788.400024, 1809.839966, 1794.314941, 1778.040039, 1765.035034, 1775.01001, 1756, 1809.275024, 1903.709961, 1934.859985, 1910.949951, 1929.579956, 1925, 1890, 1898.829956, 1857.280029, 1922.391968, 1955.76001, 2116.5, 2078.550049, 2102.51001, 2123.547119, 2105.129883, 2108.370117, 2102.030029, 2108.820068, 2152.679932, 2133.659912, 2132.735107, 2130.530029, 2091.419922, 2082.01001, 2100.780029, 2094.879883, 2071.01001, 2086.52002, 2104.370117, 2088.518066, 2089.23999, 2118.110107, 2128.810059, 2078.040039, 2075, 2125.699951, 2090.26001, 2067.060059, 2123.560059, 2109.780029, 2075.5, 2053.100098, 2057.98999, 2072.302002, 2078.209961, 2058.870117, 2050.98999, 2058.429932, 2070.780029, 2093.326904, 2142.939941, 2237.310059, 2237.659912, 2255, 2284.004883, 2289.040039, 2275.320068, 2277.209961, 2277.98999, 2306.5969, 2306.4399, 2318.45, 2309.6, 2295.32, 2303.76, 2325.82 ], "low": [ 715.59, 703.026, 692.365, 689.55, 689, 691, 692, 689.01, 695.72, 698.107, 710, 715.72, 712.8, 709, 709.26, 705.65, 704.11, 700.63, 696.8, 700.52, 704.18, 706.86, 719.705, 720.28, 724, 731.26, 730.66, 724.17, 720.56, 714.61, 716.55, 720.58, 722.336, 716.43, 716.51, 713.12, 717.31, 703.26, 688.452, 693.41, 692.01, 693.082, 687, 673.45, 663.284, 673, 681.41, 683.65, 692.13, 688.88, 689.09, 688.215, 696.435, 707.24, 715.91, 716.85, 718.03, 719.055, 721.19, 729, 737.1, 735.831, 736.56, 737.5, 734.27, 737, 739.3, 766.77, 761.09, 767.85, 766.82, 768.795, 772.34, 778.091, 780.57, 782.778, 782.97, 780.4, 780.11, 773.444, 773.53, 777, 773.13, 770.05, 771.785, 767.07, 763.185, 765.85, 766.615, 766.84, 765.38, 764.3, 768.41, 771, 776.2, 773.58, 759.66, 754, 755.8, 759.11, 759.96, 764.66, 764.441, 768.53, 768.301, 778.44, 784.15, 773.07, 774.308, 774.97, 774.232, 774.09, 769.5, 772.89, 775.65, 775.54, 770.75, 775.87, 780.58, 782.06, 773, 776, 777.5, 785.565, 798.03, 796.03, 794, 804.82, 805.14, 796.32, 791.5, 793.59, 784, 775.54, 763.45, 759.03, 750.561, 772.55, 780.19, 771.67, 752.18, 750.38, 727.54, 746.97, 750.51, 764.23, 760, 760.6, 767, 755.25, 760.52, 759.8, 768.24, 754.83, 737.025, 743.1, 752.9, 757.34, 755.8, 767.23, 779.021, 784.355, 793.34, 794.01, 792.92, 790.29, 786.27, 793.27, 787.1, 788.58, 787.28, 787.657, 783.2, 778.92, 770.41, 775.8, 783.16, 785.02, 792.204, 802.83, 803.51, 801.37, 799.17, 806.69, 800.37, 800.99, 801.8, 801.69, 803.74, 817.821, 825.06, 827.01, 820.44, 799.8, 790.52, 791.19, 792, 800.37, 795.25, 801.78, 803.19, 804.54, 809.78, 815.49, 816, 818.47, 818.98, 821.655, 828.35, 828.64, 822.88, 824.2, 824, 820.2, 827.26, 829.64, 825.751, 822.4, 826.52, 831.79, 834.21, 839.5, 843.25, 840.8, 840.77, 846.13, 847.11, 845.15, 829.02, 827.18, 812.257, 808.89, 803.37, 814.027, 822.38, 829, 827.39, 829.22, 829.036, 830.72, 826.46, 820.513, 823.77, 817.02, 821.02, 821.44, 824.47, 832.71, 836.29, 839.32, 840.6, 849.86, 862.81, 867.748, 870.38, 905.77, 901.45, 909.453, 912.543, 924.59, 925.2, 925.26, 929.53, 925.16, 923.03, 927.85, 929.34, 937.58, 918.14, 918.75, 931, 935, 942.575, 949.5, 955.47, 965.03, 969.49, 960.18, 960.01, 966, 975.1, 975.14, 975.94, 977.2, 935.63, 915.233, 944.09, 942.25, 924.44, 931.595, 949.05, 950.01, 950.76, 954.55, 954.2, 950.79, 926.85, 916, 910.62, 908.31, 894.79, 898.5, 899.7, 908.85, 919.59, 922, 934.47, 943.01, 948.005, 949.241, 950.6, 964.03, 961.51, 960.15, 970.77, 945.4, 942.279, 920, 927.5, 926.04, 929.26, 916.68, 922.24, 923.03, 926.5, 925.61, 917.25, 906.13, 905.58, 918.19, 919.82, 923.445, 910.98, 907.154, 903.4, 911.475, 919.36, 915.5, 915.5, 911.87, 905, 919.65, 931.76, 935.15, 921.96, 919.27, 923.62, 924.88, 926.92, 923.861, 929.86, 924, 916.36, 910.6, 912.55, 922, 923.83, 926.48, 909.7, 921.14, 927.74, 940.55, 951.51, 947.84, 949.14, 950.69, 955.18, 963.36, 976.11, 966.08, 972.25, 985, 989, 984, 988.59, 986.975, 978.39, 984.58, 966.12, 961, 960.52, 972.2, 1008.2, 1007.5, 1010.42, 1016.95, 1013.01, 1020.31, 1025, 1025.13, 1028.45, 1019.666, 1025.28, 1022.57, 1014.15, 1015.42, 1022.52, 1017.75, 1017.5, 1022.655, 1031.4301, 1035, 1038.4399, 1040, 1015.65, 1015, 1002.02, 995.57, 988.28, 1001.14, 1018.071, 1032.522, 1032.05, 1033.6899, 1038.38, 1043.11, 1049.5, 1062, 1063.55, 1061.52, 1061.7939, 1059.4399, 1050.2, 1048.05, 1044.77, 1044.9, 1045.23, 1063.21, 1084.002, 1092, 1101.62, 1101.231, 1096.11, 1099.59, 1101.15, 1117.832, 1117.01, 1117.5, 1128.3, 1135.11, 1158.75, 1161.05, 1162.76, 1158.11, 1171.98, 1163.52, 1159.13, 1157.52, 1107.278, 1052.03, 1023.137, 1048.26, 1000.66, 992.56, 1040.928, 1044.087, 1046.75, 1064.34, 1088.313, 1088.52, 1106.33, 1102.59, 1104.714, 1126.6949, 1118, 1103.24, 1067.001, 1048.115, 1069, 1089.775, 1085.4821, 1112.8, 1132.4611, 1157.42, 1133.33, 1141.4399, 1134.54, 1131.96, 1089.01, 1083.46, 1085.15, 1045.91, 1021.22, 1008.4, 996.92, 980.64, 1002.9, 990.37, 994.07, 993, 1020.131, 1003.03, 1014.08, 1011.34, 1015.87, 1021.435, 1022.98, 1026.74, 1048.26, 1066.225, 1068.1801, 1069.5699, 1060.7, 1010.59, 1015.31, 1018.19, 1025.59, 1016.85, 1008.21, 1022.87, 1006.29, 1016.9, 1047.1, 1047.145, 1056.365, 1085.64, 1090.91, 1099.11, 1073.47, 1076.26, 1073.5, 1060.6801, 1073.65, 1066.6899, 1061.71, 1066.15, 1073.775, 1055.22, 1056.83, 1067.5601, 1098.5, 1122.005, 1133.1899, 1125.743, 1116.52, 1112.15, 1118.6, 1130.735, 1133.38, 1140.64, 1143.485, 1143.59, 1154.01, 1169.16, 1152.2321, 1147.26, 1112.78, 1116.6591, 1103.62, 1096.01, 1115, 1093.8, 1100.02, 1108.48, 1120.7371, 1143.42, 1149.59, 1141, 1155.9351, 1180, 1179.28, 1170.6, 1190.34, 1183.3199, 1184.22, 1181, 1235.5601, 1239.13, 1249.02, 1231, 1211.47, 1205.6, 1210.21, 1204.79, 1215.0601, 1215.797, 1236.17, 1238.0081, 1246.01, 1232, 1233.641, 1225.11, 1209.51, 1202.55, 1188.24, 1194.626, 1200.354, 1199, 1204.24, 1206.359, 1225.7159, 1228.6899, 1236.359, 1232.59, 1211.285, 1192.5, 1162, 1152, 1157.215, 1160.11, 1156.24, 1158.36, 1162.85, 1168.33, 1154.03, 1157.09, 1154.58, 1173.36, 1166.04, 1146.91, 1168, 1174.765, 1183.63, 1184.5, 1190.3, 1186.63, 1193.83, 1155.576, 1145.12, 1127.364, 1137.572, 1081.13, 1068.27, 1086.402, 1089, 1102.5, 1102.1899, 1077.09, 1087.75, 1091, 1070, 1048.74, 1069.55, 1034.09, 995.83, 1000.75, 1057, 1062.46, 1054.61, 1021.24, 1038.0699, 1065.9, 1072.205, 1053.11, 1031, 1031.15, 1031, 1031.78, 1048.98, 1016.26, 996.02, 1033.47, 1022.399, 1033.91, 1038.49, 1035.76, 1076, 1077.88, 1103.665, 1049.98, 1030.77, 1028.5, 1023.29, 1039.84, 1062.79, 1053.9301, 1040.79, 1007.9, 1021.44, 1008.05, 996.36, 973.69, 970.11, 983, 997, 1033.1, 1023.59, 1015.71, 1014.07, 1027.418, 1054.76, 1060.53, 1066.4, 1057.71, 1048.48, 1041.255, 1047.34, 1079.34, 1073.5, 1090.9, 1063.47, 1059.75, 1060.7, 1081.8199, 1063.8, 1055.865, 1066.85, 1095.41, 1104.89, 1109.02, 1117.248, 1112.77, 1086, 1086.55, 1092.86, 1105.85, 1118.5, 1110.4449, 1110.65, 1110, 1105.28, 1092.52, 1095.6, 1107.27, 1099.92, 1101, 1111.01, 1124.75, 1130.6899, 1146.1949, 1155.49, 1134.91, 1123.3, 1144.45, 1178.26, 1191.9399, 1184.48, 1182.61, 1177.421, 1185.87, 1196.17, 1213.15, 1202.825, 1187.04, 1176.72, 1159.37, 1159.431, 1162.88, 1182, 1185.71, 1200.5, 1204.13, 1205.03, 1199.86, 1193.08, 1196.4351, 1200.13, 1208.11, 1209.11, 1220.12, 1227.8199, 1234.61, 1228.3101, 1246.38, 1255, 1252.03, 1260.3199, 1266.295, 1175, 1167.1801, 1155.002, 1169, 1166.26, 1161.04, 1165.74, 1150.85, 1142.5, 1122.11, 1119.55, 1116.666, 1162.84, 1160.01, 1131.443, 1137.9399, 1145.89, 1129.224, 1131.66, 1133.12, 1108.22, 1112.12, 1100.1801, 1025, 1033.6899, 1030.49, 1033.7, 1048.4, 1072.322, 1077.603, 1067.54, 1080.15, 1080.172, 1086.28, 1098.99, 1093.48, 1104.74, 1108.08, 1111.01, 1083.8, 1072.24, 1075.29, 1073.37, 1093.703, 1098.17, 1113.86, 1116.14, 1111.21, 1107.17, 1130.97, 1139.58, 1138.78, 1139.4, 1145, 1145.77, 1132.73, 1129.62, 1124.24, 1131.8, 1126.99, 1120.92, 1224, 1228.23, 1223.3, 1207.764, 1205.72, 1188.9399, 1140.14, 1160, 1149.624, 1173.02, 1183.603, 1167.672, 1171.46, 1160.54, 1162.11, 1171.8101, 1190.09, 1182.11, 1187.4301, 1178.58, 1147.75, 1152.96, 1161.45, 1157.3, 1181.12, 1183.803, 1163.2, 1171, 1191.53, 1202.522, 1192.62, 1194.58, 1202.2, 1223.02, 1227.01, 1225.61, 1223.6899, 1216.53, 1232.02, 1223.08, 1224.17, 1210.6801, 1210.09, 1232.2679, 1214.45, 1212.3, 1203.58, 1171.29, 1162.4301, 1189.17, 1203.75, 1189.01, 1197.63, 1197.34, 1213.74, 1211.76, 1220.4, 1238.45, 1249.9399, 1241.08, 1240.6, 1241.38, 1242.36, 1253.715, 1250.01, 1272.54, 1257.212, 1252, 1250.843, 1260.5, 1276.355, 1291.229, 1282.5, 1294.245, 1304.365, 1297.41, 1295.77, 1293.51, 1295.65, 1314.28, 1317.5, 1312.8, 1291.15, 1293, 1291.41, 1298.13, 1305.09, 1309.63, 1303.97, 1281, 1279, 1304.87, 1316.4399, 1333.4399, 1337.84, 1336.04, 1342.67, 1340.5, 1343.87, 1352.67, 1351.323, 1351, 1348.985, 1349, 1346.51, 1342.78, 1344.47, 1349.3101, 1334.02, 1329.085, 1341.55, 1345.5439, 1350, 1390.38, 1390.84, 1410.27, 1418.35, 1426.02, 1428.37, 1430.21, 1440.92, 1458.22, 1471.2, 1484.9301, 1482.1, 1465.25, 1421.2, 1432.47, 1446.74, 1436.4, 1428.53, 1458.99, 1426.3, 1430.5601, 1449.5699, 1466.35, 1474.3199, 1505.6379, 1508.11, 1504.6, 1507.34, 1512.59, 1521.4, 1506.8199, 1480.4399, 1411.39, 1382.4, 1379, 1317.17, 1271, 1326.8149, 1332, 1343.11, 1305.1, 1261.05, 1200, 1218.77, 1196.0699, 1113.3, 1117.1429, 1074.4399, 1056.01, 1037.28, 1060.108, 1065.49, 1013.536, 1090.62, 1086.01, 1093.53, 1105.91, 1096.48, 1138.14, 1097.45, 1096.4, 1079.8101, 1130.9399, 1182.23, 1188.16, 1196.735, 1187.598, 1236.9301, 1240.4, 1242.62, 1271.23, 1261.37, 1209.71, 1242, 1265.67, 1249.45, 1269, 1232.2, 1325.34, 1322.49, 1311, 1299, 1337.46, 1347.29, 1355.27, 1375.48, 1377.152, 1374.77, 1328.4, 1323.91, 1339, 1354.25, 1373.485, 1387.25, 1393.45, 1391.83, 1412.13, 1391.29, 1396, 1413.35, 1418, 1418.83, 1429.777, 1404.73, 1406, 1422.34, 1443.21, 1456.27, 1402, 1386.02, 1387.92, 1425.9, 1431.38, 1427.01, 1421.35, 1423.21, 1445.24, 1429.75, 1420, 1351.99, 1347.01, 1383.96, 1409.8199, 1446.42, 1472.86, 1483.55, 1485.63, 1488.085, 1496.54, 1505.243, 1483.5, 1498, 1486.3101, 1498.42, 1503.6, 1554.28, 1546.1, 1507.392, 1488.4, 1515.21, 1497.66, 1501.33, 1492.22, 1454.03, 1465.64, 1458.65, 1463.46, 1466, 1481.64, 1473.079956, 1478, 1485.25, 1508.005005, 1502.880005, 1507.969971, 1523.709961, 1543.949951, 1538.2, 1568.005005, 1580.569946, 1582.069946, 1603.599976, 1625.75, 1630.75, 1630.310059, 1632.219971, 1666.329956, 1615.060059, 1547.613037, 1528.01001, 1536.051025, 1525.805054, 1497.359985, 1515.73999, 1531.834961, 1519.819946, 1470, 1437.130005, 1406.550049, 1434.530029, 1407.699951, 1409.849976, 1413.339966, 1449.301025, 1458.805054, 1459.880005, 1479.209961, 1450.920044, 1464.27002, 1448.589966, 1436, 1465.089966, 1489.449951, 1532.569946, 1563.199951, 1550.530029, 1545.030029, 1563, 1528, 1525.670044, 1571.630005, 1585, 1620.51001, 1576.5, 1582.780029, 1514.619995, 1522.23999, 1604.459961, 1616.030029, 1616.619995, 1706.030029, 1750.51001, 1740.349976, 1760.02002, 1717.300049, 1747.36499, 1745.599976, 1744.550049, 1767.689941, 1767, 1746.140015, 1737.005005, 1741.859985, 1717.719971, 1727.689941, 1756.540039, 1772.439941, 1755, 1769.369995, 1789.473022, 1822.650024, 1816.98999, 1805.780029, 1796.204956, 1767.810059, 1740.319946, 1760, 1757.214966, 1749.949951, 1756.079956, 1738.660034, 1720.219971, 1699, 1712.574951, 1725.040039, 1729.109985, 1746.334961, 1756.089966, 1725.599976, 1735.420044, 1707.849976, 1718.015015, 1699, 1737.050049, 1773.535034, 1760.52002, 1725.310059, 1738.01001, 1733.400024, 1721.550049, 1741.459961, 1825.530029, 1887.109985, 1881.76001, 1867.530029, 1884.244995, 1809, 1842.640015, 1810.199951, 1850.930054, 1914.48999, 2018.380005, 2042.589966, 2059.330078, 2072, 2078.540039, 2063.090088, 2077.320068, 2083.129883, 2104.360107, 2098.919922, 2103.709961, 2097.409912, 2062.139893, 2002.02002, 2038.130005, 2021.290039, 2016.060059, 2046.099976, 2071.26001, 2010, 2020.27002, 2046.415039, 2021.609985, 2047.829956, 2033.369995, 2072.379883, 2047.550049, 2043.51001, 2070, 2054, 2033.550049, 2017.680054, 2026.069946, 2039.219971, 2041.555054, 2010.72998, 2014.02002, 2015.619995, 2044.030029, 2056.745117, 2096.889893, 2151.620117, 2214.800049, 2225.330078, 2257.679932, 2253.714111, 2238.465088, 2256.090088, 2249.189941, 2266, 2284.45, 2287.85, 2271.71, 2258.57, 2256.45, 2278.21 ], "open": [ 716.1, 725.42, 707.29, 708.26, 690.7, 697.63, 696.87, 690.49, 697.7, 698.38, 712, 716.75, 723.41, 717.06, 711.93, 709.13, 715.99, 703.67, 702.36, 701.62, 706.53, 706.86, 720.76, 722.87, 724.01, 731.74, 734.53, 732.5, 729.27, 724.91, 719.84, 723.96, 722.87, 719.47, 716.51, 716.48, 719, 714.91, 708.65, 698.77, 698.4, 699.06, 697.45, 675.17, 671, 678.97, 683, 685.47, 692.2, 696.06, 689.98, 698.08, 699.5, 708.05, 719.12, 723.62, 721.58, 725.73, 722.71, 729.89, 737.33, 740.36, 741.86, 740.67, 739.04, 738.28, 747.04, 772.71, 761.09, 768.69, 767.18, 772.22, 773.78, 782, 781.1, 783.75, 785, 781.5, 783.75, 780.3, 777.32, 780.01, 775, 773.27, 775.48, 770.58, 767, 769, 768.74, 769.33, 767.01, 769.25, 773.01, 773.45, 780, 778.59, 770.1, 755.13, 764.48, 759.61, 762.89, 769.75, 772.42, 769, 772.66, 780, 786.59, 782.74, 775.5, 777.85, 781.44, 776.33, 774.25, 776.03, 779.31, 779, 779.66, 777.71, 786.66, 783.76, 781.22, 781.65, 779.8, 787.85, 798.24, 803.3, 795, 804.9, 816.68, 806.34, 801, 808.35, 795.47, 782.89, 778.2, 767.25, 750.66, 774.5, 783.4, 779.94, 791.17, 756.54, 755.6, 746.97, 755.2, 766.92, 771.37, 762.61, 772.63, 767.73, 764.26, 760, 771.53, 770.07, 757.44, 744.59, 757.71, 764.73, 761, 772.48, 780, 785.04, 793.9, 797.4, 797.34, 800.4, 790.22, 796.76, 795.84, 792.36, 790.9, 790.68, 793.7, 783.33, 782.75, 778.81, 788.36, 786.08, 795.26, 806.4, 807.86, 805, 807.14, 807.48, 807.08, 805.81, 805.12, 806.91, 807.25, 822.3, 829.62, 837.81, 834.71, 814.66, 796.86, 799.68, 793.8, 802.99, 799.7, 803.99, 807, 809.51, 811.7, 816, 819, 819.36, 819.93, 823.02, 828.66, 828.66, 830.12, 827.73, 824.55, 825.61, 828.85, 833.85, 830.56, 826.95, 827.4, 833.51, 836, 843.28, 844, 843.64, 847.59, 849.03, 851.61, 850.01, 851.4, 831.91, 821, 820.08, 806.95, 820.41, 825, 833.5, 828.97, 829.22, 831.36, 835.51, 832.4, 827.96, 825.39, 824.71, 821.93, 822.14, 825.01, 834.22, 839.79, 841.44, 842.88, 851.2, 865, 874.23, 873.6, 910.66, 901.94, 909.62, 914.86, 926.07, 933.54, 926.12, 936.95, 931.98, 925.32, 931.53, 932.95, 940, 935.67, 921, 931.47, 935, 947.92, 952.98, 957.33, 969.7, 970.31, 975.02, 968.95, 969.46, 976.55, 983.16, 980, 982.35, 984.5, 939.56, 951.91, 959.92, 933.97, 940, 949.96, 957.52, 953.64, 958.7, 956.83, 969.9, 942.46, 929, 929.92, 926.05, 912.18, 901.76, 904.12, 908.85, 921.77, 929.54, 938.68, 946.29, 952, 957, 953, 967.84, 975, 962.25, 972.22, 953.81, 954.68, 951.78, 929.4, 941.89, 932.38, 928.61, 930.34, 926.75, 929.06, 927.09, 920.61, 917.55, 907.97, 922.53, 924.23, 925.29, 925.78, 910.31, 910, 912.72, 921.93, 928.66, 923.49, 916, 905.1, 920.05, 931.76, 941.13, 933.08, 930.15, 931.73, 936.49, 934.25, 932.59, 930.66, 931.25, 924.66, 920.01, 917.42, 922.98, 933, 927.75, 925.45, 923.72, 927.74, 941.36, 952, 959.98, 954, 957, 955.49, 966.7, 980, 980, 973.72, 987.45, 992, 992.1, 990.29, 991.77, 986, 989.44, 989.52, 970, 968.37, 980, 1009.19, 1014, 1015.22, 1017.21, 1021.76, 1022.11, 1028.99, 1027.27, 1030.52, 1033.99, 1026.46, 1023.42, 1022.59, 1019.21, 1022.52, 1034.01, 1020.26, 1023.31, 1035, 1035.87, 1040, 1055.09, 1042.6801, 1022.37, 1015.8, 1012.66, 995.94, 1001.5, 1020.43, 1037.49, 1035.5, 1039.63, 1046.12, 1045, 1054.61, 1066.08, 1075.2, 1071.78, 1064.95, 1061.11, 1058.0699, 1057.39, 1051.6, 1046.72, 1048.34, 1064.3101, 1088, 1094, 1102.23, 1109.4, 1097.1, 1106.3, 1102.41, 1132.51, 1126.22, 1131.41, 1131.83, 1137.49, 1159.85, 1177.33, 1172.53, 1175.08, 1176.48, 1167.83, 1170.5699, 1162.61, 1122, 1090.6, 1027.1801, 1081.54, 1055.41, 1017.25, 1048, 1045, 1048.95, 1079.0699, 1088.41, 1090.5699, 1106.47, 1116.1899, 1112.64, 1127.8, 1141.24, 1123.03, 1107.87, 1053.08, 1075.14, 1099.22, 1089.1899, 1115.3199, 1136, 1163.85, 1170, 1145.21, 1149.96, 1154.14, 1120.01, 1099, 1092.74, 1081.88, 1047.03, 1046, 1063, 998, 1011.63, 1022.82, 1013.91, 993.41, 1041.33, 1020, 1016.8, 1026.4399, 1027.99, 1025.04, 1040.88, 1037, 1051.37, 1077.4301, 1069.4, 1082, 1077.86, 1052, 1025.52, 1029.51, 1046, 1030.01, 1013.66, 1028.1, 1019, 1016.9, 1049.23, 1058.54, 1058.1, 1086.03, 1093.6, 1100, 1090, 1077.3101, 1079.89, 1061.86, 1074.0601, 1083.5601, 1065.13, 1079, 1079.02, 1064.89, 1063.03, 1067.5601, 1099.35, 1122.33, 1140.99, 1142.17, 1131.3199, 1118.1801, 1118.6, 1131.0699, 1141.12, 1143.85, 1148.86, 1143.65, 1158.5, 1175.3101, 1174.85, 1159.14, 1143.6, 1128, 1121.34, 1102.09, 1120, 1099, 1135.8199, 1110.53, 1123.58, 1148.48, 1156.98, 1144.59, 1159.89, 1185, 1189.39, 1172.22, 1196.5601, 1191, 1186.96, 1181.01, 1262.59, 1239.13, 1251, 1271, 1228.01, 1220.01, 1228, 1205.9, 1229.62, 1225, 1237, 1240.47, 1249.9, 1243, 1236.98, 1235.1899, 1229.26, 1224.73, 1202.03, 1205.02, 1208, 1200, 1207.14, 1208.8199, 1227.6, 1241.29, 1237.45, 1244.23, 1234.98, 1204.27, 1193.8, 1186.3, 1158.67, 1172.1899, 1161.63, 1172.72, 1170.74, 1179.1, 1170.14, 1157.09, 1164.98, 1179.99, 1192, 1157.17, 1176.15, 1185.15, 1186.73, 1191.87, 1199.89, 1190.96, 1205, 1195.33, 1167.5, 1150.11, 1146.15, 1131.08, 1072.9399, 1108, 1108.91, 1104.59, 1126.46, 1121.84, 1093.37, 1103.0601, 1080.89, 1104.25, 1071.79, 1037.03, 1082.47, 1008.46, 1059.8101, 1075.8, 1073.73, 1055, 1039.48, 1069, 1091.38, 1073.99, 1061.39, 1043.29, 1050, 1044.71, 1059.41, 1057.2, 1000, 1036.76, 1030, 1038.35, 1041, 1048.76, 1076.08, 1089.0699, 1123.14, 1103.12, 1034.26, 1060.01, 1035.05, 1056.49, 1068, 1068.0699, 1049.98, 1037.51, 1026.09, 1033.99, 1018.13, 1015.3, 973.9, 989.01, 1017.15, 1049.62, 1050.96, 1016.57, 1041, 1032.59, 1071.5, 1076.11, 1081.65, 1067.66, 1063.1801, 1046.92, 1050.17, 1080, 1079.47, 1100, 1088, 1077.35, 1076.48, 1085, 1080.11, 1072.6801, 1068.4301, 1103, 1112.4, 1112.66, 1124.84, 1139.5699, 1104.16, 1087, 1096.95, 1106.8, 1124.99, 1118.05, 1130.08, 1110, 1119.99, 1110.84, 1100.9, 1116, 1105.75, 1106.95, 1111.3, 1124.9, 1146.99, 1150.0601, 1162.49, 1155.72, 1126.73, 1144.45, 1178.26, 1200.645, 1194.51, 1193.38, 1183.3, 1188.8101, 1197.35, 1216, 1226.3199, 1196.9301, 1198.53, 1185.5, 1171.54, 1174.9, 1184.1, 1195.3199, 1207.48, 1205.9399, 1214.99, 1207.89, 1196, 1200.6801, 1203.96, 1210, 1218, 1225, 1233, 1239.1801, 1235.99, 1250.6899, 1264.12, 1264.77, 1269, 1274, 1185, 1188.05, 1167.76, 1173.65, 1166.26, 1180.47, 1172.01, 1159.03, 1163.59, 1141.96, 1137.21, 1117.87, 1164.51, 1168.47, 1144.5, 1148.49, 1146.75, 1140.5, 1147.36, 1134, 1127.52, 1115.54, 1101.29, 1065.5, 1042.9, 1051.54, 1044.99, 1050.63, 1072.98, 1093.98, 1078, 1083.64, 1086.42, 1086.28, 1109.6899, 1105.6, 1119.99, 1109.24, 1119.61, 1112.66, 1086.5, 1084, 1076.39, 1098, 1102.24, 1117.41, 1117.8, 1125.17, 1111.8, 1131.22, 1143.25, 1143.99, 1146.86, 1146, 1150.97, 1141.74, 1148.1899, 1133.45, 1144, 1131.9, 1137.8199, 1224.04, 1241.05, 1225.41, 1223, 1214.03, 1200.74, 1170.04, 1163.3101, 1156, 1182.83, 1197.99, 1179.21, 1171.46, 1176.3101, 1163.5, 1179.55, 1190.09, 1195.25, 1193.15, 1194.0699, 1181.99, 1157.26, 1180.53, 1161.71, 1181.12, 1198.5, 1177.03, 1176.71, 1191.53, 1208.13, 1204, 1195.15, 1203.41, 1224.3, 1231.35, 1229.52, 1230.4, 1227.51, 1232.0601, 1233.12, 1226, 1240, 1215.8199, 1241.96, 1243.01, 1220.97, 1219, 1196.98, 1180, 1191.89, 1204.4, 1197.59, 1199.35, 1198.58, 1222.21, 1212.34, 1220.4, 1241.17, 1250.9301, 1253.46, 1252.26, 1247.85, 1242.36, 1260.9, 1251.03, 1275.45, 1276.23, 1252.97, 1261.28, 1265, 1276.45, 1292.89, 1289.46, 1294.28, 1305.28, 1303.1801, 1300, 1294.0699, 1297.5, 1318.9399, 1332.22, 1327.7, 1311.74, 1301.48, 1305.62, 1299.1801, 1309.86, 1315, 1307.12, 1301, 1279.5699, 1307.01, 1328, 1333.4399, 1338.04, 1341.5, 1350.84, 1345.9399, 1347.95, 1356.5, 1362.89, 1356.6, 1351.8199, 1363.35, 1355.87, 1348.5, 1346.17, 1362.99, 1350, 1330.11, 1341.55, 1347.86, 1350, 1397.9399, 1392.08, 1420.5699, 1427.5601, 1436.13, 1439.01, 1430.21, 1447.4399, 1462.91, 1479.12, 1491, 1487.64, 1493.59, 1431, 1443, 1458.8, 1439.96, 1468.9, 1462, 1457.0699, 1462.42, 1450.33, 1467.3, 1474.3199, 1511.8101, 1514.48, 1512.6899, 1515.6, 1515, 1525.0699, 1522, 1508.03, 1426.11, 1433, 1396.14, 1362.0601, 1277.5, 1351.61, 1399.42, 1359.23, 1350.2, 1277.0601, 1205.3, 1260, 1249.7, 1126, 1179, 1096, 1093.11, 1056.51, 1093.05, 1135.72, 1061.3199, 1103.77, 1126.47, 1111.8, 1125.67, 1125.04, 1147.3, 1122, 1098.26, 1119.015, 1138, 1221, 1206.5, 1224.08, 1209.1801, 1245.09, 1245.61, 1274.1, 1284.85, 1271, 1247, 1245.54, 1271.55, 1261.17, 1296, 1287.9301, 1341.46, 1324.88, 1328.5, 1308.23, 1337.92, 1361.6899, 1365.9399, 1383.13, 1378.28, 1407.12, 1377.05, 1335.02, 1350, 1361.75, 1386.9969, 1389.58, 1408, 1396.71, 1437.27, 1417.25, 1396.86, 1416.9399, 1418.39, 1430.55, 1438.3, 1430.4, 1413.17, 1422.34, 1445.36, 1459.54, 1442.48, 1428.49, 1390.8, 1445.22, 1447.16, 1449.16, 1444, 1429, 1455.64, 1461.51, 1429.9, 1431.39, 1358.1801, 1390.4399, 1411.1, 1446.9399, 1480.0601, 1490, 1494.3199, 1506.45, 1506.15, 1550, 1490.3101, 1523.13, 1500, 1521.62, 1515.26, 1586.99, 1560.5, 1566.97, 1498.9301, 1515.6, 1525.1801, 1506.3199, 1497, 1505.01, 1486.64, 1476.5699, 1469.3, 1471.75, 1500, 1487.180054, 1492.439941, 1485.579956, 1510.339966, 1515.660034, 1514.670044, 1526.180054, 1553.310059, 1543.45, 1577.030029, 1593.97998, 1582.069946, 1608, 1653.680054, 1633.48999, 1647.890015, 1636.630005, 1673.775024, 1709.713989, 1624.26001, 1533.51001, 1557.530029, 1560.640015, 1536, 1539.005005, 1536, 1555.540039, 1496, 1498.01001, 1440.060059, 1450.089966, 1458.780029, 1411.030029, 1432.630005, 1474.209961, 1470.390015, 1466.800049, 1484.27002, 1462.030029, 1466.209961, 1475.579956, 1464.290039, 1465.089966, 1494.699951, 1543, 1583.72998, 1578.589966, 1547.150024, 1565.849976, 1580.459961, 1527.050049, 1573.329956, 1593.050049, 1626.069946, 1625.01001, 1595.670044, 1559.73999, 1522.359985, 1672.109985, 1628.160034, 1631.780029, 1710.280029, 1781, 1753.949951, 1790.900024, 1731.089966, 1750, 1747.630005, 1757.630005, 1771.699951, 1776.939941, 1765.22998, 1738.380005, 1765.209961, 1749.599976, 1730.5, 1772.890015, 1773.089966, 1781.18396, 1774.369995, 1798.099976, 1824.01001, 1824.52002, 1819, 1810.099976, 1812.01001, 1769.800049, 1763.060059, 1775, 1764.420044, 1772.880005, 1768.51001, 1754.180054, 1713.51001, 1734.430054, 1728.109985, 1735, 1751.63501, 1787.790039, 1762.01001, 1735.420044, 1757.540039, 1725, 1702.630005, 1740.060059, 1787.97998, 1786.069946, 1753.920044, 1738.579956, 1753.619995, 1738.189941, 1752.25, 1831.459961, 1898, 1895.680054, 1920.670044, 1888.839966, 1882.530029, 1843.939941, 1846.170044, 1853.569946, 1922.560059, 2073, 2068.889893, 2070, 2105.909912, 2078.540039, 2094.209961, 2099.51001, 2090.25, 2104.360107, 2100, 2110.389893, 2119.27002, 2067, 2025.01001, 2041.829956, 2067.449951, 2050.52002, 2056.52002, 2076.189941, 2067.209961, 2023.369995, 2073.120117, 2101.129883, 2070, 2071.76001, 2074.060059, 2085, 2062.300049, 2078.98999, 2076.030029, 2061, 2042.050049, 2041.839966, 2051.699951, 2065.370117, 2044.810059, 2038.859985, 2027.880005, 2057.629883, 2059.120117, 2097.949951, 2152.939941, 2222.5, 2226.129883, 2277.959961, 2256.699951, 2266.25, 2261.469971, 2275.159912, 2276.98, 2303, 2291.98, 2307.89, 2285.25, 2293.23, 2283.47 ], "type": "candlestick", "x": [ "2016-04-25", "2016-04-26", "2016-04-27", "2016-04-28", "2016-04-29", "2016-05-02", "2016-05-03", "2016-05-04", "2016-05-05", "2016-05-06", "2016-05-09", "2016-05-10", "2016-05-11", "2016-05-12", "2016-05-13", "2016-05-16", "2016-05-17", "2016-05-18", "2016-05-19", "2016-05-20", "2016-05-23", "2016-05-24", "2016-05-25", "2016-05-26", "2016-05-27", "2016-05-31", "2016-06-01", "2016-06-02", "2016-06-03", "2016-06-06", "2016-06-07", "2016-06-08", "2016-06-09", "2016-06-10", "2016-06-13", "2016-06-14", "2016-06-15", "2016-06-16", "2016-06-17", "2016-06-20", "2016-06-21", "2016-06-22", "2016-06-23", "2016-06-24", "2016-06-27", "2016-06-28", "2016-06-29", "2016-06-30", "2016-07-01", "2016-07-05", "2016-07-06", "2016-07-07", "2016-07-08", "2016-07-11", "2016-07-12", "2016-07-13", "2016-07-14", "2016-07-15", "2016-07-18", "2016-07-19", "2016-07-20", "2016-07-21", "2016-07-22", "2016-07-25", "2016-07-26", "2016-07-27", "2016-07-28", "2016-07-29", "2016-08-01", "2016-08-02", "2016-08-03", "2016-08-04", "2016-08-05", "2016-08-08", "2016-08-09", "2016-08-10", "2016-08-11", "2016-08-12", "2016-08-15", "2016-08-16", "2016-08-17", "2016-08-18", "2016-08-19", "2016-08-22", "2016-08-23", "2016-08-24", "2016-08-25", "2016-08-26", "2016-08-29", "2016-08-30", "2016-08-31", "2016-09-01", "2016-09-02", "2016-09-06", "2016-09-07", "2016-09-08", "2016-09-09", "2016-09-12", "2016-09-13", "2016-09-14", "2016-09-15", "2016-09-16", "2016-09-19", "2016-09-20", "2016-09-21", "2016-09-22", "2016-09-23", "2016-09-26", "2016-09-27", "2016-09-28", "2016-09-29", "2016-09-30", "2016-10-03", "2016-10-04", "2016-10-05", "2016-10-06", "2016-10-07", "2016-10-10", "2016-10-11", "2016-10-12", "2016-10-13", "2016-10-14", "2016-10-17", "2016-10-18", "2016-10-19", "2016-10-20", "2016-10-21", "2016-10-24", "2016-10-25", "2016-10-26", "2016-10-27", "2016-10-28", "2016-10-31", "2016-11-01", "2016-11-02", "2016-11-03", "2016-11-04", "2016-11-07", "2016-11-08", "2016-11-09", "2016-11-10", "2016-11-11", "2016-11-14", "2016-11-15", "2016-11-16", "2016-11-17", "2016-11-18", "2016-11-21", "2016-11-22", "2016-11-23", "2016-11-25", "2016-11-28", "2016-11-29", "2016-11-30", "2016-12-01", "2016-12-02", "2016-12-05", "2016-12-06", "2016-12-07", "2016-12-08", "2016-12-09", "2016-12-12", "2016-12-13", "2016-12-14", "2016-12-15", "2016-12-16", "2016-12-19", "2016-12-20", "2016-12-21", "2016-12-22", "2016-12-23", "2016-12-27", "2016-12-28", "2016-12-29", "2016-12-30", "2017-01-03", "2017-01-04", "2017-01-05", "2017-01-06", "2017-01-09", "2017-01-10", "2017-01-11", "2017-01-12", "2017-01-13", "2017-01-17", "2017-01-18", "2017-01-19", "2017-01-20", "2017-01-23", "2017-01-24", "2017-01-25", "2017-01-26", "2017-01-27", "2017-01-30", "2017-01-31", "2017-02-01", "2017-02-02", "2017-02-03", "2017-02-06", "2017-02-07", "2017-02-08", "2017-02-09", "2017-02-10", "2017-02-13", "2017-02-14", "2017-02-15", "2017-02-16", "2017-02-17", "2017-02-21", "2017-02-22", "2017-02-23", "2017-02-24", "2017-02-27", "2017-02-28", "2017-03-01", "2017-03-02", "2017-03-03", "2017-03-06", "2017-03-07", "2017-03-08", "2017-03-09", "2017-03-10", "2017-03-13", "2017-03-14", "2017-03-15", "2017-03-16", "2017-03-17", "2017-03-20", "2017-03-21", "2017-03-22", "2017-03-23", "2017-03-24", "2017-03-27", "2017-03-28", "2017-03-29", "2017-03-30", "2017-03-31", "2017-04-03", "2017-04-04", "2017-04-05", "2017-04-06", "2017-04-07", "2017-04-10", "2017-04-11", "2017-04-12", "2017-04-13", "2017-04-17", "2017-04-18", "2017-04-19", "2017-04-20", "2017-04-21", "2017-04-24", "2017-04-25", "2017-04-26", "2017-04-27", "2017-04-28", "2017-05-01", "2017-05-02", "2017-05-03", "2017-05-04", "2017-05-05", "2017-05-08", "2017-05-09", "2017-05-10", "2017-05-11", "2017-05-12", "2017-05-15", "2017-05-16", "2017-05-17", "2017-05-18", "2017-05-19", "2017-05-22", "2017-05-23", "2017-05-24", "2017-05-25", "2017-05-26", "2017-05-30", "2017-05-31", "2017-06-01", "2017-06-02", "2017-06-05", "2017-06-06", "2017-06-07", "2017-06-08", "2017-06-09", "2017-06-12", "2017-06-13", "2017-06-14", "2017-06-15", "2017-06-16", "2017-06-19", "2017-06-20", "2017-06-21", "2017-06-22", "2017-06-23", "2017-06-26", "2017-06-27", "2017-06-28", "2017-06-29", "2017-06-30", "2017-07-03", "2017-07-05", "2017-07-06", "2017-07-07", "2017-07-10", "2017-07-11", "2017-07-12", "2017-07-13", "2017-07-14", "2017-07-17", "2017-07-18", "2017-07-19", "2017-07-20", "2017-07-21", "2017-07-24", "2017-07-25", "2017-07-26", "2017-07-27", "2017-07-28", "2017-07-31", "2017-08-01", "2017-08-02", "2017-08-03", "2017-08-04", "2017-08-07", "2017-08-08", "2017-08-09", "2017-08-10", "2017-08-11", "2017-08-14", "2017-08-15", "2017-08-16", "2017-08-17", "2017-08-18", "2017-08-21", "2017-08-22", "2017-08-23", "2017-08-24", "2017-08-25", "2017-08-28", "2017-08-29", "2017-08-30", "2017-08-31", "2017-09-01", "2017-09-05", "2017-09-06", "2017-09-07", "2017-09-08", "2017-09-11", "2017-09-12", "2017-09-13", "2017-09-14", "2017-09-15", "2017-09-18", "2017-09-19", "2017-09-20", "2017-09-21", "2017-09-22", "2017-09-25", "2017-09-26", "2017-09-27", "2017-09-28", "2017-09-29", "2017-10-02", "2017-10-03", "2017-10-04", "2017-10-05", "2017-10-06", "2017-10-09", "2017-10-10", "2017-10-11", "2017-10-12", "2017-10-13", "2017-10-16", "2017-10-17", "2017-10-18", "2017-10-19", "2017-10-20", "2017-10-23", "2017-10-24", "2017-10-25", "2017-10-26", "2017-10-27", "2017-10-30", "2017-10-31", "2017-11-01", "2017-11-02", "2017-11-03", "2017-11-06", "2017-11-07", "2017-11-08", "2017-11-09", "2017-11-10", "2017-11-13", "2017-11-14", "2017-11-15", "2017-11-16", "2017-11-17", "2017-11-20", "2017-11-21", "2017-11-22", "2017-11-24", "2017-11-27", "2017-11-28", "2017-11-29", "2017-11-30", "2017-12-01", "2017-12-04", "2017-12-05", "2017-12-06", "2017-12-07", "2017-12-08", "2017-12-11", "2017-12-12", "2017-12-13", "2017-12-14", "2017-12-15", "2017-12-18", "2017-12-19", "2017-12-20", "2017-12-21", "2017-12-22", "2017-12-26", "2017-12-27", "2017-12-28", "2017-12-29", "2018-01-02", "2018-01-03", "2018-01-04", "2018-01-05", "2018-01-08", "2018-01-09", "2018-01-10", "2018-01-11", "2018-01-12", "2018-01-16", "2018-01-17", "2018-01-18", "2018-01-19", "2018-01-22", "2018-01-23", "2018-01-24", "2018-01-25", "2018-01-26", "2018-01-29", "2018-01-30", "2018-01-31", "2018-02-01", "2018-02-02", "2018-02-05", "2018-02-06", "2018-02-07", "2018-02-08", "2018-02-09", "2018-02-12", "2018-02-13", "2018-02-14", "2018-02-15", "2018-02-16", "2018-02-20", "2018-02-21", "2018-02-22", "2018-02-23", "2018-02-26", "2018-02-27", "2018-02-28", "2018-03-01", "2018-03-02", "2018-03-05", "2018-03-06", "2018-03-07", "2018-03-08", "2018-03-09", "2018-03-12", "2018-03-13", "2018-03-14", "2018-03-15", "2018-03-16", "2018-03-19", "2018-03-20", "2018-03-21", "2018-03-22", "2018-03-23", "2018-03-26", "2018-03-27", "2018-03-28", "2018-03-29", "2018-04-02", "2018-04-03", "2018-04-04", "2018-04-05", "2018-04-06", "2018-04-09", "2018-04-10", "2018-04-11", "2018-04-12", "2018-04-13", "2018-04-16", "2018-04-17", "2018-04-18", "2018-04-19", "2018-04-20", "2018-04-23", "2018-04-24", "2018-04-25", "2018-04-26", "2018-04-27", "2018-04-30", "2018-05-01", "2018-05-02", "2018-05-03", "2018-05-04", "2018-05-07", "2018-05-08", "2018-05-09", "2018-05-10", "2018-05-11", "2018-05-14", "2018-05-15", "2018-05-16", "2018-05-17", "2018-05-18", "2018-05-21", "2018-05-22", "2018-05-23", "2018-05-24", "2018-05-25", "2018-05-29", "2018-05-30", "2018-05-31", "2018-06-01", "2018-06-04", "2018-06-05", "2018-06-06", "2018-06-07", "2018-06-08", "2018-06-11", "2018-06-12", "2018-06-13", "2018-06-14", "2018-06-15", "2018-06-18", "2018-06-19", "2018-06-20", "2018-06-21", "2018-06-22", "2018-06-25", "2018-06-26", "2018-06-27", "2018-06-28", "2018-06-29", "2018-07-02", "2018-07-03", "2018-07-05", "2018-07-06", "2018-07-09", "2018-07-10", "2018-07-11", "2018-07-12", "2018-07-13", "2018-07-16", "2018-07-17", "2018-07-18", "2018-07-19", "2018-07-20", "2018-07-23", "2018-07-24", "2018-07-25", "2018-07-26", "2018-07-27", "2018-07-30", "2018-07-31", "2018-08-01", "2018-08-02", "2018-08-03", "2018-08-06", "2018-08-07", "2018-08-08", "2018-08-09", "2018-08-10", "2018-08-13", "2018-08-14", "2018-08-15", "2018-08-16", "2018-08-17", "2018-08-20", "2018-08-21", "2018-08-22", "2018-08-23", "2018-08-24", "2018-08-27", "2018-08-28", "2018-08-29", "2018-08-30", "2018-08-31", "2018-09-04", "2018-09-05", "2018-09-06", "2018-09-07", "2018-09-10", "2018-09-11", "2018-09-12", "2018-09-13", "2018-09-14", "2018-09-17", "2018-09-18", "2018-09-19", "2018-09-20", "2018-09-21", "2018-09-24", "2018-09-25", "2018-09-26", "2018-09-27", "2018-09-28", "2018-10-01", "2018-10-02", "2018-10-03", "2018-10-04", "2018-10-05", "2018-10-08", "2018-10-09", "2018-10-10", "2018-10-11", "2018-10-12", "2018-10-15", "2018-10-16", "2018-10-17", "2018-10-18", "2018-10-19", "2018-10-22", "2018-10-23", "2018-10-24", "2018-10-25", "2018-10-26", "2018-10-29", "2018-10-30", "2018-10-31", "2018-11-01", "2018-11-02", "2018-11-05", "2018-11-06", "2018-11-07", "2018-11-08", "2018-11-09", "2018-11-12", "2018-11-13", "2018-11-14", "2018-11-15", "2018-11-16", "2018-11-19", "2018-11-20", "2018-11-21", "2018-11-23", "2018-11-26", "2018-11-27", "2018-11-28", "2018-11-29", "2018-11-30", "2018-12-03", "2018-12-04", "2018-12-06", "2018-12-07", "2018-12-10", "2018-12-11", "2018-12-12", "2018-12-13", "2018-12-14", "2018-12-17", "2018-12-18", "2018-12-19", "2018-12-20", "2018-12-21", "2018-12-24", "2018-12-26", "2018-12-27", "2018-12-28", "2018-12-31", "2019-01-02", "2019-01-03", "2019-01-04", "2019-01-07", "2019-01-08", "2019-01-09", "2019-01-10", "2019-01-11", "2019-01-14", "2019-01-15", "2019-01-16", "2019-01-17", "2019-01-18", "2019-01-22", "2019-01-23", "2019-01-24", "2019-01-25", "2019-01-28", "2019-01-29", "2019-01-30", "2019-01-31", "2019-02-01", "2019-02-04", "2019-02-05", "2019-02-06", "2019-02-07", "2019-02-08", "2019-02-11", "2019-02-12", "2019-02-13", "2019-02-14", "2019-02-15", "2019-02-19", "2019-02-20", "2019-02-21", "2019-02-22", "2019-02-25", "2019-02-26", "2019-02-27", "2019-02-28", "2019-03-01", "2019-03-04", "2019-03-05", "2019-03-06", "2019-03-07", "2019-03-08", "2019-03-11", "2019-03-12", "2019-03-13", "2019-03-14", "2019-03-15", "2019-03-18", "2019-03-19", "2019-03-20", "2019-03-21", "2019-03-22", "2019-03-25", "2019-03-26", "2019-03-27", "2019-03-28", "2019-03-29", "2019-04-01", "2019-04-02", "2019-04-03", "2019-04-04", "2019-04-05", "2019-04-08", "2019-04-09", "2019-04-10", "2019-04-11", "2019-04-12", "2019-04-15", "2019-04-16", "2019-04-17", "2019-04-18", "2019-04-22", "2019-04-23", "2019-04-24", "2019-04-25", "2019-04-26", "2019-04-29", "2019-04-30", "2019-05-01", "2019-05-02", "2019-05-03", "2019-05-06", "2019-05-07", "2019-05-08", "2019-05-09", "2019-05-10", "2019-05-13", "2019-05-14", "2019-05-15", "2019-05-16", "2019-05-17", "2019-05-20", "2019-05-21", "2019-05-22", "2019-05-23", "2019-05-24", "2019-05-28", "2019-05-29", "2019-05-30", "2019-05-31", "2019-06-03", "2019-06-04", "2019-06-05", "2019-06-06", "2019-06-07", "2019-06-10", "2019-06-11", "2019-06-12", "2019-06-13", "2019-06-14", "2019-06-17", "2019-06-18", "2019-06-19", "2019-06-20", "2019-06-21", "2019-06-24", "2019-06-25", "2019-06-26", "2019-06-27", "2019-06-28", "2019-07-01", "2019-07-02", "2019-07-03", "2019-07-05", "2019-07-08", "2019-07-09", "2019-07-10", "2019-07-11", "2019-07-12", "2019-07-15", "2019-07-16", "2019-07-17", "2019-07-18", "2019-07-19", "2019-07-22", "2019-07-23", "2019-07-24", "2019-07-25", "2019-07-26", "2019-07-29", "2019-07-30", "2019-07-31", "2019-08-01", "2019-08-02", "2019-08-05", "2019-08-06", "2019-08-07", "2019-08-08", "2019-08-09", "2019-08-12", "2019-08-13", "2019-08-14", "2019-08-15", "2019-08-16", "2019-08-19", "2019-08-20", "2019-08-21", "2019-08-22", "2019-08-23", "2019-08-26", "2019-08-27", "2019-08-28", "2019-08-29", "2019-08-30", "2019-09-03", "2019-09-04", "2019-09-05", "2019-09-06", "2019-09-09", "2019-09-10", "2019-09-11", "2019-09-12", "2019-09-13", "2019-09-16", "2019-09-17", "2019-09-18", "2019-09-19", "2019-09-20", "2019-09-23", "2019-09-24", "2019-09-25", "2019-09-26", "2019-09-27", "2019-09-30", "2019-10-01", "2019-10-02", "2019-10-03", "2019-10-04", "2019-10-07", "2019-10-08", "2019-10-09", "2019-10-10", "2019-10-11", "2019-10-14", "2019-10-15", "2019-10-16", "2019-10-17", "2019-10-18", "2019-10-21", "2019-10-22", "2019-10-23", "2019-10-24", "2019-10-25", "2019-10-28", "2019-10-29", "2019-10-30", "2019-10-31", "2019-11-01", "2019-11-04", "2019-11-05", "2019-11-06", "2019-11-07", "2019-11-08", "2019-11-11", "2019-11-12", "2019-11-13", "2019-11-14", "2019-11-15", "2019-11-18", "2019-11-19", "2019-11-20", "2019-11-21", "2019-11-22", "2019-11-25", "2019-11-26", "2019-11-27", "2019-11-29", "2019-12-02", "2019-12-03", "2019-12-04", "2019-12-05", "2019-12-06", "2019-12-09", "2019-12-10", "2019-12-11", "2019-12-12", "2019-12-13", "2019-12-16", "2019-12-17", "2019-12-18", "2019-12-19", "2019-12-20", "2019-12-23", "2019-12-24", "2019-12-26", "2019-12-27", "2019-12-30", "2019-12-31", "2020-01-02", "2020-01-03", "2020-01-06", "2020-01-07", "2020-01-08", "2020-01-09", "2020-01-10", "2020-01-13", "2020-01-14", "2020-01-15", "2020-01-16", "2020-01-17", "2020-01-21", "2020-01-22", "2020-01-23", "2020-01-24", "2020-01-27", "2020-01-28", "2020-01-29", "2020-01-30", "2020-01-31", "2020-02-03", "2020-02-04", "2020-02-05", "2020-02-06", "2020-02-07", "2020-02-10", "2020-02-11", "2020-02-12", "2020-02-13", "2020-02-14", "2020-02-18", "2020-02-19", "2020-02-20", "2020-02-21", "2020-02-24", "2020-02-25", "2020-02-26", "2020-02-27", "2020-02-28", "2020-03-02", "2020-03-03", "2020-03-04", "2020-03-05", "2020-03-06", "2020-03-09", "2020-03-10", "2020-03-11", "2020-03-12", "2020-03-13", "2020-03-16", "2020-03-17", "2020-03-18", "2020-03-19", "2020-03-20", "2020-03-23", "2020-03-24", "2020-03-25", "2020-03-26", "2020-03-27", "2020-03-30", "2020-03-31", "2020-04-01", "2020-04-02", "2020-04-03", "2020-04-06", "2020-04-07", "2020-04-08", "2020-04-09", "2020-04-13", "2020-04-14", "2020-04-15", "2020-04-16", "2020-04-17", "2020-04-20", "2020-04-21", "2020-04-22", "2020-04-23", "2020-04-24", "2020-04-27", "2020-04-28", "2020-04-29", "2020-04-30", "2020-05-01", "2020-05-04", "2020-05-05", "2020-05-06", "2020-05-07", "2020-05-08", "2020-05-11", "2020-05-12", "2020-05-13", "2020-05-14", "2020-05-15", "2020-05-18", "2020-05-19", "2020-05-20", "2020-05-21", "2020-05-22", "2020-05-26", "2020-05-27", "2020-05-28", "2020-05-29", "2020-06-01", "2020-06-02", "2020-06-03", "2020-06-04", "2020-06-05", "2020-06-08", "2020-06-09", "2020-06-10", "2020-06-11", "2020-06-12", "2020-06-15", "2020-06-16", "2020-06-17", "2020-06-18", "2020-06-19", "2020-06-22", "2020-06-23", "2020-06-24", "2020-06-25", "2020-06-26", "2020-06-29", "2020-06-30", "2020-07-01", "2020-07-02", "2020-07-06", "2020-07-07", "2020-07-08", "2020-07-09", "2020-07-10", "2020-07-13", "2020-07-14", "2020-07-15", "2020-07-16", "2020-07-17", "2020-07-20", "2020-07-21", "2020-07-22", "2020-07-23", "2020-07-24", "2020-07-27", "2020-07-28", "2020-07-29", "2020-07-30", "2020-07-31", "2020-08-03", "2020-08-04", "2020-08-05", "2020-08-06", "2020-08-07", "2020-08-10", "2020-08-11", "2020-08-12", "2020-08-13", "2020-08-14", "2020-08-17", "2020-08-18", "2020-08-19", "2020-08-20", "2020-08-21", "2020-08-24", "2020-08-25", "2020-08-26", "2020-08-27", "2020-08-28", "2020-08-31", "2020-09-01", "2020-09-02", "2020-09-03", "2020-09-04", "2020-09-08", "2020-09-09", "2020-09-10", "2020-09-11", "2020-09-14", "2020-09-15", "2020-09-16", "2020-09-17", "2020-09-18", "2020-09-21", "2020-09-22", "2020-09-23", "2020-09-24", "2020-09-25", "2020-09-28", "2020-09-29", "2020-09-30", "2020-10-01", "2020-10-02", "2020-10-05", "2020-10-06", "2020-10-07", "2020-10-08", "2020-10-09", "2020-10-12", "2020-10-13", "2020-10-14", "2020-10-15", "2020-10-16", "2020-10-19", "2020-10-20", "2020-10-21", "2020-10-22", "2020-10-23", "2020-10-26", "2020-10-27", "2020-10-28", "2020-10-29", "2020-10-30", "2020-11-02", "2020-11-03", "2020-11-04", "2020-11-05", "2020-11-06", "2020-11-09", "2020-11-10", "2020-11-11", "2020-11-12", "2020-11-13", "2020-11-16", "2020-11-17", "2020-11-18", "2020-11-19", "2020-11-20", "2020-11-23", "2020-11-24", "2020-11-25", "2020-11-27", "2020-11-30", "2020-12-01", "2020-12-02", "2020-12-03", "2020-12-04", "2020-12-07", "2020-12-08", "2020-12-09", "2020-12-10", "2020-12-11", "2020-12-14", "2020-12-15", "2020-12-16", "2020-12-17", "2020-12-18", "2020-12-21", "2020-12-22", "2020-12-23", "2020-12-24", "2020-12-28", "2020-12-29", "2020-12-30", "2020-12-31", "2021-01-04", "2021-01-05", "2021-01-06", "2021-01-07", "2021-01-08", "2021-01-11", "2021-01-12", "2021-01-13", "2021-01-14", "2021-01-15", "2021-01-19", "2021-01-20", "2021-01-21", "2021-01-22", "2021-01-25", "2021-01-26", "2021-01-27", "2021-01-28", "2021-01-29", "2021-02-01", "2021-02-02", "2021-02-03", "2021-02-04", "2021-02-05", "2021-02-08", "2021-02-09", "2021-02-10", "2021-02-11", "2021-02-12", "2021-02-16", "2021-02-17", "2021-02-18", "2021-02-19", "2021-02-22", "2021-02-23", "2021-02-24", "2021-02-25", "2021-02-26", "2021-03-01", "2021-03-02", "2021-03-03", "2021-03-04", "2021-03-05", "2021-03-08", "2021-03-09", "2021-03-10", "2021-03-11", "2021-03-12", "2021-03-15", "2021-03-16", "2021-03-17", "2021-03-18", "2021-03-19", "2021-03-22", "2021-03-23", "2021-03-24", "2021-03-25", "2021-03-26", "2021-03-29", "2021-03-30", "2021-03-31", "2021-04-01", "2021-04-05", "2021-04-06", "2021-04-07", "2021-04-08", "2021-04-09", "2021-04-12", "2021-04-13", "2021-04-14", "2021-04-15", "2021-04-16", "2021-04-19", "2021-04-20", "2021-04-21", "2021-04-22", "2021-04-23" ] } ], "layout": { "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "scatter": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "sequentialminus": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "zerolinecolor": "white", "zerolinewidth": 2 } } } } }, "text/html": [ "
\n", " \n", " \n", "
\n", " \n", "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "historical_prices(history)" ] }, { "cell_type": "code", "execution_count": 690, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "0 0.12770532012826136\n", "1 0.1830008989979462\n", "2 0.23421586757475982\n", "Revenue variation of the last year: 12.77 %\n" ] } ], "source": [ "count = 0\n", "#get revenue growth to estimate future sales\n", "revenue_g = []\n", "for item in IS:\n", " if count < 4:\n", " #print(item)\n", " revenue_g.append(item['revenue'])\n", " count = count + 1\n", "for i in range(len(revenue_g)-1):\n", " print(i,(revenue_g[i] - revenue_g[i+1]) /revenue_g[i+1])\n", "\n", "revenue_g = (revenue_g[timeframe] - revenue_g[timeframe+1]) /revenue_g[timeframe+1] \n", "print('Revenue variation of the last year:',round(revenue_g*100,2),'%')" ] }, { "cell_type": "code", "execution_count": 691, "metadata": { "scrolled": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/share/apps/gnu/8.2.0/soft/python-3.5.7/lib/python3.5/site-packages/ipykernel_launcher.py:14: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame\n", "\n", "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " \n" ] } ], "source": [ "income_statement = income_perc_years_ahead(IS,timeframe, y_ahead, revenue_g)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 692, "metadata": { "scrolled": true }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/share/apps/gnu/8.2.0/soft/python-3.5.7/lib/python3.5/site-packages/ipykernel_launcher.py:9: SettingWithCopyWarning: \n", "A value is trying to be set on a copy of a slice from a DataFrame\n", "\n", "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n", " if __name__ == '__main__':\n" ] } ], "source": [ "balance_sheet=balance_perc_years_ahead(BS,timeframe, income_statement, y_ahead)" ] }, { "cell_type": "code", "execution_count": 598, "metadata": {}, "outputs": [], "source": [ "#balance_sheet\n", "#income_statement" ] }, { "cell_type": "code", "execution_count": 693, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
next1yearnext2yearnext3yearnext4yearnext5year
CAPEX27,828,487,609.4331,382,333,528.2835,390,024,477.8839,909,518,883.1845,006,176,768.32
CF_operations43,773,617,100.2849,363,740,885.2455,667,753,217.7262,776,821,463.2170,793,755,544.81
FCF71,602,104,709.7180,746,074,413.5291,057,777,695.60102,686,340,346.39115,799,932,313.12
inc_depreciation1,749,179,769.801,972,559,332.262,224,465,653.262,508,541,751.622,828,895,879.07
inc_inventory92,969,473.05104,842,169.37118,231,072.17133,329,809.10150,356,735.05
inc_payables713,745,034.20804,894,072.28907,683,327.451,023,599,317.361,154,318,395.86
inc_receivables4,007,903,766.914,519,734,400.505,096,928,529.015,747,833,418.486,481,862,325.23
netIncome45,411,565,536.2451,210,864,050.5857,750,763,838.2065,125,843,621.8173,442,760,330.16
\n", "
" ], "text/plain": [ " next1year next2year next3year \\\n", "CAPEX 27,828,487,609.43 31,382,333,528.28 35,390,024,477.88 \n", "CF_operations 43,773,617,100.28 49,363,740,885.24 55,667,753,217.72 \n", "FCF 71,602,104,709.71 80,746,074,413.52 91,057,777,695.60 \n", "inc_depreciation 1,749,179,769.80 1,972,559,332.26 2,224,465,653.26 \n", "inc_inventory 92,969,473.05 104,842,169.37 118,231,072.17 \n", "inc_payables 713,745,034.20 804,894,072.28 907,683,327.45 \n", "inc_receivables 4,007,903,766.91 4,519,734,400.50 5,096,928,529.01 \n", "netIncome 45,411,565,536.24 51,210,864,050.58 57,750,763,838.20 \n", "\n", " next4year next5year \n", "CAPEX 39,909,518,883.18 45,006,176,768.32 \n", "CF_operations 62,776,821,463.21 70,793,755,544.81 \n", "FCF 102,686,340,346.39 115,799,932,313.12 \n", "inc_depreciation 2,508,541,751.62 2,828,895,879.07 \n", "inc_inventory 133,329,809.10 150,356,735.05 \n", "inc_payables 1,023,599,317.36 1,154,318,395.86 \n", "inc_receivables 5,747,833,418.48 6,481,862,325.23 \n", "netIncome 65,125,843,621.81 73,442,760,330.16 " ] }, "execution_count": 693, "metadata": {}, "output_type": "execute_result" } ], "source": [ "CF_forecast = CF_forecast_perc_years_ahead(income_statement, balance_sheet, y_ahead)\n", "CF_forecast" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## WACC" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Functions" ] }, { "cell_type": "code", "execution_count": 576, "metadata": {}, "outputs": [], "source": [ "#Interest coverage ratio = EBIT / interest expenses\n", "\n", "def interest_coverage_and_RF(IS,timeframe, st_date=[]):\n", " EBIT= IS[timeframe]['ebitda'] - IS[timeframe]['depreciationAndAmortization'] \n", " interest_expense = IS[timeframe]['interestExpense']\n", " interest_coverage_ratio = EBIT / interest_expense\n", "\n", " #RF\n", " start = datetime.datetime(st_date[0], st_date[1], st_date[2])\n", "\n", " #end= datetime.datetime.today().strftime('%Y-%m-%d')\n", " end= datetime.datetime(st_date[0]+1, st_date[1], st_date[2]).strftime('%Y-%m-%d')\n", " \n", " Treasury = web.DataReader(['TB1YR'], 'fred', start, end)\n", " \n", " RF = float(Treasury.iloc[-1])\n", " RF = RF/100\n", " \n", " return [RF,interest_coverage_ratio]" ] }, { "cell_type": "code", "execution_count": 577, "metadata": {}, "outputs": [], "source": [ "#Cost of debt\n", "def cost_of_debt(RF,interest_coverage_ratio):\n", " if interest_coverage_ratio > 8.5:\n", " #Rating is AAA\n", " credit_spread = 0.0063\n", " if (interest_coverage_ratio > 6.5) & (interest_coverage_ratio <= 8.5):\n", " #Rating is AA\n", " credit_spread = 0.0078\n", " if (interest_coverage_ratio > 5.5) & (interest_coverage_ratio <= 6.5):\n", " #Rating is A+\n", " credit_spread = 0.0098\n", " if (interest_coverage_ratio > 4.25) & (interest_coverage_ratio <= 5.49):\n", " #Rating is A\n", " credit_spread = 0.0108\n", " if (interest_coverage_ratio > 3) & (interest_coverage_ratio <= 4.25):\n", " #Rating is A-\n", " credit_spread = 0.0122\n", " if (interest_coverage_ratio > 2.5) & (interest_coverage_ratio <= 3):\n", " #Rating is BBB\n", " credit_spread = 0.0156\n", " if (interest_coverage_ratio > 2.25) & (interest_coverage_ratio <= 2.5):\n", " #Rating is BB+\n", " credit_spread = 0.02\n", " if (interest_coverage_ratio > 2) & (interest_coverage_ratio <= 2.25):\n", " #Rating is BB\n", " credit_spread = 0.0240\n", " if (interest_coverage_ratio > 1.75) & (interest_coverage_ratio <= 2):\n", " #Rating is B+\n", " credit_spread = 0.0351\n", " if (interest_coverage_ratio > 1.5) & (interest_coverage_ratio <= 1.75):\n", " #Rating is B\n", " credit_spread = 0.0421\n", " if (interest_coverage_ratio > 1.25) & (interest_coverage_ratio <= 1.5):\n", " #Rating is B-\n", " credit_spread = 0.0515\n", " if (interest_coverage_ratio > 0.8) & (interest_coverage_ratio <= 1.25):\n", " #Rating is CCC\n", " credit_spread = 0.0820\n", " if (interest_coverage_ratio > 0.65) & (interest_coverage_ratio <= 0.8):\n", " #Rating is CC\n", " credit_spread = 0.0864\n", " if (interest_coverage_ratio > 0.2) & (interest_coverage_ratio <= 0.65):\n", " #Rating is C\n", " credit_spread = 0.1134\n", " if interest_coverage_ratio <= 0.2:\n", " #Rating is D\n", " credit_spread = 0.1512\n", "\n", " cost_of_debt = RF + credit_spread\n", " \n", " return cost_of_debt" ] }, { "cell_type": "code", "execution_count": 615, "metadata": {}, "outputs": [], "source": [ "def costofequity(company, profile, RF, st_date=[]):\n", "\n", "\n", " #Start end dates\n", " start = datetime.datetime(st_date[0], st_date[1], st_date[2])\n", " #end= datetime.datetime.today().strftime('%Y-%m-%d')\n", " end= datetime.datetime(st_date[0]+1, st_date[1], st_date[2]).strftime('%Y-%m-%d')\n", "\n", "#Beta\n", "\n", " beta = float(profile['profile']['beta'])\n", " stock_cur = float(profile['profile']['price'])\n", "\n", " #Market Return\n", " SP500 = web.DataReader(['sp500'], 'fred', start, end)\n", " #Drop all Not a number values using drop method.\n", " SP500.dropna(inplace = True)\n", "\n", " SP500yearlyreturn = (SP500['sp500'].iloc[-1]/ SP500['sp500'].iloc[-252])-1\n", " \n", " cost_of_equity = RF+(beta*(SP500yearlyreturn - RF))\n", " \n", " return cost_of_equity, stock_cur" ] }, { "cell_type": "code", "execution_count": 613, "metadata": {}, "outputs": [], "source": [ "#effective tax rate and capital structure\n", "def wacc(company, BS, FR, timeframe, ke, kd):\n", "\n", " ETR = FR[timeframe]['effectiveTaxRate']\n", "\n", "# \n", " Debt_to = BS[timeframe]['totalDebt'] / (BS[timeframe]['totalDebt'] + BS[timeframe]['totalStockholdersEquity'])\n", " equity_to = BS[timeframe]['totalStockholdersEquity'] / (BS[timeframe]['totalDebt'] + BS[timeframe]['totalStockholdersEquity'])\n", "\n", " WACC = (kd*(1-ETR)*Debt_to) + (ke*equity_to)\n", " \n", " return WACC" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Calculations" ] }, { "cell_type": "code", "execution_count": 694, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "wacc of GOOG is 4.980497654294513%\n" ] } ], "source": [ "RF_and_IntCov = interest_coverage_and_RF(IS,timeframe, st_date=date_start) \n", "RF = RF_and_IntCov[0]\n", "interest_coverage_ratio = RF_and_IntCov[1]\n", "ke, stock_cur = costofequity(company, profile, RF, st_date=date_start)\n", "kd = cost_of_debt(RF,interest_coverage_ratio)\n", "wacc_company = wacc(company, BS, FR, timeframe, ke, kd)\n", "print('wacc of ' + company + ' is ' + str((wacc_company*100))+'%')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Net Present Value of the Forecasted Free Cash Flows" ] }, { "cell_type": "code", "execution_count": 695, "metadata": {}, "outputs": [], "source": [ "#FCF List of CFs for each year\n", "FCF_List = CF_forecast.loc[['FCF']].values[0].tolist()\n", "npv = np.npv(wacc_company,FCF_List)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Terminal Value" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "The net present value obtained in the section F covers only the next 5 years of the company cash flows. But what happen after these forecasted years?\n", "\n", "We need to calculate the terminal value of the company. The terminal value captures the value of the company after the forecasting period. The terminal value will constitute at least 50% of the forecasted value. Therefore, it is super important to pay attention to the assumptions that we make here. \n", "\n", "We will assume 2% perpetuity rate since it is a common practice to be in line with the long-term inflation rate which is usually around 2%. Then, we discount the value using the WACC rate." ] }, { "cell_type": "code", "execution_count": 696, "metadata": {}, "outputs": [], "source": [ "#Terminal value\n", "LTGrowth = 0.02\n", "\n", "Terminal_value = (CF_forecast['next'+str(y_ahead)+'year']['FCF'] * (1+ LTGrowth)) /(wacc_company - LTGrowth)\n", "\n", "Terminal_value_Discounted = Terminal_value/(1+wacc_company)**4\n", "#Terminal_value_Discounted" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Target Price" ] }, { "cell_type": "code", "execution_count": 697, "metadata": {}, "outputs": [], "source": [ "target_equity_value = Terminal_value_Discounted + npv\n", "debt = balance_sheet['current_year']['totalDebt']\n", "target_value = target_equity_value - debt\n", "numbre_of_shares = requests.get('https://financialmodelingprep.com/api/v3/enterprise-values/'+company+'?apikey='+demo).json()\n", "numbre_of_shares = numbre_of_shares[0]['numberOfShares']\n", "\n", "target_price_per_share = target_value/numbre_of_shares\n", "#target_price_per_share" ] }, { "cell_type": "code", "execution_count": 698, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "GOOG current price per stock is 2300.01\n", "GOOG forecasted price per stock is 5272.227316237697\n", "The forecast is based on the following assumptions:\n", " Revenue growth: 12.77 %\n", " Cost of Capital: 4.98 %\n", " Perpetuity growth: 2.0 %\n" ] } ], "source": [ "print(company + ' current price per stock is ' + str(stock_cur) )\n", "print(company + ' forecasted price per stock is ' + str(target_price_per_share) )\n", "print('The forecast is based on the following assumptions:')\n", "print(' Revenue growth: ',round(revenue_g*100,2),'%')\n", "print(' Cost of Capital: ', round(wacc_company*100,2),'%' )\n", "print(' Perpetuity growth: ', round(LTGrowth*100,2),'%')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "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.5.7" } }, "nbformat": 4, "nbformat_minor": 2 }