Skip to content

Instantly share code, notes, and snippets.

@mikaelz

mikaelz/ttm-dividend-yield.js

Created May 3, 2020 09:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikaelz/73e1b4f00256720e00d4f22fa92e1807 to your computer and use it in GitHub Desktop.
Save mikaelz/73e1b4f00256720e00d4f22fa92e1807 to your computer and use it in GitHub Desktop.
Download ZIP
Google Spreadsheet script to fetch Dividend Yield from https://fmpcloud.io/plans
Raw
ttm-dividend-yield.js
function DivYieldTtm(ticker) {
var ticker = ticker || "GOOG";
ticker = encodeURI(ticker);
var response = UrlFetchApp.fetch("https://fmpcloud.io/api/v3/ratios-ttm/" + ticker + "?apikey=YOUR_API_KEY");
var result = JSON.parse(response.getContentText());
return parseFloat(result[0].dividendYielTTM);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment