App Inventor 线上语音股票查询(3)

最近自我学习,利用 Apps Script 结合股票价格用 LINE 通知,分享给大家参考
优点说明:
1.利用 Apps Script 可设定触发,当符合条件便会LINE通知
2.只要在 google sheet 设定好价格,她会随时为您把关
3.当设定价格小于现价或停损大于现价
4.用LINE通知即时性高
5.Google Sheet 人人会
6.设定好不用开 app 便可帮您把关
7.Apps Script 简单好用不用钱
8.跟 javascript 语法类似很讚

Line Notify 画面如下:

gooele sheet 画面如下:

Apps Script画面如下:

google sheet 价格自动抓法:

=iferror(ifs(A2="美股",GOOGLEFINANCE(C2,"price"),B2="上市",GOOGLEFINANCE("TPE:"&C2,"price"),B2="上柜",vlookup(value(C2),'上柜资讯'!A:C,3,0)),"找不到资料")

Apps Script 程式码如下:

function readData(){  //let sheet = SpreadsheetApp.getActiveSheet()  var ss = SpreadsheetApp.openByUrl("自已google sheet 网址");  let sheet = ss.getSheetByName('股票资讯');  let start_row = 2;  let start_col = 4;  let num_row = sheet.getLastRow()-1;  let num_col = 4;  let data = sheet.getRange(start_row, start_col, num_row, num_col).getValues();   return data;}//警告设定function stockPriceAlert(){  let data = readData();  let emailAddress = "joulongleu2@gmail.com";  for (row_data of data){    let curr_product = row_data[0];    let curr_price = row_data[1];    let higher_target = row_data[2];    let lower_target = row_data[3];    let alert_price = row_data[4];        //当设定价格小于现价或停损大于现价    if((curr_price > higher_target) || (curr_price < lower_target)){       let msg =curr_product +'设定值' + (higher_target) +'已超过' + (curr_price - higher_target)       //当符合条件便会LINE通知      doPost(msg)    }        }  Logger.log(data); }function doPost(msg) {  UrlFetchApp.fetch('https://notify-api.line.me/api/notify', {    'headers': {      'Authorization': 'Bearer ' + '权杖',    },    'method': 'post',    'payload': {      'message': msg,      'stickerPackageId': '2',      'stickerId': '523'        }    });}

设定触发画面如下: