Create the engine and bind the session to a database :params new_session: Bind to a new session if True :params con_str: Use

Overriden method to return all errors to us

:raises: ValueError if all arguments are not supplied

Not to be confused with str.isnumeric. Takes an arg or a list and tests if all members are numeric types and not NAN.

Return a pandas Timestamp from a QDateTime

Register named style if it is not lready and add the style to the dict self.styles :params ns: The NamedStyle :params strNs:

Return a QDateTime or a QDate from a time object of Timestamp :qdate: Return QDateTime if False (by default) and QDate if True

Save wb as an excel file. If Permission Denied error is thrown, try renaming it.

Translates numerical coordinates as tuplets to excels string addresses e.g., (1,1) returns 'A1' :params icell: The cell to translate.

Get the trades from a single day. This is the default and corresponds tradeSummaries with numbered trades from a single day. Create a

Creates a new DataFrame with the length numRow. Each cell is filled with empty string :param cols: An array or DataFrame to use as t

formatCurrency

Get the location of the current input directory. This should correspond to the values found in selected date, input file type, journa

Open an IB Statement

Remove the associataion between the given tag and TradeSums :params tag_id: int. Either tag_id or tag_name must have a value or metho

Run the methods to create the new DataFrame and fill in the data for the new trade- centric (as opposed to transaction-centric, trade

Retrieve the object for the record associated with date. :return: None if the record does not exist.

Checks that dframe has the fields in the array requiredFields. Also checks that there are no duplicate fields Returns True on success

Get the chart data from the tradeObject :params key: Trade name from the tradeList widget :params ckey: The widget name of th

Retrieves the current strategy from self.ts

select *

Create an alternate dataFrame by ticket. For large share sizes this may have dramatically fewer transactions. :params listdf:

Color and order the api pref after done editing

Add the start time to the new column labeled Start or frc.start. Each transaction whthin a trade will share a start time. :pa

Put together the settings for scheme (realized here), journal and theDate to get the indir

Get the id of the strategy named name or return None if not found

Get links for the strategey 'name' :return: list<string>: Get a list of urls

Determine if infile is a statement. If it is return a tuple (data, type) TODO: Not doing what I said... If it is a DAS statement, determine i

Store the chart data in the trade object :params key: Trade name from the tradeList :params data: a list or list of lists. Ea

Adds numRow rows to the end of the DataFrame object dframe' :params dframe: A DataFrame to increase in size. :params numRow:

Labels and numbers the trades by populating the TIndex column. 'Trade 1' for example includes the transactions between the initial pu

Return the location of outdir

Callback when dateEdit is changed. Gather the settings and locate what input files exist. Enable/disable radio buttons to choose IB o

Perform a merge cell :params ws: The Worksheet to place the merged cells. :params begin: The top left cell as a tuple of ints

:params strat: str: name of strat :params name: str: the image file string

Sets strategy in self.ts to val

Add a trade summary P/L. That is total the transaction P/L and write a summary P/L for the trade in the c.sum column

Adjust size to keep the aspect ratio the same as determined by self.numCells and self.pixPerCell

Save or update the db file for the notes field. If no note is given. will retrieve the text from the qt dailyNotes widget. Use setNo

:params daDate: A date string in the form yyyymmdd as it is held in the db :return: Two OrderedDict with keys for the account alias n

From the text in the infileEdit box, determine if we have trades in the db. We can tell because the first token is an int sho

Creates a dictionary of moving averages based settings values. All window values in chartSettings will be processed. Returns a dict of MA: SM

Populate the tags widget with all tags in the db and, if tsum_id is given, select the tags for the selected trade

Helper method for export to excel. Populate the excel formulas in the daily summary forms. The formulas are in self.ts and the inform

This is intended for testing code only. Be sure the db either has a backup or is initialized to a test db.

Top level script for this form. Populate the widgets.

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 assoi

Create DAS export like random trades.csv files for testing purposes :params dates: Create one file for each date. Date will be append

Set clean in self.ts to b. The clean value is used to determine if there is user input to maintain in the mistake note/mistake val.

Apply styles to a range of cells as if they were a single cell. This function is mostly unchanged from StackOverflow, where it was gotten fro

Get a time delta beween the time of the first and last transaction. Place it in the c.dur column on the last transaction of the trade

Create DB entries in trade_sum and its relations they do not already exist

Given the current list of apis as av, bc, fh and ib, determine if the given api will likely return data for the given times.

If the ibapi is not installed or available, disable its use.

In the directory theDir, create 1 month of directories, one for each weekday. Use the date theDate to and the format given to create the name

This is a method function for use in developement. It will probably move up in the heirarchy to the inclusive program. Instructive to see

HACK ALERT:The access to the chartData methods uses an arbitrary reference to charts[0]. Filter the strategies and numbers

In the DataFrame t, change some types from str to numeric. :params t: DataFrame, a Trades or TRNT table from an IbStatement

Format the date into a string for uniform DB format

Returns Description object or None

Get the directory in the journal subdirs that represent daDate. Relies on the naming scheme saved in ff.settings

The data structure is: [price, time, share, pl, diff, entryOrExit]. Share is positive for buy, negative for sell. :params key

Seperates self.data into two arrays padded with 0s, one for negative values and one for positive.

Retrieve the notes field for the db entry for the date associated with this object. The date can be given as an argument or retrieved

Get a quote by id or name :return: list :raises: ValueError if neither id or name are supplied