Syntax
Public Function SymbolLotsReport(ClientID As Long, FromDate As String, ToDate As String, Optional ByVal isPaging As Boolean = False) As String
Description
The SymbolLotsReport operation is used to get the symbol lots report that shows the net closed positions on each symbol with more detail for the account(s).
Request Parameters
Name |
Description |
Required |
ClientID |
- Client identifier to get symbol lots report for
- Type : Long
- Default : None
- Constraints : Must be valid client Id and accessible by logged in dealer
|
Yes
|
FromDate |
- Specify the duration
- Type : String
- Default : None
- Constraints : must be valid date format (“DD/MM/YYYY HH:NN:SS”)
- “” : means from beginning
|
Yes
|
ToDate |
- Specify the duration
- Type : String
- Default : None
- Constraints : must be valid date format (“DD/MM/YYYY HH:NN:SS”)
- “” : means till now
|
Yes
|
isPaging |
- Boolean value which indicate that you are calling SymbolLotsReport to get remaining records
- This is useful if you are calling a large amount of data to split the returned data as 3000 rows for each response
- Type : Boolean
- Default : False
- Constraints : on first call must be false and next calls true
|
Conditional if the first ClientID in SymbolLotsReport List = -1200
|
Response Elements
Name |
Description |
Result |
The operation returns list of type SymbolLotsReport, otherwise an explicit error code is returned if ClientID is less than 0 .
The Following are the SymbolLotsReport data member
- ClientID : Client number
- AccountId : Account number
- SymbolID: Symbol ID
- Amount : Lots Amount
- commission : commission value
- Interest : Interest Value
- PL : Profit loss value
- SymbolName : Symbol name
|
Sample
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>SymbolLotsReport</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
</head>
<script>
$(document).ready(function () {
var urlStr = "http://173.249.35.43/webtrader/webservice.svc";
jQuery.support.cors = true;
$("#progress").ajaxStart(function () { $(this).css("display", "block"); });
$("#progress").ajaxComplete(function () { $(this).css("display", "none"); });
$("#resultAction").ajaxError(function (result) { $(this).html('An error occured'); });
function onSuccessResultt(dataResult) {
var result = eval(dataResult);
var rst = ""
if (result[0].ClientID > 0) {
for (var i = 0; i < result.length; i++) {
rst += "AccountID : " + result[i].AccountID + "<br/>"
rst += "SymbolID : " + result[i].SymbolID + "<br/>"
rst += "SymbolName : " + result[i].SymbolName + "<br/>"
rst += "Amount : " + result[i].Amount + "<br/>"
rst += "Commission : " + result[i].Commission + "<br/>"
rst += "Interest : " + result[i].Interest + "<br/>"
rst += "PL : " + result[i].PL + "<br/>"
rst += "ClientID : " + result[i].ClientID + "<br/>"
rst += "--------------------------------------------------" + "<br/>"
$("#resultAction").html(rst)
}
}
else {
$("#resultAction").html("Error Code : " + result[0].ClientID + "<br/>" );
}
}
function onSuccessResult(response) {
response = eval('(' + response + ')')
if (response.UserId == -1 || response.UserId == -207) {
$("#resultData").html("Invalid username or password");
}
else if (response.UserId == -231) {
$("#resultData").html("You must have at least one account");
}
else if (response == null || response == "" || response.UserId < 0) {
$("#resultData").html("Error while login.Please try later");
}
else {
$("#resultData").html("SuccessResult ... UserId is :" + response.UserId);
}
}
function onErrorResult(result) {
alert('Service call faild : ' + result.status + ' ' + result.statusText);
}
$("#btnLogin").click(function () {
$.getJSON(urlStr + "/BackofficeLogin?username=" + $("#txtusername").val() + "&password=" + $("#txtpassword").val() + "&callback=?" , onSuccessResult);
});
$("#btnAction").click(function () {
$.getJSON(urlStr + "/SymbolLotsReport?ClientID="+ $("#txtClientID").val() + "&FormDate=" + $("#txtFromDate").val() + "&ToDate=" + $("#txtToDate").val()+ "&isPaging=" + $("#txtIsPaging").val() + "&callback=?", onSuccessResultt);
});
});
</script>
<body>
<table border="1px">
<tbody>
<tr>
<td>
Username: <input type="text" id="txtusername" value=""/>
Password: <input type="text" id="txtpassword" value=""/>
<button id="btnLogin"> Login </button>
</td>
</tr>
<tr >
<td>
ClientID : <input type="text" id="txtClientID" value ="" />
FromDate : <input type="text" id="txtFromDate" value=""/>
ToDate : <input type="text" id="txtToDate" value="" />
</td>
</tr>
<tr>
<td>
IsPaging : <input type="text" id="txtIsPaging" value="FALSE"/>
<button id="btnAction"> SymbolLotsReport </button>
</td>
</tr>
</tbody>
</table>
<div id="resultData"> </div>
<div id="resultAction"> </div>
</body>
</html>
See Also
VertexFX Backoffice WCF Service Index
|