2019年9月10日 星期二

setup items for retrieving twse info

key knowledge :
- 2 URLs for stock info
- determine which day is off
- determine database fields
- how to determine boolean tunnel

modules :
- http engine
- stock info parsing engine
- daily update engine
- fields data generation

twse URL:
https://www.twse.com.tw/exchangeReport/MI_INDEX?response=csv&date=20190924&type=ALLBUT0999

tpex URL:
http://www.tpex.org.tw/web/stock/aftertrading/daily_close_quotes/stk_quote_download.php?l=zh-tw&d=107/02/09&s=0,asc,0


database fields :
from twse :

stock_id
orddate
name             object
shares           int64
transactions      int64
amount            int64
open            float64
high            float64
low             float64
close           float64
diff            float64
lastbuy         float64
lastbuys          int64
lastsell        float64
lastsells         int64
eps             float64
allshares         int64

derived data :
deviation            float64
avg_5                 float64
avg_10               float64
avg_20               float64
avg_60               float64



沒有留言:

張貼留言