Documentation for sqlite DB and strategyanalyzerlogs xml

[idan2208]

Hi !
I want to monitor my Strategies on live from my phone and I want to build a little app,
I found the sqlite DB of the platform but it kinda big with couple tables,
do you have documentation where I can Read more about all the Tables and the columns ?
Like I want to see the P&L of each strategy for historical time (like in the platform) and all of that,
thanks

[NinjaTrader_ChelseaB]

Hello idan2208,

Welcome to the NinjaTrader forums!

Direct access to the NinjaTrader database is not supported, and further we discourage developers from reading or modifying the database.

This may be possible with unsupported and undocumented code, but would not be something our support is able to assist with.
This thread will remain open for any community members that would like to share tips or information.

An approach through NinjaScript that does not involve accessing the database would still be unsupported, but would be preferred from the standpoint of the NinjaTrader team.
One idea might be to have the strategies add their information to a collection in a static class addon, and then through some utilization of inter-process communication send the information from the collection to another application.

I have some information about a static class that might be helpful. Unfortunately, I don't have further information about inter-process communication.

https://ninjatrader.com/support/forum/forum/historical-beta-archive/version-8-beta/83018-partial-class-does-not-work#post712245

[idan2208]

Do you have the values of the number related to OrderType on Orders tables?
i want to know the values of the OrderType and what the say

[NinjaTrader_ChelseaB]

Hello idan2208,

Below is a link to the help guide.

https://ninjatrader.com/support/helpGuides/nt8/order.htm