怎麼用EXCEL抓每日資料？ - 股票

By Emily
at 2016-07-28T04:10

Table of Contents

只要網路上有的資料都可以抓(期交所、證交所...)
可以製作自己專屬的籌碼應用分析
更進階的當然可以用來做程式交易

附上簡單應用的範例：
大盤籌碼變化：http://i.imgur.com/zAJB1Gx.png

月選未平倉變化http://i.imgur.com/OlK3e8X.png

週選未平倉變化http://i.imgur.com/khCtiE1.png

三十大權值籌碼http://i.imgur.com/I8C7M0p.png

一頁好讀圖文教學版(皆以「週選擇權未平倉」為例)
http://i.imgur.com/GPhakoV.jpg

1.選擇你所要抓取的資料(期交所都有提供EXCEL專用連結)
2.將資料匯入EXCEL
3.利用公式篩選出你所要的資料
4.完成(後續就看個人需求，進行繪圖或篩選，也可以加簡單的巨集方便作業)

--

Tags: 股票

All Comments

By Victoria
at 2016-07-28T11:22

推

By Faithe
at 2016-07-31T10:00

淚推！

By Donna
at 2016-08-01T06:29

Good job

By Anonymous
at 2016-08-02T06:06

推

By Edwina
at 2016-08-02T16:09

淚推op 一次解決我好多問題謝謝你！！！

By Jack
at 2016-08-06T19:29

大推！

By Regina
at 2016-08-08T19:34

GOOD!!

By Kumar
at 2016-08-13T14:22

感謝大大~

By Daph Bay
at 2016-08-15T00:18

好心人!

By Kama
at 2016-08-15T12:46

推好心

By Dorothy
at 2016-08-19T12:11

推好心

By Thomas
at 2016-08-20T02:16

推!!!

By Rebecca
at 2016-08-23T19:47

推！

By Yuri
at 2016-08-27T23:53

感謝分享

By Caitlin
at 2016-08-30T23:25

謝謝分享

By Delia
at 2016-08-31T11:40

感謝

By Ethan
at 2016-09-04T03:28

第一張有沒有檔案載點 3Q

By Ursula
at 2016-09-05T01:24

推!謝謝分享

By Michael
at 2016-09-06T15:58

排版好厲害

By Lucy
at 2016-09-07T06:35

厲害

By Sandy
at 2016-09-10T09:12

推啦

By Belly
at 2016-09-10T17:56

推好心教學

By Irma
at 2016-09-14T22:19

推~

By Lucy
at 2016-09-16T12:58

大推

By Ursula
at 2016-09-18T14:43

推

By Edward Lewis
at 2016-09-21T19:42

這一篇全部都是推

By Eden
at 2016-09-26T15:03

推用心

By Hedda
at 2016-09-29T10:25

謝謝

By Agatha
at 2016-10-03T00:56

做的真精美！！

By Christine
at 2016-10-06T19:07

加入收藏！

By Regina
at 2016-10-07T16:47

推！

By Irma
at 2016-10-11T11:56

謝謝

By Jack
at 2016-10-15T19:54

感謝!!!

By Delia
at 2016-10-18T22:20

太感謝了!!!

By Quanna
at 2016-10-23T09:17

只能推了讚

By Poppy
at 2016-10-25T09:33

分享推

By Rebecca
at 2016-10-30T01:03

推

By Frederic
at 2016-11-02T00:42

推

By Thomas
at 2016-11-03T21:04

推

By Genevieve
at 2016-11-08T00:47

用python比較爽

By Olivia
at 2016-11-11T05:29

感恩

By Sarah
at 2016-11-12T06:19

感謝！

By Kelly
at 2016-11-13T21:59

教學文大好~感謝

By Eartha
at 2016-11-14T07:34

推推

By Gilbert
at 2016-11-19T07:09

難得股版的好文純幫助沒唬爛沒嘲諷，難得

By Steve
at 2016-11-21T08:59

推U質

By Bethany
at 2016-11-22T05:33

推!!

By Valerie
at 2016-11-23T14:54

推

By Charlie
at 2016-11-25T09:57

推!!造福人群

By Ina
at 2016-11-25T20:12

推

By Jake
at 2016-11-29T07:27

謝分享

By Callum
at 2016-12-02T21:24

推

By Frederica
at 2016-12-04T17:34

推用心分享非常感謝提點

By Agnes
at 2016-12-05T09:38

神人推

By Enid
at 2016-12-09T02:00

推

By Irma
at 2016-12-13T05:00

謝謝

By Suhail Hany
at 2016-12-15T07:31

淚推！感謝

By Lily
at 2016-12-17T01:28

股價博

By Susan
at 2016-12-21T19:16

強

By Tristan Cohan
at 2016-12-26T08:11

