1. App Script Bot-1 Telegram Saham Turun
function checkStockAlerts() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
const data = sheet.getDataRange().getValues();
const TELEGRAM_TOKEN = "8050614158:AAGnHHBERuADp2bBFl3PHsaFSuctLol6yVM";
const TELEGRAM_CHAT_ID = "1243483408";
let alerts = [];
for (let i = 1; i < data.length; i++) {
const row = data[i];
const kode = row[1];
const nama = row[2];
const harga = parseFloat(row[3]);
const batasTurun = parseFloat(row[4]);
const batasNaik = parseFloat(row[5]);
const statusTurun = (row[6] || "").toLowerCase();
const statusNaik = (row[7] || "").toLowerCase();
Logger.log(`Row ${i + 1}: harga=${harga}, batasTurun=${batasTurun}, statusTurun=${statusTurun}`);
if (!isNaN(harga) && !isNaN(batasTurun) && harga < batasTurun && statusTurun !== "terkirim") {
alerts.push(`🔻 ${kode} (${nama}) TURUN ke ${harga} (batas: ${batasTurun})`);
sheet.getRange(i + 1, 7).setValue("terkirim"); // kolom G
}
if (!isNaN(harga) && !isNaN(batasNaik) && harga > batasNaik && statusNaik !== "terkirim") {
alerts.push(`🔺 ${kode} (${nama}) NAIK ke ${harga} (batas: ${batasNaik})`);
sheet.getRange(i + 1, 7).setValue("terkirim"); // kolom H
}
}
if (alerts.length > 0) {
const message = "📢 ALERT SAHAM:\n" + alerts.join("\n");
const url = `https://api.telegram.org/bot${TELEGRAM_TOKEN}/sendMessage`;
const payload = {
method: "post",
payload: {
chat_id: TELEGRAM_CHAT_ID,
text: message,
},
};
const response = UrlFetchApp.fetch(url, payload);
Logger.log("Telegram response: " + response.getContentText());
} else {
Logger.log("Tidak ada alert.");
}
}
Comments
Post a Comment