[心得] 分享財報EXCEL表格製作
作者: newlife520 (綠油油) 看板: Stock
標題: [心得] 分享財報EXCEL表格製作
時間: Thu Aug 10 21:03:13 2017
1.此表格參考『看財報不抓狂』一書,僅供參考,有興趣可以去買書參考
也給作者一個鼓勵!
2.建議使用2010版本EXCEL
3.財報藏寶圖表格中
『市場別、產業別、股票名稱、上市年數』
這幾欄書上找不到公式,所以顯示不出來(書上範例是有的)
還懇請知道公式如何輸入的先進講一下~~
4.因為表格太多了,如果有先進能夠分享表格內重要、次重要的參或是提供其它參考,實在是非常感謝。
5.連結:
http://bit.ly/2vSAuoJ
補充:表格內Z-SCORE,是作者所謂的『Z值財務體質』有興趣請自行去買書參考
另外請問
我這樣PO這表格,有算違反著作權什麼之類的嗎?
補充二:0810日09:22我更新了檔名叫_『財報藏寶圖-分享版』分享版才有辦法連結喔!!
※ 編輯: newlife520 (36.233.8.20), 08/10/2017 21:06:41
推
08/10 21:04, , 1F
08/10 21:04, 1F
推
08/10 21:05, , 2F
08/10 21:05, 2F
推
08/10 21:07, , 3F
08/10 21:07, 3F
推
08/10 21:08, , 4F
08/10 21:08, 4F
推
08/10 21:10, , 5F
08/10 21:10, 5F
推
08/10 21:10, , 6F
08/10 21:10, 6F
推
08/10 21:10, , 7F
08/10 21:10, 7F
推
08/10 21:11, , 8F
08/10 21:11, 8F
→
08/10 21:12, , 9F
08/10 21:12, 9F
※ 編輯: newlife520 (36.233.8.20), 08/10/2017 21:20:21
※ 編輯: newlife520 (36.233.8.20), 08/10/2017 21:23:30
推
08/10 21:29, , 10F
08/10 21:29, 10F
→
08/10 21:37, , 11F
08/10 21:37, 11F
→
08/10 21:38, , 12F
08/10 21:38, 12F
→
08/10 21:38, , 13F
08/10 21:38, 13F
推
08/10 23:04, , 14F
08/10 23:04, 14F
推
08/10 23:07, , 15F
08/10 23:07, 15F
推
08/10 23:10, , 16F
08/10 23:10, 16F
推
08/10 23:11, , 17F
08/10 23:11, 17F
推
08/10 23:41, , 18F
08/10 23:41, 18F
推
08/10 23:41, , 19F
08/10 23:41, 19F
→
08/11 01:21, , 20F
08/11 01:21, 20F
推
08/11 02:21, , 21F
08/11 02:21, 21F
推
08/11 04:38, , 22F
08/11 04:38, 22F
推
08/11 07:19, , 23F
08/11 07:19, 23F
推
08/11 08:59, , 24F
08/11 08:59, 24F
推
08/11 09:43, , 25F
08/11 09:43, 25F
推
08/11 09:50, , 26F
08/11 09:50, 26F
推
08/11 09:51, , 27F
08/11 09:51, 27F
推
08/11 10:12, , 28F
08/11 10:12, 28F
推
08/11 11:02, , 29F
08/11 11:02, 29F
→
08/11 11:02, , 30F
08/11 11:02, 30F
→
08/11 11:02, , 31F
08/11 11:02, 31F
→
08/11 11:02, , 32F
08/11 11:02, 32F
→
08/11 11:02, , 33F
08/11 11:02, 33F
→
08/11 11:02, , 34F
08/11 11:02, 34F
→
08/11 11:02, , 35F
08/11 11:02, 35F
→
08/11 11:02, , 36F
08/11 11:02, 36F
→
08/11 11:02, , 37F
08/11 11:02, 37F
→
08/11 11:02, , 38F
08/11 11:02, 38F
→
08/11 11:02, , 39F
08/11 11:02, 39F
→
08/11 11:02, , 40F
08/11 11:02, 40F
→
08/11 11:02, , 41F
08/11 11:02, 41F
→
08/11 11:02, , 42F
08/11 11:02, 42F
→
08/11 11:02, , 43F
08/11 11:02, 43F
→
08/11 11:02, , 44F
08/11 11:02, 44F
→
08/11 11:02, , 45F
08/11 11:02, 45F
→
08/11 11:02, , 46F
08/11 11:02, 46F
→
08/11 11:02, , 47F
08/11 11:02, 47F
→
08/11 11:03, , 48F
08/11 11:03, 48F
→
08/11 11:03, , 49F
08/11 11:03, 49F
→
08/11 11:03, , 50F
08/11 11:03, 50F
→
08/11 11:03, , 51F
08/11 11:03, 51F
→
08/11 11:03, , 52F
08/11 11:03, 52F
→
08/11 11:03, , 53F
08/11 11:03, 53F
→
08/11 11:03, , 54F
08/11 11:03, 54F
→
08/11 11:03, , 55F
08/11 11:03, 55F
→
08/11 11:03, , 56F
08/11 11:03, 56F
→
08/11 11:03, , 57F
08/11 11:03, 57F
推
08/11 12:19, , 58F
08/11 12:19, 58F
推
08/12 21:54, , 59F
08/12 21:54, 59F
推
08/12 21:57, , 60F
08/12 21:57, 60F
→
08/12 21:57, , 61F
08/12 21:57, 61F
推
08/14 11:45, , 62F
08/14 11:45, 62F
推
08/16 23:54, , 63F
08/16 23:54, 63F
→
08/16 23:54, , 64F
08/16 23:54, 64F
→
08/16 23:54, , 65F
08/16 23:54, 65F