VBA 連動goodinfo爬蟲 - 股票

By Adele
at 2020-04-19T03:37
at 2020-04-19T03:37
Table of Contents
之前有很多人站內信我
但沒回 也是因為覺得之前弄出來的檔案
太For自己使用
大家用起來可能會很多問題
不過剛剛弄好了一份新的檔案
是可以For所有人 而且很簡單
1. 必須從ie登入goodinfo
2.把自訂條件的名稱 key進excel
(有幾個就要key幾個進去)
3.若要刪除原先資料 請選刪除
要保留原先資料 請選不刪除
4.看要使用哪一個自訂條件 在下方打勾
5.按start
https://i.imgur.com/95QSOGc.jpg
https://i.imgur.com/3fEoZAQ.jpg
請各位自行服用 謝謝~
影片:
https://drive.google.com/file/d/1Dhaif3G1WxjLLs9XGDgM06Qpdw7FdCrb/view?usp=sha
ring
https://streamable.com/4mqmmd
檔案:
https://drive.google.com/file/d/1ps_3y6SY6qsidNxF7fq5x6OSrEGCLhC1/view?usp=dri
vesdk
--
但沒回 也是因為覺得之前弄出來的檔案
太For自己使用
大家用起來可能會很多問題
不過剛剛弄好了一份新的檔案
是可以For所有人 而且很簡單
1. 必須從ie登入goodinfo
2.把自訂條件的名稱 key進excel
(有幾個就要key幾個進去)
3.若要刪除原先資料 請選刪除
要保留原先資料 請選不刪除
4.看要使用哪一個自訂條件 在下方打勾
5.按start
https://i.imgur.com/95QSOGc.jpg
https://i.imgur.com/3fEoZAQ.jpg
請各位自行服用 謝謝~
影片:
https://drive.google.com/file/d/1Dhaif3G1WxjLLs9XGDgM06Qpdw7FdCrb/view?usp=sha
ring
https://streamable.com/4mqmmd
檔案:
https://drive.google.com/file/d/1ps_3y6SY6qsidNxF7fq5x6OSrEGCLhC1/view?usp=dri
vesdk
--
Tags:
股票
All Comments

By Wallis
at 2020-04-23T12:11
at 2020-04-23T12:11

By Noah
at 2020-04-25T19:32
at 2020-04-25T19:32

By Oliver
at 2020-04-27T07:49
at 2020-04-27T07:49

By Donna
at 2020-04-30T07:13
at 2020-04-30T07:13

By Blanche
at 2020-05-02T20:44
at 2020-05-02T20:44

By Oscar
at 2020-05-06T14:37
at 2020-05-06T14:37

By Jacob
at 2020-05-07T01:37
at 2020-05-07T01:37

By Lily
at 2020-05-07T07:34
at 2020-05-07T07:34

By Gary
at 2020-05-09T12:07
at 2020-05-09T12:07

By Andrew
at 2020-05-13T21:29
at 2020-05-13T21:29

By Sierra Rose
at 2020-05-18T12:16
at 2020-05-18T12:16

By Doris
at 2020-05-21T06:49
at 2020-05-21T06:49

By Hazel
at 2020-05-22T00:38
at 2020-05-22T00:38

By Callum
at 2020-05-25T19:02
at 2020-05-25T19:02

By Skylar Davis
at 2020-05-29T16:33
at 2020-05-29T16:33

By Suhail Hany
at 2020-05-29T23:23
at 2020-05-29T23:23

By Franklin
at 2020-05-31T05:16
at 2020-05-31T05:16

By Jacob
at 2020-06-04T06:07
at 2020-06-04T06:07

By Delia
at 2020-06-06T14:18
at 2020-06-06T14:18

By Zenobia
at 2020-06-06T17:19
at 2020-06-06T17:19

By Caroline
at 2020-06-09T11:59
at 2020-06-09T11:59

By Madame
at 2020-06-12T00:36
at 2020-06-12T00:36

