Dear Murray

I will be very pleased if you can give a procedure of how to export the trade by trade spreadsheet, function that was possible with previous version.

Please help me otherwise I am stuck in my work.

The new version is great!

In the inner menu on the session level  where you have file ,session results,view the file menu has save session results. That is the same as the old export spreadsheet. It will export a multi-tab workbook.

How do I export the equity curve data? Or alternatively how do I write a custom report that would tabulate date vs current equity value?

Thanks.

For a particular "session" I would like to export the equity curve data for a single commodity.  I would also like to to export the curve data for all commodities "combined".

I cannot see functionality for that, so i am guessing i need a "custom report" but I'm not sure how to go about it...

Thanks.

There are two ways to do it. The first for each market is simple.

FileAppend("c:\MyResults\"&getactivesymbol()&Equ.csv",formatdatetime(Date)&","&NetProfit)

This would write out date and netprofi on a bar by bar basis and save it in a file with the active symbol name. The second way is to create the files from a macro.

 Here is an example of using getequity from a macro. These features are part of the processor object.

The following example demonstrates GetEquity :

Sub MacroTest()
    Dim S As TSProcessor.ISession
    Dim EqDates As Array
    Dim EqVals As Array
    Dim i As Integer

    S = Processor.LoadSession("CHANBREAKOUT")
    If IsNull(S) Then
        MsgBox("Session cannot be loaded.")
        Exit Sub
    End If

    If Not S.RunParams("25") Then
        MsgBox("Error running session")
        Exit Sub
    End If

    S.ShowForm()

    Print S.EquityCount

    S.GetEquity(EqDates, EqVals)
   
    For i = 0 To UBound(EqDates) - 1
        Print FormatDateTime(EqDates[i]), "  ", EqVals[i]
    Next
End Sub

Murray,

Thanks for the swift replies.  I am still getting to grips with the software so perhaps I'm trying to do too much at this early stage.

Having said that, this is what I want to do:  I have run a session and displayed the "reports".  For each commodity or on a consolidated  basis the standard reports can be displayed or saved to an excel file.  There is also a "custom report" tab.  Within that "custom" tab I want to include the "daily equity curve values".  So that I can display and then "save session results" to excel.

Question: Given the code you provided above, what do I need to do next?

Taking it one stage further, I would also want to do the same within a "Trade Plan".

In an ideal world I would just "right click" on the equity curve bitmap and save that to a file as raw data instead of as an image file.  But that doesn't seem to work.

Thanks again.

The code I posted just need to have the output written to a file instead of the terminal, but you are correct we should have an easy way to do this. I will look into this for the general maintenance version due out this summer; this will be a free upgrade.