[心得] 怎麼用EXCEL抓每日資料?
只要網路上有的資料都可以抓(期交所、證交所...)
可以製作自己專屬的籌碼應用分析
更進階的當然可以用來做程式交易
附上簡單應用的範例:
大盤籌碼變化:http://i.imgur.com/zAJB1Gx.png
一頁好讀圖文教學版(皆以「週選擇權未平倉」為例)
http://i.imgur.com/GPhakoV.jpg
1.選擇你所要抓取的資料(期交所都有提供EXCEL專用連結)
2.將資料匯入EXCEL
3.利用公式篩選出你所要的資料
4.完成(後續就看個人需求,進行繪圖或篩選,也可以加簡單的巨集方便作業)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.171.9.73
※ 文章網址: https://www.ptt.cc/bbs/Stock/M.1469650234.A.432.html
※ BuyPut:轉錄至看板 Option 07/28 04:10
※ BuyPut:轉錄至看板 Trading 07/28 04:10
推
07/28 04:21, , 1F
07/28 04:21, 1F
推
07/28 04:33, , 2F
07/28 04:33, 2F
推
07/28 04:38, , 3F
07/28 04:38, 3F
推
07/28 05:55, , 4F
07/28 05:55, 4F
推
07/28 06:16, , 5F
07/28 06:16, 5F
推
07/28 06:38, , 6F
07/28 06:38, 6F
推
07/28 07:06, , 7F
07/28 07:06, 7F
推
07/28 07:07, , 8F
07/28 07:07, 8F
推
07/28 07:24, , 9F
07/28 07:24, 9F
推
07/28 07:28, , 10F
07/28 07:28, 10F
推
07/28 07:38, , 11F
07/28 07:38, 11F
推
07/28 07:39, , 12F
07/28 07:39, 12F
推
07/28 07:41, , 13F
07/28 07:41, 13F
推
07/28 07:48, , 14F
07/28 07:48, 14F
推
07/28 07:50, , 15F
07/28 07:50, 15F
推
07/28 07:50, , 16F
07/28 07:50, 16F
推
07/28 07:53, , 17F
07/28 07:53, 17F
推
07/28 07:53, , 18F
07/28 07:53, 18F
推
07/28 07:59, , 19F
07/28 07:59, 19F
推
07/28 08:03, , 20F
07/28 08:03, 20F
推
07/28 08:04, , 21F
07/28 08:04, 21F
推
07/28 08:04, , 22F
07/28 08:04, 22F
推
07/28 08:07, , 23F
07/28 08:07, 23F
推
07/28 08:14, , 24F
07/28 08:14, 24F
推
07/28 08:14, , 25F
07/28 08:14, 25F
推
07/28 08:22, , 26F
07/28 08:22, 26F
推
07/28 08:24, , 27F
07/28 08:24, 27F
推
07/28 08:24, , 28F
07/28 08:24, 28F
推
07/28 08:25, , 29F
07/28 08:25, 29F
推
07/28 08:25, , 30F
07/28 08:25, 30F
推
07/28 08:31, , 31F
07/28 08:31, 31F
推
07/28 08:34, , 32F
07/28 08:34, 32F
推
07/28 08:36, , 33F
07/28 08:36, 33F
推
07/28 08:49, , 34F
07/28 08:49, 34F
推
07/28 08:55, , 35F
07/28 08:55, 35F
推
07/28 08:55, , 36F
07/28 08:55, 36F
推
07/28 08:56, , 37F
07/28 08:56, 37F
推
07/28 08:56, , 38F
07/28 08:56, 38F
推
07/28 08:59, , 39F
07/28 08:59, 39F
推
07/28 09:00, , 40F
07/28 09:00, 40F
推
07/28 09:09, , 41F
07/28 09:09, 41F
推
07/28 09:13, , 42F
07/28 09:13, 42F
推
07/28 09:16, , 43F
07/28 09:16, 43F
→
07/28 09:30, , 44F
07/28 09:30, 44F
推
07/28 09:30, , 45F
07/28 09:30, 45F
推
07/28 09:33, , 46F
07/28 09:33, 46F
推
07/28 09:40, , 47F
07/28 09:40, 47F
推
07/28 09:43, , 48F
07/28 09:43, 48F
推
07/28 09:50, , 49F
07/28 09:50, 49F
推
07/28 10:01, , 50F
07/28 10:01, 50F
推
07/28 10:13, , 51F
07/28 10:13, 51F
推
07/28 10:18, , 52F
07/28 10:18, 52F
推
07/28 10:19, , 53F
07/28 10:19, 53F
推
07/28 10:23, , 54F
07/28 10:23, 54F
推
07/28 10:29, , 55F
07/28 10:29, 55F
推
07/28 10:47, , 56F
07/28 10:47, 56F
推
07/28 10:50, , 57F
07/28 10:50, 57F
推
07/28 10:57, , 58F
07/28 10:57, 58F
推
07/28 11:02, , 59F
07/28 11:02, 59F
推
07/28 11:05, , 60F
07/28 11:05, 60F
推
07/28 11:06, , 61F
07/28 11:06, 61F
推
07/28 11:11, , 62F
07/28 11:11, 62F
推
07/28 11:28, , 63F
07/28 11:28, 63F
推
07/28 12:01, , 64F
07/28 12:01, 64F
推
07/28 12:02, , 65F
07/28 12:02, 65F
推
07/28 12:04, , 66F
07/28 12:04, 66F
推
07/28 12:18, , 67F
07/28 12:18, 67F
推
07/28 12:28, , 68F
07/28 12:28, 68F
推
07/28 12:30, , 69F
07/28 12:30, 69F
推
07/28 12:35, , 70F
07/28 12:35, 70F
推
07/28 12:46, , 71F
07/28 12:46, 71F
推
07/28 13:41, , 72F
07/28 13:41, 72F
推
07/28 13:58, , 73F
07/28 13:58, 73F
推
07/28 14:14, , 74F
07/28 14:14, 74F
推
07/28 16:00, , 75F
07/28 16:00, 75F
推
07/28 16:23, , 76F
07/28 16:23, 76F
推
07/28 16:40, , 77F
07/28 16:40, 77F
推
07/28 18:12, , 78F
07/28 18:12, 78F
推
07/28 19:14, , 79F
07/28 19:14, 79F
推
07/28 19:17, , 80F
07/28 19:17, 80F
推
07/28 19:47, , 81F
07/28 19:47, 81F
推
07/28 19:54, , 82F
07/28 19:54, 82F
推
07/28 20:05, , 83F
07/28 20:05, 83F
推
07/28 20:11, , 84F
07/28 20:11, 84F
推
07/28 21:13, , 85F
07/28 21:13, 85F
推
07/28 21:29, , 86F
07/28 21:29, 86F
推
07/28 23:25, , 87F
07/28 23:25, 87F
推
07/29 00:25, , 88F
07/29 00:25, 88F
推
07/29 00:56, , 89F
07/29 00:56, 89F
推
07/29 13:28, , 90F
07/29 13:28, 90F
推
07/29 17:05, , 91F
07/29 17:05, 91F
推
07/29 23:08, , 92F
07/29 23:08, 92F
推
07/31 19:49, , 93F
07/31 19:49, 93F
推
08/07 14:25, , 94F
08/07 14:25, 94F
推
09/12 17:47, , 95F
09/12 17:47, 95F
推
12/13 18:37, , 96F
12/13 18:37, 96F
推
01/20 22:17, , 97F
01/20 22:17, 97F