By Carolina Franco
at 2020-06-15T01:28
at 2020-06-15T01:28

By Tristan Cohan
at 2020-06-17T04:18
at 2020-06-17T04:18

By Olga
at 2020-06-17T15:51
at 2020-06-17T15:51

By Poppy
at 2020-06-20T19:34
at 2020-06-20T19:34

By Margaret
at 2020-06-21T19:03
at 2020-06-21T19:03

By Noah
at 2020-06-22T13:40
at 2020-06-22T13:40

By Andrew
at 2020-06-26T14:31
at 2020-06-26T14:31

By Susan
at 2020-07-01T07:44
at 2020-07-01T07:44

By Bethany
at 2020-07-03T15:58
at 2020-07-03T15:58

By Gary
at 2020-07-08T06:33
at 2020-07-08T06:33

By Irma
at 2020-07-09T17:23
at 2020-07-09T17:23

By Ina
at 2020-07-11T00:01
at 2020-07-11T00:01

By Jake
at 2020-07-14T14:08
at 2020-07-14T14:08

By Rosalind
at 2020-07-15T04:12
at 2020-07-15T04:12

By Victoria
at 2020-07-19T15:21
at 2020-07-19T15:21

By Edwina
at 2020-07-23T20:33
at 2020-07-23T20:33

By Daph Bay
at 2020-07-28T10:34
at 2020-07-28T10:34

By Ida
at 2020-08-01T19:38
at 2020-08-01T19:38

By Odelette
at 2020-08-03T05:40
at 2020-08-03T05:40

By Olivia
at 2020-08-08T01:31
at 2020-08-08T01:31

By Olivia
at 2020-08-09T15:14
at 2020-08-09T15:14

By Edward Lewis
at 2020-08-10T11:56
at 2020-08-10T11:56

By Tristan Cohan
at 2020-08-13T00:59
at 2020-08-13T00:59

By Kelly
at 2020-08-17T22:35
at 2020-08-17T22:35

By Jacky
at 2020-08-18T16:51
at 2020-08-18T16:51

By Bethany
at 2020-08-21T05:50
at 2020-08-21T05:50

By Tristan Cohan
at 2020-08-24T08:18
at 2020-08-24T08:18

By Mason
at 2020-08-26T07:43
at 2020-08-26T07:43

By James
at 2020-08-29T10:49
at 2020-08-29T10:49

By Oliver
at 2020-08-30T08:01
at 2020-08-30T08:01

By Franklin
at 2020-08-31T19:26
at 2020-08-31T19:26

By Hazel
at 2020-09-05T16:49
at 2020-09-05T16:49

By Susan
at 2020-09-06T22:15
at 2020-09-06T22:15

By Heather
at 2020-09-10T03:54
at 2020-09-10T03:54

By Lily
at 2020-09-12T10:27
at 2020-09-12T10:27

By Linda
at 2020-09-13T04:19
at 2020-09-13T04:19

By Emily
at 2020-09-15T11:50
at 2020-09-15T11:50

By Blanche
at 2020-09-16T20:03
at 2020-09-16T20:03

By Daph Bay
at 2020-09-21T08:52
at 2020-09-21T08:52

By Dora
at 2020-09-26T06:06
at 2020-09-26T06:06
Related Posts
曾在手遊踢鐵板 新幹線靠這兩款遊戲鋒芒

By Rebecca
at 2020-04-19T02:14
at 2020-04-19T02:14
趁新冠危機大舉入市抄底?孟格:這次我

By Hamiltion
at 2020-04-19T01:38
at 2020-04-19T01:38
紓困金3500億美元用罄 美國中小企業臨倒

By Erin
at 2020-04-19T01:21
at 2020-04-19T01:21
陸瘋搶新iPhone SE 京東預購人數破40萬

By Freda
at 2020-04-19T00:41
at 2020-04-19T00:41
哲哲要洗白了嗎

By Heather
at 2020-04-18T22:28
at 2020-04-18T22:28