-
Notifications
You must be signed in to change notification settings - Fork 5
/
earn_every_money_100_OTS.py
executable file
·141 lines (104 loc) · 4.26 KB
/
earn_every_money_100_OTS.py
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
# -*- coding: utf-8 -*-
"""
抓取http://mops.twse.com.tw/mops/web/t05st10_ifrs公開資訊觀測站
各股累積營運情況
2013.01後採用IFRSs後之月營業收入資訊
@author: tim
"""
import urllib, re
import requests
import csv
import time
import datetime
#from datetime import datetime
import os
start = time.time()
content = "贏要衝,輸要縮." #沒有辦法換行
#time_now = datetime.now().strftime("%Y%m%d_%H%M%S") #今天的日期 ex:2015-0411
#title = str("OTS每月營收_100") #Email郵件的標題 ex:2015-0411-選股機器人
realtime_txt = open("earn_money_OTS_100.txt", 'w') #開啟檔案,w沒有該檔案就新增
realtime_txt.write("ID 值利率 與去年月營收比較 與去年累積營收比較 "+"\n")
f = open('/home/tim/GMAIL.txt','r') #於前一個相對目錄中放置登入GMAIL帳號密碼,目的為了不再GitHub顯示出來.
ID = f.readline().strip('\n') #不包含換行符號\n
PW = f.readline().strip('\n')
def cumulative_revenues(co_id, yearmonth, year, month):
"""
輸入:
co_id = '8383' 股票代碼
yearmonth = '10312'
year = 103
month = '01'
http://mops.twse.com.tw/mops/web/t05st10_ifrs
回傳list:['目前累積營收增減百分比']
"""
r = requests.post("http://mops.twse.com.tw/mops/web/t05st10_ifrs")
#選歷史資料後按搜尋
payload = {
'encodeURIComponent':'1',
'run':' Y',
'step':'0',
'yearmonth':yearmonth,
'TYPEK':'sii',
'co_id':co_id,
'off':'1',
'year':year,
'month':month,
'firstin':'true'}
r = requests.get("http://mops.twse.com.tw/mops/web/t05st10_ifrs", params=payload)
optionUrl = r.url
html = urllib.urlopen(optionUrl) #open file-like object
regexp = re.compile(r"<TD class='even' style='text-align:right !important;'> (?P<file>.*)</TD></TR>")
i = 0 #只抓第四筆符合資料
data =[]
for line in html.readlines():
result = regexp.search(line)
if result != None:
money = result.group('file')
i+=1
if i==2:
data.append(money.split())
if i==4:
data.append(money.split())
return data
if __name__ == "__main__":
today = datetime.date.today()
first = today.replace(day=1)
lastMonth = first - datetime.timedelta(days=1)
year=str(int(lastMonth.strftime("%Y"))-1911)
month=lastMonth.strftime("%m")
year_month=year+month
title = str("OTS_"+month+"月營收_100")
count = 0
#a = cumulative_revenues('2412','10609','106','09')
print "與去年月營收比較 與去年累積營收比較"
with open('OTS.csv') as csvfile:
csvfile = csvfile.readlines()[3:104]
readCSV = csv.reader(csvfile, delimiter=',') #以模組csv裡的函數reader來讀取csvfile變數，區隔符號為逗號(,)，讀>取後存到readCSV變數裡
for row in readCSV: #就readCSV裡的所有資料(以列為單位)
try:
time.sleep(10)
#a = cumulative_revenues(row[0],'10609','106','09')
a = cumulative_revenues(row[0],year_month,year,month)
if float(a[6][0]) >= 0 and float(row[4]) >= 3: #年累積營收要大於0 值利率要大於3%
#a = cumulative_revenues(row[0], str( int(datetime.datetime.now().strftime("%Y"))-1911)+datetime.datetime.now().strftime("%m"),str( int(datetime.datetime.now().strftime("%Y"))-1911),datetime.datetime.now().strftime("%m"))
realtime_txt.write(str(row[0])+" "+str(row[1]).strip()+" "+str(row[4])+" "+str(a[5])+" "+str(a[6])+" "+"\n")
print row[0],row[1],row[4],a[5],a[6]
count+=1
except:
pass
realtime_txt.write("月與年營收皆成長公司共有"+str(count)+"間"+"\n")
end = time.time()
elapsed = end - start
print( "Time taken: ", elapsed, "seconds.")
realtime_txt.write("Time taken: "+ str(elapsed) + " seconds.")
realtime_txt.close()
os.system('sendEmail -o \
-f u160895@taipower.com.tw \
-t "WEI <weihautin@gmail.com>" \
-s smtp.gmail.com:587 \
-xu %s \
-xp %s \
-u %s \
-o message-file=/home/tim/earn_money_OTS_100.txt \
'%(ID, PW, title))
os.remove('earn_money_OTS_100.txt')