Hi,
I just wanted to check if anyone else was having the same issue as me in downloading the WTI Crude oil prices as demonstrated in the quandl demo notebook.
I have obtained an API key and stored it in a .env file which I bring in to the notebook. I then run the below code:
api_key = os.environ[‘QUANDL_API_KEY’]
oil = quandl.get(‘EIA/PET_RWTC_D’, api_key=api_key).squeeze()
And obtain:
NotFoundError Traceback (most recent call last)
Cell In[11], line 2
1 api_key = os.environ[‘QUANDL_API_KEY’]
----> 2 oil = quandl.get(‘EIA/PET_RWTC_D’, api_key=api_key).squeeze()
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/get.py:48, in get(dataset, **kwargs)
46 if dataset_args[‘column_index’] is not None:
47 kwargs.update({‘column_index’: dataset_args[‘column_index’]})
—> 48 data = Dataset(dataset_args[‘code’]).data(params=kwargs, handle_column_not_found=True)
49 # Array
50 elif isinstance(dataset, list):
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/model/dataset.py:47, in Dataset.data(self, **options)
45 updated_options = Util.merge_options(‘params’, params, **options)
46 try:
—> 47 return Data.all(**updated_options)
48 except NotFoundError:
49 if handle_not_found_error:
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/operations/list.py:15, in ListOperation.all(cls, **options)
13 options[‘params’] = {}
14 path = Util.constructed_path(cls.list_path(), options[‘params’])
—> 15 r = Connection.request(‘get’, path, **options)
16 response_data = r.json()
17 Util.convert_to_dates(response_data)
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/connection.py:38, in Connection.request(cls, http_verb, url, **options)
34 options[‘headers’] = headers
36 abs_url = ‘%s/%s’ % (ApiConfig.api_base, url)
—> 38 return cls.execute_request(http_verb, abs_url, **options)
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/connection.py:47, in Connection.execute_request(cls, http_verb, url, **options)
45 response = session.request(method=http_verb, url=url, **options)
46 if response.status_code < 200 or response.status_code >= 300:
—> 47 cls.handle_api_error(response)
48 else:
49 return response
File ~/anaconda3/envs/ml4t/lib/python3.8/site-packages/quandl/connection.py:111, in Connection.handle_api_error(cls, resp)
100 d_klass = {
101 ‘L’: LimitExceededError,
102 ‘M’: InternalServerError,
(…)
107 ‘X’: ServiceUnavailableError
108 }
109 klass = d_klass.get(code_letter, QuandlError)
→ 111 raise klass(message, resp.status_code, resp.text, resp.headers, code)
NotFoundError: (Status 404) (Quandl Error QECx02) You have submitted an incorrect Dataset code. Please check your Dataset codes and try again.
I have checked online and EIA/PET_RWTC_D still seems to be the correct code.