CODEWITHSUNDEEP
google-sheetsgoogle-finance
HEKTO
HEKTO

Reputation: 4191

Google Sheets Financial API - dates are wrong

I'm using Google Sheets for tracking my mutual funds portfolio, and I'm supposed to call the function below to get the timestamp of the most recent change of the VASIX fund share price:

=GOOGLEFINANCE("VASIX", "date")

The problem is that the date, returned by this function, is typically two-three days late.

What might be wrong here?

Upvotes: 1

Views: 374

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

GOOGLEFINANCE("VASIX", "date") returns The date at which the net asset value was reported. For mutual funds this is at market close on trading days. So, for example, Sat. would show the market close on Fri. The date won't change again until Tue. when Mondays NAV is reoported. Try =GOOGLEFINANCE("VASIX", "close","8/25/2017") requesting specific dates over a weekend through Tuesday to see what is happening.

Upvotes: 1

Related Questions