tickers for NDX, SPX, RUT, DIA?

Discussion in 'General Questions' started by kmcintyre, Nov 3, 2017.

tickers for NDX, SPX, RUT, DIA?

  1. kmcintyre

    kmcintyre New Member

    Joined:
    Nov 3, 2017
    Messages:
    6
    Likes Received:
    1
    I just purchased MarketXLS and installed it. I have a few tickers that don't appear to be working correctly. I'm using =Last(A1) where A! holds the text "NDX" or "SPX" or RUT" or "DIA". The formula works great with stocks and ETFs (like SPY, QQQ, IWM, etc.)

    What symbols should I be using?

    And just to make sure, is there any support for futures contracts such as YM, NQ, ES, etc?

    Thanks!

    Keith
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Keith,

    This one?
    knowledge-base - FAQ

    Thank You
    Ankur
     
  3. kmcintyre

    kmcintyre New Member

    Joined:
    Nov 3, 2017
    Messages:
    6
    Likes Received:
    1
    Thanks, that was helpful.

    How about the RUT (Russell 2K)?

    Also, I tried both Last1("^GSPC") and Last("SPX:IND") for SPX, but neither match InteractiveBrokers price for SPX. I know that it is delayed data, but this was premarket and the SPX wasn't moving according to IB.

    Ideas?

    Keith
     
  4. kmcintyre

    kmcintyre New Member

    Joined:
    Nov 3, 2017
    Messages:
    6
    Likes Received:
    1
    This is what I found worked best for me -

    Last("^NDX")
    Last("^SPX")
    Last("^RUT")
    LAST("^DJI")

    Thanks!
     
    marketxls likes this.

Share This Page