{"id":1367,"date":"2026-10-03T06:48:47","date_gmt":"2026-10-02T22:48:47","guid":{"rendered":"https:\/\/www.tsnien.idv.tw\/trade\/?page_id=1367"},"modified":"2026-10-03T10:52:44","modified_gmt":"2026-10-03T02:52:44","slug":"%e4%b8%80%e3%80%81%e7%b3%bb%e7%b5%b1%e7%b0%a1%e4%bb%8b","status":"publish","type":"page","link":"https:\/\/www.tsnien.idv.tw\/trade\/%e4%b8%80%e3%80%81%e7%b3%bb%e7%b5%b1%e7%b0%a1%e4%bb%8b\/","title":{"rendered":"\u4e00\u3001\u7cfb\u7d71\u7c21\u4ecb"},"content":{"rendered":"

\u672c\u7cfb\u7d71<\/strong><\/span>\u4fc2\u5efa\u7acb\u5728 Google Sheet<\/strong><\/span> \u4e0a\uff0c\u4e26\u900f\u904e Google finance<\/span> <\/strong>\u64f7\u53d6\u8b49\u4ea4\u6240\u8cc7\u6599\uff0c\u518d\u8a08\u7b97\u51fa\u6240\u9700\u7684\u6578\u64da\uff0c\u904e\u7a0b\u4e2d\u96a8\u6642\u9808\u5c07\u8cc7\u6599\u5132\u5b58\u300e\u500b\u4eba\u96f2\u7aef\u786c\u789f<\/span><\/strong>\u300f\u4e0a\uff0c\u56e0\u6b64\uff0c\u5fc5\u9808\u9023\u7d50\u4e0a\u7db2\uff0c\u4e26\u5efa\u7acb\u81ea\u5df1\u64c1\u6709\u7684 Google \u8a66\u7b97\u8868\uff0c\u624d\u53ef\u4ee5\u6b63\u5e38\u64cd\u4f5c\u3002\u53e6\u5916\uff0c\u672c\u7cfb\u7d71\u8a08\u7b97\u6578\u91cf\u9f90\u5927\uff0c\u5118\u91cf\u4e0d\u8981\u7528\u592a\u820a\u7684\u7b46\u96fb\u64cd\u4f5c\uff0c\u5982\u679c\u901f\u5ea6\u8f49\u6162\uff0c\u91cd\u65b0\u555f\u52d5\u5373\u53ef(\u50c5\u770b\u677f\u53ef\u4ee5\u7528\u624b\u6a5f)\u3002<\/span><\/p>\n

\u9996\u5148\uff0c\u8acb\u8907\u88fd\u7522\u751f\u81ea\u5df1\u7684 Google \u8a66\u7b97\u8868\uff0c\u6b65\u9a5f\u5982\u4e0b\uff1a<\/span><\/p>\n

* \u6b65\u9a5f<\/span><\/strong>1<\/strong><\/span>\uff1a\u958b\u555f\u8a66\u7b97\u8868\u7db2\u5740\u7db2\u5740\uff1a\u3002<\/span><\/p>\n

* \u6b65\u9a5f<\/span><\/strong> 2<\/strong><\/span>\uff1a\u8a66\u7b97\u8868\u5de6\u4e0a\u65b9\u9ede\u9078\u6a94\u6848 => \u5efa\u7acb\u526f\u672c => \u8f38\u5165\u540d\u7a31 (\u9078\u64c7\u81ea\u5df1\u8a66\u7b97\u8868\u540d\u7a31)=> \u78ba\u8a8d => (\u5efa\u7acb\u6210\u529f) => \u6309\u53f3\u4e0a\u89d2 \u2605 \u52a0\u5165\u6211\u7684\u6700\u611b\uff0c\u4e26\u653e\u7f6e\u65bc\u700f\u89bd\u5668\u5217\u8868\u4e0a\uff0c\u65b9\u4fbf\u4e0b\u6b21\u958b\u555f\u3002<\/span><\/p>\n

1-1 <\/u><\/strong>\u8ffd\u8e64\u8da8\u52e2\u904b\u4f5c\u6a21\u5f0f<\/u><\/strong><\/span><\/p>\n

\u00a0(1)<\/span><\/strong> \u672c\u7cfb\u7d71\u50c5\u9069\u7528\u65bc\u9577\u671f\u6295\u8cc7\u990a\u80a1\uff0c\u4e26\u4e0d\u9069\u5408\u77ed\u7dda\u64cd\u4f5c\u3002<\/span><\/p>\n

(2)<\/strong> <\/span>\u8ffd\u8e64\u80a1\u7968\u8da8\u52e2\u7684\u904b\u4f5c\u6a21\u5f0f\u662f\uff1a\u5728\u591a\u982d\u76e4\u52e2\u4e0b\uff0c\u5c11\u8cb7\u591a\u8ce3\u3001\u5728\u7a7a\u982d\u76e4\u52e2\u4e0b\uff0c\u5c11\u8ce3\u591a\u8cb7\u3002<\/span><\/p>\n

(3)<\/strong><\/span> \u672c\u7cfb\u7d71\u6709\u56db\u53ea\u8a66\u7b97\u8868\u300e\u53f0\u80a1\u8da8\u52e2\u8ffd\u8e64\u5340<\/strong><\/span>\u300f\u3001\u300e\u53f0\u80a1\u8cb7\u8ce3\u770b\u677f<\/span><\/strong>\u300f\u3001\u300e\u7f8e\u80a1\u8da8\u52e2\u8ffd\u8e64\u5340<\/strong><\/span>\u300f\u8207\u300e\u7f8e\u80a1\u8cb7\u8ce3\u770b\u677f<\/strong><\/span>\u300f\uff0c\u4e26\u53ef\u4f9d\u6295\u8cc7\u8005\u7d93\u6fdf\u80fd\u529b\u9078\u64c7\u6295\u5165\u91d1\u984d\uff0c\u6c7a\u5b9a\u8cb7\u8ce3\u6578\u91cf\uff0c\u9069\u5408\u5e74\u8f15\u4eba\u9577\u671f\u6295\u8cc7\u3002<\/span><\/p>\n

(4)<\/span><\/strong> \u300e\u53f0\u80a1\/\u7f8e\u80a1\u8da8\u52e2\u8ffd\u8e64\u5340<\/strong><\/span>\u300f\u4fc2\u63d0\u4f9b\u89c0\u5bdf\u76ee\u524d\u8ffd\u8e64\u80a1\u7968\u7684\u8da8\u52e2\u8d70\u5411\uff0c\u53ef\u505a\u70ba\u8cb7\u8ce3\u80a1\u7968\u7684\u53c3\u8003\u4f9d\u64da\uff0c\u5176\u4e2d\u727d\u6d89\u5230\u67d0\u4e9b\u5c08\u9580\u8853\u8a9e\uff0c\u8acb\u591a\u7559\u610f\u3002<\/span><\/p>\n

(5)<\/span> <\/strong>\u300e\u53f0\u80a1\/\u7f8e\u80a1\u8cb7\u8ce3\u770b\u677f<\/strong><\/span>\u300f\u4fc2\u7cfb\u7d71\u4f9d\u7167\u8da8\u52e2\u8d70\u5411\u8a08\u7b97\u51fa\u8cb7\u8ce3\u7684\u50f9\u4f4d\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u53c3\u8003\u3002\u5b83\u7248\u9762\u8f03\u7c21\u6f54\u5bb9\u6613\u4e86\u89e3\u3002<\/span><\/p>\n

(6)<\/strong><\/span> \u672c\u7cfb\u7d71\u6709\u300e\u80a1\u50f9\u6ce2\u52d5\u7387\u00a0 K \u503c<\/strong><\/span>\u300f\u3001\u300e\u4ea4\u6613\u91cf\u6ce2\u52d5\u7387 L \u503c<\/strong><\/span>\u300f\u8207\u300e\u8cc7\u91d1\u57fa\u6578<\/span><\/strong>\u300f\u4e09\u500b\u91cd\u8981\u6307\u6a19\u3002\u300eK \u503c<\/span><\/strong>\u300f\u8868\u793a\u80a1\u7968\u9748\u6d3b\u5ea6(\u5982\u4e2d\u83ef\u96fb = 1.4\u3001\u4e2d\u4fe1\u91d1 = 4.2\u3001\u9d3b\u6d77 = 9.5) \uff0c\u300eL \u503c<\/span><\/strong>\u300f\u986f\u793a\u7576\u524d\u8a72\u80a1\u7968\u71b1\u7d61\u7684\u60c5\u6cc1\uff0c\u5169\u8005\u7684\u7bc4\u570d 1.0\u00a0 ~10.0 \u4e4b\u9593\uff0c\u4ee5 0.1 \u5206\u9694\u5340\u6bb5\u3002\u5c0d\u8a72\u80a1\u7968\u4e0d\u5f88\u5b70\u6089\uff0c\u5118\u53ef\u80fd\u63a1\u7528\u7cfb\u7d71\u5075\u503c\u3002\u53e6\u5916\u300e\u8cc7\u91d1\u57fa\u6578<\/strong><\/span>\u300f\u4e0d\u662f\u91d1\u984d\u3001\u4e5f\u4e0d\u662f\u80a1\u6578\uff0c\u662f\u8a08\u7b97\u8cb7\u8ce3\u80a1\u6578\u7684\u57fa\u6578\uff0c\u53ef\u8a2d\u5b9a\u4f7f\u7528\u8005\u5c0d\u8a72\u80a1\u7968\u6295\u8cc7\u898f\u6a21\u5927\u5c0f\uff0c\u672c\u7cfb\u7d71\u63d0\u4f9b\u8a08\u7b97\u5de5\u5177\u4f7f\u7528\u3002<\/span><\/p>\n

1-2 <\/u><\/strong>\u770b\u677f\u64cd\u4f5c\u9806\u5e8f<\/u><\/strong><\/span><\/p>\n

\u672c\u7cfb\u7d71\u4fc2\u63d0\u4f9b\u9577\u671f\u6295\u8cc7\u5b58\u80a1\u4f7f\u7528\uff0c\u4e26\u4e0d\u9069\u5408\u77ed\u7dda\u64cd\u4f5c\u8cfa\u53d6\u80a1\u50f9\u5dee\u984d\u3002\u56e0\u6b64\uff0c\u4e0d\u9700\u8981\u96a8\u6642\u76ef\u76e4\u770b\u80a1\u50f9\u884c\u60c5\uff0c\u4f46\u9808\u591a\u7559\u610f\u8ca1\u7d93\u65b0\u805e\uff0c\u5927\u7565\u4e86\u89e3\u5e02\u5834\u8d70\u5411\uff0c\u9078\u64c7\u6295\u8cc7\u5c0d\u8c61\u3002\u9078\u53d6\u6295\u8cc7\u6a19\u4e4b\u5f8c\uff0c\u5c07\u80a1\u7968\u865f\u78bc\u586b\u5165\u672c\u7cfb\u7d71\uff0c\u672c\u7cfb\u7d71\u6703\u96a8\u6642\u8ffd\u8e64\u5b83\u7684\u8da8\u52e2\u8d70\u5411\uff0c\u63d0\u4f9b\u8cb7\u8ce3\u8a0a\u606f\uff0c\u8b93\u4f7f\u7528\u8005\u4ee5\u300e\u5c0f\u788e\u6b65\u65b9\u5f0f\u300f\u6162\u6162\u7d2f\u9032\u5b58\u80a1\u3002<\/span><\/p>\n

\u4f7f\u7528\u672c\u7cfb\u7d71\u7684\u64cd\u4f5c\u9806\u5e8f\u5982\u4e0b\uff1a<\/span><\/p>\n

(1)<\/strong><\/span> \u5728\u300e\u53f0\u80a1\u8da8\u52e2\u8ffd\u8e64\u5340<\/strong><\/span>\u300f\u4e0a\u67e5\u95b1\u8a72\u80a1\u7968\u7684 \u300e\u80a1\u50f9\u6ce2\u52d5 K\u300f\u3001\u300e\u4ea4\u6613\u91cf\u6ce2\u52d5 L\u300f\u3001\u9577\u7a0b\u8da8\u52e2\u3001\u77ed\u7a0b\u8a3a\u65b7\u3001\u8da8\u52e2\u8d70\u5411\u3001\u3001\u3002<\/span><\/p>\n

(2)<\/strong> <\/span>\u7279\u5225\u7559\u610f\u300e\u8a0a\u865f\u8b8a\u5316<\/span><\/strong>\u300f\uff1a\u65b0\u89f8\u767c\u3001\u6301\u7e8c\u6216\u7d1a\u5225\u6539\u8b8a\uff0c\u4ee5\u53ca\u8a72\u8a0a\u865f\u5df2\u300e\u9023\u7e8c\u65e5\u6578\u300f\u3002<\/span><\/p>\n

(3)<\/span><\/strong> \u518d\u67e5\u95b1\u300e\u53f0\u80a1\u8cb7\u8ce3\u770b\u677f<\/span><\/strong>\u300f\uff0c\u8a72\u80a1\u7968\u7684\u8cb7\u5165\u9ede\u50f9\u4f4d\u8207\u8ce3\u51fa\u9ede\u50f9\u4f4d(\u5404\u63d0\u4f9b 3 \u500b\u4f4d\u7f6e)\uff0c\u4ee5\u53ca\u8ddd\u96e2\u591a\u5c11\u5143\u3002\u8cb7\u5165\u4e4b\u524d\u4e5f\u8acb\u53c3\u8003\u8a72\u80a1\u7968\u7684 EPS\u3001PE\u3001\u6b96\u5229\u7387\u8207 ROE (\u4e5f\u8a31\u67d0\u4e9b\u80a1\u7968\u4e0d\u63d0\u4f9b\u67e5\u95b1)\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u672c\u7cfb\u7d71\u4fc2\u5efa\u7acb\u5728 Google Sheet \u4e0a\uff0c\u4e26\u900f\u904e Google finance \u64f7\u53d6\u8b49\u4ea4\u6240\u8cc7\u6599\uff0c\u518d\u8a08\u7b97\u51fa\u6240\u9700\u7684\u6578\u64da\uff0c…<\/p>\n

Read More Read More<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1367","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/pages\/1367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/comments?post=1367"}],"version-history":[{"count":7,"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/pages\/1367\/revisions"}],"predecessor-version":[{"id":1386,"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/pages\/1367\/revisions\/1386"}],"wp:attachment":[{"href":"https:\/\/www.tsnien.idv.tw\/trade\/wp-json\/wp\/v2\/media?parent=1367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}