Visual FoxPro Requires Chilkat v11.0.0+
Visual FoxPro
Schwab: Check equity market hours for a date
See more Schwab Examples
Looks up the US equity calendar for a selected trading date. Reads each product’s open flag and the actual regular-session start and end, including their offsets. This distinguishes a holiday closure from a shortened session. The open flag describes the requested date, not whether the market is open at this instant.
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 Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loVault
LOCAL loEntry
LOCAL loTokens
LOCAL lcAccessToken
LOCAL loHttp
LOCAL loClock
LOCAL lcMarketDate
LOCAL loResp
LOCAL loQuery
LOCAL loReply
LOCAL loProducts
LOCAL loProduct
LOCAL i
LOCAL j
LOCAL lnCount
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
* Supply the calendar date you want to check, for example a US holiday.
loClock = CreateObject('Chilkat.CkDateTime')
loClock.SetFromCurrentSystemTime()
lcMarketDate = loClock.GetAsIso8601("YYYY-MM-DD",0)
loResp = CreateObject('Chilkat.HttpResponse')
loQuery = CreateObject('Chilkat.HttpRequest')
loQuery.HttpVerb = "GET"
loQuery.AddParam("date",lcMarketDate)
lnSuccess = loHttp.HttpReq("https://api.schwabapi.com/marketdata/v1/markets/equity",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 loClock
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 loClock
RELEASE loResp
RELEASE loQuery
RELEASE loReply
CANCEL
ENDIF
loProducts = CreateObject('Chilkat.JsonObject')
lnSuccess = loReply.ObjectOf2("equity",loProducts)
IF ((lnSuccess <> 1) OR (loProducts.Size = 0)) THEN
? "No equity market schedule returned for " + lcMarketDate
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loClock
RELEASE loResp
RELEASE loQuery
RELEASE loReply
RELEASE loProducts
CANCEL
ENDIF
loProduct = CreateObject('Chilkat.JsonObject')
i = 0
DO WHILE (i < loProducts.Size)
loProducts.ObjectAt2(i,loProduct)
? loProducts.NameAt(i) + " " + loProduct.StringOf("date")
IF (loProduct.BoolOf("isOpen") = 1) THEN
j = 0
lnCount = loProduct.SizeOfArray("sessionHours.regularMarket")
IF (lnCount <= 0) THEN
? "Open date, but no regular-session times were supplied."
ENDIF
DO WHILE (j < lnCount)
loProduct.J = j
? "Regular session: " + loProduct.StringOf("sessionHours.regularMarket[j].start") + " to " + loProduct.StringOf("sessionHours.regularMarket[j].end")
j = j + 1
ENDDO
ELSE
? "Closed for this date."
ENDIF
i = i + 1
ENDDO
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loClock
RELEASE loResp
RELEASE loQuery
RELEASE loReply
RELEASE loProducts
RELEASE loProduct