def main(argv):
db = dbConnector("test")
try:
table = db.getTable(argv[0])
except :
print 'WRONG TABLE NAME.'
for element in table:
doc=table[element]
print '------------------------------------------------------------------------------------------------'
print doc['texto']
def dashboard():
if request.method == 'GET':
global symbol
connector = db.dbConnector()
connection = connector.createConnection()
scrapedStocks = connector.getMentions(connection)
symbols = []
for x in scrapedStocks:
symbols.append(x['symbol'])
this = datetime.datetime.today() - timedelta(days=5)
time = str(this.year) + "-" + str(this.month) + "-" + str(
this.day) + " " + str(datetime.time(9, 35))
day = str(this.year) + "-" + str(this.month) + "-" + str(this.day)
print(day)
trades = connector.getTradeRecents(connection, time)
trades = trades[0:25]
stonks = connector.getBarsByTime(connection, time)
stonks = stonks[0:25]
results = connector.getResultsByDate(connection, day)
for x in results:
diff = x['endCash'] - x['startCash']
percentChange = diff / floaty(x['startCash']) + 1
x['percentChange'] = percentChange
strategy = ad.Strategy()
hammerChanges = strategy.calculateProfits(connector, connection,
'hammer')
morningStarChanges = strategy.calculateProfits(connector, connection,
'morningStar')
senkouBChanges = strategy.calculateProfits(connector, connection,
'senkouB_')
if request.method == 'POST':
symbol = request.form.get('symbol')
df = api.polygon.historic_agg_v2(symbol,
1,
'minute',
_from='2020-07-01',
to='2020-07-01').df
df['timestamp'] = df.index
df = df.reset_index(drop=True)
return render_template('graph.html', df=df.to_json(), symbol=symbol)
return render_template('dashboard_copy.html',
symbols=symbols,
trades=trades,
stonks=stonks,
results=results,
hammerChanges=hammerChanges,
morningStarChanges=morningStarChanges,
senkouBChanges=senkouBChanges)
import alpaca_trade_api as tradeapi
import csv
from numpy import float as floaty
ALPACA_KEY_ID = 'PK3VZLXGJAE5FPVLWCOU'
ALPACA_SECRET_KEY = r'NtLnmeY6PtUpPXD2kGblhezLg/6f4lHqEcIqrR/3'
api = tradeapi.REST(key_id=ALPACA_KEY_ID,
secret_key=ALPACA_SECRET_KEY,
base_url='https://paper-api.alpaca.markets')
if __name__ == "__main__":
fromTime = "06-01-2017"
toTime = "06-30-2017"
connector = db.dbConnector()
connection = connector.createConnection()
symbols = connector.getAllDistinctMentions(connection)
symbols = symbols[0:700]
print(len(symbols))
stocks = []
takeProfit = 1.03
takeLoss = .985
filename = "/Users/ryangould/Desktop/hammerTradeTrainData.csv"
fields = [
"takeLoss", "takeProfit", "SMA", "tailLength", "volume", "hourOfBuy",
"minuteOfBuy", "profitable"
]
for x in symbols:
stocks.append(x['symbol'])
positions = bt.algoStart(api, stocks, fromTime, toTime, 25000)
import dbConnector
from custom_validators import height_validator, weight_validator
import requests
import json
from flask import Flask, render_template, flash, request
from wtforms import Form, TextField, validators, SubmitField, SelectField, IntegerField
db = dbConnector.dbConnector()
db.build_table()
app = Flask(__name__)
app.config.from_object(__name__)
app.config['SECRET_KEY'] = 'SeCrEt'
class Questionnaire(Form):
nombreunidadproductiva = TextField('Nombre_unidad_productiva:',
[validators.InputRequired()])
callenumero = TextField('Calle_y_numero:', [validators.InputRequired()])
localidad = TextField('Localidad:', [validators.InputRequired()])
rubro = TextField('Rubro:', [validators.InputRequired()])
aniorecuperacion = IntegerField('Año_de_recuperacion:',
[validators.InputRequired()])
feelings_options = requests.get('http://localhost:8081/categories').json()
feelings_options2 = requests.get(
'http://localhost:8081/categories/1/subcategories').json()
feelings_options3 = requests.get(
'http://localhost:8081/business-area').json()
if __name__ == '__main__':
__CRITERIASFILE__ = '../../static/DATA/criterias.xml'
__OUTPUTFILE__ = '../../static/DATA/data.tab'
ta = TextAnalyser(__CRITERIASFILE__)
serFile = TextFileWriter()
#StringIO is an objet that kinda works like a file
ofile = StringIO()
print 'Creation of the file:'
ofile.write(ta.createTabHeader())
db = dbConnector("test")
print '\t- Manchetes...'
table = db.getTable("manchete")
if table != None:
for element in table:
try:
ofile.write(ta.passTheCriterias(table[element]['titulo'],"manchete"))
except:
pass
else:
print ' --> No record in the table'
print '\t- Noticia...'
table = db.getTable("noticia")
if table != None:
for element in table:
# -*- coding: utf-8 -*-
from dbConnector import dbConnector
from models.Models import School,Student,Admin
if __name__ == '__main__':
students = None
schools = None
db = dbConnector("jogodojornal")
print "--> Students..."
aStudent = Student(_id="Damien",grade="9th grade")
aStudent = Student(_id="Chuck",grade="9th grade")
aStudent = Student(_id="Pedro",grade="9th grade")
aStudent = Student(_id="Didier",grade="9th grade")
print aStudent
print '--> Schools...'
if not db.has("schools"):
db.createTable('schools')
schools = db.getTable('schools')
aSchool = School(name="Escola Santa Clara" ,password='******',studentPassword='******',email='*****@*****.**')
aSchool.addStudent(aStudent)
aSchool.store(schools)
print '--> Admin...'
anAdmin = Admin(name='damien' , email = '*****@*****.**', password = '******')
if not db.has('admins-jogodojornal'):
db.createTable('admins-jogodojornal')
def __init__(self):
self.db_connector = dbConnector()
self.notifier = Notifier()
