YieldWatchJS

function YieldWatch(Coin, Stage, address) {
  var CoinSelect = { "BDO": 0, "SBDO": 1, "CAKE": 0, "BIFI": 1, "BNB": 2, "DAI": 3, "VAI": 0, "XVS": 1};
  var rAddress = address ? address : "0x0F1496afBf539837780c8Ae77CDC63dD78dB71D8";
  var url = "https://yieldwatch.net/api/all/" + rAddress + "?platforms=beefy,pancake,venus";
  var result = UrlFetchApp.fetch(url).getContentText();
  var res = JSON.parse(result);
  switch(Stage) {
    case "Beefy":
      return res.result.BeefyFinance.vaults.vaults[CoinSelect[Coin]].currentTokens - res.result.BeefyFinance.vaults.vaults[CoinSelect[Coin]].depositedTokens;
    break;
    case "Venus":
      return res.result.Venus.staking.vaults[CoinSelect[Coin]].pendingRewards;
    break;
    case "Bdollar":
      return res.result.BeefyFinance.LPVaults.vaults[CoinSelect[Coin]].currentTokens - res.result.BeefyFinance.LPVaults.vaults[CoinSelect[Coin]].depositedTokens;
    break;
  default:
      return "No such Stage"
  }
  SpreadsheetApp.flush();
}