|
In google sheets, if I want today's share price of AAPL, I can use: =GOOGLEFINANCE("AAPL")Per: Support > GOOGLEFINANCE That is not "today's share price" but the most recent price delayed by to 20 minutes. If any date parameters are specified, the request is considered historical and only the historical attributes are allowed. You could try combining two GOOGLEFINANCE formulas but you'd need to address the different types of results: =QUERY( { GOOGLEFINANCE("NASDAQ:AAPL", "price", "11/18/2024", 3); NOW(), GOOGLEFINANCE("AAPL") }, "Order by Col1 Desc", 1)
Shows how the formulas above can be used dynamically based on whether the end date is today. Returns historical close prices based on an end date and a maximum number of days (markets may not be open for all historical dates). Includes the current price if the end date is today. Sample values used: End date in A2 Max history in B2 =LET( dt,A2, td,dt=TODAY(), daze,B2-td, hist,REDUCE(1/0,SEQUENCE(3,1,,-1), LAMBDA(a,v, IF(ISERROR(a), GOOGLEFINANCE("NASDAQ:AAPL", "price", dt-daze, daze), a))), QUERY(IF(td,IFNA(VSTACK(hist,{dt,GOOGLEFINANCE("AAPL")})),hist), "Order by Col1 Desc", 1))Example using Today's date
Example using yesterday's date
|