一生平安

By Queena
at 2016-12-28T07:40

推!

By Skylar Davis
at 2016-12-28T15:40

請問etf淨值有辦法抓嗎？好像抓不到資料

By Jake
at 2016-12-28T22:19

推

By Caroline
at 2017-01-01T08:03

謝謝分享

By Oscar
at 2017-01-04T03:20

專業推

By Jacob
at 2017-01-05T15:01

請問怎麼抓全部股票某月盈收，謝謝

By Sierra Rose
at 2017-01-08T01:07

推

By Blanche
at 2017-01-09T06:00

推

By Tom
at 2017-01-10T21:27

推感謝分享

By Dora
at 2017-01-14T12:34

謝謝分享

By Poppy
at 2017-01-16T12:40

未看先推

By Yuri
at 2017-01-16T17:56

推

By Ina
at 2017-01-20T23:42

讚讚讚讚

By Tracy
at 2017-01-23T18:16

推

By Ida
at 2017-01-27T17:41

本日最佛心~~~

By Gilbert
at 2017-02-01T03:50

推

By Xanthe
at 2017-02-03T01:14

推

By Tom
at 2017-02-03T06:46

推

By Elma
at 2017-02-08T05:12

推！

By Delia
at 2017-02-08T13:15

推

By James
at 2017-02-13T06:34

淚推已哭到崩潰

By Joseph
at 2017-02-16T07:16

推

By Anthony
at 2017-02-20T14:20

有看有推

By Todd Johnson
at 2017-02-24T20:06

推好心

By Emma
at 2017-03-01T00:59

推

By Valerie
at 2017-03-03T11:53

再來推一次

By Iris
at 2017-03-04T19:47

首推就給你了謝謝

By Mary
at 2017-03-08T19:53

推！

By Ida
at 2017-03-13T00:15

今日首推

By Kristin
at 2017-03-17T20:57

大推專業實用文！

By Olivia
at 2017-03-19T17:41

用心推惠我良多

By Joseph
at 2017-03-20T23:42

推

By Hedy
at 2017-03-22T18:59

期貨沒碰，但推原PO的善行，謝謝分享。

By Carolina Franco
at 2017-03-23T11:51

push

By Jake
at 2017-03-27T09:26

推

By Dorothy
at 2017-03-31T23:30

大哥一生平安

By Hedy
at 2017-04-03T11:23

收藏推個，謝謝分享！

利用公開說明書的運氣

By Carolina Franco
at 2016-07-25T22:49

原文恕刪我個人寫過兩間公司的公開說明書，我只能說真的很恐怖，可能我都沒遇到正直善良的好老闆。裡面的東西讓我自己寫完晚上會睡不著。公開說明書是個非常神奇的東西，每個投資人都如果要買該公司的股票，都會非常認真研究，但是如果是公司內部資訊人，通常只在乎是否合規跟怎樣可以完成上市即可，對許多公司來說只要 ...

公開收購的解說

By Adele
at 2016-07-25T15:19

目前至少有四、五個人站內信問我公開收購的事情我看我還是把一些常常會被問的答案寫出來好了讓許多新手日後也能夠爬文找到這樣的資料 1.公開收購是什麼? 公開收購就是其他公司要把這一間被收購的公司收購下來基本上會是以高於盤面上的股價收購該公司發行的股票 2.為什麼要花更多的錢來收購? 收購如果成功之後將 ...

Stock發文門檻調整

By Kyle
at 2016-07-24T21:59

※ [本文轉錄自 Law-Service 看板 #1NbCbvXh ] 作者: IanLi (IanLi) 看板: Law-Service 標題: Fw: [申請] Stock發文門檻調整時間: Sun Jul 24 21:58:16 2016 ※ [本文轉錄自 AboutBoards 看板 #1NaZ ...

上奇(6123) (附加投資風險評估與提醒)

By Barb Cronin
at 2016-07-22T18:15

※ 引述《jokeman ( )》之銘言： : 1. 標的：上奇 (6123) : 2. 分類：多 : 3. 分析/正文： : a.基本面：最近七個月營收都能維持年增率正成長，代表公司訂單開始成長 : 2016 Q1 毛利率:21.06%，表現略遜於去年同期，但是..... ...

九年投資心得[代PO]

By Jacky
at 2016-07-18T11:16

昨天看了一些推文，一直猶豫要不要回文，現在有點空，還是來碎碎唸一下好了。 --------------------------------------------------- 昨天文發完後當然也有持反面意見類似如下：比氣長其實也沒意義,玩了20年最後沒輸贏也沒比較好最後變成娛樂打發時間,重點還是要能 ...

怎麼用EXCEL抓每日資料？ - 股票

All Comments

Related Posts