Forum Discussion

JoshApt's avatar
JoshApt
Copper Contributor
Apr 13, 2022

Stock Dividend Information in Excel

Hello,

I am trying to add additional dividend information to a list of stocks that I have in a table in Excel. According to https://support.microsoft.com/en-us/office/encodeurl-function-07c7fb90-7c60-4bff-8687-fac50fe33d0e, I think that this should be possible. I want to use a formula so that it updates automatically over time and updates according to what that ticker symbol is on the respective row. 

 

Right now this is all that I have (the ticker symbol is on the J column): =WEBSERVICE(http://www.nasdaq.com/market-activity/stocks/ ENCODEURL(J2))

 

However, it returns with a #NAME? error. 

It does not necessarily have to use this exact format, I just need it to work.

 

excel
Formulas and Functions

2 Replies

Sort By
  • JoshApt's avatar
    JoshApt
    Copper Contributor
    Apr 13, 2022
    Forgot to add but if it is important I was wanting to get the Annualized Dividend, Ex-Dividend Date, Dividend Pay Date, and Current Yield.
    • dlcartin's avatar
      dlcartin
      Iron Contributor
      Nov 26, 2022
      'Google Sheets' will do this....and, it works very good!!

Resources