快速瀏覽各公司股利及月營收(Excel分享) - 股票
By Wallis
at 2017-06-08T21:31
at 2017-06-08T21:31
Table of Contents
各位股神晚安，
小弟去年八月有分享Excel快速觀察各公司每月營收。
最近有新增股利查詢及查詢近一年營收狀況。
檔案連結如下:
https://goo.gl/Amx45n
關於此Excel幾點說明:
1. 製作此簡式Excel動機在於月初時，不用到處找新聞，一鍵即能查詢營收。
2. 股利部分，則是可以快速查詢今年公司股利發放情形及除權息交易日。
3. 使用方法如下:
a. 每月營收觀察名單可以填入自己的觀察股or持股，當營收資料下載完成，
此觀察名單會抓取營收資料，並進行帶入的動作。
b. All營收Data可以填入觀察的持股代號，即可觀看近一年營收狀況。
c. 股利Data可以填入想查詢的股票代號，即可觀看股利發放及殖利率。
簡單的Excel分享，謝謝大家。
--
Sent From My AirBus 350-900
--
小弟去年八月有分享Excel快速觀察各公司每月營收。
最近有新增股利查詢及查詢近一年營收狀況。
檔案連結如下:
https://goo.gl/Amx45n
關於此Excel幾點說明:
1. 製作此簡式Excel動機在於月初時，不用到處找新聞，一鍵即能查詢營收。
2. 股利部分，則是可以快速查詢今年公司股利發放情形及除權息交易日。
3. 使用方法如下:
a. 每月營收觀察名單可以填入自己的觀察股or持股，當營收資料下載完成，
此觀察名單會抓取營收資料，並進行帶入的動作。
b. All營收Data可以填入觀察的持股代號，即可觀看近一年營收狀況。
c. 股利Data可以填入想查詢的股票代號，即可觀看股利發放及殖利率。
簡單的Excel分享，謝謝大家。
--
Sent From My AirBus 350-900
--
Tags:
股票
All Comments
By Kelly
at 2017-06-11T18:32
at 2017-06-11T18:32
By Hamiltion
at 2017-06-13T01:13
at 2017-06-13T01:13
By Vanessa
at 2017-06-16T08:47
at 2017-06-16T08:47
By Jake
at 2017-06-17T22:15
at 2017-06-17T22:15
By Susan
at 2017-06-21T20:19
at 2017-06-21T20:19
By Brianna
at 2017-06-22T18:24
at 2017-06-22T18:24
By Heather
at 2017-06-27T17:23
at 2017-06-27T17:23
By Mary
at 2017-06-30T10:26
at 2017-06-30T10:26
By Agatha
at 2017-07-03T11:25
at 2017-07-03T11:25
By Hazel
at 2017-07-05T12:00
at 2017-07-05T12:00
By Connor
at 2017-07-08T11:31
at 2017-07-08T11:31
By Kristin
at 2017-07-12T17:46
at 2017-07-12T17:46
By David
at 2017-07-16T14:06
at 2017-07-16T14:06
By Ethan
at 2017-07-18T12:36
at 2017-07-18T12:36
By Tracy
at 2017-07-20T02:58
at 2017-07-20T02:58
By Elizabeth
at 2017-07-24T05:19
at 2017-07-24T05:19
By Elizabeth
at 2017-07-29T03:57
at 2017-07-29T03:57
By Madame
at 2017-07-30T04:15
at 2017-07-30T04:15
By Rosalind
at 2017-08-02T00:31
at 2017-08-02T00:31
By Madame
at 2017-08-05T02:38
at 2017-08-05T02:38
By Steve
at 2017-08-08T20:22
at 2017-08-08T20:22
By Lily
at 2017-08-09T10:16
at 2017-08-09T10:16
By Quintina
at 2017-08-10T00:50
at 2017-08-10T00:50
By Vanessa
at 2017-08-12T19:05
at 2017-08-12T19:05
By Regina
at 2017-08-15T01:43
at 2017-08-15T01:43
By Necoo
at 2017-08-19T06:58
at 2017-08-19T06:58
By Quanna
at 2017-08-19T17:53
at 2017-08-19T17:53
By Anthony
at 2017-08-21T03:36
at 2017-08-21T03:36
By Callum
at 2017-08-25T12:53
at 2017-08-25T12:53
By Barb Cronin
at 2017-08-26T15:38
at 2017-08-26T15:38
By Sandy
at 2017-08-31T11:02
at 2017-08-31T11:02
By Frederica
at 2017-09-02T03:53
at 2017-09-02T03:53
By Audriana
at 2017-09-02T16:19
at 2017-09-02T16:19
By Belly
at 2017-09-04T09:47
at 2017-09-04T09:47
By Ophelia
at 2017-09-04T20:03
at 2017-09-04T20:03
By Rachel
at 2017-09-08T05:09
at 2017-09-08T05:09
By Sarah
at 2017-09-09T16:24
at 2017-09-09T16:24
By Heather
at 2017-09-14T05:47
at 2017-09-14T05:47
By Ethan
at 2017-09-15T17:17
at 2017-09-15T17:17
By Todd Johnson
at 2017-09-19T11:12
at 2017-09-19T11:12
By Belly
at 2017-09-20T05:40
at 2017-09-20T05:40
By Edith
at 2017-09-21T20:52
at 2017-09-21T20:52
By Connor
at 2017-09-26T02:58
at 2017-09-26T02:58
By Eden
at 2017-09-27T10:47
at 2017-09-27T10:47
By Hedy
at 2017-10-02T07:42
at 2017-10-02T07:42
By Lydia
at 2017-10-05T23:50
at 2017-10-05T23:50
By Bethany
at 2017-10-06T02:26
at 2017-10-06T02:26
By Mary
at 2017-10-08T22:02
at 2017-10-08T22:02
By Rosalind
at 2017-10-09T08:05
at 2017-10-09T08:05
By Emily
at 2017-10-10T12:12
at 2017-10-10T12:12
By Joseph
at 2017-10-13T03:28
at 2017-10-13T03:28
By Puput
at 2017-10-15T03:59
at 2017-10-15T03:59
By Selena
at 2017-10-18T21:34
at 2017-10-18T21:34
By Selena
at 2017-10-20T09:15
at 2017-10-20T09:15
By Olga
at 2017-10-24T13:41
at 2017-10-24T13:41
By Isla
at 2017-10-26T20:28
at 2017-10-26T20:28
By Dinah
at 2017-10-30T03:09
at 2017-10-30T03:09
By Mia
at 2017-10-30T23:33
at 2017-10-30T23:33
By Robert
at 2017-11-03T14:10
at 2017-11-03T14:10
By Andy
at 2017-11-08T03:55
at 2017-11-08T03:55
By George
at 2017-11-12T12:14
at 2017-11-12T12:14
By Megan
at 2017-11-16T03:01
at 2017-11-16T03:01
By Necoo
at 2017-11-19T00:03
at 2017-11-19T00:03
By Necoo
at 2017-11-23T18:16
at 2017-11-23T18:16
By Connor
at 2017-11-26T12:53
at 2017-11-26T12:53
By Agnes
at 2017-11-28T04:09
at 2017-11-28T04:09
By Doris
at 2017-12-01T08:05
at 2017-12-01T08:05
By Oscar
at 2017-12-03T11:35
at 2017-12-03T11:35
By Frederic
at 2017-12-07T03:56
at 2017-12-07T03:56
By Hedwig
at 2017-12-10T00:36
at 2017-12-10T00:36
By Daniel
at 2017-12-12T00:56
at 2017-12-12T00:56
By Hedwig
at 2017-12-15T01:30
at 2017-12-15T01:30
By Olive
at 2017-12-19T00:57
at 2017-12-19T00:57
By Zora
at 2017-12-20T00:26
at 2017-12-20T00:26
By Andrew
at 2017-12-24T09:10
at 2017-12-24T09:10
By Thomas
at 2017-12-27T11:31
at 2017-12-27T11:31
By Kama
at 2017-12-28T16:00
at 2017-12-28T16:00
By William
at 2017-12-31T05:32
at 2017-12-31T05:32
By Skylar DavisLinda
at 2018-01-04T00:39
at 2018-01-04T00:39
By Annie
at 2018-01-05T05:09
at 2018-01-05T05:09
By Anonymous
at 2018-01-08T18:42
at 2018-01-08T18:42
By Steve
at 2018-01-09T10:23
at 2018-01-09T10:23
By Annie
at 2018-01-11T11:25
at 2018-01-11T11:25
Related Posts
威剛(3260)配息4元 法人:今年可賺一個股本
By Quanna
at 2017-06-08T21:04
at 2017-06-08T21:04
頁岩油逼死OPEC？油商驚爆內情
By Catherine
at 2017-06-08T20:59
at 2017-06-08T20:59
張忠謀：外資持股8成是台資沒信心 籲台灣
By Kristin
at 2017-06-08T20:58
at 2017-06-08T20:58
張忠謀：外資持股8成是台資沒信心 籲台灣
By Olivia
at 2017-06-08T20:45
at 2017-06-08T20:45
106年06月08日信用交易統計
By Madame
at 2017-06-08T20:37
at 2017-06-08T20:37