quandl.py 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. '''Module containing a handful of methods for
  2. aggregating data from markets throughout the world'''
  3. import requests
  4. import json
  5. def fetchData(apikey, url):
  6. '''Returns JSON data of the Dow Jones Average.'''
  7. parameters = {'rows' : 1, 'auth_token' : apikey}
  8. req = requests.get(url, params=parameters)
  9. data = json.loads(req.content)
  10. parsedData = []
  11. stockData = {}
  12. for datum in data:
  13. stockData['name'] = data['name']
  14. stockData['description'] = data['description']
  15. stockData['data'] = data['data']
  16. stockData['code'] = data['code']
  17. parsedData.append(stockData)
  18. return parsedData
  19. def dowjonesIndustrialAvg(apikey):
  20. '''Returns JSON data of the Dow Jones Average.'''
  21. parameters = {'rows' : 1, 'auth_token' : apikey}
  22. apiurl = 'https://www.quandl.com/api/v1/datasets/BCB/UDJIAD1.json?'
  23. req = requests.get(apiurl, params=parameters)
  24. data = json.loads(req.content)
  25. parsedData = []
  26. stockData = {}
  27. for datum in data:
  28. stockData['name'] = data['name']
  29. stockData['description'] = data['description']
  30. stockData['data'] = data['data']
  31. stockData['code'] = data['code']
  32. parsedData.append(stockData)
  33. return parsedData
  34. def snp500IndexPull(apikey):
  35. '''Returns JSON data of the S&P 500 Index.'''
  36. parameters = {'rows' : 1, 'auth_token' : apikey}
  37. apiurl = 'https://www.quandl.com/api/v1/datasets/YAHOO/INDEX_GSPC.json?'
  38. req = requests.get(apiurl, params=parameters)
  39. data = json.loads(req.content)
  40. parsedData = []
  41. stockData = {}
  42. for datum in data:
  43. stockData['name'] = data['name']
  44. stockData['description'] = data['description']
  45. stockData['data'] = data['data']
  46. stockData['code'] = data['code']
  47. parsedData.append(stockData)
  48. return parsedData
  49. def nasdaqPull(apikey):
  50. '''Returns JSON data of the Nasdaq Index.'''
  51. parameters = {'rows' : 1, 'auth_token' : apikey}
  52. apiurl = 'https://www.quandl.com/api/v1/datasets/NASDAQOMX/COMP.json?'
  53. req = requests.get(apiurl, params=parameters)
  54. data = json.loads(req.content)
  55. parsedData = []
  56. stockData = {}
  57. for datum in data:
  58. stockData['name'] = data['name']
  59. stockData['description'] = data['description']
  60. stockData['data'] = data['data']
  61. stockData['code'] = data['code']
  62. parsedData.append(stockData)
  63. return parsedData