-
Notifications
You must be signed in to change notification settings - Fork 14
/
STANDARD TODAY AUTOMATIC SYSTEM
127 lines (97 loc) · 3.52 KB
/
STANDARD TODAY AUTOMATIC SYSTEM
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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
function doGet() {
var Match = function(date,time,league,home_team,away_team,odds,tip,home_score,away_score,gotcha){
this.date=date;
this.time = time;
this.league = league;
this.home_team = home_team;
this.away_team = away_team;
this.odds = odds;
this.tip = tip;
this.home_score = home_score;
this.away_score = away_score;
this.gotcha = gotcha;
}
var fetchString="https://vipbetting8.blogspot.gr/"
var response = UrlFetchApp.fetch(fetchString);
var doc = Xml.parse(response.getBlob().getDataAsString(),true);
var b = doc.html.body;
var table = b[1].table.thead;
var date = b[1].getElement("p").getElements("span")[6].getElement("strong").getText();
date = date.replace(/ /g,'');
date = date.slice(6)+'-'+date.slice(3,5)+'-'+date.slice(0,2);
var rows = [];
var matches = [];
var trs = table.getElements("tr");
for(var r=2;r<trs.length-1;r=r+2){
var tds = trs[r].getElements("td");
var time = tds[0];
while(time.getElement()!=null){
time = time.getElement();
}
time = time.getText();
var teams = tds[2];
while(teams.getElement()!=null){
teams = teams.getElement();
}
teams = teams.getText();
if(teams.search("-")!==-1){
var seperator = teams.search(" - ");
var home_team = teams.slice(0,seperator);
home_team = home_team.replace(/\t/g,'');
var away_team = teams.slice(seperator+3);
}else{
var seperator = teams.search(" v ");
var home_team = teams.slice(0,seperator);
home_team = home_team.replace(/\t/g,'');
var away_team = teams.slice(seperator+3);
}
var odds = tds[3];
while(odds.getElement()!=null){
odds = odds.getElement();
}
odds = odds.getText();
tds = trs[r+1].getElements("td");
var league = tds[0];
while(league.getElement()!=null){
league = league.getElement();
}
league = league.getText();
var tip = tds[1];
while(tip.getElement()!=null){
tip = tip.getElement();
}
tip = tip.getText();
var home_score = "0";
var away_score = "0";
var gotcha = "yet";
var match = new Match(date,time,league,home_team,away_team,odds,tip,home_score,away_score,gotcha);
matches.push(match);
}
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var lastRow = sheet.getLastRow();
for(var i=lastRow; i>1; i--){
sheet.deleteRow(i);
}
for(var i=0; i<matches.length; i++){
sheet.appendRow([matches[i].date,matches[i].league,matches[i].time,matches[i].home_team,matches[i].away_team,matches[i].home_score,matches[i].away_score,matches[i].odds,matches[i].tip,matches[i].gotcha]);
}
var range = sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns());
range.setNumberFormat('@');
//MailApp.sendEmail("","", "");
}
///**
// * Automatically sorts the 1st column (not the header row) Ascending.ΤΕΣΤ
// */
//function onEdit(event){
// var sheet = event.source.getActiveSheet();
// var editedCell = sheet.getActiveCell();
//
// var columnToSortBy = 1;
// var tableRange = "A2:T200"; // What to sort.
//
// if(editedCell.getColumn() == columnToSortBy && sheet.getName()!="stats"){
// var range = sheet.getRange(tableRange);
// range.sort( { column : columnToSortBy, ascending: false } );
// }
//}