A University of Bath study of 36,000 people found that excessive optimism is linked to lower cognitive ability and poorer financial decisions. Here's what it means for you.