Tradovate and NinjaTrader web: import the fills

Every plan; Free imports one file a day.

Tradovate and the NinjaTrader web and mobile platforms (Prop and Brokerage accounts) share one backend and one export. A live sync with them waits for NinjaTrader’s partner programme, which is closed to new vendors at the moment; the export covers them until it opens.

The file

Account Reports (Statements) → Download CSV. Of the files you get, Fills.csv is the one to import: one row per fill, the time in UTC with milliseconds, the order id, the commission per fill. Orders.csv works too (one row per filled order, no fees, the fill time in your zone); Account Balance History.csv and Cash History.csv bring the balances and the money moved (below).

In TakeJournal

Tradovate has no live sync, so the file is the way in: drop it anywhere in TakeJournal, or Import a file in the sidebar. It is read before anything is saved, and every Tradovate account in it gets a row with where it goes:

• A number TakeJournal knows goes into the account that imports it.
• A new number gets a manual account named by it, with the product its number names (APEX-… proposes Apex’s; pick the right one) or an account of your own of a type. A manual account counts towards your plan’s account limit like any other.
• Skip, and do not ask again leaves the number out, in this file and the next ones, until you send it somewhere.
• Another account sends its fills into another manual account this once; the number stays its own account’s.

One button imports them all. The next day’s file comes with every row where it went the day before: one click. Free imports one file a day, however many accounts it holds. An account’s page → Import trades imports that account’s number from the file.

Fills of the same order merge into one; a file imported twice adds nothing; a later file with an overlap adds only what is new. The report after the import says, per account, what was read, what was known and which rows could not be read; each account’s import is taken back on its own.

An account the copier fills from a master synced elsewhere (Rithmic, TopstepX): set its role to Follower with its copy size and “Follows the master of” to the master’s connection (Pro and Fleet); every imported file then joins its trades to the master’s, with the copy audit. Left on “this connection”, the setting joins nothing, since a manual account has no master next to it: its trades show as rows of their own with “1 account”. Set it before the first import or before you journal the trades; the steps and the checks are in Followers on another connection or from files.

Balances and money moved

Two more reports from the same place import the same way, every account of the file in one table:

• Account Balance History.csv, each account’s balance at the end of every trading day. Each day is compared with the journal, its trades after fees and the money moved; a day that differs shows on the account’s page under Balance from Tradovate, mostly fees its fills lack or a fill missing. The last day’s balance becomes the account’s balance, Balance (Tradovate), with the journal’s trades after that day; the firm’s rules count from it.
• Cash History.csv, every movement of money. A Fund Transaction goes into the account’s Costs & payouts once: the first one, the funding, fills in the start balance; one that sets the balance back to the start is a reset; money out of a funded account is its payout. Any other, and a kind TakeJournal does not know, counts in the balance at once as a credit or a debit marked To confirm: confirm it, or change its kind with Edit. The fee lines (commission, exchange, clearing and NFA fees) complete the fees of their fills, since Fills.csv carries the commission alone, so import the fills first.

The files’ times are Tradovate’s display time (Central or your computer’s); TakeJournal tells which from the fills, and the days come from the trading dates. A file imported twice adds nothing, each import is taken back on its own, and each file is one of Free’s imports of the day.

Related

NinjaTrader 8 · Import reports · Brokers and imports