Betting against others’ overconfidence is key to beating the market. So is knowing when to tune out the financial pundits.