Google-sheets – Google Finance API call for stock dividend (Yield)

I ended up using logging from Google App Script to file.

function onEdit(event) {

  var observableSheets = ["Sheet1", "Sheet2", "Sheet3"];
  var ignoredUsers = ["ignored_user@gmail.com", "ignored_user2@gmail.com"];
  var current = new Date();

  Logger.log("%s - %s", "Change Logger", new Date());

  var s = SpreadsheetApp.getActiveSheet();
  var r = s.getActiveCell();
  var val = r.getValue();
  var activeCellAddress = r.getA1Notation();
  var sheetName = s.getName();

  if (observableSheets.indexOf(sheetName) > -1 && r.getRow() > 1) {
    Logger.log("Change in %s sheet detected", sheetName);
    Logger.log("Cell change at: %s", activeCellAddress);
    Logger.log("value of active cell: %s", val);
  }

  var sessionEmail = Session.getActiveUser().getEmail();

  if (ignoredUsers.indexOf(sessionEmail) > -1) {
    return;
  }
  SaveLogToFile();
}

The following formula works fine:

=googlefinance("spy", "price")

There are some attributes that are not available for some stocks, this could the the case for SPY.