Re:[心得] 用Excel抓Yahoo Finance歷史股價
第一版是陽春麵,一次下載一支股票,還限定上市股
連我自己都覺得很雞肋
所以,第二版就改成我喜歡的香菇雞湯
有香菇,有雞肉,冬天喝很溫暖
第二版功能包含
1.可抓上市與上櫃股票(只要Yahoo Finance有提供歷史數據就抓的到)
2.一次下載N支股票的數據,讓你吃到飽,吃到吐
3.自行編輯要下載的股票代碼!!!!!!提供最佳的自由度
如果看到第一版陽春麵就感動的話
喝第二版香菇雞湯之前請先把包大人穿好,避免感動到尿失禁
Excel 2007版 http://ppt.cc/Ej7-
Excel 2003版 http://ppt.cc/8a7m
使用說明 http://ppt.cc/U;e5
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 221.169.218.131
推
11/29 21:21, , 1F
11/29 21:21, 1F
推
11/29 21:25, , 2F
11/29 21:25, 2F
推
11/29 21:31, , 3F
11/29 21:31, 3F
推
11/29 21:34, , 4F
11/29 21:34, 4F
推
11/29 21:36, , 5F
11/29 21:36, 5F
推
11/29 21:37, , 6F
11/29 21:37, 6F
推
11/29 21:44, , 7F
11/29 21:44, 7F
推
11/29 21:47, , 8F
11/29 21:47, 8F
推
11/29 21:51, , 9F
11/29 21:51, 9F
推
11/29 21:53, , 10F
11/29 21:53, 10F
推
11/29 22:04, , 11F
11/29 22:04, 11F
推
11/29 22:09, , 12F
11/29 22:09, 12F
推
11/29 22:24, , 13F
11/29 22:24, 13F
→
11/29 22:35, , 14F
11/29 22:35, 14F
推
11/29 22:43, , 15F
11/29 22:43, 15F
推
11/29 23:22, , 16F
11/29 23:22, 16F
推
11/29 23:52, , 17F
11/29 23:52, 17F
推
11/30 00:17, , 18F
11/30 00:17, 18F
推
11/30 01:00, , 19F
11/30 01:00, 19F
推
11/30 01:05, , 20F
11/30 01:05, 20F
推
11/30 01:43, , 21F
11/30 01:43, 21F
推
11/30 12:47, , 22F
11/30 12:47, 22F
→
11/30 12:49, , 23F
11/30 12:49, 23F
推
11/30 13:07, , 24F
11/30 13:07, 24F
推
11/30 20:05, , 25F
11/30 20:05, 25F
→
11/30 21:20, , 26F
11/30 21:20, 26F
→
11/30 22:21, , 27F
11/30 22:21, 27F
推
12/19 19:44, , 28F
12/19 19:44, 28F
討論串 (同標題文章)
完整討論串 (本文為第 2 之 7 篇):