Visual FoxPro Requires Chilkat v11.0.0+
Visual FoxPro
Schwab: Find an option contract by expiration and strike
See more Schwab Examples
Filters a chain by underlying, call or put, exact expiration, and strike. Choose a currently listed expiration and strike. Schwab groups contracts by expiration and strike and may return multiple deliverables. Compare the descriptions and use the exact returned contract symbol, including its spaces, for a later quote request.
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 lcUnderlying
LOCAL lcExpiration
LOCAL lcStrike
LOCAL lcSide
LOCAL loResp
LOCAL loQuery
LOCAL loReply
LOCAL lcMapName
LOCAL loExpirations
LOCAL loStrikes
LOCAL loContracts
LOCAL loContract
LOCAL lnFound
LOCAL i
LOCAL j
LOCAL k
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
lcUnderlying = "AAPL"
lcExpiration = "2027-01-15"
lcStrike = "250"
lcSide = "CALL"
loResp = CreateObject('Chilkat.HttpResponse')
loQuery = CreateObject('Chilkat.HttpRequest')
loQuery.HttpVerb = "GET"
loQuery.AddParam("symbol",lcUnderlying)
loQuery.AddParam("contractType",lcSide)
loQuery.AddParam("strike",lcStrike)
loQuery.AddParam("fromDate",lcExpiration)
loQuery.AddParam("toDate",lcExpiration)
lnSuccess = loHttp.HttpReq("https://api.schwabapi.com/marketdata/v1/chains",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 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 loResp
RELEASE loQuery
RELEASE loReply
CANCEL
ENDIF
lcMapName = "callExpDateMap"
IF (lcSide = "PUT") THEN
lcMapName = "putExpDateMap"
ENDIF
loExpirations = CreateObject('Chilkat.JsonObject')
lnSuccess = loReply.ObjectOf2(lcMapName,loExpirations)
IF (lnSuccess <> 1) THEN
? "No option map returned. Chain status: " + loReply.StringOf("status")
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loResp
RELEASE loQuery
RELEASE loReply
RELEASE loExpirations
CANCEL
ENDIF
* Expiration keys contain a day count. Strike keys may contain a decimal point.
loStrikes = CreateObject('Chilkat.JsonObject')
loContracts = CreateObject('Chilkat.JsonArray')
loContract = CreateObject('Chilkat.JsonObject')
lnFound = 0
i = 0
DO WHILE (i < loExpirations.Size)
loExpirations.ObjectAt2(i,loStrikes)
j = 0
DO WHILE (j < loStrikes.Size)
loStrikes.ArrayAt2(j,loContracts)
k = 0
DO WHILE (k < loContracts.Size)
loContracts.ObjectAt2(k,loContract)
? loContract.StringOf("description") + " strike " + loContract.StringOf("strikePrice")
? "Contract symbol: [" + loContract.StringOf("symbol") + "]"
lnFound = lnFound + 1
k = k + 1
ENDDO
j = j + 1
ENDDO
i = i + 1
ENDDO
IF (lnFound = 0) THEN
? "No contracts matched the requested expiration, side and strike."
ENDIF
RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loResp
RELEASE loQuery
RELEASE loReply
RELEASE loExpirations
RELEASE loStrikes
RELEASE loContracts
RELEASE loContract