Example #1
0
def indicator_reference():
    check_if_logged_in()
    populate_cookie(session['user_id'])

    print session['indicator']
    indicator_ref = CreateForm('indicator_ref', session['indicator'])

    if request.method == 'POST' and indicator_ref.validate():

        # If the indicators are identical
        if indicator_ref.ind_1.data == indicator_ref.ind_2.data:
            flash('You must choose two different indicators!')
            return render_template('indicator_reference.html',
                                   form=indicator_ref)

        start_date = '01-{}-{}'.format(indicator_ref.start_month.data,
                                       str(indicator_ref.start_year.data))
        row = [start_date,
               '01-mar-2013',
               indicator_ref.ind_1.data,
               indicator_ref.ind_2.data,
               indicator_ref.action.data,
               indicator_ref.operator.data,
               indicator_ref.action_security.data,
               indicator_ref.share_amount.data,
               indicator_ref.allocation.data,
               indicator_ref.cash_value.data]

        # Inserting the relations data
        add_data('indicator_reference', row)
        flash('Your new trigger has been created!')
        if 'indicator_ref' in session:

            trigger_string = process_trigger(indicator_ref.ind_1.data,
                                             indicator_ref.ind_2.data,
                                             indicator_ref.action.data,
                                             indicator_ref.operator.data,
                                             indicator_ref.action_security.data)
            session['indicator_ref'].append(trigger_string)

        else:
            trigger_string = process_trigger(indicator_ref.ind_1.data,
                                             indicator_ref.ind_2.data,
                                             indicator_ref.action.data,
                                             indicator_ref.operator.data,
                                             indicator_ref.action_security.data)
            session['indicator_ref'] = [trigger_string]

        # Trying to upload the action security to the databse
        load_finance.upload_ticker(indicator_ref.action_security.data)
        session['calculated'] = False
        return redirect(url_for('home'))

    return render_template('indicator_reference.html',
                           form=indicator_ref)
Example #2
0
def create_indicator():
    check_if_logged_in()
    create_indicator_form = CreateForm('indicator', session['strategy'])
    #print session['strategy']

    if request.method == 'POST' and create_indicator_form.validate():
        indicator_id = get_next_index('indicator', 'indicator_id')
        ticker = create_indicator_form.security.data
        print 'HERE', create_indicator_form.mva.data
        if create_indicator_form.mva.data == 'mva_10_day':
            mva_10_day = 'T'
            mva_25_day = 'F'
        else:
            mva_10_day = 'F'
            mva_25_day = 'T'
        row = [indicator_id, ticker, mva_10_day, mva_25_day]
        add_data('indicator', row)
        # adding relation
        criteria_row = [create_indicator_form.strategy.data, indicator_id]
        add_data('criteria', criteria_row)
        # adding to session
        if 'indicator' in session:
            print 'ind in session'
            session['indicator'].append((indicator_id,
                                        u'{} {}'.format(ticker,
                                        create_indicator_form.mva.data)))
        else:
            session['indicator'] = [(indicator_id,
                                    u'{} {}'.format(ticker,
                                    create_indicator_form.mva.data))]
        print session['indicator']
        # Trying to upload ticker to the database
        load_finance.upload_ticker(ticker)
        return redirect(url_for('home'))

    return render_template('create_indicator.html',
                           form=create_indicator_form)