Classic ASP Requires Chilkat v11.0.0+
Classic ASP
Schwab: Export account transactions to CSV
See more Schwab Examples
Exports the last seven days of trades, dividends, and interest for one account. Each UTF-8 CSV row represents an activity, including its signed net amount. The file is replaced on each run. For incremental imports, key records by account and activityId so overlapping date windows do not duplicate entries. If a window returns the 3,000-transaction maximum, split it before treating it as complete.
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)
' Use UTC endpoints for a rolling seven-day window.
set clock = Server.CreateObject("Chilkat.CkDateTime")
success = clock.SetFromCurrentSystemTime()
set endTime = Server.CreateObject("Chilkat.StringBuilder")
success = endTime.Append(clock.GetAsTimestamp(0))
replacements = endTime.Replace("Z",".000Z")
success = clock.AddDays(-7)
set startTime = Server.CreateObject("Chilkat.StringBuilder")
success = startTime.Append(clock.GetAsTimestamp(0))
replacements = startTime.Replace("Z",".000Z")
set resp = Server.CreateObject("Chilkat.HttpResponse")
set query = Server.CreateObject("Chilkat.HttpRequest")
query.HttpVerb = "GET"
query.AddParam "startDate",startTime.GetAsString()
query.AddParam "endDate",endTime.GetAsString()
query.AddParam "types","TRADE,DIVIDEND_OR_INTEREST"
success = http.HttpReq("https://api.schwabapi.com/trader/v1/accounts/{$account}/transactions",query,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 activity = Server.CreateObject("Chilkat.JsonArray")
success = activity.Load(resp.BodyStr)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "Schwab returned unexpected JSON.") & "</pre>"
Response.End
End If
If (activity.Size >= 3000) Then
Response.Write "<pre>" & Server.HTMLEncode( "The response reached the transaction limit. Export smaller time windows.") & "</pre>"
Response.End
End If
set csv = Server.CreateObject("Chilkat.Csv")
success = csv.SetColumnName(0,"activityId")
success = csv.SetColumnName(1,"time")
success = csv.SetColumnName(2,"type")
success = csv.SetColumnName(3,"tradeDate")
success = csv.SetColumnName(4,"settlementDate")
success = csv.SetColumnName(5,"netAmount")
set row = Server.CreateObject("Chilkat.JsonObject")
i = 0
Do While (i < activity.Size)
success = activity.ObjectAt2(i,row)
' Keep identifiers and decimal amounts as returned by Schwab.
success = csv.SetCell(i,0,row.StringOf("activityId"))
success = csv.SetCell(i,1,row.StringOf("time"))
success = csv.SetCell(i,2,row.StringOf("type"))
success = csv.SetCell(i,3,row.StringOf("tradeDate"))
success = csv.SetCell(i,4,row.StringOf("settlementDate"))
success = csv.SetCell(i,5,row.StringOf("netAmount"))
i = i + 1
Loop
success = csv.SaveFile2("schwab-transactions.csv","utf-8")
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "Could not write schwab-transactions.csv.") & "</pre>"
Response.End
End If
Response.Write "<pre>" & Server.HTMLEncode( "Wrote " & csv.NumRows & " rows to schwab-transactions.csv.") & "</pre>"
%>
</body>
</html>