-
Notifications
You must be signed in to change notification settings - Fork 0
/
portfolioAnalysis.py
45 lines (41 loc) · 1.63 KB
/
portfolioAnalysis.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
from companyAnalysis import predictor
from dbAccess import dbAccessor
import operator
class portfolioPredictor:
def __init__(self):
self.companyPredic = predictor()
self.userId = None
self.allStocks = None
def categorizePortfolio(self,stockList):
companyAnan = []
companyDict = {}
for row in stockList:
prediction = self.companyPredic.getAnalysis(row[1]) #row[1] contains company symbol
companyAnan.append([prediction,row[7]])
for row in companyAnan:
if companyDict.get(row[1]):
if row[0] == 'BUY':
companyDict[row[1]] += 1
elif row[0] == 'SELL':
companyDict[row[1]] -= 1
else:
if row[0] == 'BUY':
companyDict[row[1]] = 1
elif row[0] == 'SELL':
companyDict[row[1]] = -1
else :
companyDict[row[1]] = 0
return companyDict
def getPortfolioAnalysis(self,userId):
self.userId = userId
db = dbAccessor()
self.allStocks = db.getInvestments(self.userId)
t1 = self.categorizePortfolio(self.allStocks)
return sorted(t1.items(), reverse=True, key= operator.itemgetter(1))
def getTopPerformers(self, category = 'all', top = True):
db = dbAccessor()
companiesReturn = []
companyList = db.companiesOfType()
for row in companyList:
companiesReturn.append( (row[1],self.companyPredic.getMonthlyReturns(row[2])) )
return sorted(companiesReturn, reverse=top, key= lambda x: x[1])