Spreadsheet: 741504d1627067701-help-with-formula-to-find-duplicates-within-30-days-and-populate-data-if-true-wash-trade-formula-help
Sheet: Stocks

STOCK LOG SHEET
 |  |  |  |  |  |  |  |  |  |  |  | % Loss
 |  |  |  |  |  |  |  |  |  |  |  | Tolerance |  | Target ROI |  |  |  |  |  | Default Fee
 |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  | 0.1 |  |  |  |  | 0.02
Date Bought | Symbol | [NAME]? | Loss Carried Over | Price Target | Shares Bought | $ / Share | Purchase Price | Buy Commission | Adj  $ / Share | [NAME] Adj $ / Share | Adj Purchase Price | Loss $ / Share  (Inc Fees) | Break Even  (Inc Fees) | Midpoint         $ / Share | Target            $ / Share | Sell Price / Share | Sell Commission | Sell Total       (No Fees) | Profit / Loss  ($) (No fees) | Regulatory Fee | Sell Total           (Inc Fees) | Date Sold | Profit / Loss  ($) (Incl fees) | Profit / Loss (%) (Inc Fees)
2021-03-29 00:00:00 | UPC |  |  |  | 20 | 11.489 |  | 0 |  |  |  |  |  |  |  | 7.9015 |  |  |  | 0 |  | 2021-03-29 00:00:00
2021-03-29 00:00:00 | CYAN |  |  |  | 100 | 5.3881 |  | 0 |  |  |  |  |  |  |  | 5.86 |  |  |  | 0.01 |  | 2021-03-29 00:00:00
2021-03-29 00:00:00 | SEAC |  |  |  | 50 | 1.46 |  | 0 |  |  |  |  |  |  |  | 1.6701 |  |  |  | 0.01 |  | 2021-03-29 00:00:00
2021-03-30 00:00:00 | CSCW |  |  |  | 100 | 2.24 |  | 0 |  |  |  |  |  |  |  | 2.45 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-30 00:00:00 | MBRX |  |  |  | 100 | 4.55 |  | 0 |  |  |  |  |  |  |  | 4.52 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-30 00:00:00 | VTSI |  |  |  | 100 | 7.57 |  | 0 |  |  |  |  |  |  |  | 8.33 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-30 00:00:00 | MBRX | Yes | $3.01 (from X12) |  | 100 | 4.3499 |  | 0 |  | I can create this formula.  It will calcualte a new share price based on current price and carried over loss. |  |  |  |  |  | 4.2 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-30 00:00:00 | GNUS |  |  |  | 100 | 2.1 |  | 0 |  |  |  |  |  |  |  | 2 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-30 00:00:00 | MBRX | Yes | $18.01 (from D14 & X14) |  | 100 | 4.5399 |  | 0 |  |  |  |  |  |  |  | 3.67
2021-03-30 00:00:00 | OCGN |  |  |  | 100 | 6.4187 |  | 0 |  |  |  |  |  |  |  | 6.79 |  |  |  | 0.01 |  | 2021-03-30 00:00:00
2021-03-31 00:00:00 | RAIL |  |  |  | 100 | 6.0974 |  | 0 |  |  |  |  |  |  |  | 6.24 |  |  |  | 0.01 |  | 2021-03-31 00:00:00
2021-03-31 00:00:00 | RAIL |  |  |  | 100 | 6.7398 |  | 0 |  |  |  |  |  |  |  | 7.25 |  |  |  | 0.01 |  | 2021-04-06 00:00:00
2021-03-31 00:00:00 | MARK |  |  |  | 100 | 2.32 |  | 0 |  |  |  |  |  |  |  | 1.86
2021-04-01 00:00:00 | EBON |  |  |  | 100 | 7.1499 |  | 0 |  |  |  |  |  |  |  | 3.08
2021-04-01 00:00:00 | WIMI |  |  |  | 14 | 6.79 |  | 0 |  |  |  |  |  |  |  | 5.49
2021-04-01 00:00:00 | WIMI |  |  |  | 86 | 6.7986 |  | 0 |  |  |  |  |  |  |  | 5.49
2021-04-01 00:00:00 | IDEX |  |  |  | 100 | 3.35 |  | 0 |  |  |  |  |  |  |  | 2.84
2021-04-01 00:00:00 | HOFV |  |  |  | 100 | 5.1385 |  | 0 |  |  |  |  |  |  |  | 3.93
2021-04-01 00:00:00 | UPC | Yes | $71.75 (from X8) |  | 100 | 6.05 |  | 0 |  |  |  |  |  |  |  | 3.17
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0