是否有一种方法来检索最近的公开市场日的股票价格数据与谷歌金融？

Question

我正在使用谷歌单张，并想知道最近的股票价格为计算的日期。目前我在用这个，

=GOOGLEFINANCE("NASDAQ:TSLA", "close",EOMONTH(today(),-1))

如果返回的日期不是公开市场日，我会收到一个错误消息。这很有道理。不过，我想返回最接近的市场开放日。不确定这是否可能。提前谢谢。

Answer 1

试一试

=index(sort(GOOGLEFINANCE("NASDAQ:TSLA", "close",today()-33,3),1,0),2,2)

的值减去30天或前一天的值(如果该天是假的)。

Answer 2

用途：

=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

​

​