search

business-science / tidyquant

Bringing financial analysis to the tidyverse
https://business-science.github.io/tidyquant/
Other
854 stars 175 forks source link

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

Open ogig33 opened 3 years ago

ogig33 commented 3 years ago

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:

pauleeeeee commented 1 year ago

I also have this issue