Find the files in direct that match fn, either exactly or including the same parts. :direct: The directory to search :fn: A filename or f

A helper method for addTradeSummariesSA and updateTradeSummaries Get a single trade summary record by date and time :date: A

A helper method for addTradeSummariesSA and updateTradeSummaries Get a single trade summary record by date and time :date: A

Find a unique trade for date, symbol, quantity and account. This method is here to prevent duplicate trades, not to get a collection

Implement the Summary Trade Form within the openpyxl worksheet object. The form is defined in SumReqFields.tfcolumns, which contains

Retrieve a list of all accounts that have trades. The entries in the table are actual account numbers

Returns the key for the barchart API

We want to display jut one exit in the Trade log. It might as well be the average exit when we scale out. If there are more than 8 combined entrie

Retrive all trades in ib_trades missing either average or balance

Abstract method without ABC

Get the associated widgets for c one of chart1, chart2 or chart3. That includes the widgets for start, end, interval and name.

Get the indir/dasInfile based on self.d

Probaly place in utilities. Will returne a tz aware datetime object. If datime is None, will coerce a start or end date that is either 9:15 o

Return a default image

Get the transactions (ib_trades) related to a trade (trade_sum) by trade_sum_id.

The interactive portion of this method is deprectaed and will be removed at a future time. With no paramters, this is a conversation to deter

Gets a list of IB Activity based on the glob in settings, returns a list. :return: A list of file name or an empty list. (no pathname

Returns the image name or None

:return a list of [<Images>, <Strategy>]

This is an image name for a pasted image. We don't know the interval or time limits beyond the trade times. Remove any interval info,

This is a chart name for which we know the candle interval because we gave that parameter to the stock api.

Gathers specific image names as stored in self.ts[tradekey][chartkey] :return: A dict of all image names in self.ts organized by trad

Get the indir/ based on self.d

Retrive all the transactions from a single day :params daDate: A time string, datetime or pd.Timestamp :return: All the ib_tr

Retrieve the last biz day from today or from d if the arg is given. Holidays are ignored :params d: A datetime object. :return: A datetim

Takes a query realized result, groups the trades and returns summarized pnl with data

Set the extension and format to png. (Be sure to save it with a png format). Create the pathfile name and return it. :params

This needs to be a name that can be gleaned from the info on the form and settings loaded for each file name

Top level script to load the trades in fname. :fname: An excel file generated by structjour containing a Daily trade table, a Daily notes

Find the Trade Summary Forms within the excel doc and save their location in tradeLoc trades.max_row :params:ws: The openpyxl Worksheet o

Return True if this trade processed at least one exit. Return False if the exits are all None :params:trade: DataFrame representing a single

Currently this will retrieve the data using apiChooser. Set self.preferences to limit acceptible apis. To place tx markers, set (

1) Determine the locations in the Excel doc to place trade summaries, trade tables and images. 2) Create the empty rows a

Load up each trade summary in the excel doc into a 1 row DataFrame, return a list of these DataFrames. The addresses are supplied by srf plus

This is the runner for the application

Create the file

Maxrow() method will get the maximum row for the current TradeSummaries form as it is translated from row 1. :return maxrow:

Create the directory self.outdir. Allows a Permission exception to stop the program. :return: True if successful or False if not.

Site specific testing stuff-- open a multi day statement

:params t: a naive datetime object :exception: Will raise an assertion error if t is not datetime or has no tzinfo assoatiated.

Store the transaction based Dataframe as (getStoredTradeName()) for the input file just after it was loaded from file.

A helper method for export to excel. Place images and the tradesummary stylesin the openpyxl ws object

Populat the holidays table.

Populate the listwidget from every strategy that has been named in a trade or in the argument strats. If strats is None, this will i

Use the widget dictionary (self.wd) and tto to populate the form. The images and related widgets are handled seperately in sc.setChar

Export the daily note as found in the DailyControl dialog.

For the export to excel daily summary forms. Populate the daily Summary Form. The values are retrieved from self.ts via the D

A few items that need fixing up. Locate and name flipped positions and overnight holds and change the name appropriately. Look for tr

Its sketchy still Process the ib_trades.balance field for all trade entries between begin and end :prerequisites: Balance-- t

Rename the sa names in a dict to the SumReqFields as used every where else

Figure and set the Risk:Reward label for rr and realrr

Run sqlalchemy filters on self.query. The filters that run are determined by contents of the dict self.cud. The reusult is that self.

Load an initial input file and process it.

Signal call back from saveBtn. Initiates saving the data.

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

Set up default times and intervals for charts

Set the lable widget from the text widget and color the label to show existance/not

Set the default name of positions.csv

Set the location of the sqlite db file. Store in main Settings

Uncheck the 30 60 and 90 day checkboxes

Use the glob in the text widget to find a list of matched input files. Set the settings variable to the first one, but warn the user

Uses session created in getImage. :params strat: str: name of strategy :params name: str: name of image

Set the journal settings from the widget and color the widget text showing existance/not.

Set the outdir and outdir policy settings using the policy and text widgets. Set the label color to show existance/not

Set the directory naming scheme to the default value defined here.

When the user enters a value in stoploss several things happen in the callback then here we store all the related values in tto. If t

Store the values affected by a change in the target value

Button, LineEdit and Label used to set and display a directory naming scheme.

DB update ib_trades balance

Helper method for updateTradeSummaries. Not intended for api use

A secondary attempt to get balance for the badTrade bt. bt has a PL but lacks balance. First set it as a closer and set the a