It took him WAY too long to go to a scientist and try to get the pill recreated. It's like wishing for more wishes. How is that not the obvious first priority. Also, he forgot to pay back the criminal that lent him the money? Why wouldn't you do that as soon as you quintupled (or whatever he did) your money?
I think the pill makes you smart enough to be an intriguing character but leaves you with enough stupid to make an interesting movie
