How to retrieve annual dividend for spreadsheets?

[BruceLynn Erickson]

Hi all - simple, but probably not easy question...

How do you retrieve the current dividend being paid by a company.  Google finance has almost all of the other attributes I need for my tracking, but not the dividend paid.

Any ideas???

[Bogdan D.]

1. Go to  IEX Cloud, register for free account an get you API Key.

 2. In your Google Sheets Create a new function in by using Tools>Scripts editor.

Copy and paste this function in Google Apps Script:

////////////////////////////////////////////

function GETDIVIDEND2(symbl){

  

var key="[Your API KEY from IEX Cloud]";// replace [Your API KEY from IEX Cloud] with your API Key from IEX Cloud

  try {

    var recentDivi;

    var freq;

    urlnxt="https://cloud.iexapis.com/stable/stock/"+symbl+"/dividends?filter=amount,frequency&token="+key;

    var resnxt = UrlFetchApp.fetch(urlnxt);

   

      var content = resnxt.getContentText();

      var json = JSON.parse(content);

      recentDivi = json[0].amount;

      freq = json[0].frequency;

    

    

    if(freq.toLowerCase() =="quarterly"){

      return recentDivi*4;

    }else if(freq.toLowerCase() == "semi-annual"){

      return recentDivi*2;

    }else if(freq.toLowerCase() == "monthly"){

      return recentDivi*12;

    }

    

    return 0;

  }

  catch (err) {

    return 0;

  }

}

////////////////////////////////////////////

Save the script and grant permission to the function to run.

Use the function to find out the dividend paid for which company you want. For example =GETDIVIDEND2("AAPL")

[UTKU BALCI]

thanks a lot Bogdan D.

[Franz Critchlow]

Great suggestion and thanks.