Thanks. It's much more complex with multi leg options though because what I consider to be one "position" is the initial purchase plus any short against my long through the life of that. But brokers must show these as individual transactions for tax purposes, so I'm back to where I started. I've considered setting up a website for myself so I could use php and mySQL to manage it...but that's a lot of back-end programming, and then I have to write other code to do the spreadsheet functions I need...and this isn't part of my journal that has my narrative in it. Nor is it particularly more efficient than a spreadsheet with one symbol per sheet.I don't trade options so Im not sure if this is applicable, but in my case, the platform I use has very good trade reporting and statistics built in. I use SierraChart.
When putting on a trade, I scribble (with a pen and paper) 3 additional pieces of info, which were mentioned in my previous post in this thread. It's an extremely quick process. At eod (preferably), I export (actually copy paste) the trade report directly to XL, and I append my scribbles to each. I do this separately for each symbol I trade. I average 36 trades per day. It takes me 10-15 mins to do the append in XL. XL of course, allows splice, dice and combine data any way I like. And SierraChart has many sort, filter, and stats available for each type report on screen, real-time, exportable.
Trade On!
The problem is reconciling chronology with the positions in a sufficiently parsimonious way that it's useful, but also getting enough info for data analysis, while also keeping track of open positions...

