[心得] 快速瀏覽各公司股利及月營收(Excel分享)
各位股神晚安,
小弟去年八月有分享Excel快速觀察各公司每月營收。
最近有新增股利查詢及查詢近一年營收狀況。
檔案連結如下:
https://goo.gl/Amx45n
關於此Excel幾點說明:
1. 製作此簡式Excel動機在於月初時,不用到處找新聞,一鍵即能查詢營收。
2. 股利部分,則是可以快速查詢今年公司股利發放情形及除權息交易日。
3. 使用方法如下:
a. 每月營收觀察名單可以填入自己的觀察股or持股,當營收資料下載完成,
此觀察名單會抓取營收資料,並進行帶入的動作。
b. All營收Data可以填入觀察的持股代號,即可觀看近一年營收狀況。
c. 股利Data可以填入想查詢的股票代號,即可觀看股利發放及殖利率。
簡單的Excel分享,謝謝大家。
--
Sent From My AirBus 350-900
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.224.89.163
※ 文章網址: https://www.ptt.cc/bbs/Stock/M.1496928715.A.D1A.html
噓
06/08 21:33, , 1F
06/08 21:33, 1F
推
06/08 21:34, , 2F
06/08 21:34, 2F
推
06/08 21:35, , 3F
06/08 21:35, 3F
→
06/08 21:36, , 4F
06/08 21:36, 4F
推
06/08 21:40, , 5F
06/08 21:40, 5F
推
06/08 21:42, , 6F
06/08 21:42, 6F
推
06/08 21:42, , 7F
06/08 21:42, 7F
推
06/08 21:46, , 8F
06/08 21:46, 8F
推
06/08 21:47, , 9F
06/08 21:47, 9F
推
06/08 21:52, , 10F
06/08 21:52, 10F
推
06/08 21:52, , 11F
06/08 21:52, 11F
推
06/08 21:52, , 12F
06/08 21:52, 12F
推
06/08 21:52, , 13F
06/08 21:52, 13F
噓
06/08 21:55, , 14F
06/08 21:55, 14F
推
06/08 21:58, , 15F
06/08 21:58, 15F
推
06/08 21:58, , 16F
06/08 21:58, 16F
推
06/08 22:01, , 17F
06/08 22:01, 17F
推
06/08 22:07, , 18F
06/08 22:07, 18F
推
06/08 22:09, , 19F
06/08 22:09, 19F
推
06/08 22:11, , 20F
06/08 22:11, 20F
推
06/08 22:13, , 21F
06/08 22:13, 21F
推
06/08 22:14, , 22F
06/08 22:14, 22F
推
06/08 22:15, , 23F
06/08 22:15, 23F
推
06/08 22:16, , 24F
06/08 22:16, 24F
推
06/08 22:19, , 25F
06/08 22:19, 25F
推
06/08 22:23, , 26F
06/08 22:23, 26F
推
06/08 22:26, , 27F
06/08 22:26, 27F
推
06/08 22:27, , 28F
06/08 22:27, 28F
推
06/08 22:28, , 29F
06/08 22:28, 29F
推
06/08 22:36, , 30F
06/08 22:36, 30F
推
06/08 22:39, , 31F
06/08 22:39, 31F
推
06/08 22:54, , 32F
06/08 22:54, 32F
推
06/08 22:57, , 33F
06/08 22:57, 33F
推
06/08 23:00, , 34F
06/08 23:00, 34F
推
06/08 23:01, , 35F
06/08 23:01, 35F
推
06/08 23:03, , 36F
06/08 23:03, 36F
推
06/08 23:19, , 37F
06/08 23:19, 37F
推
06/08 23:19, , 38F
06/08 23:19, 38F
推
06/08 23:19, , 39F
06/08 23:19, 39F
推
06/08 23:32, , 40F
06/08 23:32, 40F
推
06/08 23:52, , 41F
06/08 23:52, 41F
推
06/09 00:02, , 42F
06/09 00:02, 42F
推
06/09 00:05, , 43F
06/09 00:05, 43F
推
06/09 00:07, , 44F
06/09 00:07, 44F
推
06/09 00:11, , 45F
06/09 00:11, 45F
推
06/09 00:27, , 46F
06/09 00:27, 46F
推
06/09 00:27, , 47F
06/09 00:27, 47F
推
06/09 00:39, , 48F
06/09 00:39, 48F
推
06/09 00:48, , 49F
06/09 00:48, 49F
推
06/09 01:23, , 50F
06/09 01:23, 50F
推
06/09 01:23, , 51F
06/09 01:23, 51F
推
06/09 01:41, , 52F
06/09 01:41, 52F
→
06/09 01:51, , 53F
06/09 01:51, 53F
推
06/09 04:04, , 54F
06/09 04:04, 54F
推
06/09 04:54, , 55F
06/09 04:54, 55F
推
06/09 07:27, , 56F
06/09 07:27, 56F
推
06/09 08:05, , 57F
06/09 08:05, 57F
推
06/09 08:06, , 58F
06/09 08:06, 58F
推
06/09 08:25, , 59F
06/09 08:25, 59F
推
06/09 08:31, , 60F
06/09 08:31, 60F
推
06/09 08:56, , 61F
06/09 08:56, 61F
推
06/09 09:17, , 62F
06/09 09:17, 62F
推
06/09 09:48, , 63F
06/09 09:48, 63F
推
06/09 09:58, , 64F
06/09 09:58, 64F
推
06/09 10:08, , 65F
06/09 10:08, 65F
推
06/09 12:02, , 66F
06/09 12:02, 66F
推
06/09 12:32, , 67F
06/09 12:32, 67F
推
06/09 13:10, , 68F
06/09 13:10, 68F
推
06/09 13:31, , 69F
06/09 13:31, 69F
推
06/09 13:39, , 70F
06/09 13:39, 70F
推
06/09 13:50, , 71F
06/09 13:50, 71F
推
06/09 16:35, , 72F
06/09 16:35, 72F
推
06/09 17:29, , 73F
06/09 17:29, 73F
推
06/09 20:26, , 74F
06/09 20:26, 74F
推
06/09 22:29, , 75F
06/09 22:29, 75F
推
06/10 04:43, , 76F
06/10 04:43, 76F
推
06/11 22:07, , 77F
06/11 22:07, 77F
推
06/13 11:38, , 78F
06/13 11:38, 78F
推
06/16 11:48, , 79F
06/16 11:48, 79F
推
07/10 21:52, , 80F
07/10 21:52, 80F
推
08/17 08:43, , 81F
08/17 08:43, 81F
推
08/17 11:35, , 82F
08/17 11:35, 82F
推
11/17 22:11, , 83F
11/17 22:11, 83F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 2 篇):