For years HSBC Holdings Plc harbored dreams of becoming a major player on Wall Street and in the City of London. This week, it finally called time on those ambitions.