Ok, I've been looking for this type of formula but not finding it. So here I am asking for help.
I'm a day trader on stocks and I want to analyze my performance. For example:
+-----------------+--------------+-----------+-----------------+----------+
| Days | Profit/Loss | Per Day | Per Day Pr/Loss | Best Day |
+-----------------+--------------+-----------+-----------------+----------+
| Monday | $100 | Monday | -1088 | Friday |
| Tuesday | -$50 | Tuesday | -3550 | |
| Thursday | $21 | Wednesday | -958 | |
| Monday | $12 | Thursday | 21 | |
| Monday | -$1200 | Friday | 5715 | |
| Wednesday | -$1200 | | | |
| Friday | $3200 | | | |
| Tuesday | -$3500 | | | |
| Wednesday | -$300 | | | |
| Wednesday | $42 | | | |
| Wednesday | $500 | | | |
| Friday | $15 | | | |
| Friday | $2500 | | | |
+-----------------+--------------+-----------+-----------------+----------+
P/L according to days should be:
Mondays -$1088,
Tuesdays -$3550,
Wednesdays -$958,
Thursdays $21,
Fridays $5715
(How can I calculate this as well?)
And the most profitable days traded from the example above should be FRIDAY
.
Now my question is, how can I formulate this so that it gives me Friday
as the answer?