Export chart + indicator values in .CSV

[lld32308]

Hello
I found this link below which perfectly explains how to export the values of the bars of the chart in a text file but I would also like to export the data of an indicator too.

In mql there is the iCustom function...
is there its equivalent?
Do you have an example please that shows how to call an indicator and retrieve its value because I can't find it.
Thanks for your help

[NinjaTrader_Emily]

Hello lld32308,

Thank you for your post.

You could use an indicator method to call the indicator and get the value for its plot(s). We have a list of default system indicator methods here:
https://ninjatrader.com/support/help...indicators.htm

In that reference sample, the Time, Open, High, Low, and Close are written to the text file as follows:

protected override void OnBarUpdate()
{
sw = File.AppendText(path);  // Open the path for writing
sw.WriteLine(Time[0] + "," + Open[0] + "," + High[0] + "," + Low[0] + "," + Close[0]); // Append a new line to the file
sw.Close(); // Close the file to allow future calls to access the file again.
}
​

An indicator's value, such as the SMA, could be added to that as well. This would also be a good time to implement the best practice of storing a reference to an indicator instance since you would be reusing the same indicator many times.

        
private SMA mySma;

protected override void OnStateChange()
{
if (State == State.DataLoaded)
{
mySma = SMA(14);
}
}

protected override void OnBarUpdate()
{
sw = File.AppendText(path);  // Open the path for writing
sw.WriteLine(Time[0] + "," + Open[0] + "," + High[0] + "," + Low[0] + "," + Close[0] + ", SMA: " + mySma[0]); // Append a new line to the file
sw.Close(); // Close the file to allow future calls to access the file again.
}
​

As for exporting to .CSV, StreamWriter would export to a .txt file. You could then potentially import the .txt into a .CSV. I was able to find the following publicly available page from the Microsoft Support site regarding importing a text file to Excel:

https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

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

[lld32308]

Thank you for your very complete answer. A small clarification, it is a commercial indicator. Can you confirm that the procedure is the same because I am completely familiar with your platform and programming. Thank you for you precious help

[NinjaTrader_Emily]

Hello lld32308,

Thanks for your reply.

By commercial indicator, are you referring to a 3rd party indicator? If that is the case, then the indicator would need a public plot in order to be called from another script. There is a note in the help guide about what functionality is or isn't provided in a 3rd party indicator:

Note: It is important to understand the functionality provided or NOT provided in a 3rd party proprietary indicator. Just because they provide an indicator that displays a bullish or bearish trend on a chart does NOT mean that you can access this trend state from their indicator. It is up to the developer of the indicator to determine what information is accessible.

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

If you are unsure about whether the indicator may be called from another script or what the syntax may be to do so, you will need to reach out to the developer/vendor of the indicator for assistance.

Please feel free to reach out with any additional questions or concerns.