Creates a python list of DataFrames for each trade. It relies on addTradeIndex successfully creating the trade index in the format Tr

Get a random quote.

Insert a trade into ib_trades table. Commit not included for speed. :params row:A pandas object that includes the headers:

Identify a csv file as a type of IB Statement and send to the right place to open it

For the export to excel the mistake summary form. Populate the dynamic parts of mistake summaries. That includes fomulas and hyperlin

Set the amount of time before the first transaction and after the last transaction to include in the chart. This may include some tre

Set the stopDiff to the difference between the stoploss and the first entry, then call rrCalc

Check flxcols against ourcols, remove any cols in ourcols that are missing in flxcols and send a warning :return: ourcols are

Add the columns from FinReqCol that are not already in dframe. :params dframe: The original DataFrame with the columns of the input f

Create a name for this trade like 'AMD Short'. Place it in the c.name column. This could still be a flipped position. The test is ba

Get a data method as set in self.api :return the method

Create the journal directories for the current month and next month. The QSettings value journal must exist and the value for directories_aut

Implementation for signals from interval widgets

Get the date from the path

Create the sub directories in the journal directory

Wrapper to createDirs take care of the structjour journal directory and naming scheme from QSettings :params testSettings: Override stand

Create the workbook obj and give it all the data in the DataFrame. This copies almost verbatim each cell in the DataFrame to a cell i

Create the shape and populate the daily Summary Form :params ws: The openpyxl Worksheet object :parmas tf: The TradeFormat ob

Adds a filter to a query on the TradeSum table

If start is not given, return all trades from the given date or [] If start is given, return a single trade :params date: st

Collect the all files in the since daDate in the journal directory that match fn. Relies on the naming scheme saved in settings :fn: A fi

html statments and all trade type statements are no longer supported. But leaving the column information here. Using the tabl

Get a list of the strategies that are in use and the number of trades that use them. :return: A python list of tuples (name, count).

Retrieve the rows between (fid[0], fid[1]) in df :fid: A section identifier like ('BOF', 'EOF')

Queries the database to get the count of transactions recorded from a single day. By default will retrieve the tickets from all accou

Get the outdir based on self.d

Utility method to get a probable market open day prior to td. The least likely closed days are Tuesday and Wednesday. This will occassionally

Get a time that is in the future a random amount of seconds from earliset

Utility to get the number of shares in this Trade. Each TradeObject object represents a single trade, or the part of a trade that hap

Get the TradeSummaries as list of dict, each element is a transaction from the trade. Combine info from the related tables into Trade

Get Market days between beg and end for which we are not covered by a statement saved to the db. Paramaters: :params account

Initialize the inputs and outs

Load the image named name into the QLable widget widg. Loads a default image if name does not exist. Used to initialize the form.

This is a one-off to load the quotes in the inspiration.inspire.Inspire class. Its a one-off becasue we have to seperate 2 fields fro

Load the strategy combo box from the db

Load strategies from database into the strategy Combobox. If the tto stored strategy is not in the db, then add it too. Call lf.setSt

Create the shape and stye for the Mistake summary form, populate the static values. The rest is done elsewhere including formulas (wi

Processs the trade, positions, and covered tables using the Trades table and the OpenPositions table.

Get the trades from daDate in the DB and process the trades

This script creates the tto object for each trade in the input file and appends it to a list It also creates a generic name for assoiated ima

Set the Pnl widget with the daily profit. The profit can be set for one account or all accounts in file settings

Set mstkval and mstknote in self.ts :params key: The current trade name is the key found in the tradeList Combo box :params v

Commit or update the dailyNotes db table with self.date and note A redundant method that was in the api

The checkboxes (30 60, 90 days) are short cuts to fill in the start and end dates. Un checking all three will also trigger this metho

Retrieve the dates from the widgets and place them in the self.cud dict. If they are not ordered (start > end), set the dict to None

Style the table, and the top bit. Here we style the table and the things above it. The table data is already there. Above the table a

Ib sends back differnt formats from different files. All statement processing should call this method.

DB update ib_trades for average, balance, PnL and OpenClose :params atrade: A dict that includes the key 'id' for id value.

Check the value of self.inpathfile, self.inpathfile2 (if the entry exists), and self.outdir for existance. Note that this is called b

Use only this method to add tags in order to format them uniformly :params session: :params tag: A Tags object

Take a date and advance a number of months up to 12. The returned date's day is the same as the argument's unless it is >= 28 when it returns

HACK ALERT: adding columns to the the 'final' list of cols. Not ready to add these cols to FinReqCol

placeholder

There are a few seperate orders for equities that share the same order time. These cannot have an assigned share balance because ther

Create an html table that displays the dict d :d: A dict or a list of dict of the same type

Triggered when the targ value changes, set targ, tarDiff and rr. Then store vals in tto

Search for duplicate trades and determine which records from ib_trades and trade_sum should be removed. This is called in StatementDb

Export to excel the trade tables, trade summaries, and daily forms

Figure the average price and the PL. Although DAS has PL, it often does not match the figures -- or IB

Figure Balance, Average price and PL :params tt: Trades table from statement :params tos: Positions table from statement