請問盤後板有沒有財務資料靜態分析或財務資料動態分析
如以下這些


1522 堤維西 2006/02/06財務資料靜態分析

盈利能力
淨資產收益率 = 淨利潤/股東權益 = -10.54/-8.00 = 0.00%
總資產收益率 = 淨利潤/總資產 = -10.54/15338.00 = -0.07%
淨利潤率 = 淨利潤/主營業務收入 = -10.54/5.01 = -210.37%
主營業務利潤率 = 主營業務利潤/主營業務收入 = -0.76/5.01 = -15.15%
總資產周轉率 = 主營業務收入/總資產 = 5.01/15338.00 = 0.03%

償債能力
流動比率 = 流動資產/流動負債 = 87322.00/0.00 = 0.00
流動資產對負債總額比率 = 流動資產/總負債 = 87322.00/-3.00 = 0.00
淨營運資金 = 流動資產-流動負債 = 87322.00-0.00 = 87322.00(千元)

單股指標
每股收益 = 1.25Ｍ 每股公積金 = 0.00
每股淨資產 = 18.33 調整後每股淨資產 = -6.80
每股主營收入 = 主營業務收入/總股本 = 5.01/10/2426.00 = 0.00
市盈率 = 每股市價/每股收益 = 22.40/1.67 = 13.44
淨資產倍率 = 每股市價/每股淨資產 = 22.40/18.33 = 1.22
潛損比率 = (每股淨資產-調整後每股淨資產)/每股淨資產 = (18.33--6.80)/18.33 = 137.10%

資本結構
股東權益比率 = 股東權益/總資產 = -8.00/15338.00 = -0.05%
資產負債比率 = 總負債/總資產 = (-3.00+0.00)/15338.00 = -0.02%
長期負債比率 = 長期負債/總資產 = -3.00/15338.00 = -0.02%
債務資本比率 = 總負債/股東權益 = (-3.00+0.00)/-8.00 = 0.00%
長期資產對長期資金比率 = (總資產-流動資產)/(長期負債+股東權益) = -71984.00/-11.00 = 0.00%
股東權益與固定資產比率 = 股東權益/固定資產 = -8.00/105.00 = -7.62%
固定資產比率 = 固定資產/總資產 = 105.00/15338.00 = 0.68%

股本結構
流通股比例 = 流通股/總股本 = 2426.00/2426.00 = 100.00%
國家股比例 = 國家股/總股本 = 8801.00/2426.00 = 362.78%
法人股比例 = (發起法人股+法人股)/總股本 = (112.00+15119.00)/2426.00 = 627.82%

現金流
現金比率 = 現金及等價物/流動負債 = 0.00/0.00 = 0.00
每股經營現金 = 經營現金流量/總股本 = 0.00/10/2426.00 = 0.00
資產現金回收率 = (經營現金流入+投資現金流入)/總資產 = (0.00+0.00)/15338.00 = 0.00
經營流入流出比 = 經營現金流入/經營現金流出 = 0.00/0.00 = 0.00
投資流入流出比 = 投資現金流入/投資現金流出 = 0.00/0.00 = 0.00
籌資流入流出比 = 籌資現金流入/籌資現金流出 = 0.00/0.00 = 0.00
經營流入比例 = 經營現金流入/總現金流入 = 0.00/0.00 = 0.00
投資流入比例 = 投資現金流入/總現金流入 = 0.00/0.00 = 0.00
籌資流入比例 = 籌資現金流入/總現金流入 = 0.00/0.00 = 0.00
經營流出比例 = 經營現金流出/總現金流出 = 0.00/0.00 = 0.00
投資流出比例 = 投資現金流出/總現金流出 = 0.00/0.00 = 0.00
籌資流出比例 = 籌資現金流出/總現金流出 = 0.00/0.00 = 0.00

您好目前盤後版有提供季的財務數據。

