Extract to excel

[bagzi]

Hello,

i have a question regarding possibility to extract certain info from a Strategy analyzer to excel. I know i can extract an entire grid to excel, but when im testing a big group of stocks like SP500, and i want to see Profit factors for long only or short only entries for each particular stock i cant do this unless i manually extract this data to excel. Do you maybe know an option to extract this data all at once?

thanks

[NinjaTrader_CalH]

Hi Bagzi,

Thank you for your post.

Unfortunately, you can only do this one at a time with the grid to excel for each instrument.

Let me know if I can be of further assistance.

[Nana111]

Hi there
I have googled an excel processing program which supports to extract to excel.And here is the code:
/// <summary>
/// Extract a single page and form a new document
/// </summary>
/// <param name="filePath"></param>
/// <param name="indx"></param>
/// <returns></returns>
public ExcelDocument GetOnePageDocument(String sourceFilePath, int index, String destnFilePath)
{
Excel Document Process.GetOnePageDocument(sourceFilePath, index, destnFilePath);
}

Hope to help you.

[bagzi]

Hey Nana111, thanks for posting. I dont know C#, its all a pain in the but when i need to open code and fix it outside the wizard. Could u advise where should i put this code when i open the code viewer? I have Initialize and On bar update section. I would like to get all the trades that show up on the analyzer at once when testing multi instrument, not have to go to export instrument by instrument. Any idea how to achieve that?

[Chesterton]

Hi there
I have googled an excel processing program which supports to extract to excel.And here is the code:
/// <summary>
/// Extract a single page and form a new document
/// </summary>
/// <param name="filePath"></param>
/// <param name="indx"></param>
/// <returns></returns>
public ExcelDocument GetOnePageDocument(String sourceFilePath, int index, String destnFilePath)
{
Excel Document Process.GetOnePageDocument(sourceFilePath, index, destnFilePath);
}

Hope to help you.

Hi Nana111, I am not familar with C# sharp code, I am a newbie for programming, and recently, I need to finish a small project about excel page exporting for my school work, can you offer me some visual basic codes? Thanks!