Spreadsheet: 704178d1605410378-nested-if-function-formula-issue-is-this-the-best-way-to-solve-this-problem-acounting
Sheet: Sheet1 (1)

Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy | 10333 |  | 10330 | 0.3
Entry pos 2 |  | limit | buy | 10689.98
Entry pos 3 |  | limit | buy | 10900.87 |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell | 11500 |  | 11500 | 0.089483
Exit pos 2 |  | limit | sell | 15313 |  | 13100 | 0.136908 |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell | 16500 |  | 15789 | 0.131539
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy |  |  | 10330 | 0.3
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell |  |  | 11500 | 0.089483
Exit pos 2 |  | limit | sell |  |  | 13100 | 0.136908 |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell |  |  | 15789 | 0.131539
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell
Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy
Entry pos 2 |  | limit | buy
Entry pos 3 |  | limit | buy |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell
Exit pos 2 |  | limit | sell |  |  |  |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell
Exit pos 4 |  | limit | sell