How to get Historical Price via VBA from "Today" to a fixed date

Discussion in 'Historical Data' started by Jack_S, Jul 29, 2017.

How to get Historical Price via VBA from "Today" to a fixed date

  1. Jack_S

    Jack_S New Member

    Joined:
    Jul 29, 2017
    Messages:
    3
    Likes Received:
    0
    Is there a way to get Historical Price Data (O,H,L,C,Vol,AC) via a VBA Macro in Excel from "Today" to a fixed historical date, say January 2, 1992.

    As of July 28, 2017, the "Record" in Excel does not facilitate this. Is there a way to get the Historical Price Data with "Code" or are there plans to have this function work with the Macro Record function?

    :- )
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Its a bit tricky as we do not use VBA but we have a COM dll. But I am sure it is possible. I have not figured it yet nor have done it. I tried once but Excel could support as there is a lot going on under the hoods in MarketXLS. I will try again and update you.
     
    Carl likes this.
  3. Keith Salmon

    Keith Salmon New Member

    Joined:
    Aug 25, 2020
    Messages:
    1
    Likes Received:
    0
    Just wondering if this was ever solved.
     

Share This Page