Sample code for 30+ languages & platforms
Visual FoxPro Requires Chilkat v11.0.0+

Schwab: Export daily OHLCV price history

See more Schwab Examples

Downloads one year of daily open, high, low, close, and volume for one equity. The CSV records each candle’s UTC timestamp and original Unix milliseconds. Volume and prices retain their JSON number text. An empty series leaves any previous export in place.

Use the access token saved by desktop authorization. Enable the Market Data API for the Schwab app. Use the same Chilkat Secrets store as the OAuth example.

Schwab API specification

Chilkat Visual FoxPro Downloads

Visual FoxPro
LOCAL lnSuccess
LOCAL loVault
LOCAL loEntry
LOCAL loTokens
LOCAL lcAccessToken
LOCAL loHttp
LOCAL loResp
LOCAL loQuery
LOCAL loReply
LOCAL lnCount
LOCAL loCsv
LOCAL loMillis
LOCAL loUnixTime
LOCAL loCandleTime
LOCAL i
LOCAL lcTimestamp
LOCAL lnDigits

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

loResp = CreateObject('Chilkat.HttpResponse')
loQuery = CreateObject('Chilkat.HttpRequest')
loQuery.HttpVerb = "GET"
loQuery.AddParam("symbol","AAPL")
loQuery.AddParam("periodType","year")
loQuery.AddParam("period","1")
loQuery.AddParam("frequencyType","daily")
loQuery.AddParam("frequency","1")
loQuery.AddParam("needExtendedHoursData","false")
lnSuccess = loHttp.HttpReq("https://api.schwabapi.com/marketdata/v1/pricehistory",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 loResp
    RELEASE loQuery
    CANCEL
ENDIF

loReply = CreateObject('Chilkat.JsonObject')
lnSuccess = loReply.Load(loResp.BodyStr)
IF (lnSuccess <> 1) THEN
    ? "Schwab returned unexpected JSON."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loQuery
    RELEASE loReply
    CANCEL
ENDIF

lnCount = loReply.SizeOfArray("candles")
IF (lnCount <= 0) THEN
    ? "No candles for this symbol and period."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loQuery
    RELEASE loReply
    CANCEL
ENDIF

loCsv = CreateObject('Chilkat.Csv')
loCsv.SetColumnName(0,"utcTime")
loCsv.SetColumnName(1,"unixMilliseconds")
loCsv.SetColumnName(2,"open")
loCsv.SetColumnName(3,"high")
loCsv.SetColumnName(4,"low")
loCsv.SetColumnName(5,"close")
loCsv.SetColumnName(6,"volume")
loMillis = CreateObject('Chilkat.StringBuilder')
loUnixTime = CreateObject('Chilkat.JsonObject')
loCandleTime = CreateObject('Chilkat.CkDateTime')
i = 0
DO WHILE (i < lnCount)
    loReply.I = i
    lcTimestamp = loReply.StringOf("candles[i].datetime")
    *  DateOf reads Unix seconds. Drop the three millisecond digits as text.
    loMillis.SetString(lcTimestamp)
    lnDigits = loMillis.Length - 3
    IF (lnDigits <= 0) THEN
        ? "Missing candle timestamp."
        RELEASE loVault
        RELEASE loEntry
        RELEASE loTokens
        RELEASE loHttp
        RELEASE loResp
        RELEASE loQuery
        RELEASE loReply
        RELEASE loCsv
        RELEASE loMillis
        RELEASE loUnixTime
        RELEASE loCandleTime
        CANCEL
    ENDIF

    loUnixTime.UpdateNumber("seconds",loMillis.GetRange(0,lnDigits,0))
    lnSuccess = loUnixTime.DateOf("seconds",loCandleTime)
    IF (lnSuccess <> 1) THEN
        ? "Invalid candle timestamp."
        RELEASE loVault
        RELEASE loEntry
        RELEASE loTokens
        RELEASE loHttp
        RELEASE loResp
        RELEASE loQuery
        RELEASE loReply
        RELEASE loCsv
        RELEASE loMillis
        RELEASE loUnixTime
        RELEASE loCandleTime
        CANCEL
    ENDIF

    loCsv.SetCell(i,0,loCandleTime.GetAsTimestamp(0))
    loCsv.SetCell(i,1,lcTimestamp)
    loCsv.SetCell(i,2,loReply.StringOf("candles[i].open"))
    loCsv.SetCell(i,3,loReply.StringOf("candles[i].high"))
    loCsv.SetCell(i,4,loReply.StringOf("candles[i].low"))
    loCsv.SetCell(i,5,loReply.StringOf("candles[i].close"))
    loCsv.SetCell(i,6,loReply.StringOf("candles[i].volume"))
    i = i + 1
ENDDO
lnSuccess = loCsv.SaveFile2("schwab-daily-prices.csv","utf-8")
IF (lnSuccess <> 1) THEN
    ? "Could not write schwab-daily-prices.csv."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loQuery
    RELEASE loReply
    RELEASE loCsv
    RELEASE loMillis
    RELEASE loUnixTime
    RELEASE loCandleTime
    CANCEL
ENDIF

? "Wrote " + STR(loCsv.NumRows) + " rows to schwab-daily-prices.csv."

RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loResp
RELEASE loQuery
RELEASE loReply
RELEASE loCsv
RELEASE loMillis
RELEASE loUnixTime
RELEASE loCandleTime