-
Notifications
You must be signed in to change notification settings - Fork 0
/
tests.js
57 lines (42 loc) · 1.11 KB
/
tests.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
function testYahoo(){
t = new YahooFinance();
var data = t.QueryHistorical('0056.TW', 100, 1, 1000);
console.log(data);
}
function testYahooQuote(){
t = new YahooFinance();
var data = t.Quote('0050.TW');
console.log(data);
}
function testProvision() {
provisionSheetsQuote("0050.TW");
}
function testProvisionSheet() {
var SheetName = "Rich";
resetSheet( SheetName );
provisionSheets( SheetName );
};
function testQuery() {
var rows = QueryStockValuesEx("Day", "V", 380, 1, 250);
var rows = QueryStockValuesEx("Week", "V", 3650, 7, 500);
Logger.log(rows);
}
function testStockPrice()
{
var price = FinanceApp.getStockInfo("0050")
}
function testLastRow(symbol) {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var template = spreadsheet.getSheetByName("Day");
var lastRow = template.getLastRow();
Logger.log(lastRow);
}
function testRangeHeight()
{
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var template = spreadsheet.getSheetByName("Day");
var range = template.getRange("A:A");
Logger.log(range.getLastRow());
var aaa = 100;
Logger.log("A"+aaa);
}