Classic ASP Requires Chilkat v11.0.0+
Classic ASP
Schwab: Inspect an order, its legs, and fills
See more Schwab Examples
Use an order ID from the selected account’s recent orders. The example reads a single order and matches executions to order legs by legId. Each execution can have its own quantity, price, and timestamp. Working orders can have zero or partial fills. The loops cover the returned order’s own legs and activities.
Use the access token saved by desktop authorization. First select the authorized account whose data you want to use. Use the same Chilkat Secrets store as the OAuth example.
Chilkat Classic ASP Downloads
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0
' Assumes Chilkat is unlocked. See Global Unlock Sample.
success = 0
set vault = Server.CreateObject("Chilkat.Secrets")
vault.Location = "local_manager"
vault.AutoSplit = 1
set entry = Server.CreateObject("Chilkat.JsonObject")
success = entry.UpdateString("appName","SchwabTrader")
success = entry.UpdateString("service","OAuth2")
success = entry.UpdateString("username","personal-desktop")
set tokens = Server.CreateObject("Chilkat.JsonObject")
success = vault.GetSecretJson(entry,tokens)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "Could not read the token record. Check the store and complete desktop authorization first.") & "</pre>"
Response.End
End If
accessToken = tokens.StringOf("access_token")
If (accessToken = "") Then
Response.Write "<pre>" & Server.HTMLEncode( "Run the Schwab authorization or refresh example to save an access token.") & "</pre>"
Response.End
End If
set http = Server.CreateObject("Chilkat.Http")
http.RequireSslCertVerify = 1
http.AuthToken = accessToken
' Read the hash saved by the authorized-account selection example.
success = entry.UpdateString("service","SelectedAccount")
set selection = Server.CreateObject("Chilkat.JsonObject")
success = vault.GetSecretJson(entry,selection)
accountHash = selection.StringOf("hashValue")
If ((success <> 1) Or (accountHash = "")) Then
Response.Write "<pre>" & Server.HTMLEncode( "Select an authorized account first.") & "</pre>"
Response.End
End If
success = http.SetUrlVar("account",accountHash)
' Supply the ID as text so large numeric identifiers keep all their digits.
orderId = "ORDER_ID_FROM_LIST"
success = http.SetUrlVar("orderId",orderId)
set resp = Server.CreateObject("Chilkat.HttpResponse")
success = http.HttpNoBody("GET","https://api.schwabapi.com/trader/v1/accounts/{$account}/orders/{$orderId}",resp)
If ((success <> 1) Or (resp.StatusCode <> 200)) Then
If (resp.StatusCode = 0) Then
Response.Write "<pre>" & Server.HTMLEncode( "No HTTP response. Check connectivity.") & "</pre>"
Else
Response.Write "<pre>" & Server.HTMLEncode( "Schwab returned HTTP " & resp.StatusCode) & "</pre>"
If (resp.StatusCode = 401) Then
Response.Write "<pre>" & Server.HTMLEncode( "Refresh the access token or repeat desktop authorization.") & "</pre>"
End If
End If
Response.End
End If
set order = Server.CreateObject("Chilkat.JsonObject")
success = order.Load(resp.BodyStr)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "Schwab returned unexpected JSON.") & "</pre>"
Response.End
End If
Response.Write "<pre>" & Server.HTMLEncode( "Order " & order.StringOf("orderId") & " " & order.StringOf("status")) & "</pre>"
set symbols = Server.CreateObject("Chilkat.JsonObject")
i = 0
Do While (i < order.SizeOfArray("orderLegCollection"))
order.I = i
legId = order.StringOf("orderLegCollection[i].legId")
symbol = order.StringOf("orderLegCollection[i].instrument.symbol")
success = symbols.UpdateString(legId,symbol)
Response.Write "<pre>" & Server.HTMLEncode( "Leg " & legId & " " & order.StringOf("orderLegCollection[i].instruction") & " " & order.StringOf("orderLegCollection[i].quantity") _
& " " & symbol) & "</pre>"
i = i + 1
Loop
fills = 0
i = 0
Do While (i < order.SizeOfArray("orderActivityCollection"))
order.I = i
If (order.StringOfEquals("orderActivityCollection[i].executionType","FILL",1) = 1) Then
j = 0
Do While (j < order.SizeOfArray("orderActivityCollection[i].executionLegs"))
order.J = j
filledLeg = order.StringOf("orderActivityCollection[i].executionLegs[j].legId")
Response.Write "<pre>" & Server.HTMLEncode( "Fill on leg " & filledLeg & " " & symbols.StringOf(filledLeg) & " quantity " & order.StringOf("orderActivityCollection[i].executionLegs[j].quantity") _
& " price " & order.StringOf("orderActivityCollection[i].executionLegs[j].price") & " time " & order.StringOf("orderActivityCollection[i].executionLegs[j].time")) & "</pre>"
fills = fills + 1
j = j + 1
Loop
End If
i = i + 1
Loop
If (fills = 0) Then
Response.Write "<pre>" & Server.HTMLEncode( "No fills reported for this order.") & "</pre>"
End If
%>
</body>
</html>