Show Dividends in excel

I pull data from Stock into excel. But what I like to have in addition the estimated dividend in % and amount. Does anyone have a formula I could add?