[其他] 使用EXCEL搜尋定存股已回收
感謝u48652004兄提供的懶人投資法好文,小弟用VBA改寫一下EXCEL
方便查詢,有需要的就下戴試試吧!
http://ppt.cc/5Kf8 請儲存在D:\
執行步驟:
1.請用EXCEL 2003,其它的版本抱歉了@@
2.開啟D:\定存.XLS,啟動自動更新取得最新收盤價
3.鍵入資料後記得按儲存,再按確定執行
4.執行完畢後,用EXCEL開啟文字檔D:\STACK.TXT,都按下一步後,再按完成就會顯示資料
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.39.59.250
推
02/12 22:51, , 1F
02/12 22:51, 1F
→
02/12 22:53, , 2F
02/12 22:53, 2F
推
02/12 22:59, , 3F
02/12 22:59, 3F
推
02/12 23:00, , 4F
02/12 23:00, 4F
推
02/12 23:01, , 5F
02/12 23:01, 5F
推
02/12 23:04, , 6F
02/12 23:04, 6F
→
02/12 23:05, , 7F
02/12 23:05, 7F
推
02/12 23:14, , 8F
02/12 23:14, 8F
→
02/12 23:19, , 9F
02/12 23:19, 9F
推
02/12 23:19, , 10F
02/12 23:19, 10F
推
02/12 23:29, , 11F
02/12 23:29, 11F
推
02/12 23:40, , 12F
02/12 23:40, 12F
推
02/12 23:54, , 13F
02/12 23:54, 13F
推
02/12 23:59, , 14F
02/12 23:59, 14F
推
02/13 00:30, , 15F
02/13 00:30, 15F
→
02/13 10:04, , 16F
02/13 10:04, 16F
推
02/13 10:21, , 17F
02/13 10:21, 17F
→
02/13 10:39, , 18F
02/13 10:39, 18F
推
02/13 11:07, , 19F
02/13 11:07, 19F
→
02/13 11:07, , 20F
02/13 11:07, 20F
推
02/13 14:23, , 21F
02/13 14:23, 21F
推
02/13 14:24, , 22F
02/13 14:24, 22F
推
02/13 15:35, , 23F
02/13 15:35, 23F
→
02/13 17:59, , 24F
02/13 17:59, 24F
→
02/13 20:25, , 25F
02/13 20:25, 25F
推
02/13 22:08, , 26F
02/13 22:08, 26F
推
02/13 22:40, , 27F
02/13 22:40, 27F
推
02/14 02:14, , 28F
02/14 02:14, 28F
推
02/14 10:04, , 29F
02/14 10:04, 29F
→
02/14 10:05, , 30F
02/14 10:05, 30F
→
02/14 10:05, , 31F
02/14 10:05, 31F
→
02/14 11:28, , 32F
02/14 11:28, 32F
→
02/14 11:29, , 33F
02/14 11:29, 33F
→
02/14 11:31, , 34F
02/14 11:31, 34F
→
02/14 11:33, , 35F
02/14 11:33, 35F
→
02/14 11:34, , 36F
02/14 11:34, 36F
※ 編輯: eyenet11 來自: 114.39.60.44 (02/14 11:39)
→
02/15 16:44, , 37F
02/15 16:44, 37F
它只是一個檔案,不用裝阿@@
※ 編輯: eyenet11 來自: 114.27.129.131 (02/15 22:40)
推
02/17 00:11, , 38F
02/17 00:11, 38F