Sets the duration delta to a nicely formatted string for humans. Return just the number of days if its 1 or more. Otherwise return so

This method places data into the trade summary from entries, exits, time of transaction, number of shares, and the difference between

Set the market value based on shares * price. For incomplete trades, the info may be incomplete and a NaN value produced. A value i

Local proof of concept

Create a summaries of live, sim and total P/L for the day and place it in new rows. Total and sim total go in the first blank row und

Helper method for backup. If either db file is not found, change the backup dir name to include 'FAILED'. That will prevent a

Check average, balance, and oc that they all exist in harmony. Make no changes. Return False if anything is not right. TODO:

Clean up the data for insertion into excel.

Run unittests cl style. Can debug

Color the API pref as red or green as user edits

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

In flex Statements, the TRNT (Trades) table input might be in transacations instead of tickets identified by LevelOfDetail=EXECUTION

Compare the user data in the two trade dictionaries, Update one if one is empty

Inserts the dates between begin and end into the ib_covered table

Add a datefield to df that uses a Timestamp

Create a single row ticket from a Dataframe with a list (1 or more) of Transactions. :prerequisites: tickTx needs to have 'len(unique

create db table

Creates the api_keys if it doesnt exist then adds a row for each api that requires a key if they dont exist

Set the self.settings value for input type to DAS

Local proof of concept. Will delete the first Charilie Brown quote or do nothing.

Get the offset for ny time on the last index time and set the date values to a naive Timestamp adjusted from Grenwich (Aware) to NY Naive

Deal with idiosyncracies; set uniform format in the Activity Flex Trades table (tableid = TRNT) 1) Some statements' TRNT

Fix up the idiosyncracies in the tables from a default csv statement

Fix up the idiosyncracies in the tables in from an Activity Flex Statement

Fix up the time entries to contain the dates as Timestamps and charts entries. Plan not to try to deal with the whole excel related files. Th

Basically this fixes up my stuff (developer) and should be unnecessary by release time Fix up the legacy objects (which is every obje

Add a Date field if its missing

Set the paramaters and send to finnhub. (The requesed start time should allow for moving average calculations.) :symbol: The ticker to get

This is called if the positions table is lacking to detemine if there is missing data for any equities traded today. This is not idea

The easy way (using positions.csv) and the hard way (no positions.csv). The hard way should occassionally fail and require user inter

Figure Balance, Average, and PnL. DAS has a PL column but it often differs from the calculations (and from IB). :ttdf: A dat

The file settings dialog. Top level dialg triggered by File->FileSettings menu. Display the current settings (QSetting), define the d

Match the file in the given month that contain the name fn. Relies on the naming scheme saved in settings :fn: A filename of file pattern

This is for unbalanced trades, that is a (ticker/account) set that has sum(qty) != 0 Prerequisite is there is at least one trade tha

Format the time into a string for uniform DB format

The dialog does not use this. It shows the info in charts. It is called by the export to excel stuff. Put together into a dictionar

Utility Gets a dictionary of all input file and all saved files associated with each input file. Relies on the structjour fil

Get a randoms account real or sim

Retrieves files formatted {account}_{yyyymmdd}_{yyyymmdd}.csv The dates are begin and end dates

Uses an ongoing session

Getting an array of queries will allow the devel of digging down into each candle

QInputDialog to get the date

Uses session from getId

:return: List of [strat, query]. Each query will retrive the trades that correspond to the the strategy strat and can be filtered.

Have been unable to write a usable query using the ORM. Here it is in SQL

Common interface for apiChooser. :params start: Time string or naive pandas timestamp or naive datetime object. :params end: Time string

:params end: datetime object for the end time requested :params dur: a string for how long before end should the chart begin "1 D"

Using the glob for ib files in settings, search for ib files in the directory indir

Get the pickled object from the ib statement input

Get all transactions and times from a single day and organize accumulated intraday pnl and trade time into a dict of DataFrames, keye

This is unrelated to structjour, but the quotes.json file sits in the structjour directory structure. It is available as a raw file h