我正在使用谷歌表格，想知道計算出的日期的最新股票價格。目前我正在使用這個，
=GOOGLEFINANCE("NASDAQ:TSLA", "close",EOMONTH(today(),-1))
如果它回傳的日期不是公開市場日，我會收到錯誤訊息。這是有道理的。然而，我想回傳最近的市場開放日。不確定這是否可能。提前致謝。
uj5u.com熱心網友回復：
嘗試
=query(GOOGLEFINANCE("NASDAQ:TSLA", "close",EOMONTH(today(),-1)-3,3),"select * order by Col1 desc limit 1",0)
或者
=index(query(GOOGLEFINANCE("NASDAQ:TSLA", "close",EOMONTH(today(),-1)-3,3),"select * order by Col1 desc limit 1",0),1,2)
uj5u.com熱心網友回復：
嘗試
=index(sort(GOOGLEFINANCE("NASDAQ:TSLA", "close",today()-33,3),1,0),2,2)
為今天減去 30 天的值，如果當天休息，則為之前的值
uj5u.com熱心網友回復：
用：
=VLOOKUP(IF(ABS((LARGE(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)), COUNTIF(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)),">"&
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00") 1))-(
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00"))<ABS((SMALL(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)), COUNTIF(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)),"<"&
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00") 1))-(
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00")), LARGE(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)), COUNTIF(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)),">"&
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00") 1), SMALL(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)), COUNTIF(
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)),"<"&
DATE(YEAR(TODAY()), MONTH(TODAY())-1, DAY(TODAY())) "16:00") 1)),
GOOGLEFINANCE("NASDAQ:TSLA", "CLOSE", EOMONTH(TODAY(), -2) 1, EOMONTH(TODAY(), -1)), 2, 0)
- 今天和明天這會給你 B8
- 3日這會給你B9
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/343973.html