Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

tq_get with Alphavantage returns warning when using OVERVIEW and other functions #209

Open
ogig33 opened this issue Oct 30, 2021 · 1 comment

Comments

@ogig33
Copy link

ogig33 commented Oct 30, 2021

I am trying to load fundamental data from Alphavantage API, e.g. by using the OVERVIEW function. However, the returned object is empty. The stock time series functions work fine.
The identical function works just fine in a REST client: https://www.alphavantage.co/query?function=OVERVIEW&symbol=FB&apikey=removedmykey

My code:

library(tidyquant)
av_api_key("removedmykey")
av_data <- tq_get("FB", get = "alphavantager", av_fun = "OVERVIEW")
print(av_data)

Output with warnings and empty result:

## Warning: x = 'FB', get = 'alphavantager': Error: FB. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYCommon Stock. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYFacebook Inc. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYFacebook, Inc., is an American multinational technology conglomerate based in Menlo Park, California. It is one of the world's most valuable companies. It is considered one of the Big Five companies in U.S. information technology, with Google, Apple, Microsoft and Amazon. Facebook offers other products and services beyond its social networking platform, including Facebook Messenger, Facebook Watch, and Facebook Portal. It also has acquired Instagram, WhatsApp, Oculus, Giphy and Mapillary, and has a 9.9% stake in Jio Platforms.. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY1326801. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNASDAQ. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYUSD. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYUSA. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYTECHNOLOGY. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYSERVICES-COMPUTER PROGRAMMING, DATA PROCESSING, ETC.. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY1601 WILLOW ROAD, MENLO PARK, CA, US. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYDecember. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY2021-09-30. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY900094099000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY54758998000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY23.16. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.803. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY47.75. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNone. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY13.97. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY39.59. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.359. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.418. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.186. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.321. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY112329998000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY69273000000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY13.97. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.188. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.351. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY403.74. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY23.16. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY20.16. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY8.01. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY6.59. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY7.42. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY15.21. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY1.322. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY384.33. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY244.61. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY340.94. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY340.42. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY2366280000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY2340545000. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY23914900. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY25835300. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY1.1. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.01. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.0101. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0.6. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY81.25. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY0. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNone. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNone. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNone. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETYNone. API parameters used: symbol=FB, function=OVERVIEW, apikey=HIDDEN_FOR_YOUR_SAFETY
## [1] NA

My specs:

  • macOS 12.0.1
  • RStudio 2021.09.0
  • tidyquant: 1.0.3
@pauleeeeee
Copy link

I also have this issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants