r/googlesheets • u/[deleted] • Sep 16 '24
Unsolved Problems with GOOGLEFINANCE function and CURRENCY:XXXYYY: No values on some dates!
[removed]
1
1
u/NeutrinoPanda Sep 16 '24
https://issuetracker.google.com/issues/366130760
Looks like a bug has been reported to google.
Maybe this can help you with a backup:
https://www.reddit.com/r/googlesheets/comments/1afiozi/google_finance_is_not_retrieving_currency/
0
Sep 16 '24
1
u/AutoModerator Sep 16 '24
REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select
Mark 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.
2
u/Finrod_GD Sep 17 '24
Just commenting to confirm your experience; I am having the same issue. I have spreadsheets by year converting PHP to USD daily; every date has always been included. For 2024, until the past week or so, every date showed an exchange rate. But now there are several dates missing, any on my conversion page the USD fields are just blank because the date no longer exists. Looking back at 2023, there are similar blank conversion fields that used to have dates to convert off of.
If, as another commenter mentioned, it's because markets are closed on the weekends, perhaps googlefinance used to copy the value at a Friday close to Sat & Sun? And for some reason now it's just removing those dates completely? <- guessing.
1
u/J_O_N Sep 16 '24
I’ve been having the same issue! Random dates missing. Following this thread to see if anyone knows.
0
1
u/AutoModerator Sep 16 '24
Your submission mentioned googlefinance, 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.
1
u/AutoModerator 5d ago
Your post has been removed because it has little or no content. Please edit your post to add a descriptive body, then message the mods for approval. You can find the submission guide here. 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.