I have a spreadsheet that tries to predict a price that the stockmarket will not reach within the next x number of days. The Win/Lose feature of the spreadsheet checks back after that number of days has passed to see whether the prediction was correct or not. Previously, the spreadsheet used to predict both an upper & lower price that would not be reached. However I recently changed it so that it only predicts one of those levels. Since doing that the Win/Lose feature does not work properly, as it sometimes indicates a loss when infact it was a win. So, this formula needs rewriting.
## Deliverables
This is the current formula to decide if there was a WIN (ie the prediction was correct):
=IF(AND(H16<OFFSET(H16,-offset2,14),I16>OFFSET(I16,-offset2,14)),1/1,"0")
This is the current formula to decide if there was a LOSE (ie the prediction was wrong):
=IF((AND(OFFSET(H16,-offset2,14)="",OFFSET(I16,-offset2,14)="")),("0"),IF((C17=""),("0"),IF((AND(H16<OFFSET(H16,-offset2,14),I16>OFFSET(I16,-offset2,14))),("0"),1/1)))