Live Formula Sandbox & Tester

Test formulas live against REITwave's ultra-low latency REST formula resolver

function REITWAVE(ticker, metric, apiKey) {
  if (!ticker || !metric) return "#N/A: Missing ticker or metric";
  var cleanTicker = ticker.toString().trim().toUpperCase();
  var cleanMetric = metric.toString().trim().toUpperCase();
  var cache = CacheService.getScriptCache();
  var cacheKey = "rw_" + cleanTicker + "_" + cleanMetric;
  var cachedVal = cache.get(cacheKey);
  if (cachedVal !== null) {
    var num = Number(cachedVal);
    return isNaN(num) ? cachedVal : num;
  }
  var url = "https://reitwave.com/api/sheets/quote?ticker=" + encodeURIComponent(cleanTicker) + 
            "&metric=" + encodeURIComponent(cleanMetric) +
            (apiKey ? "&api_key=" + encodeURIComponent(apiKey) : "");
  try {
    var response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
    if (response.getResponseCode() !== 200) {
      return "#ERROR: " + response.getContentText();
    }
    var data = JSON.parse(response.getContentText());
    cache.put(cacheKey, data.value.toString(), 600);
    var num = Number(data.value);
    return isNaN(num) ? data.value : num;
  } catch (err) {
    return "#ERR: Connection failed";
  }
}