I'm trying to find a script which all it does is takes the value of the equity on your account and uploads it on the internet or at least saves it in such a way that it can be stored in a database. Is this possible?
Joined Oct 2006
|
Status: Friendly Neighborhood Programmer
|533 Posts
This 60 seconds of code brought to you by Tesla...
PHP Code
bool logAndUploadEquity() {
static string sFile = "Equity.csv";
int iFile;
string sTimestamp;
string sEquity;
// if file couldn't be opened, return false
iFile = FileOpen(sFile,FILE_READ|FILE_WRITE|FILE_CSV,",");
if(iFile == -1)
return(false);
// write out timestamp and equity to file
sTimestamp = TimeToStr(TimeLocal(),TIME_DATE|TIME_SECONDS);
sEquity = DoubleToStr(AccountEquity(),2);
FileWrite(iFile,sTimestamp,sEquity);
FileFlush(iFile);
// close the file
FileClose(iFile);
// upload the file
// Note: a second param can be used to specify ftp_path
// returns true if successful, false otherwise
return(SendFTP(sFile));
}
This has been defined as a function, so it can be dropped into just about any script/ea that you choose. It creates/opens a csv file and adds timestamp and current equity, then uploads it to the ftp server you have defined in server options.
is there a way to have this update automatically as soon as the market updates?
Ignored
copy paste the above function at start() function of Expert Advisor, compile them, this should automatically upload your file to your ftp path on each and every tick of the pair you attach the EA.
Joined Oct 2006
|
Status: Friendly Neighborhood Programmer
|533 Posts
Make sure everything's configured properly (port#, etc.)
Publisher Tab
Terminal allows to publish reports about the account status in internet automatically. To do so, one has to set up internet connection parameters through FTP (File Transfer Protocol). This can be done in the "Publisher" tab:
Enable — enable support reports publishing. If disabled, other fields are inaccessible;
Account — the account number the report for which should be published; Attention: Reports of only active accounts can be published. If the account number given in this field does not match with the current one, the reports will not be published.
Refresh every — periodicity of sending reports to the web server (in minutes);
FTP server — FTP server address to which the report will be sent. The server address and, if necessary, port should be specified in this field. The entry must have the following format: "[server internet address] : [port number]", for example: "192.168.0.1:443", where "192.168.0.1" is the server address, and "443" is the port number;
FTP path — name of the directory at the FTP server in which the report will be placed. The path (starting with the root directory) for sending reports must be given in this field;
FTP login — login for authorization at the FTP server;
FTP password — password for access to the FTP server;
Passive mode — switch between active and passive mode of data transfer.
In active mode, a free port (from dynamic range of 1024 to 65535) is allotted in the client terminal to which the server will connect in order to set connection for transferring of data. The FTP server connects to the client's port with the given number using TCP port 20 from its part to transfer data. In passive mode, the server informs the client about the TCP port number (from the dynamic range of 1024 to 65535) to which the client can connect to set up data transfer.
The main difference between active and passive FTP mode is the part that opens connection for data transferring. In active mode, it is the client who has to accept connection from the FTP server. In passive mode, the client initiates connection, and the server accepts it.
The "Test" button sends report about the current account status using the specified settings that allows to check their workability. If it has been tested successfully, the "OK" button must be pressed to activate these settings. If the test did not succeed, it is recommended to check all settings again and retest.
Thanks for all your help. I've got the FTP connected properly since I get the statement.htm files and my equity amount is saved in the Equity.csv file every tick, but it still doesn't get uploaded. Everything else is fine.
Joined Oct 2006
|
Status: Friendly Neighborhood Programmer
|533 Posts
Are you specifying a directory that you have write permissions to? Aside from that (which is just a guess) I can't really help you much more from my end.
