(Visual Basic 6.0) Finnhub API - Get Stock Quote

See more AI Examples

Note: This example requires Chilkat v11.4.0 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim success As Long
success = 0

' Replace with your actual Finnhub API key.
Dim apiKey As String
apiKey = "YOUR_FINNHUB_API_KEY"
Dim symbol As String
symbol = "AAPL"

Dim http As New ChilkatHttp

' This is the URL without params.
Dim urlWithoutParams As String
urlWithoutParams = "https://finnhub.io/api/v1/quote"

Dim req As New ChilkatHttpRequest

' Add params that will be sent in the URL.
req.AddParam "symbol",symbol
req.AddParam "token",apiKey

req.HttpVerb = "GET"

' Send the request to get the JSON response.
Dim resp As New ChilkatHttpResponse
success = http.HttpReq(urlWithoutParams,req,resp)
If (success = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim json As New ChilkatJsonObject
success = resp.GetBodyJson(json)

Dim statusCode As Long
statusCode = resp.StatusCode
Debug.Print "response status code: " & statusCode

json.EmitCompact = 0
Debug.Print json.Emit()

' Sample result:

' {
'   "c": 248.8,
'   "d": -4.09,
'   "dp": -1.6173,
'   "h": 255.493,
'   "l": 248.07,
'   "o": 253.9,
'   "pc": 252.89,
'   "t": 1774641600
' }

If (statusCode = 200) Then
    ' Add the symbol to the top of the result.
    success = json.AddStringAt(0,"symbol",symbol)

    ' Rename members for clarification.
    success = json.Rename("c","currentPrice")
    success = json.Rename("d","change")
    success = json.Rename("dp","percentChange")
    success = json.Rename("h","high")
    success = json.Rename("l","low")
    success = json.Rename("o","open")
    success = json.Rename("pc","prevClose")
    success = json.Rename("t","unixTime")

    Debug.Print json.Emit()

Else
    Debug.Print "Failed"
End If