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