Closed Trades Table

[jjb8942]

Good morning!

I am looking to access my closed trades and am having trouble understand the syntax. This seems to be the one sample that is missing from the ForexConnect sample pack. Does anyone have any code for accessing the closed trades table in the same way that the samples access the open positions?

Thanks for the help

[sunshine]

Please check the PrintTable sample located in the folder SimpleSamples\TableManagerSamples\PrintTable\ within the folder where FXConnect is installed.
Please note that the Closed Trades table is cleared at the beginning of the trading day.

[jjb8942]

My apology, I failed to mention that I am referring to VBA as I would like to use this data in excel. I don't see the print trades in the sample folder for VBA. But I also do not have that file in the SimpleSamples VB folder...

[Ekaterina]

Hi jjb8942,

Do you prefer to work with tables through TableManager or through Readers?

[jjb8942]

I have only worked with the TableManager.

[Ekaterina]

Hi jjb8942,

I have only worked with the TableManager.

Please see the following sample, that has a similar functionality with the PrintTable sample:

Code: Select all

 Do While offers.getNextRow(iter, offer)
            If offer.SubscriptionStatus <> "D" then
                sOffers = sOffers & offer.Instrument & " Bid:" & CSTR(offer.Bid) & ", Ask:" & CSTR(offer.Ask) & CHR(10) & CHR(13)
            End If
        Loop

This sample is located in the ForexConenct folder: %:\ProgramFiles\Candleworks\ForexConnectAPI\samples\com\VBS\offers_TableManager.vbs

Best regards,
Ekaterina

[compac]

Enter the email address you want to send the emails to by default. This address will be used as a default value of the email parameters in the strategies.