What's the best way of pulling historical stock price data to excel?

I've tried using the STOCKHISTORY() function but the arrays that it generates are not consistent throughout (not same lenght/missing data).