Yes, you are right that being strongly optimistic can harm you in stock market. But you need to build confidence to stay invested. Money comes from that optimism, if proved right. Many times, I come here to read more to build optimism.
I am still positive even after your caution. Lets see.