GoogleFinance 查詢台股

使用google 試算表的GoogleFinance公式，取得台股價格 取得大盤現在股價 =GoogleFinance("TPE:TAIEX","PRICE") 取得個股現在股價 =GoogleFinance("TPE:1101","PRICE") 1101是股票代碼 取得昨天收盤價 =GoogleFinance("TPE:1101","closeyest") 取得EPS =GoogleFinance("TPE:1101","EPS") 取得本益比 =GoogleFinance("TPE:1101","PE")