Database appears to be corrupt

[ldvinvestments]

When I run Account Performance for January it shows a different number for profit that what I know I really made via my brokerage reports. I believe my database is corrupt. How do I go about fixing this?

Thanks,
John

[NinjaTrader_ChristopherJ]

Hello,

Thank you for your post.

Within the Account Performance window please left mouse click on Advanced-->Select your Live account only-->confirm "Group trades by ATM strategy" is unchecked and Generate a new report.

Please let me know if the issue persists after this procedure.

[ldvinvestments]

Tried that, didn't work

Thanks but using only my live account and unchecking "group by ATM strategy" was how I was doing it.

What's the next step?

[NinjaTrader_ChristopherJ]

Do you have NinjaTrader configured to apply commissions to your PnL?

Also when comparing trades to what you see within your account statement do all trades match or are there missing executions?

[ldvinvestments]

I do not have NT configured to apply commissions and am comparing only on a gross basis. I have not compared trade by trade but can do that before the end of today.

[ldvinvestments]

I'm having this problem again. When I generate my Account Performance for the month of April there are trades that I did not do. I need the Trades report to complete an analysis. Why is Ninja doing this and how can I repair it?

[NinjaTrader_ChristopherJ]

The orders that are appearing are they showing within your Live account or the Sim101 account? Also in the Account Performance tab do you have "Group trades by ATM strategy" enabled?

[ldvinvestments]

The orders are appearing in my live account and I do not have 'group trades by atm strategy' checked

[NinjaTrader_ChristopherJ]

It is possible to have trades before the From date being listed in your report. NinjaTrader generates reports from the last time you were flat. If a particular instrument was already in the middle of a position at the beginning of the From date, NinjaTrader will report all trades prior to this date up to the point where the position was flat. This will ensure you have a complete picture in terms of your performance on any specific date instead of "jumping" into the middle of a position which may cause inaccurate overall performance.
If you go thru your records can you match up which executions don't match?

[ldvinvestments]

I can do that but it won't fix it. Is there anything I can do to fix it (e.g. DB repair)?

[NinjaTrader_ChristopherJ]

Yes please repair your database with the steps I have provided below:

• Disconnect
• Tools-->Options-->Data tab
• Repair DB
• Restart NinjaTrader
• Generate a new report

[ldvinvestments]

Didn't fix it. When I run a trade report I see a trade that has the wrong exit price on April 23 and then there is a series of incorrect trades.

[NinjaTrader_ChristopherJ]

Is this an Exit that should not exist which is throwing everything off? If so to resolve the issue you are experiencing please add an execution to the database to cancel out the Exit on that day. To add an execution please go to the Executions tab-->Right mouse click-->Add.

After you have added the execution please repair the database again-->Restart NinjaTrader and generate a new report.

[ldvinvestments]

It's an exit at the wrong price. How do I fix that?

[NinjaTrader_ChristopherJ]

There is not an option to change the price of the execution that is recorded. The only option is manually enter another entry and exit to pick up where the error occurred.