Well after many hours searching web sites I figured out an easy solution I cant believe I missed. On the Yahoo historical prices, if you select the radio button 'dividends only', the excel export will then include the dividend payouts where it didn't previously.