Anyone know how to add dividend yield information of stocks live into Excel spreadsheet? also easy to control so that I can simply drag and autocomplete for all the stock based on the given ticker in a column from an existing table?. (I have tried Power Query and API, perhaps Visual Basic code?) As the image shows, I only have to get the dividend yield automatically inserted and up to date

Anyone know how to add dividend yield information of stocks live into Excel spreadsheet also easy to control so that I can simply drag and autocomplete for all class=