Economist Steve Moore predicted the stock market could see a "massive turnaround" depending on factors like the approval of a GOP-led budget resolution.