Advisor Confidence Holds Steady in August