Data retrieval API

Discussion in 'General Questions' started by Catherine, Jan 17, 2018.

Data retrieval API

Tags:
  1. Catherine

    Catherine New Member

    Joined:
    Jan 16, 2018
    Messages:
    2
    Likes Received:
    0
    Hello

    Regarding the API, what Key should I use in my code? ---“Enter your Key here”

    Thanks!
    Catherine
    =======================================================
    Sub Test()

    Dim objRequest As Object
    Dim strResponse As String
    Dim blnAsync As Boolean

    Set objRequest = CreateObject(“WinHttp.WinHttpRequest.5.1”)
    blnAsync = True

    With objRequest
    .Open “GET”, “https://api.marketxls.com/historical-prices/MSFT/2017-01-01/2018-01-16/daily/ohlcv”, blnAsync
    .setRequestHeader “x-api-key”, “Enter your Key here”
    .send
    .WaitForResponse
    strResponse = .responseText

    Debug.Print strResponse
    Debug.Print .Status
    End With

    MsgBox strResponse

    End Sub
     
  2. Yanique

    Yanique Administrator
    Staff Member

    Joined:
    Dec 12, 2017
    Messages:
    9
    Likes Received:
    0
    Where is it asking you to enter the API?
     
  3. Catherine

    Catherine New Member

    Joined:
    Jan 16, 2018
    Messages:
    2
    Likes Received:
    0
  4. Yanique

    Yanique Administrator
    Staff Member

    Joined:
    Dec 12, 2017
    Messages:
    9
    Likes Received:
    0
    Thank you Catherine,

    MarketXLS so not current support API, so we will not be able to provide this to you.

    Sorry for any inconvenience.

    Regards,
     

Share This Page