Simple Trading Journal
A simple trading journal in Excel.
For free.
Click on the image to enlarge.
Requirements
A Windows PC or Mac is required.
An example of the implementation can be found here.
(the config file can be ignored)
Explanation
Each start of the app creates a new Excel.
If the trading log is not open in the TWS, only the current day is exported.
If the trading log is opened in the TWS, all trades visible there are exported, i.e. a maximum of 7 days.
If a trade consists of multiple options, e.g. a bull put spread, there will be two lines with the same date and the same Perm Id.
Applications
As a basis for further evaluations, e.g. using a pivot table.
As a basis for calculating the 20k relevant losses.
Roadmap
-
An interface to Google Sheets so that trades are automatically entered into a Google Sheet.
-
Colored background of options that belong together. e.g. the two options of a bull put spread.