Spreadsheet: 857374d1706391249-match-buy-and-sell-orders-journalsample
Sheet: Sheet7

Raw Data to Calculate from |  |  |  |  |  |  |  |  |  |  |  | SAMPLE: Correct Answers to solve for |  | [NAME]
Ticker | Exchange | Side | Type | Qty | Price | Fill Price | Status | Commission | Placing Time | Closing Time | Order id | Fill Price 1 | Closing Time 1 | Fill Price 2 | Closing Time 3
IVP | NASDAQ | Sell | Market | 60 000 | 0.4027 | 0.4027 | Filled |  | 2024-01-26 10:06:03 | 2024-01-26 10:06:04 | 1145031799
IVP | NASDAQ | Buy | Market | 20 000 | 0.4299 | 0.4299 | Filled |  | 2024-01-26 10:02:08 | 2024-01-26 10:02:09 | 1145016967 | 0.4027 | 2024-01-26 10:06:04
CRBP | NASDAQ | Sell | Market | 530 | 20.71 | 20.71 | Filled |  | 2024-01-26 09:57:55 | 2024-01-26 09:57:55 | 1144999721
CRBP | NASDAQ | Buy | Market | 530 | 20.4 | 20.4 | Filled |  | 2024-01-26 09:57:40 | 2024-01-26 09:57:40 | 1144998892 | 20.71 | 2024-01-26 09:57:55
CRBP | NASDAQ | Sell | Market | 530 | 19.54 | 19.54 | Filled |  | 2024-01-26 09:56:46 | 2024-01-26 09:56:46 | 1144996259
IVP | NASDAQ | Buy | Market | 20 000 | 0.4073 | 0.4073 | Filled |  | 2024-01-26 09:54:35 | 2024-01-26 09:54:35 | 1144988442 | 0.4027 | 2024-01-26 10:06:04
CRBP | NASDAQ | Buy | Market | 530 | 17.9 | 17.9 | Filled |  | 2024-01-26 09:47:15 | 2024-01-26 09:47:15 | 1144962262 | 19.54 | 2024-01-26 09:56:46
CRBP | NASDAQ | Sell | Market | 530 | 17.2 | 17.2 | Filled |  | 2024-01-26 09:43:19 | 2024-01-26 09:43:19 | 1144948827
IVP | NASDAQ | Buy | Market | 20 000 | 0.4983 | 0.4983 | Filled |  | 2024-01-26 09:42:51 | 2024-01-26 09:42:51 | 1144947265 | 0.4027 | 2024-01-26 10:06:04
CRBP | NASDAQ | Buy | Market | 530 | 18.46 | 18.46 | Filled |  | 2024-01-26 09:40:11 | 2024-01-26 09:40:11 | 1144937306 | 17.2 | 2024-01-26 09:43:19
PBLA | NASDAQ | Sell | Market | 1 900 | 4.72 | 4.72 | Filled |  | 2024-01-26 09:38:03 | 2024-01-26 09:38:03 | 1144928497
PBLA | NASDAQ | Buy | Market | 1 900 | 5.3 | 5.3 | Filled |  | 2024-01-26 09:36:16 | 2024-01-26 09:36:16 | 1144921151 | 4.72 | 2024-01-26 09:38:03
VERA | NASDAQ | Sell | Market | 400 | 25.42 | 25.42 | Filled |  | 2024-01-25 14:14:45 | 2024-01-25 14:14:45 | 1143757731
VERA | NASDAQ | Buy | Market | 400 | 25.07 | 25.07 | Filled |  | 2024-01-25 14:09:49 | 2024-01-25 14:09:49 | 1143748260 | 25.42 | 2024-01-25 14:14:45
VERA | NASDAQ | Sell | Market | 400 | 25.29 | 25.29 | Filled |  | 2024-01-25 14:01:16 | 2024-01-25 14:01:16 | 1143732905
VERA | NASDAQ | Buy | Market | 400 | 25.04 | 25.04 | Filled |  | 2024-01-25 14:00:01 | 2024-01-25 14:00:01 | 1143730422 | 25.29 | 2024-01-25 14:01:16
VERA | NASDAQ | Sell | Market | 400 | 24.93 | 24.93 | Filled |  | 2024-01-25 13:58:00 | 2024-01-25 13:58:00 | 1143726567
VERA | NASDAQ | Buy | Market | 400 | 24.86 | 24.86 | Filled |  | 2024-01-25 13:55:57 | 2024-01-25 13:55:58 | 1143722671 | 24.93 | 2024-01-25 13:58:00
RVSN | NASDAQ | Sell | Market | 1 200 | 8.88 | 8.88 | Filled |  | 2024-01-25 13:33:01 | 2024-01-25 13:33:01 | 1143678495
AMSC | NASDAQ | Sell | Market | 800 | 12.62 | 12.62 | Filled |  | 2024-01-25 13:32:27 | 2024-01-25 13:32:27 | 1143677282
RVSN | NASDAQ | Buy | Market | 1 200 | 8.49 | 8.49 | Filled |  | 2024-01-25 13:26:28 | 2024-01-25 13:26:28 | 1143666172 | 8.88 | 2024-01-25 13:33:01
AMSC | NASDAQ | Buy | Market | 800 | 12.63 | 12.63 | Filled |  | 2024-01-25 13:24:55 | 2024-01-25 13:24:55 | 1143663243 | 12.62 | 2024-01-25 13:32:27