__author__ = 'gio'
from sqlalchemy import create_engine
engine = create_engine('postgresql://localhost/gio')
import matplotlib.pyplot as plt
from pydatastream import Datastream
DWE = Datastream(username="******", password="******")
data = DWE.get_price('@AAPL', date_from='2008', date_to='2016')
print data.head()
plt.plot(data['P'])
plt.ylabel('Apple')
plt.show()
import pg8000
from pydatastream import Datastream
DWE = Datastream(username="******", password="******")
conn = pg8000.connect(user="******", password="")
cursor = conn.cursor()
cursor.execute("SELECT isin FROM TRIAL1")
results = cursor.fetchall()
print(results)
b = type(results)
print (b)
for item in results:
print (item)
DWE.raise_on_error = False
data = DWE.get_price(item, date_from='2008', date_to='2016')
a = type (data)
print (a)
print(data)
