Scrape Data from FanDuel with vba

date,short term debt/assets,acts rec/pay,long term assets/debt,total net worth,short term liquidity,,,,,,,,,
41911,-2100,2650,-450,100,=C2+B2,,,,,,,,,
41912,-2254,2747.16666666667,-357.219999999999,135.946666666668,=C3+B3,,,,,,,,,
41913,-435,14,595,174,=C4+B4,,,,,,,,,
41914,-475,114,595,274,=C5+B5,,,,,,,,,
41915,-500,222,595,317,=C6+B6,,,,,,,,,
41916,-550,333,595,378,=C7+B7,,,,,,,,,
41917,-600,443,595,438,=C8+B8,,,,,,,,,
41918,-761,518.616666666667,687.02,444.636666666668,=C9+B9,,,,,,,,,
41919,-776.48,610.66,577.89,412.070000000001,=C10+B10,,,,,,,,,
41920,-796.43,708.943333333333,675.68,588.193333333332,=C11+B11,,,,,,,,,
41921,-812.2,807.226666666667,577.47,572.496666666667,=C12+B12,,,,,,,,,
41922,-850,860,370,380,=C13+B13,,,,,,,,,
41923,-850,860,370,380,=C14+B14,,,,,,,,,
41924,-850,860,370,380,=C15+B15,,,,,,,,,
41925,-900,1200,320,620,=C16+B16,,,,,,,,,
41926,-1080.2,1351.87333333333,364.41,636.083333333333,=C17+B17,,,,,,,,,
41927,-969.34,1272.15666666667,434.860000000001,737.676666666667,=C18+B18,,,,,,,,,
41928,-1024.84,1370.44,445.35,790.950000000001,=C19+B19,,,,,,,,,
41929,-1087.59,1468.72333333333,421,802.133333333333,=C20+B20,,,,,,,,,
41930,-1087.59,1468.72333333333,421,802.133333333333,=C21+B21,,,,,,,,,
41931,-1087.59,1468.72333333333,421,802.133333333333,=C22+B22,,,,,,,,,
41932,-1288.52,1763.57333333333,461,936.053333333334,=C23+B23,,,,,,,,,
41933,-1402.4,1869.17,508.7,975.470000000001,=C24+B24,,,,,,,,,
41934,-1413.85,1965.28666666667,482.73,1034.16666666667,=C25+B25,,,,,,,,,
41935,-1436,2083.40333333333,535,1182.40333333333,=C26+B26,,,,,,,,,
41936,-1454.25,2179.52,542.910000000001,1268.18,=C27+B27,,,,,,,,,
41937,-1454.25,2179.52,542.910000000001,1268.18,=C28+B28,,,,,,,,,
41938,-1454.25,2179.52,542.910000000001,1268.18,=C29+B29,,,,,,,,,
41939,-1629.8,2467.87,647.900000000001,1485.97,=C30+B30,,,,,,,,,
41940,-1629.8,2467.87,647.900000000001,1485.97,=C31+B31,,,,,,,,,
41941,-1745.05,2672.83333333333,744.75,1672.53333333333,=C32+B32,,,,,,,,,
41942,-1751.05,2666.94139784946,752.79,1668.68139784946,=C33+B33,,,,,,,,,
41943,2270.83,-1398.13333333333,909.32,1782.01666666667,=C34+B34,,,,,,,,,
41944,-377.95,-398.133333333333,2559.32,1783.23666666667,=C35+B35,,,,,,,,,
41945,=IF(TODAY()=A36,personal_finance!$I$2,B35),=IF(TODAY()=A36,personal_finance!$I$3,C35),=IF(TODAY()=A36,personal_finance!$I$4,D35),=IF(TODAY()=A36,personal_finance!$I$5,E35),=C36+B36,,,,,,,,,
41946,-551,-117.271075268817,2622.01,1953.73892473118,=C37+B37,,,,,,,,,
41947,-654.19,1.36967741935496,2578.82,1925.99967741936,=C38+B38,,,,,,,,,
41948,-639.99,69.2304301075271,2555.13,1984.37043010753,=C39+B39,,,,,,,,,
41949,-691.56,212.591182795699,2581.16,2102.1911827957,=C40+B40,,,,,,,,,
41950,-699.06,305.451935483871,2564.27,2170.66193548387,=C41+B41,,,,,,,,,
41951,-699.06,305.451935483871,2564.27,2170.66193548387,=C42+B42,,,,,,,,,
41952,-699.06,305.451935483871,2564.27,2170.66193548387,=C43+B43,,,,,,,,,
41953,-842.27,573.934193548387,2654.37,2386.03419354839,=C44+B44,,,,,,,,,
41954,-854.07,674.474946236559,2657.05,2477.45494623656,=C45+B45,,,,,,,,,
41955,-926.07,774.835698924731,2647.65,2496.41569892473,=C46+B46,,,,,,,,,
41956,-945.54,874.196451612903,2607.62,2536.2764516129,=C47+B47,,,,,,,,,
41957,-908.8,887.557204301075,2621.63,2600.38720430108,=C48+B48,,,,,,,,,
41958,=IF(TODAY()=A49,personal_finance!$I$2,B48),=IF(TODAY()=A49,personal_finance!$I$3,C48),=IF(TODAY()=A49,personal_finance!$I$4,D48),=IF(TODAY()=A49,personal_finance!$I$5,E48),=C49+B49,,,,,,,,,
41959,=IF(TODAY()=A50,personal_finance!$I$2,B49),=IF(TODAY()=A50,personal_finance!$I$3,C49),=IF(TODAY()=A50,personal_finance!$I$4,D49),=IF(TODAY()=A50,personal_finance!$I$5,E49),=C50+B50,,,,,,,,,
41960,-1070.56,1156.26946236559,2622.18,2707.88946236559,=C51+B51,,,,,,,,,
41961,-1170.4,1245.03021505376,2654.35,2728.98021505376,=C52+B52,,,,,,,,,
41962,-1193.6,1337.89096774194,2661.19,2805.48096774194,=C53+B53,,,,,,,,,
41963,-1197.9,1430.75172043011,2692.55,2925.40172043011,=C54+B54,,,,,,,,,
41964,-1187.77,1523.61247311828,2698.55,3034.39247311828,=C55+B55,,,,,,,,,
41965,=IF(TODAY()=A56,personal_finance!$I$2,B55),=IF(TODAY()=A56,personal_finance!$I$3,C55),=IF(TODAY()=A56,personal_finance!$I$4,D55),=IF(TODAY()=A56,personal_finance!$I$5,E55),=C56+B56,,,,,,,,,
41966,=IF(TODAY()=A57,personal_finance!$I$2,B56),=IF(TODAY()=A57,personal_finance!$I$3,C56),=IF(TODAY()=A57,personal_finance!$I$4,D56),=IF(TODAY()=A57,personal_finance!$I$5,E56),=C57+B57,,,,,,,,,
41967,-1382.52,1802.1947311828,2743.45,3163.1247311828,=C58+B58,,,,,,,,,
41968,=IF(TODAY()=A59,personal_finance!$I$2,B58),=IF(TODAY()=A59,personal_finance!$I$3,C58),=IF(TODAY()=A59,personal_finance!$I$4,D58),=IF(TODAY()=A59,personal_finance!$I$5,E58),=C59+B59,,,,,,,,,
41969,906,-1194,4478.65,4190,=C60+B60,,,,,,,,,
41970,666.082,-1044.2123655914,4454.392,4075.6116344086,=C61+B61,,,,,,,,,
41971,426.164,-894.424731182796,4430.134,3961.2232688172,=C62+B62,,,,,,,,,
41972,186.246,-744.637096774194,4405.876,3846.83490322581,=C63+B63,,,,,,,,,
41973,-53.6720000000001,-594.849462365592,4381.618,3732.44653763441,=C64+B64,,,,,,,,,
41974,-294,-445,4357.36,3618,=C65+B65,,,,,,,,,
41975,-317.8,-346.908494623656,4372.11,3707.40150537635,=C66+B66,,,,,,,,,
41976,-456.27,-248.881075268817,4502.86,3797.70892473118,=C67+B67,,,,,,,,,
41977,-479.27,-150.353655913979,4496.71,3867.08634408602,-629.623655913978,,,,,,,,,
41978,-502.57,-51.8262365591396,4479.87,3925.47376344086,=C69+B69,,,,,,,,,
41979,-502.57,-51.8262365591396,4479.87,3925.47376344086,-554.39623655914,,,,,,,,,
41980,-502.57,-51.8262365591396,4479.87,3925.47376344086,-554.39623655914,,,,,,,,,
41981,-840.56,243.756021505376,4404.79,3807.98602150537,-596.803978494624,,,,,,,,,
41982,-889.26,333.283440860215,4439.67,3883.69344086022,-555.976559139785,,,,,,,,,
41983,-896.71,430.810860215054,4368.71,3902.81086021505,=C74+B74,,,,,,,,,
41984,-979.46,528.338279569892,4312.17,3861.04827956989,=C75+B75,,,,,,,,,
41985,-1010.06,625.865698924731,4210.47,3826.27569892473,-384.194301075269,,,,,,,,,
41986,=IF(TODAY()=A77,personal_finance!$I$2,B76),=IF(TODAY()=A77,personal_finance!$I$3,C76),=IF(TODAY()=A77,personal_finance!$I$4,D76),=IF(TODAY()=A77,personal_finance!$I$5,E76),=C77+B77,,,,,,,,,
41987,=IF(TODAY()=A78,personal_finance!$I$2,B77),=IF(TODAY()=A78,personal_finance!$I$3,C77),=IF(TODAY()=A78,personal_finance!$I$4,D77),=IF(TODAY()=A78,personal_finance!$I$5,E77),=C78+B78,,,,,,,,,
41988,-1147.34,730.777956989247,4208.17,3791.60795698925,-416.562043010753,,,,,,,,,
41989,-1210.69,936.475376344086,4189.57,3915.35537634409,-274.214623655914,,,,,,,,,
41990,=IF(TODAY()=A81,personal_finance!$I$2,B80),=IF(TODAY()=A81,personal_finance!$I$3,C80),=IF(TODAY()=A81,personal_finance!$I$4,D80),=IF(TODAY()=A81,personal_finance!$I$5,E80),=C81+B81,,,,,,,,,
41991,=IF(TODAY()=A82,personal_finance!$I$2,B81),=IF(TODAY()=A82,personal_finance!$I$3,C81),=IF(TODAY()=A82,personal_finance!$I$4,D81),=IF(TODAY()=A82,personal_finance!$I$5,E81),=C82+B82,,,,,,,,,
41992,=IF(TODAY()=A83,personal_finance!$I$2,B82),=IF(TODAY()=A83,personal_finance!$I$3,C82),=IF(TODAY()=A83,personal_finance!$I$4,D82),=IF(TODAY()=A83,personal_finance!$I$5,E82),=C83+B83,,,,,,,,,
41993,=IF(TODAY()=A84,personal_finance!$I$2,B83),=IF(TODAY()=A84,personal_finance!$I$3,C83),=IF(TODAY()=A84,personal_finance!$I$4,D83),=IF(TODAY()=A84,personal_finance!$I$5,E83),=C84+B84,,,,,,,,,
41994,=IF(TODAY()=A85,personal_finance!$I$2,B84),=IF(TODAY()=A85,personal_finance!$I$3,C84),=IF(TODAY()=A85,personal_finance!$I$4,D84),=IF(TODAY()=A85,personal_finance!$I$5,E84),=C85+B85,,,,,,,,,
41995,=IF(TODAY()=A86,personal_finance!$I$2,B85),=IF(TODAY()=A86,personal_finance!$I$3,C85),=IF(TODAY()=A86,personal_finance!$I$4,D85),=IF(TODAY()=A86,personal_finance!$I$5,E85),=C86+B86,,,,,,,,,
41996,=IF(TODAY()=A87,personal_finance!$I$2,B86),=IF(TODAY()=A87,personal_finance!$I$3,C86),=IF(TODAY()=A87,personal_finance!$I$4,D86),=IF(TODAY()=A87,personal_finance!$I$5,E86),=C87+B87,,,,,,,,,
41997,=IF(TODAY()=A88,personal_finance!$I$2,B87),=IF(TODAY()=A88,personal_finance!$I$3,C87),=IF(TODAY()=A88,personal_finance!$I$4,D87),=IF(TODAY()=A88,personal_finance!$I$5,E87),=C88+B88,,,,,,,,,
41998,=IF(TODAY()=A89,personal_finance!$I$2,B88),=IF(TODAY()=A89,personal_finance!$I$3,C88),=IF(TODAY()=A89,personal_finance!$I$4,D88),=IF(TODAY()=A89,personal_finance!$I$5,E88),=C89+B89,,,,,,,,,
41999,=IF(TODAY()=A90,personal_finance!$I$2,B89),=IF(TODAY()=A90,personal_finance!$I$3,C89),=IF(TODAY()=A90,personal_finance!$I$4,D89),=IF(TODAY()=A90,personal_finance!$I$5,E89),=C90+B90,,,,,,,,,
42000,=IF(TODAY()=A91,personal_finance!$I$2,B90),=IF(TODAY()=A91,personal_finance!$I$3,C90),=IF(TODAY()=A91,personal_finance!$I$4,D90),=IF(TODAY()=A91,personal_finance!$I$5,E90),=C91+B91,,,,,,,,,
42001,=IF(TODAY()=A92,personal_finance!$I$2,B91),=IF(TODAY()=A92,personal_finance!$I$3,C91),=IF(TODAY()=A92,personal_finance!$I$4,D91),=IF(TODAY()=A92,personal_finance!$I$5,E91),=C92+B92,,,,,,,,,
42002,=IF(TODAY()=A93,personal_finance!$I$2,B92),=IF(TODAY()=A93,personal_finance!$I$3,C92),=IF(TODAY()=A93,personal_finance!$I$4,D92),=IF(TODAY()=A93,personal_finance!$I$5,E92),=C93+B93,,,,,,,,,
42003,=IF(TODAY()=A94,personal_finance!$I$2,B93),=IF(TODAY()=A94,personal_finance!$I$3,C93),=IF(TODAY()=A94,personal_finance!$I$4,D93),=IF(TODAY()=A94,personal_finance!$I$5,E93),=C94+B94,,,,,,,,,
42004,=IF(TODAY()=A95,personal_finance!$I$2,B94),=IF(TODAY()=A95,personal_finance!$I$3,C94),=IF(TODAY()=A95,personal_finance!$I$4,D94),=IF(TODAY()=A95,personal_finance!$I$5,E94),=C95+B95,,,,,,,,,
/r/dfsports Thread