Sample code for 30+ languages & platforms
Xbase++ 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 Xbase++ Downloads

Xbase++
LOCAL nSuccess
LOCAL oVault
LOCAL oEntry
LOCAL oTokens
LOCAL cAccessToken
LOCAL oHttp
LOCAL oResp
LOCAL oQuery
LOCAL oReply
LOCAL nCount
LOCAL oCsv
LOCAL oMillis
LOCAL oUnixTime
LOCAL oCandleTime
LOCAL i
LOCAL cTimestamp
LOCAL nDigits

nSuccess := 0

//  Assumes Chilkat is unlocked. See Global Unlock Sample.
nSuccess := 0

oVault := CreateObject("Chilkat.Secrets")
oVault:Location := "local_manager"
oVault:AutoSplit := 1
oEntry := CreateObject("Chilkat.JsonObject")
oEntry:UpdateString("appName", "SchwabTrader")
oEntry:UpdateString("service", "OAuth2")
oEntry:UpdateString("username", "personal-desktop")
oTokens := CreateObject("Chilkat.JsonObject")
nSuccess := oVault:GetSecretJson(oEntry, oTokens)
IF (nSuccess != 1)
    ? "Could not read the token record. Check the store and complete desktop authorization first."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    RETURN
ENDIF

cAccessToken := oTokens:StringOf("access_token")
IF (cAccessToken == "")
    ? "Run the Schwab authorization or refresh example to save an access token."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    RETURN
ENDIF

oHttp := CreateObject("Chilkat.Http")
oHttp:RequireSslCertVerify := 1
oHttp:AuthToken := cAccessToken

oResp := CreateObject("Chilkat.HttpResponse")
oQuery := CreateObject("Chilkat.HttpRequest")
oQuery:HttpVerb := "GET"
oQuery:AddParam("symbol", "AAPL")
oQuery:AddParam("periodType", "year")
oQuery:AddParam("period", "1")
oQuery:AddParam("frequencyType", "daily")
oQuery:AddParam("frequency", "1")
oQuery:AddParam("needExtendedHoursData", "false")
nSuccess := oHttp:HttpReq("https://api.schwabapi.com/marketdata/v1/pricehistory", oQuery, oResp)
IF ((nSuccess != 1) .OR. (oResp:StatusCode != 200))
    IF (oResp:StatusCode == 0)
        ? "No HTTP response. Check connectivity."
    ELSE
        ? "Schwab returned HTTP " + Str(oResp:StatusCode)
        IF (oResp:StatusCode == 401)
            ? "Refresh the access token or repeat desktop authorization."
        ENDIF

    ENDIF

    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oQuery:destroy()
    RETURN
ENDIF

oReply := CreateObject("Chilkat.JsonObject")
nSuccess := oReply:Load(oResp:BodyStr)
IF (nSuccess != 1)
    ? "Schwab returned unexpected JSON."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oQuery:destroy()
    oReply:destroy()
    RETURN
ENDIF

nCount := oReply:SizeOfArray("candles")
IF (nCount <= 0)
    ? "No candles for this symbol and period."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oQuery:destroy()
    oReply:destroy()
    RETURN
ENDIF

oCsv := CreateObject("Chilkat.Csv")
oCsv:SetColumnName(0, "utcTime")
oCsv:SetColumnName(1, "unixMilliseconds")
oCsv:SetColumnName(2, "open")
oCsv:SetColumnName(3, "high")
oCsv:SetColumnName(4, "low")
oCsv:SetColumnName(5, "close")
oCsv:SetColumnName(6, "volume")
oMillis := CreateObject("Chilkat.StringBuilder")
oUnixTime := CreateObject("Chilkat.JsonObject")
oCandleTime := CreateObject("Chilkat.CkDateTime")
i := 0
DO WHILE (i < nCount)
    oReply:I := i
    cTimestamp := oReply:StringOf("candles[i].datetime")
    //  DateOf reads Unix seconds. Drop the three millisecond digits as text.
    oMillis:SetString(cTimestamp)
    nDigits := oMillis:Length - 3
    IF (nDigits <= 0)
        ? "Missing candle timestamp."
        oVault:destroy()
        oEntry:destroy()
        oTokens:destroy()
        oHttp:destroy()
        oResp:destroy()
        oQuery:destroy()
        oReply:destroy()
        oCsv:destroy()
        oMillis:destroy()
        oUnixTime:destroy()
        oCandleTime:destroy()
        RETURN
    ENDIF

    oUnixTime:UpdateNumber("seconds", oMillis:GetRange(0, nDigits, 0))
    nSuccess := oUnixTime:DateOf("seconds", oCandleTime)
    IF (nSuccess != 1)
        ? "Invalid candle timestamp."
        oVault:destroy()
        oEntry:destroy()
        oTokens:destroy()
        oHttp:destroy()
        oResp:destroy()
        oQuery:destroy()
        oReply:destroy()
        oCsv:destroy()
        oMillis:destroy()
        oUnixTime:destroy()
        oCandleTime:destroy()
        RETURN
    ENDIF

    oCsv:SetCell(i, 0, oCandleTime:GetAsTimestamp(0))
    oCsv:SetCell(i, 1, cTimestamp)
    oCsv:SetCell(i, 2, oReply:StringOf("candles[i].open"))
    oCsv:SetCell(i, 3, oReply:StringOf("candles[i].high"))
    oCsv:SetCell(i, 4, oReply:StringOf("candles[i].low"))
    oCsv:SetCell(i, 5, oReply:StringOf("candles[i].close"))
    oCsv:SetCell(i, 6, oReply:StringOf("candles[i].volume"))
    i := i + 1
ENDDO
nSuccess := oCsv:SaveFile2("schwab-daily-prices.csv", "utf-8")
IF (nSuccess != 1)
    ? "Could not write schwab-daily-prices.csv."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oQuery:destroy()
    oReply:destroy()
    oCsv:destroy()
    oMillis:destroy()
    oUnixTime:destroy()
    oCandleTime:destroy()
    RETURN
ENDIF

? "Wrote " + Str(oCsv:NumRows) + " rows to schwab-daily-prices.csv."

oVault:destroy()
oEntry:destroy()
oTokens:destroy()
oHttp:destroy()
oResp:destroy()
oQuery:destroy()
oReply:destroy()
oCsv:destroy()
oMillis:destroy()
oUnixTime:destroy()
oCandleTime:destroy()