I need the formulas for the last column, please! I am having a lot of trouble. Could you explain why to use the formula?
Stock FHS JUS NIK WES QQS POP ODB DCB WDB LCP Purchase Date 12/25/18 7/20/18 10/15/18 4/20/10 7/31/12 5/14/19 2/5/15 4/21/17 5/14/19 5/5/19 Shares Purchased 100 200 300 150 200 250 300 350 400 200 Basis per Share $ 15.55 $ 18.22 $ 21.21 $ 36.77 $ 12.21 $ 23.08 $ 5.69 $ 7.24 $ 8.99 $ 22.03 Shares Sold 72 139 252 140 200 231 244 322 350 125 6/1/2019 Sale Price | Gain/(Loss) Gain/(Loss) per Share per share in total $ 9.79 $ (5.76) $ (414.72) $ 10.93 $ (7.29) S (1,013.31) $ 18.45 $ (2.76) $ (695.52)| $ 23.53 $ (13.24) S (1,853.60) $ 15.14 $ 2.93S 586.00 $ 33.46 $ 10.38 $ 2,397.78 $ 6.65 $ 0.96 $ 234.24 $ 9.19 $ 1.95S 627.90 $ 7.37 $ (1.62) S (567.00) $ 18.72 $ (3.31) S (413.75) Shares Purchased 291 167 330 266 60 220 92 350 174 100 6/14/2019 Purchase Price Dissallowed loss in total per Share from 6/1/2019 sale $ 9.20 $ 11.69 $ 18.08 $ 25.88 $ 14.23 $ 35.47 $ 5.99 $ 9.19 S 7.37 $ 18.91 NOW UEL BULLI UOMO you have two seperate categories of shares: those remaining from the original purchase and those from the June 14th purchase Share Purchased 291 6/14/2019 Purchase Price Dissallowed loss in local per Share from 612019 sale $ 9.2011 11.69 167 Stock FHS JUS NIK WES QOS POP ODB DCB WDB LCP Purchase Date 1225/18 7/20/18 10/15/18 4/20/10 781/12 5/14/19 2/5/15 421/17 5/14/19 19 Shares Purchased 100 200 300 150 200 250 300 350 400 200 6/1/2019 Sale Basis Share Price Gain Loss) Gain Loss) per Share Sold per Share per share $ 15.55 72 $ 9.795 (5.76) S (414.72) $ 18.22 139 S 10.93 S (7.29) S (1,01331) S 21.21252 IS 18.45 S (2.76S (695.52) $ 36.77 140 $ 23.53 $ (13.24) S (1,853.60) $ 12.21 200 $ 15.14 $ 293 | S 586.00 S 23 08 231 S 33.46 S 10.38 $ 2.397.78 $ 5.69 244 $ 665 $ 0.96 $ 214 24 $ 724 322 $ 9.19 $ 1.95 $ 627.90 $ 8.99 350 S 737S (1.62) $ (567.00) $ 22.03 125 S 18.72 S (331) S (413.75) 330 266 60 220 350 174 Wash Sale Exercise Stock FHS JUS NIK WES QQS POP ODB DCB WDB LCP Purchase Date 12/25/18 7/20/18 10/15/18 4/20/10 7/31/12 5/14/19 2/5/15 4/21/17 5/14/19 5/5/19 Shares Purchased 100 200 300 150 200 250 300 350 400 200 Basis per Share $ 15.55 $ 18.22 $ 21.21 $ 36.77 $ 12.21 $ 23.08 $ 5.69 $ 7.24 $ 8.99 $ 22.03 Shares Sold 72 139 252 140 200 231 244 322 350 125 6/1/2019 Sale Price | Gain/(Loss) Gain/(Loss) per Share per share in total $ 9.79 $ (5.76) $ (414.72) $ 10.93 $ (7.29) S (1,013.31) $ 18.45 $ (2.76) $ (695.52)| $ 23.53 $ (13.24) S (1,853.60) $ 15.14 $ 2.93S 586.00 $ 33.46 $ 10.38 $ 2,397.78 $ 6.65 $ 0.96 $ 234.24 $ 9.19 $ 1.95S 627.90 $ 7.37 $ (1.62) S (567.00) $ 18.72 $ (3.31) S (413.75) Shares Purchased 291 167 330 266 60 220 92 350 174 100 6/14/2019 Purchase Price Dissallowed loss in total per Share from 6/1/2019 sale $ 9.20 $ 11.69 $ 18.08 $ 25.88 $ 14.23 $ 35.47 $ 5.99 $ 9.19 S 7.37 $ 18.91 NOW UEL BULLI UOMO you have two seperate categories of shares: those remaining from the original purchase and those from the June 14th purchase Share Purchased 291 6/14/2019 Purchase Price Dissallowed loss in local per Share from 612019 sale $ 9.2011 11.69 167 Stock FHS JUS NIK WES QOS POP ODB DCB WDB LCP Purchase Date 1225/18 7/20/18 10/15/18 4/20/10 781/12 5/14/19 2/5/15 421/17 5/14/19 19 Shares Purchased 100 200 300 150 200 250 300 350 400 200 6/1/2019 Sale Basis Share Price Gain Loss) Gain Loss) per Share Sold per Share per share $ 15.55 72 $ 9.795 (5.76) S (414.72) $ 18.22 139 S 10.93 S (7.29) S (1,01331) S 21.21252 IS 18.45 S (2.76S (695.52) $ 36.77 140 $ 23.53 $ (13.24) S (1,853.60) $ 12.21 200 $ 15.14 $ 293 | S 586.00 S 23 08 231 S 33.46 S 10.38 $ 2.397.78 $ 5.69 244 $ 665 $ 0.96 $ 214 24 $ 724 322 $ 9.19 $ 1.95 $ 627.90 $ 8.99 350 S 737S (1.62) $ (567.00) $ 22.03 125 S 18.72 S (331) S (413.75) 330 266 60 220 350 174 Wash Sale Exercise