Googlefinance function in Sheets returning incorrect share price for ETF "USMV"?

231 views
Skip to first unread message

Joseph Wilson

unread,
Aug 28, 2017, 2:42:23 AM8/28/17
to Google Finance
Hello -- I have a very specific error to report. When using the googlefinance() function in Sheets to get the share price for the ETF named "USMV", it continues to return 189.75, even though a quick search via google search shows the share price around 49..

I don't have any other issues with the function to report -- any thoughts on what to do? I don't want to manually enter this one in?

Thanks!

Chris Rennick

unread,
Sep 14, 2017, 10:20:56 PM9/14/17
to Google Finance
I found that that ETF and others now have to be prefixed with BATS: to see the proper value.
Reply all
Reply to author
Forward
0 new messages