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

Unicode C
#include <C_CkSecretsW.h>
#include <C_CkJsonObjectW.h>
#include <C_CkHttpW.h>
#include <C_CkHttpResponseW.h>
#include <C_CkHttpRequestW.h>
#include <C_CkCsvW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkDateTimeW.h>

void ChilkatSample(void)
    {
    BOOL success;
    HCkSecretsW vault;
    HCkJsonObjectW entry;
    HCkJsonObjectW tokens;
    const wchar_t *accessToken;
    HCkHttpW http;
    HCkHttpResponseW resp;
    HCkHttpRequestW query;
    HCkJsonObjectW reply;
    int count;
    HCkCsvW csv;
    HCkStringBuilderW millis;
    HCkJsonObjectW unixTime;
    HCkDateTimeW candleTime;
    int i;
    const wchar_t *timestamp;
    int digits;

    success = FALSE;

    //  Assumes Chilkat is unlocked. See Global Unlock Sample.
    success = FALSE;

    vault = CkSecretsW_Create();
    CkSecretsW_putLocation(vault,L"local_manager");
    CkSecretsW_putAutoSplit(vault,TRUE);
    entry = CkJsonObjectW_Create();
    CkJsonObjectW_UpdateString(entry,L"appName",L"SchwabTrader");
    CkJsonObjectW_UpdateString(entry,L"service",L"OAuth2");
    CkJsonObjectW_UpdateString(entry,L"username",L"personal-desktop");
    tokens = CkJsonObjectW_Create();
    success = CkSecretsW_GetSecretJson(vault,entry,tokens);
    if (success != TRUE) {
        wprintf(L"Could not read the token record. Check the store and complete desktop authorization first.\n");
        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        return;
    }

    accessToken = CkJsonObjectW_stringOf(tokens,L"access_token");
    if (accessToken == L"") {
        wprintf(L"Run the Schwab authorization or refresh example to save an access token.\n");
        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        return;
    }

    http = CkHttpW_Create();
    CkHttpW_putRequireSslCertVerify(http,TRUE);
    CkHttpW_putAuthToken(http,accessToken);

    resp = CkHttpResponseW_Create();
    query = CkHttpRequestW_Create();
    CkHttpRequestW_putHttpVerb(query,L"GET");
    CkHttpRequestW_AddParam(query,L"symbol",L"AAPL");
    CkHttpRequestW_AddParam(query,L"periodType",L"year");
    CkHttpRequestW_AddParam(query,L"period",L"1");
    CkHttpRequestW_AddParam(query,L"frequencyType",L"daily");
    CkHttpRequestW_AddParam(query,L"frequency",L"1");
    CkHttpRequestW_AddParam(query,L"needExtendedHoursData",L"false");
    success = CkHttpW_HttpReq(http,L"https://api.schwabapi.com/marketdata/v1/pricehistory",query,resp);
    if ((success != TRUE) || (CkHttpResponseW_getStatusCode(resp) != 200)) {
        if (CkHttpResponseW_getStatusCode(resp) == 0) {
            wprintf(L"No HTTP response. Check connectivity.\n");
        }
        else {
            wprintf(L"Schwab returned HTTP %d\n",CkHttpResponseW_getStatusCode(resp));
            if (CkHttpResponseW_getStatusCode(resp) == 401) {
                wprintf(L"Refresh the access token or repeat desktop authorization.\n");
            }

        }

        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        CkHttpW_Dispose(http);
        CkHttpResponseW_Dispose(resp);
        CkHttpRequestW_Dispose(query);
        return;
    }

    reply = CkJsonObjectW_Create();
    success = CkJsonObjectW_Load(reply,CkHttpResponseW_bodyStr(resp));
    if (success != TRUE) {
        wprintf(L"Schwab returned unexpected JSON.\n");
        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        CkHttpW_Dispose(http);
        CkHttpResponseW_Dispose(resp);
        CkHttpRequestW_Dispose(query);
        CkJsonObjectW_Dispose(reply);
        return;
    }

    count = CkJsonObjectW_SizeOfArray(reply,L"candles");
    if (count <= 0) {
        wprintf(L"No candles for this symbol and period.\n");
        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        CkHttpW_Dispose(http);
        CkHttpResponseW_Dispose(resp);
        CkHttpRequestW_Dispose(query);
        CkJsonObjectW_Dispose(reply);
        return;
    }

    csv = CkCsvW_Create();
    CkCsvW_SetColumnName(csv,0,L"utcTime");
    CkCsvW_SetColumnName(csv,1,L"unixMilliseconds");
    CkCsvW_SetColumnName(csv,2,L"open");
    CkCsvW_SetColumnName(csv,3,L"high");
    CkCsvW_SetColumnName(csv,4,L"low");
    CkCsvW_SetColumnName(csv,5,L"close");
    CkCsvW_SetColumnName(csv,6,L"volume");
    millis = CkStringBuilderW_Create();
    unixTime = CkJsonObjectW_Create();
    candleTime = CkDateTimeW_Create();
    i = 0;
    while ((i < count)) {
        CkJsonObjectW_putI(reply,i);
        timestamp = CkJsonObjectW_stringOf(reply,L"candles[i].datetime");
        //  DateOf reads Unix seconds. Drop the three millisecond digits as text.
        CkStringBuilderW_SetString(millis,timestamp);
        digits = CkStringBuilderW_getLength(millis) - 3;
        if (digits <= 0) {
            wprintf(L"Missing candle timestamp.\n");
            CkSecretsW_Dispose(vault);
            CkJsonObjectW_Dispose(entry);
            CkJsonObjectW_Dispose(tokens);
            CkHttpW_Dispose(http);
            CkHttpResponseW_Dispose(resp);
            CkHttpRequestW_Dispose(query);
            CkJsonObjectW_Dispose(reply);
            CkCsvW_Dispose(csv);
            CkStringBuilderW_Dispose(millis);
            CkJsonObjectW_Dispose(unixTime);
            CkDateTimeW_Dispose(candleTime);
            return;
        }

        CkJsonObjectW_UpdateNumber(unixTime,L"seconds",CkStringBuilderW_getRange(millis,0,digits,FALSE));
        success = CkJsonObjectW_DateOf(unixTime,L"seconds",candleTime);
        if (success != TRUE) {
            wprintf(L"Invalid candle timestamp.\n");
            CkSecretsW_Dispose(vault);
            CkJsonObjectW_Dispose(entry);
            CkJsonObjectW_Dispose(tokens);
            CkHttpW_Dispose(http);
            CkHttpResponseW_Dispose(resp);
            CkHttpRequestW_Dispose(query);
            CkJsonObjectW_Dispose(reply);
            CkCsvW_Dispose(csv);
            CkStringBuilderW_Dispose(millis);
            CkJsonObjectW_Dispose(unixTime);
            CkDateTimeW_Dispose(candleTime);
            return;
        }

        CkCsvW_SetCell(csv,i,0,CkDateTimeW_getAsTimestamp(candleTime,FALSE));
        CkCsvW_SetCell(csv,i,1,timestamp);
        CkCsvW_SetCell(csv,i,2,CkJsonObjectW_stringOf(reply,L"candles[i].open"));
        CkCsvW_SetCell(csv,i,3,CkJsonObjectW_stringOf(reply,L"candles[i].high"));
        CkCsvW_SetCell(csv,i,4,CkJsonObjectW_stringOf(reply,L"candles[i].low"));
        CkCsvW_SetCell(csv,i,5,CkJsonObjectW_stringOf(reply,L"candles[i].close"));
        CkCsvW_SetCell(csv,i,6,CkJsonObjectW_stringOf(reply,L"candles[i].volume"));
        i = i + 1;
    }

    success = CkCsvW_SaveFile2(csv,L"schwab-daily-prices.csv",L"utf-8");
    if (success != TRUE) {
        wprintf(L"Could not write schwab-daily-prices.csv.\n");
        CkSecretsW_Dispose(vault);
        CkJsonObjectW_Dispose(entry);
        CkJsonObjectW_Dispose(tokens);
        CkHttpW_Dispose(http);
        CkHttpResponseW_Dispose(resp);
        CkHttpRequestW_Dispose(query);
        CkJsonObjectW_Dispose(reply);
        CkCsvW_Dispose(csv);
        CkStringBuilderW_Dispose(millis);
        CkJsonObjectW_Dispose(unixTime);
        CkDateTimeW_Dispose(candleTime);
        return;
    }

    wprintf(L"Wrote %d rows to schwab-daily-prices.csv.\n",CkCsvW_getNumRows(csv));


    CkSecretsW_Dispose(vault);
    CkJsonObjectW_Dispose(entry);
    CkJsonObjectW_Dispose(tokens);
    CkHttpW_Dispose(http);
    CkHttpResponseW_Dispose(resp);
    CkHttpRequestW_Dispose(query);
    CkJsonObjectW_Dispose(reply);
    CkCsvW_Dispose(csv);
    CkStringBuilderW_Dispose(millis);
    CkJsonObjectW_Dispose(unixTime);
    CkDateTimeW_Dispose(candleTime);

    }