Spreadsheet: 723185d1615554682-nesting-a-sumifs-and-subtotal-together-file-rev-1_2-180221
Sheet: BUY SELL Data Input

Shares BUY,SELL Data Input
 |  |  |  |  |  |  |  |  |  | Kest Rates:
Date | Ticker | Börse | Depot | Type | Qty | Unit Price EUR € | Unit Price USD $ | FX Rate | BUY,SELL, GAIN (Excl. Fees) USD $ | BUY, SELL, GAIN (Kest Value) EUR €
2020-05-26 00:00:00 | AMD #1 | NDQ | DG | Buy | 100 |  | 28 | 1.0974
2021-06-26 00:00:00 |  |  |  | Sell | 50 |  | 30 | 1.0974
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMD #2 | NDQ | DG | Buy | 100 |  | 56 | 1.096001960900572
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMD #3 | NDQ | DG | Buy | 100 |  | 83 | 1.177620665041436
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #4 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #5 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #6 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #7 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #8 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #9 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #10 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #11 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #12 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #13 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #14 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMD #15 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
Totals | AMD |  |  | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2021-02-08 00:00:00 | AMZN #1 | NDQ | DG | Buy | 1 |  | 3325.45 | 1.20549986394934
 |  |  |  | Sell
 |  |  |  | Gain/Loss
 | AMZN #2 | FRA | BA | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2019-09-12 00:00:00 | AMZN #3 | FRA | BA | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-06 00:00:00 | AMZN #4 | NDQ $ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMZN #5 | NDQ € | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2019-10-08 00:00:00 | AMZN #6 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMZN #7 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMZN #8 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMZN #9 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMZN #10 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMZN #11 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMZN #12 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMZN #13 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | AMZN #14 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | AMZN #15 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
Totals | AMZN |  |  | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2018-12-12 00:00:00 | ZM #1 | FRA | BA | Buy | 1 |  | 145.06 | 1.0977
2020-04-29 00:00:00 |  |  |  | Sell | 1 |  | 150 | 1.086586587748488
 |  |  |  | Gain/Loss
2020-06-04 00:00:00 | ZM # 2 | NDQ | DG | Buy | 1 |  | 155 | 1.124674770416474
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #3 | NDQ | DG | Buy | 1 |  | 165 | 1.177122072886596
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-06 00:00:00 | ZM #4a | NDQ | DG | Buy | 1 |  | 180 | 1.194104464569281
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #4b | NDQ | DG | Buy | 1 |  | 200 | 1.194104464569281
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2019-10-08 00:00:00 | ZM #6 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | ZM #7 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #8 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | ZM #9 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #10 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | ZM #11 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #12 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | ZM #13 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-05-26 00:00:00 | ZM #14 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
2020-10-19 00:00:00 | ZM #15 | NDQ | DG | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
Totals | ZM |  |  | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss
Grand Totals |  |  |  | Buy
 |  |  |  | Sell
 |  |  |  | Gain/Loss