SONJOE JOSEPH
Member
Dear Excel Experts,
In the attached working file i have some trades which went on the 5 min, 15 min and 1 hr. This are represented in ND ( No Direction), Buy and Sell. In the Mood starting from B3 i need to give some conditions based on the criteria mentioned below:
1. If 1 Buy and 3 Sell shown then the mood is "BUY"
2. If 1 Sell and 3 BUY shown then the mood is "SELL"
3. If all its showing SELL then the mood is "SELL"
4. If all its showing BUY then the mood is "BUY"
5. if 1 ND and rest 3 BUY then the mood is "BUY"
6 if 1 ND and rest 3 SELL then the mood is "SELL"
7. If 2 ND and 2 BUY then the mood is "WAIT"
8.If 2 ND and 2 SELL then the mood is "WAIT"
Hoping somebody from the forum can help me to solve the above query.
Thanks % Regards,
Sonjoe
In the attached working file i have some trades which went on the 5 min, 15 min and 1 hr. This are represented in ND ( No Direction), Buy and Sell. In the Mood starting from B3 i need to give some conditions based on the criteria mentioned below:
1. If 1 Buy and 3 Sell shown then the mood is "BUY"
2. If 1 Sell and 3 BUY shown then the mood is "SELL"
3. If all its showing SELL then the mood is "SELL"
4. If all its showing BUY then the mood is "BUY"
5. if 1 ND and rest 3 BUY then the mood is "BUY"
6 if 1 ND and rest 3 SELL then the mood is "SELL"
7. If 2 ND and 2 BUY then the mood is "WAIT"
8.If 2 ND and 2 SELL then the mood is "WAIT"
Hoping somebody from the forum can help me to solve the above query.
Thanks % Regards,
Sonjoe
Attachments

11.1 KB Views: 3