這個網誌中的熱門文章
如何自動下載所有股票每天的股價與成交情形
利用google sheets 一個步驟就可以自動下載當天的所有台北股票的成交情形 只要在google sheets的 cell 裡輸入: =IMPORTDATA( http://www.twse.com.tw/exchangeReport/STOCK_DAY_ALL?response=csv ) 就可以自動下載update 當天的股價與交易資料 證券代號 證券名稱 成交股數 成交金額 開盤價 最高價 最低價 收盤價 漲跌價差 成交筆數 1101 台泥 2575942 86451888 33.65 33.65 33.5 33.6 +0.10 1153 1102 亞泥 1259786 33981719 26.9 27.05 26.9 27 +0.10 698 1103 嘉泥 148014 1797716 12.15 12.2 12.1 12.2 +0.10 62 1104 環泥 60288 1411733 23.35 23.5 23.35 23.4 +0.05 54 1108 幸福 1001176 8803484 8.68 8.86 8.67 8.78 +0.07 149 1109 信大 24012 308648 12.95 12.95 12.8 12.8 -0.1 33 1110 東泥 20169 293433 14.6 14.6 14.5 14.5 -0.1 11 1201 味全 1792915 35702850 20.2 20.2 19.8 19.85 -0.35 666 1203 味王 387933 9177084 25 25 22.5 24.7 -0.25 211 1210 大成 1465454 50413689 34.5 34.75 34.2 34.45 +0.15 885 ...
R markdown
Test This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com . When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this: summary ( cars ) ## speed dist ## Min. : 4.0 Min. : 2.00 ## 1st Qu.:12.0 1st Qu.: 26.00 ## Median :15.0 Median : 36.00 ## Mean :15.4 Mean : 42.98 ## 3rd Qu.:19.0 3rd Qu.: 56.00 ## Max. :25.0 Max. :120.00 You can also embed plots, for example: Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot. Untitled This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word doc...