Forum Discussion
Counting in IF stmt
I have a small Investment spreadsheet. Currently I'm tracking six symbols. One column, H5 - H10, tracks the change for each symbol. I'm trying to do two basic things, count the number of winners and ...
COUNTIF() shall work, but better if you provide small sample file
Thanks for the help.
| Group 3A | ||||||||||||||||||||||
| TRADE | TRADE | OPEN TRADE | CLOSED | |||||||||||||||||||
| ENTRY DATE | SYMBOL | L/S | SHARES | ENTRY PRICE | LAST PRICE | CHANGE | $ GAIN/LOSS | ROI | TRADE P&L | RISK | ||||||||||||
| 66/24/19 | FFXE | L | 1 | 108.26 | 108.27 | $ 0.0 | $ 0.01 | 0.0% | ||||||||||||||
| 66/24/19 | GLDGLD | L | 1 | 133.5 | 133.2 | $ (0.30) | $ (0.30) | -0.2% | ||||||||||||||
| 66/24/19 | QQQ | L | 1 | 188.5 | 186.74 | $ (1.76) | $ (1.76) | -0.9% | ||||||||||||||
| 66/24/19 | TLT | L | 1 | 132 | 132.81 | $ 0.81 | $ 0.81 | 0.6% | ||||||||||||||
| 66/24/19 | VXX | S | 1 | 26.6 | 26 | $ (0.60) | $ 0.60 | 2.3% | ||||||||||||||
| 66/24/19 | XOP | S | 1 | 26 | 27.25 | $ 1.25 | $ 1.25 | 4.81% | ||||||||||||||
| Open | Trades | 614.86 | 614.27 | $ 61.00 | 9.92% | $ - | #DIV/0! | |||||||||||||||
| Stocks | 6 | |||||||||||||||||||||
| Losers | #NAME? | Open P&L | $ 61.00 | |||||||||||||||||||
| Winners | ||||||||||||||||||||||
| $ winners | Open Trade | Avg ROI | 2.35% | |||||||||||||||||||
| $ Losers | ||||||||||||||||||||||
| Avg win | Closed P&L | $ - | ||||||||||||||||||||
| Avg lose | ||||||||||||||||||||||
| Profit Factor | Return On Risk | = | ||||||||||||||||||||
| Weekly Close | Open & Closed | Equity Change | Weekly Acct | |||||||||||||||||||
| Date | P/L | Plus/Minus | Gain/Loss % |