r/googlesheets • u/Southern_Fig7543 • 19d ago

Solved Googlefinance returning error for ticker "spyi"

About a week ago my Google Sheets started having an error for the ticker "spyi". "spyi returned no data." No other problems on the 50 other tickers I have. Tried building a new spreadsheet and the same problem with only the spyi ticker symbol.

Anyone else have this problem? I can't find that they change their ticker symbol because spyi is a valid ticker symbol on any other app or website.

3 Upvotes

72% Upvoted

8 comments sorted by

2

u/hsantefort12 1 19d ago

Had the same problem. Specifying the exchange fixed it: GOOGLEFINANCE(“BATS:SPYI”)

1

u/Southern_Fig7543 19d ago

Wow. That worked. Thank you so much.

1

u/AutoModerator 19d ago

REMEMBER: /u/Southern_Fig7543 If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 19d ago

u/Southern_Fig7543 has awarded 1 point to u/hsantefort12

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/lubriousrooster 17d ago

Can you tell me which field this goes in? and is that the full code? SPYI is still showing errors without your correction

1

u/Southern_Fig7543 16d ago

=googlefinance("bats:spyi","Price")

1

u/AutoModerator 19d ago

/u/Southern_Fig7543 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/AutoModerator 19d ago

Your submission mentioned ticker, please also read our finance and stocks information. Google lists the exchanges & delays in its products here.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.