for key in userdic[self.mytview.username].stockdic:
print ("stockname : "+userdic[self.mytview.username].stockdic[key].stockname)
print ("stock shares : "+str(userdic[self.mytview.username].stockdic[key].shares))
elif (self.mytview.viewchoice=='ae'):
print (userdic[self.mytview.username].amountearn)
elif (self.mytview.viewchoice=='al'):
print (userdic[self.mytview.username].amountloss)
elif (self.mytview.viewchoice=='l'):
print (userdic[self.mytview.username].liquidcash())
tdatabase=Database('ttrader')
'''
tdatabase.connect()
tdatabase.cursor()
tdatabase.curs.execute("CREATE TABLE 'Transactions' ('id' INTEGER,'Username' VARCHAR,'Transaction_Type' VARCHAR, 'Stockname' VARCHAR, 'Transaction_Shares' INTEGER, 'Transaction_Amount' REAL, 'Transaction_Stock_Price' REAL, 'Transaction_Time' TEXT, PRIMARY KEY ('id'))")
tdatabase.curs.execute("CREATE TABLE 'Portfolio'('id' INTEGER,'Username' VARCHAR,'Stockname' VARCHAR, 'Stock_Shares' INTEGER, PRIMARY KEY ('id'))")
tdatabase.commit()
tdatabase.close_connection()
'''
''' else:
tdatabase.connect()
tdatabase.cursor()
mystring="SELECT * FROM Portfolio WHERE Username='******'".format(self.username)
