NeedExcelHelp2021
New Member
- Joined
- Apr 17, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Explanation: trade #2 got open before trade #1 ended so 2 trades open at once,
trade #2 ended before trade #3 Entry Date so 2 trades open at once at trade #3 (Trade#1 Open,Trade#2 Closed,Trade#3 Open)= At Trade #3 (2 Trades Open At Once)
Thank you for any help.
trade #2 ended before trade #3 Entry Date so 2 trades open at once at trade #3 (Trade#1 Open,Trade#2 Closed,Trade#3 Open)= At Trade #3 (2 Trades Open At Once)
Thank you for any help.
Book2 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Trade # | Entry Date | Exit Date | # of trades open at once | ||||||
2 | 1 | 1/14/2009 | 10/21/2009 | 1 | ||||||
3 | 2 | 1/19/2009 | 1/21/2009 | 2 | ||||||
4 | 3 | 1/27/2009 | 1/28/2009 | 2 | ||||||
5 | 4 | 2/8/2009 | 3/23/2009 | 2 | ||||||
6 | 5 | 3/4/2009 | 10/19/2009 | 3 | ||||||
7 | 6 | 3/4/2009 | 5/7/2009 | 4 | ||||||
8 | 7 | 3/11/2009 | 3/16/2009 | 5 | ||||||
9 | 8 | 3/12/2009 | 12/23/2009 | 6 | ||||||
10 | 9 | 4/2/2009 | 4/6/2009 | 5 | ||||||
11 | 10 | 4/21/2009 | 6/1/2009 | 5 | ||||||
12 | ||||||||||
13 | ||||||||||
14 | ||||||||||
15 | ||||||||||
16 | ||||||||||
Sheet3 |