API Documentation

/**
 * DrawdownAlerts Google Sheets Integration
 * TESTED AND WORKING - Copy this entire code
 * 
 * IMPORTANT: Replace YOUR_API_KEY on line 8 with your actual key from:
 * https://drawdownalerts.com/account/api
 */

const API_KEY = 'YOUR_API_KEY';
const API_URL = 'https://drawdownalerts.com/api/data';

/**
 * Get severity score: =SEVERITY("AAPL")
 */
function SEVERITY(ticker) {
  const data = fetchData(ticker);
  if (!data) return 'ERROR';
  if (data.error) return data.error; // Show "Processing (retry in 1 min)"
  return data.severityScore;
}

/**
 * Get current price: =PRICE("AAPL")
 */
function PRICE(ticker) {
  const data = fetchData(ticker);
  if (!data) return 'ERROR';
  if (data.error) return data.error; // Show "Processing (retry in 1 min)"
  return data.currentPrice;
}

/**
 * Get alert status: =ALERT("AAPL")
 * Returns: ULTRA BUY, STRONG BUY, BUY, WATCH, or blank
 */
function ALERT(ticker) {
  const data = fetchData(ticker);
  if (!data) return 'ERROR';
  if (data.error) return data.error; // Show "Processing (retry in 1 min)"
  if (data.alertStatus.ultraBuyTriggered) return 'ULTRA BUY';
  if (data.alertStatus.strongBuyTriggered) return 'STRONG BUY';
  if (data.alertStatus.buyTriggered) return 'BUY';
  if (data.alertStatus.watchTriggered) return 'WATCH';
  return '';
}

/**
 * Get drawdown percentage: =DRAWDOWN("AAPL")
 */
function DRAWDOWN(ticker) {
  const data = fetchData(ticker);
  if (!data) return 'ERROR';
  if (data.error) return data.error; // Show "Processing (retry in 1 min)"
  // currentDrawdown is now a string like "-4.52%", parse it
  return parseFloat(data.currentDrawdown);
}

/**
 * Get days in drawdown: =DAYSINDD("AAPL")
 */
function DAYSINDD(ticker) {
  const data = fetchData(ticker);
  if (!data) return 'ERROR';
  if (data.error) return data.error;
  return data.daysInDrawdown;
}

/**
 * Internal function - fetches data from API
 * DO NOT CALL DIRECTLY - use the functions above
 */
function fetchData(ticker) {
  try {
    const url = API_URL + '?ticker=' + ticker;
    const response = UrlFetchApp.fetch(url, {
      method: 'get',
      headers: { 'X-API-Key': API_KEY },
      muteHttpExceptions: true
    });
    
    const statusCode = response.getResponseCode();
    
    if (statusCode === 200) {
      const json = JSON.parse(response.getContentText());
      return json.success ? json.data : null;
    }
    
    // Handle error responses with helpful messages
    const json = JSON.parse(response.getContentText());
    
    // Log helpful messages for each error code
    if (statusCode === 202) {
      Logger.log(ticker + ': Processing - retry in 1 min');
    } else if (statusCode === 503) {
      Logger.log(ticker + ': Data processing - retry in 1-2 min');
    } else if (statusCode === 404) {
      Logger.log(ticker + ': Not available - ' + (json.error || json.reason || 'Check ticker format'));
    } else {
      Logger.log(ticker + ': Error ' + statusCode);
    }
    
    // Return a clear error message instead of null
    // This shows in the cell: "Processing (retry)" instead of "ERROR"
    if (statusCode === 202 || statusCode === 503) {
      return { error: 'Processing (retry in 1 min)' };
    }
    
    return null;
    
  } catch (e) {
    Logger.log(ticker + ': Exception - ' + e);
    return null;
  }
}