Grid Data Extraction

[Badr123]

I wonder if there is a way or script to extract Grid Data periodically (Every specific time) Instead of right click on NinjaTrader 'Control Center - Strategies' Window then hit Export to export whether xlsx or csv file , I want to automate this

[NinjaTrader_Emily]

Hello Badr123,

Thank you for your post.

What you have described may or may not be possible to automate, though there is no supported/documented method for doing so via NinjaScript. This thread will remain open for members of the forum community to chime in with their thoughts or ideas on how this might be possible.

Otherwise, you could consider adding logic into your strategies directly that writes the desired data to a text file via StreamWriter. That text file could then potentially be converted to a xlsx or csv spreadsheet file. For an example of using StreamWriter to write to a text file:

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

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

[Badr123]

Hello Emily

Can you please provide me with the code or example how to write the desired data to a text file via StreamWriter ?

[NinjaTrader_Emily]

Hello Emily

Can you please provide me with the code or example how to write the desired data to a text file via StreamWriter ?

The link I provided contains a download for a reference sample that demonstrates how to write to a text file with StreamWriter. It is up to you to decide which data you would like to write to that file; in terms of the Strategies tab of the Control Center, you can get items such as the average price, unrealized PnL, etc. via NinjaScript methods and properties available such as the following:

• AveragePrice - https://ninjatrader.com/support/help...erageprice.htm
• GetUnrealizedProfitLoss() - https://ninjatrader.com/support/help...profitloss.htm
• MarketPosition - https://ninjatrader.com/support/help...etposition.htm
• Quantity - https://ninjatrader.com/support/help...n_quantity.htm

There are other metrics you could access from a TradeCollection:

• https://ninjatrader.com/support/help...collection.htm
• https://ninjatrader.com/support/help...erformance.htm
• https://ninjatrader.com/support/help...erformance.htm
• https://ninjatrader.com/support/help...ancevalues.htm

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

[Morkab]

Create a custom NinjaScript strategy to handle the data extraction. NinjaScript allows you to write custom C# scripts for NinjaTrader. By leveraging NinjaScript, you essentially create a data enrichment tool that automates the extraction process. This tool can be tailored to your specific requirements, allowing you to gather the necessary data at scheduled intervals without manual intervention.

[Badr123]

Create a custom NinjaScript strategy to handle the data extraction. NinjaScript allows you to write custom C# scripts for NinjaTrader.

Can you give me at least example for script to print all my Instrument in the "Control Center - Strategies" window please ?