.NET Core C# Requires Chilkat v11.0.0+
.NET Core C#
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.
Chilkat .NET Core C# Downloads
bool success = false;
// Assumes Chilkat is unlocked. See Global Unlock Sample.
success = false;
Chilkat.Secrets vault = new Chilkat.Secrets();
vault.Location = "local_manager";
vault.AutoSplit = true;
Chilkat.JsonObject entry = new Chilkat.JsonObject();
entry.UpdateString("appName","SchwabTrader");
entry.UpdateString("service","OAuth2");
entry.UpdateString("username","personal-desktop");
Chilkat.JsonObject tokens = new Chilkat.JsonObject();
success = vault.GetSecretJson(entry,tokens);
if (success != true) {
Debug.WriteLine("Could not read the token record. Check the store and complete desktop authorization first.");
return;
}
string accessToken = tokens.StringOf("access_token");
if (accessToken == "") {
Debug.WriteLine("Run the Schwab authorization or refresh example to save an access token.");
return;
}
Chilkat.Http http = new Chilkat.Http();
http.RequireSslCertVerify = true;
http.AuthToken = accessToken;
Chilkat.HttpResponse resp = new Chilkat.HttpResponse();
Chilkat.HttpRequest query = new Chilkat.HttpRequest();
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) {
Debug.WriteLine("No HTTP response. Check connectivity.");
}
else {
Debug.WriteLine("Schwab returned HTTP " + Convert.ToString(resp.StatusCode));
if (resp.StatusCode == 401) {
Debug.WriteLine("Refresh the access token or repeat desktop authorization.");
}
}
return;
}
Chilkat.JsonObject reply = new Chilkat.JsonObject();
success = reply.Load(resp.BodyStr);
if (success != true) {
Debug.WriteLine("Schwab returned unexpected JSON.");
return;
}
int count = reply.SizeOfArray("candles");
if (count <= 0) {
Debug.WriteLine("No candles for this symbol and period.");
return;
}
Chilkat.Csv csv = new Chilkat.Csv();
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");
Chilkat.StringBuilder millis = new Chilkat.StringBuilder();
Chilkat.JsonObject unixTime = new Chilkat.JsonObject();
Chilkat.CkDateTime candleTime = new Chilkat.CkDateTime();
int i = 0;
while ((i < count)) {
reply.I = i;
string timestamp = reply.StringOf("candles[i].datetime");
// DateOf reads Unix seconds. Drop the three millisecond digits as text.
millis.SetString(timestamp);
int digits = millis.Length - 3;
if (digits <= 0) {
Debug.WriteLine("Missing candle timestamp.");
return;
}
unixTime.UpdateNumber("seconds",millis.GetRange(0,digits,false));
success = unixTime.DateOf("seconds",candleTime);
if (success != true) {
Debug.WriteLine("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) {
Debug.WriteLine("Could not write schwab-daily-prices.csv.");
return;
}
Debug.WriteLine("Wrote " + Convert.ToString(csv.NumRows) + " rows to schwab-daily-prices.csv.");