1101 台　泥 2005/09/30 財務數據靜態分析償債分析
流動比率 = 流動資產 ÷ 流動負債 = 17276428 ÷ 10998894 = 157.07%負債比率 = 負債總額 ÷ 資產總額 = 38618268 ÷ 93650952 = 41.24%現金比率 = 現金 ÷ 流動資產 = 6250793 ÷ 17276428 = 36.18%速動比率 = 147.69%利息保障倍數(累計) = 16.86%經營獲利營業毛利率 = 營業毛利 ÷ 營業收入 = 2270291 ÷ 20830048 = 10.90%營業淨利率 = 營業淨利 ÷ 營業收入 = 1805445 ÷ 20830048 = 8.67%稅前淨利率 = 稅前淨利 ÷ 營業收入 = 5420368 ÷ 20830048 = 26.02%稅後淨利率 = 稅後淨利 ÷ 營業收入 = 5034599 ÷ 20830048 = 24.17%稅前淨值報酬率 = 稅前淨利 ÷ (資產總額-負債總額) = 5420368 ÷ (93650952-38618268) = 9.85%稅後淨值報酬率 = 稅後淨利 ÷ (資產總額-負債總額) = 5034599 ÷ (93650952-38618268) = 9.15%總資產報酬率 = 稅前淨利 ÷ 資產總額 = 5420368 ÷ 93650952 = 5.79%固定資產周轉率 = 營業收入 ÷ 固定資產 = 20830048 ÷ 42467000 = 0.49(倍)應收帳款周轉率 = 6.55(倍)存貨周轉率 = 21.22(倍)應收帳款收現天數 = 360 ÷ 應收帳款周轉率 = 54.96(天)存貨周轉天數 = 360 ÷ 存貨周轉率 = 16.97(天)資本結構負債對總資產比率 = 負債總額 ÷ 資產總額 = 38618268 ÷ 93650952 = 0.41(倍)股東權益對總資產比率 = 股東權益 ÷ 資產總額 = 55032684 ÷ 93650952 = 0.59(倍)負債對股東權益比率 = 負債總額 ÷ 股東權益 = 38618268 ÷ 55032684 = 0.70(倍)流動資產對總資產比率 = 流動資產 ÷ 資產總額 = 17276428 ÷ 93650952 = 0.18(倍)固定資產對總資產比率 = 固定資產 ÷ 資產總額 = 42467000 ÷ 93650952 = 0.45(倍)長期負債對總資產比率 = 長期負債 ÷ 資產總額 = 20223344 ÷ 93650952 = 0.22(倍)流動資產對總負債比率 = 流動資產 ÷ 負債總額 = 17276428 ÷ 38618268 = 0.45(倍)流動負債對總負債比率 = 流動負債 ÷ 負債總額 = 10998894 ÷ 93650952 = 0.28(倍)股東權益對固定資產比率 = 股東權益 ÷ 固定資產 = 55032684 ÷ 42467000 = 1.30(倍)長期資金對固定資產比率 = (長期負債 + 股東權益) ÷ 固定資產 = (20223344 + 55032684) ÷ 42467000 = 1.77(倍)現金流量現金流量比率 = 營業活動現金流量 ÷ 流動負債 = 5822955 ÷ 10998894 = 0.53(倍)每股現金流量 = 營業活動現金流量 ÷ 期末股本 = 5822955000 ÷ 2949351200 = 1.97(元)營業活動現金流量對總負債比率 = 營業活動現金流量 ÷ 負債總額 = 5822955 ÷ 38618268 = 0.15(倍)每股比率每股營業收入 = 營業收入 ÷ 期末股本 = 20830048000 ÷ 2949351200 = 7.06(元)每股營業淨利 = 營業淨利 ÷ 期末股本 = 1805445000 ÷ 2949351200 = 0.61(元)每股稅前淨利 = 稅前淨利 ÷ 期末股本 = 5420368000 ÷ 2949351200 = 1.84(元)每股稅後淨利 = 稅後淨利 ÷ 期末股本 = 5034599000 ÷ 2949351200 = 1.71(元)每股負債 = 負債總額 ÷ 期末股本 = 38618268000 ÷ 2949351200 = 13.09(元)每股淨值 = (資產總額-負債總額) ÷ 期末股本(股) = (93650952000 - 38618268000) ÷ 2949351200 = 18.66(元)本益比(預估) = 每股市價 ÷ 每股盈餘(預估) = 24.50 ÷ 0.00 = 0.00(倍)期末股本 = 2949351200(股)

謝謝回覆
是這麼亂嗎?
有沒有辦法提取,作為數據公式選股之用?

可用插入函數，財務數據
FINANCE(n)