angelorcc

QUANDL

Dec 1st, 2019
225
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.89 KB | None | 0 0
  1. stocks=['EOD/AAPL','EOD/MSFT','EOD/TSLA' ]
  2. data=quandl.get(stocks,start_date="2015-12-31", end_date="2016-06-31", authtoken="5KykojjZ5rxPgKnV_8rL")
  3. data
  4.  
  5. OUTPUT
  6.  
  7. ---------------------------------------------------------------------------
  8. InvalidRequestError Traceback (most recent call last)
  9. <ipython-input-10-1af7ef2a7053> in <module>
  10. 1 # importing muliple stock code
  11. 2 stocks=['EOD/AAPL','EOD/MSFT','EOD/TSLA' ]
  12. ----> 3 data=quandl.get(stocks,start_date="2015-12-31", end_date="2016-06-31", authtoken="5KykojjZ5rxPgKnV_8rL")
  13. 4 data
  14.  
  15. /anaconda3/lib/python3.7/site-packages/quandl/get.py in get(dataset, **kwargs)
  16. 54 data = MergedDataset(args).data(params=kwargs,
  17. 55 handle_not_found_error=True,
  18. ---> 56 handle_column_not_found=True)
  19. 57 # If wrong format
  20. 58 else:
  21.  
  22. /anaconda3/lib/python3.7/site-packages/quandl/model/merged_dataset.py in data(self, **options)
  23. 34 # else fetch all the data and filter column indexes requested locally
  24. 35 dataset_data_list = [self._get_dataset_data(dataset, **options)
  25. ---> 36 for dataset in self.__dataset_objects__()]
  26. 37
  27. 38 # build data frames and filter locally when necessary
  28.  
  29. /anaconda3/lib/python3.7/site-packages/quandl/model/merged_dataset.py in <listcomp>(.0)
  30. 34 # else fetch all the data and filter column indexes requested locally
  31. 35 dataset_data_list = [self._get_dataset_data(dataset, **options)
  32. ---> 36 for dataset in self.__dataset_objects__()]
  33. 37
  34. 38 # build data frames and filter locally when necessary
  35.  
  36. /anaconda3/lib/python3.7/site-packages/quandl/model/merged_dataset.py in _get_dataset_data(self, dataset, **options)
  37. 71 updated_options = options.copy()
  38. 72 updated_options = Util.merge_options('params', params, **updated_options)
  39. ---> 73 return dataset.data(**updated_options)
  40. 74
  41. 75 def _build_data_meta(self, dataset_data_list, df):
  42.  
  43. /anaconda3/lib/python3.7/site-packages/quandl/model/dataset.py in data(self, **options)
  44. 45 updated_options = Util.merge_options('params', params, **options)
  45. 46 try:
  46. ---> 47 return Data.all(**updated_options)
  47. 48 except NotFoundError:
  48. 49 if handle_not_found_error:
  49.  
  50. /anaconda3/lib/python3.7/site-packages/quandl/operations/list.py in all(cls, **options)
  51. 13 options['params'] = {}
  52. 14 path = Util.constructed_path(cls.list_path(), options['params'])
  53. ---> 15 r = Connection.request('get', path, **options)
  54. 16 response_data = r.json()
  55. 17 Util.convert_to_dates(response_data)
  56.  
  57. /anaconda3/lib/python3.7/site-packages/quandl/connection.py in request(cls, http_verb, url, **options)
  58. 36 abs_url = '%s/%s' % (ApiConfig.api_base, url)
  59. 37
  60. ---> 38 return cls.execute_request(http_verb, abs_url, **options)
  61. 39
  62. 40 @classmethod
  63.  
  64. /anaconda3/lib/python3.7/site-packages/quandl/connection.py in execute_request(cls, http_verb, url, **options)
  65. 48 **options)
  66. 49 if response.status_code < 200 or response.status_code >= 300:
  67. ---> 50 cls.handle_api_error(response)
  68. 51 else:
  69. 52 return response
  70.  
  71. /anaconda3/lib/python3.7/site-packages/quandl/connection.py in handle_api_error(cls, resp)
  72. 112 klass = d_klass.get(code_letter, QuandlError)
  73. 113
  74. --> 114 raise klass(message, resp.status_code, resp.text, resp.headers, code)
  75.  
  76. InvalidRequestError: (Status 422) (Quandl Error QESx04) You have submitted incorrect query parameters. Please check your API call syntax and try again.
Advertisement
Add Comment
Please, Sign In to add comment