Visual FoxPro Requires Chilkat v11.0.0+
Visual FoxPro
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 Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loVault
LOCAL loEntry
LOCAL loTokens
LOCAL lcAccessToken
LOCAL loHttp
LOCAL loSelection
LOCAL lcAccountHash
LOCAL loClock
LOCAL loEndTime
LOCAL lnReplacements
LOCAL loStartTime
LOCAL loResp
LOCAL loQuery
LOCAL loActivity
LOCAL loCsv
LOCAL loRow
LOCAL i
lnSuccess = 0
* Assumes Chilkat is unlocked. See Global Unlock Sample.
lnSuccess = 0
loVault = CreateObject('Chilkat.Secrets')
loVault.Location = "local_manager"
loVault.AutoSplit = 1
loEntry = CreateObject('Chilkat.JsonObject')
loEntry.UpdateString("appName","SchwabTrader")
loEntry.UpdateString("service","OAuth2")
loEntry.UpdateString("username","personal-desktop")
loTokens = CreateObject('Chilkat.JsonObject')
lnSuccess = loVault.GetSecretJson(loEntry,loTokens)
IF (lnSuccess <> 1) THEN
? "Could not read the token record. Check the store and complete desktop authorization first."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
CANCEL
ENDIF
lcAccessToken = loTokens.StringOf("access_token")
IF (lcAccessToken = "") THEN
? "Run the Schwab authorization or refresh example to save an access token."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
CANCEL
ENDIF
loHttp = CreateObject('Chilkat.Http')
loHttp.RequireSslCertVerify = 1
loHttp.AuthToken = lcAccessToken
* Read the hash saved by the authorized-account selection example.
loEntry.UpdateString("service","SelectedAccount")
loSelection = CreateObject('Chilkat.JsonObject')
lnSuccess = loVault.GetSecretJson(loEntry,loSelection)
lcAccountHash = loSelection.StringOf("hashValue")
IF ((lnSuccess <> 1) OR (lcAccountHash = "")) THEN
? "Select an authorized account first."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
CANCEL
ENDIF
loHttp.SetUrlVar("account",lcAccountHash)
* Use UTC endpoints for a rolling seven-day window.
loClock = CreateObject('Chilkat.CkDateTime')
loClock.SetFromCurrentSystemTime()
loEndTime = CreateObject('Chilkat.StringBuilder')
loEndTime.Append(loClock.GetAsTimestamp(0))
lnReplacements = loEndTime.Replace("Z",".000Z")
loClock.AddDays(-7)
loStartTime = CreateObject('Chilkat.StringBuilder')
loStartTime.Append(loClock.GetAsTimestamp(0))
lnReplacements = loStartTime.Replace("Z",".000Z")
loResp = CreateObject('Chilkat.HttpResponse')
loQuery = CreateObject('Chilkat.HttpRequest')
loQuery.HttpVerb = "GET"
loQuery.AddParam("startDate",loStartTime.GetAsString())
loQuery.AddParam("endDate",loEndTime.GetAsString())
loQuery.AddParam("types","TRADE,DIVIDEND_OR_INTEREST")
lnSuccess = loHttp.HttpReq("https://api.schwabapi.com/trader/v1/accounts/{$account}/transactions",loQuery,loResp)
IF ((lnSuccess <> 1) OR (loResp.StatusCode <> 200)) THEN
IF (loResp.StatusCode = 0) THEN
? "No HTTP response. Check connectivity."
ELSE
? "Schwab returned HTTP " + STR(loResp.StatusCode)
IF (loResp.StatusCode = 401) THEN
? "Refresh the access token or repeat desktop authorization."
ENDIF
ENDIF
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
RELEASE loClock
RELEASE loEndTime
RELEASE loStartTime
RELEASE loResp
RELEASE loQuery
CANCEL
ENDIF
loActivity = CreateObject('Chilkat.JsonArray')
lnSuccess = loActivity.Load(loResp.BodyStr)
IF (lnSuccess <> 1) THEN
? "Schwab returned unexpected JSON."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
RELEASE loClock
RELEASE loEndTime
RELEASE loStartTime
RELEASE loResp
RELEASE loQuery
RELEASE loActivity
CANCEL
ENDIF
IF (loActivity.Size >= 3000) THEN
? "The response reached the transaction limit. Export smaller time windows."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
RELEASE loClock
RELEASE loEndTime
RELEASE loStartTime
RELEASE loResp
RELEASE loQuery
RELEASE loActivity
CANCEL
ENDIF
loCsv = CreateObject('Chilkat.Csv')
loCsv.SetColumnName(0,"activityId")
loCsv.SetColumnName(1,"time")
loCsv.SetColumnName(2,"type")
loCsv.SetColumnName(3,"tradeDate")
loCsv.SetColumnName(4,"settlementDate")
loCsv.SetColumnName(5,"netAmount")
loRow = CreateObject('Chilkat.JsonObject')
i = 0
DO WHILE (i < loActivity.Size)
loActivity.ObjectAt2(i,loRow)
* Keep identifiers and decimal amounts as returned by Schwab.
loCsv.SetCell(i,0,loRow.StringOf("activityId"))
loCsv.SetCell(i,1,loRow.StringOf("time"))
loCsv.SetCell(i,2,loRow.StringOf("type"))
loCsv.SetCell(i,3,loRow.StringOf("tradeDate"))
loCsv.SetCell(i,4,loRow.StringOf("settlementDate"))
loCsv.SetCell(i,5,loRow.StringOf("netAmount"))
i = i + 1
ENDDO
lnSuccess = loCsv.SaveFile2("schwab-transactions.csv","utf-8")
IF (lnSuccess <> 1) THEN
? "Could not write schwab-transactions.csv."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
RELEASE loClock
RELEASE loEndTime
RELEASE loStartTime
RELEASE loResp
RELEASE loQuery
RELEASE loActivity
RELEASE loCsv
RELEASE loRow
CANCEL
ENDIF
? "Wrote " + STR(loCsv.NumRows) + " rows to schwab-transactions.csv."
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loSelection
RELEASE loClock
RELEASE loEndTime
RELEASE loStartTime
RELEASE loResp
RELEASE loQuery
RELEASE loActivity
RELEASE loCsv
RELEASE loRow