PriceGuard Alert

/**
 * BACKEND LOGIC (Google Apps Script)
 */

// 1. Handles Live Data Polling from Frontend
function doGet(e) {
  // Replace with real API fetch if available
  // e.g., var res = UrlFetchApp.fetch("https://api.external.com/v1/market/price?symbol=AL");
  // For this template, we simulate real-time volatility
  var mockLivePrice = (2400 + Math.random() * 100).toFixed(2);
  
  return ContentService.createTextOutput(JSON.stringify({
    price: mockLivePrice,
    timestamp: new Date().toLocaleTimeString()
  })).setMimeType(ContentService.MimeType.JSON);
}

// 2. Saves Guard Thresholds from Frontend
function doPost(e) {
  try {
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    const sheet = ss.getSheets()[0];
    const data = JSON.parse(e.postData.contents);
    sheet.appendRow([data.item, data.threshold, new Date(), "active"]);
    return ContentService.createTextOutput("Saved").setMimeType(ContentService.MimeType.TEXT);
  } catch (err) {
    return ContentService.createTextOutput("Error").setMimeType(ContentService.MimeType.TEXT);
  }
}

// 3. Automated Check (Set this on a Time Trigger)
function checkPrices() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheets()[0];
  const data = sheet.getDataRange().getValues();
  
  // Real check logic would fetch market price here
  const currentMarketPrice = 2500; 

  for(let i=1; i < data.length; i++) {
    if(currentMarketPrice > data[i][1] && data[i][3] === "active") {
      MailApp.sendEmail("your-email@domain.com", "PriceGuard Alert: " + data[i][0], 
        "The price for " + data[i][0] + " has crossed your threshold of $" + data[i][1] + ".");
    }
  }
}