JavaScript Requires Chilkat v11.0.0+
JavaScript
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.
Note
This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat
v11.4.0 or greater.
var success = false;
// Assumes Chilkat is unlocked. See Global Unlock Sample.
success = false;
var vault = new CkSecrets();
vault.Location = "local_manager";
vault.AutoSplit = true;
var entry = new CkJsonObject();
entry.UpdateString("appName","SchwabTrader");
entry.UpdateString("service","OAuth2");
entry.UpdateString("username","personal-desktop");
var tokens = new CkJsonObject();
success = vault.GetSecretJson(entry,tokens);
if (success !== true) {
console.log("Could not read the token record. Check the store and complete desktop authorization first.");
return;
}
var accessToken = tokens.StringOf("access_token");
if (accessToken == "") {
console.log("Run the Schwab authorization or refresh example to save an access token.");
return;
}
var http = new CkHttp();
http.RequireSslCertVerify = true;
http.AuthToken = accessToken;
var resp = new CkHttpResponse();
var query = new CkHttpRequest();
query.HttpVerb = "GET";
query.AddParam("symbol","AAPL");
query.AddParam("periodType","year");
query.AddParam("period","1");
query.AddParam("frequencyType","daily");
query.AddParam("frequency","1");
query.AddParam("needExtendedHoursData","false");
success = http.HttpReq("https://api.schwabapi.com/marketdata/v1/pricehistory",query,resp);
if ((success !== true) || (resp.StatusCode !== 200)) {
if (resp.StatusCode == 0) {
console.log("No HTTP response. Check connectivity.");
}
else {
console.log("Schwab returned HTTP " + resp.StatusCode);
if (resp.StatusCode == 401) {
console.log("Refresh the access token or repeat desktop authorization.");
}
}
return;
}
var reply = new CkJsonObject();
success = reply.Load(resp.BodyStr);
if (success !== true) {
console.log("Schwab returned unexpected JSON.");
return;
}
var count = reply.SizeOfArray("candles");
if (count <= 0) {
console.log("No candles for this symbol and period.");
return;
}
var csv = new CkCsv();
csv.SetColumnName(0,"utcTime");
csv.SetColumnName(1,"unixMilliseconds");
csv.SetColumnName(2,"open");
csv.SetColumnName(3,"high");
csv.SetColumnName(4,"low");
csv.SetColumnName(5,"close");
csv.SetColumnName(6,"volume");
var millis = new CkStringBuilder();
var unixTime = new CkJsonObject();
var candleTime = new CkDateTime();
var i = 0;
while ((i < count)) {
reply.I = i;
var timestamp = reply.StringOf("candles[i].datetime");
// DateOf reads Unix seconds. Drop the three millisecond digits as text.
millis.SetString(timestamp);
var digits = millis.Length - 3;
if (digits <= 0) {
console.log("Missing candle timestamp.");
return;
}
unixTime.UpdateNumber("seconds",millis.GetRange(0,digits,false));
success = unixTime.DateOf("seconds",candleTime);
if (success !== true) {
console.log("Invalid candle timestamp.");
return;
}
csv.SetCell(i,0,candleTime.GetAsTimestamp(false));
csv.SetCell(i,1,timestamp);
csv.SetCell(i,2,reply.StringOf("candles[i].open"));
csv.SetCell(i,3,reply.StringOf("candles[i].high"));
csv.SetCell(i,4,reply.StringOf("candles[i].low"));
csv.SetCell(i,5,reply.StringOf("candles[i].close"));
csv.SetCell(i,6,reply.StringOf("candles[i].volume"));
i = i+1;
}
success = csv.SaveFile2("schwab-daily-prices.csv","utf-8");
if (success !== true) {
console.log("Could not write schwab-daily-prices.csv.");
return;
}
console.log("Wrote " + csv.NumRows + " rows to schwab-daily-prices.csv.");