Many traders start with a spreadsheet journal and later move to dedicated software. The move can lose history if not planned.
Steps:
Export trade history from your broker or platform.
Map spreadsheet columns to the software's fields.
Import notes and tags where possible.
Keep the original spreadsheet as an archive.
Things that often get lost:
Custom tags and setup names.
Screenshots linked to trades.
Comments on emotions and context.
Benefits of software: automatic import, statistics, filters. Benefits of spreadsheets: flexibility and full control.
Whichever tool you end up with, a fixed set of tags — setup name, session, mistake type — applied consistently matters more than the software itself. Tags are what make statistics meaningful later.
Have you moved journal tools, and what did you lose or gain?
FXS Prop Desk, I moved from a spreadsheet to software last year and the thing that went missing was not on your list: trades that never matched the broker export. Partial closes were the worst, since the software read one ticket split three ways as three separate trades and my win rate jumped by about 8 points overnight.
Before importing everything, I would reconcile one month by hand. Count trades and net result in the spreadsheet, import the same month, and only carry on if both figures match to the cent.
Time zones are the other silent problem. My spreadsheet used London time while the export used server time, so my session tags shifted by two hours until I added a conversion column.
On screenshots, I renamed every file to the ticket number before moving. The import tool could then attach them automatically, which saved a weekend of dragging images around.
I still keep the spreadsheet for anything custom, like my mistake tags. Did you find software that handles a free text tag list well, or did you end up trimming the tags to fit?
One more trap from my own migration, this time in the statistics rather than the import. The software calculated R from whatever stop was on the trade when it closed, so every ticket where I had moved the stop to breakeven showed a tiny risk and an enormous R multiple.
My spreadsheet had always used the initial stop. On the same 212 trades, average R came out at +0.31 in the software and +0.12 in the spreadsheet, and only one of those figures was honest.
Commission was the second mismatch. The software charged it once per ticket instead of round turn, which made every trade look about 3.50 dollars per lot better than the broker statement.
I would run both side by side for a full month before trusting the new figures. If expectancy, win rate and net result do not line up within a small margin, find out why before you delete a single column.
Also check the export before you commit years of notes to a vendor. The first tool I tried imported CSV easily but only exported a summary PDF, which would have locked my history in if they ever closed. Did yours let you get the raw rows back out?
A trading platform's history tab, a journal spreadsheet and the official account statement are three separate records, and they do not always agree. Differences in time zone, rounding, commission handling and the treatment of partial fills can make totals diverge by small but persistent amounts. Spotting those gaps is part of understanding true trading cost.
A reconciliation routine compares the same period across sources. Trade counts should match first, since a missing or duplicated line often signals an export problem rather than a trading one. Next come entry and exit prices, followed by commissions, swaps and fees, which are frequently recorded separately from profit in platform exports and sometimes omitted entirely.
Export format deserves care. Date columns may arrive as text in a local format, and spreadsheet software can silently reinterpret day and month order, scrambling a timeline. Saving raw exports untouched and working on a copy preserves the original evidence. A column recording the time zone used avoids confusion when sessions are analysed by hour.
Doing the comparison monthly, rather than only when a discrepancy is suspected, makes it manageable. Over time the same small adjustments, such as slippage on exits or a consistent fee omission, become visible and can be built into the journal's cost assumptions.