connection to NinjaTrader.sqlite inside my indicator

[neboTrade]

Hello Support,

I'm trying to connect to NinjaTrader.sqlite inside my indicator, but I'm failing.

I've downloaded System.Data.SQLite.dll file from internet and added it to the indicator through references. The following code is compiled successfully

using System.Data.SQLite;
using System.Data;

protected override void OnStateChange()
{
else if (State == State.Configure)
{
using (var connection = new SQLiteConnection ("Data Source = NinjaTrader.sqlite"))
{
connection.Open();
}
}
}

but when i'm trying to add my indicator to a chart the following error occurs

06.08.2023 2:45:09	Default	Indicator 'TradesView': Error on calling 'OnStateChange' method: Не удалось загрузить файл или сборку "System.Data.SQLite, Version=1.0.92.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" либо одну из их зависимостей. Не удается найти указанный файл.

please help

[NinjaTrader_Emily]

Hello neboTrade,

Thank you for your post and welcome to the NinjaTrader forum community!

Connecting to a database via NinjaScript is a general C# concept that is not supported by the NinjaTrader support team. That said, my colleague has offered some information and publicly available links related to the .NET version and System.Data.dll that should allow access to databases here:

https://forum.ninjatrader.com/forum/ninjatrader-8/strategy-development/99598-ninjatrader-8-and-access-db?p=792074#post792074

Otherwise, what is the reason that you are trying to connect to the NinjaTrader database? There may be some other solution or workaround to get the desired data.

Please let me know if I may be of further assistance.

[neboTrade]

Hello Emily,

Many thanks for the reply.

I'm trying to get data of my past manual trades

data got from <Account>.Executions or <Account>.Orders only gives me information of the current day trades. I would like to have data on all my past trades.

The property

trades.Properties.PlotExecutions = ChartExecutionStyle.TextAndMarker;

displays past trades and their data on a chart so there is the way to get not only the current day trades data.

Any help would be appreciated

[NinjaTrader_Emily]

Hello neboTrade,

Thank you for your reply.

You should be able to access a trade collection from the SystemPerformance object:

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

This would allow you to access all trades from a strategy, short trades only, long trades only, or real-time trades generated by the strategy. More details regarding TradeCollection may be found here:

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

Please let us know if we may be of further assistance.