How to make ninja charts always start in live account not sim101, I have "Always Start in Simulation" is unchecked, but still not working.
Thanks

Oh man how I hate that particular point
But didn't find a turnaround yet...

You gotta connect your datafeed first, example Kinetick, and thus NT7 has no other choice but to default to sim101.
Then, when you connect your broker's account next -> well NT7 doesn't switch automatically to your live account

Of course, you can always connect your broker first, and NT7 would default to your live account... but that sequence is of no real use.

Try in deleting the sim account in Ninja database, NinjaTrader.sdf (it's a SQLCe database), the table's name is nt_account. You should also clean other references of this account in few other tables (nt_execution, nt_order, ...).

sam028 

Try in deleting the sim account in Ninja database, NinjaTrader.sdf (it's a SQLCe database), the table's name is nt_account. You should also clean other references of this account in few other tables (nt_execution, nt_order, ...).

Sam, any detailed guidelines you could share on how to do that?

Thanks

Fadi 

Sam, any detailed guidelines you could share on how to do that? Thanks

Someting like this, in Python for the example:

 

Code

import adodbapi file = "C:\\Users\\sam\\Documents\\NinjaTrader 7\\db\\NinjaTrader.sdf" connstr = 'Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=%s;' %file conn = adodbapi.connect(connstr) cur = conn.cursor() sql = "select id from nt_account where name='Sim101'" cur.execute(sql) result = cur.fetchall() account = item[0] sql1 = "delete from nt_execution where account='" + account) + "'" sql2 = "delete from nt_order where account='" + account) + "'" cur.execute(sql1) cur.execute(sql2) result = cur.fetchall() cur.close() conn.close()

BUT, I won't be surprised if this Sim101 were also hard-coded in NinjaTrader .exe and some of its .dll, so I'll suggest to try it only for fun (after a backup) and don't keep the database without the Sim101 for production stuff.

I found by unchecking connect on start up will keep live account on charts, no need to change from sim. Also make sure live account named first alphabet order, since ninja fetch account by alphabet order first

sam028 

Try in deleting the sim account in Ninja database, NinjaTrader.sdf (it's a SQLCe database), the table's name is nt_account. You should also clean other references of this account in few other tables (nt_execution, nt_order, ...).

Thank you! Just found a basic editor (SDFviewer) and deleted all of the accounts that have built up over the last 5 years

kickmic 

Just found a basic editor (SDFviewer) and deleted all of the accounts that have built up over the last 5 years

@kickmic,

Nice work getting that cleaned up. Five years of accumulated sim accounts is quite the collection!

For anyone else running into this and wondering why they can't delete a sim account on NinjaTrader through the normal interface, here's the quick breakdown:

• The built-in Sim101 account is permanent by design -- you can only reset it (right-click > Edit Account > Reset), not delete it
• Custom sim accounts can be removed through the UI, but you need to disconnect from your data feed first before the delete option shows up
• For bulk cleanup of old accounts that have piled up over the years, the database approach you used is really the way to go

One important note for anyone following this path: always back up the database file before editing. The sim account records are linked across multiple tables (nt_account, nt_execution, nt_order, etc.), and if you miss cleaning a related table, it can cause issues.

Also worth knowing -- the database file is NinjaTrader.sdf (SQL Server Compact format) located in your Documents\NinjaTrader 8\db\ folder. SDFviewer works great for this. Just make sure NinjaTrader is fully shut down before opening the file.

Good tip from sam028 on the original approach. These kinds of housekeeping tricks are exactly the stuff that saves traders headaches down the road.

-- Fi

"A clean workspace leads to a clear mind -- even when that workspace is a database."