New User - symbol lookup

Discussion in 'General Questions' started by yaco, Jul 4, 2017.

New User - symbol lookup

  1. yaco

    yaco New Member

    Joined:
    Jul 4, 2017
    Messages:
    2
    Likes Received:
    0
    Hello,
    Sorry so simple questions. I couldn't find the symbol for s&p500, I am actually suspecting you dont provide data about it. Do you? Could you please tell me the symbol? Also I would like to have the symbols for mini sp futures and options.
    Thanks a lot
    Yaco
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    @yaco sure please see below...

    How do I get values for the Dow Industrials, S&P 500, and NASDAQ?
    =Ask(“^GSPC”) for S&P
    =Last1(“SPX:IND”) for S&P
    =Last(“^GSPC”) for S&P
    =Last(“^DJI”) for Dow Industrial
    =Last(“^IXIC”) for NASDAQ
    =Last1(“CCMP:IND”) for NASDAQ
    =Last1(“INDU:IND”) for DJIA
     
  3. yaco

    yaco New Member

    Joined:
    Jul 4, 2017
    Messages:
    2
    Likes Received:
    0
    Thanks a lot Administrator,
    Also couldn't find SP500 MINI futures and options, which is something like ES and ES FOP.
    Many thanks again, I really appreciate your help.
    Yaco
     
  4. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    I tried using those formulas and got #VALUE error messages on all of them. What am I doing wrong?
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Do you have this working? =Last("msft")
     
  6. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    I think you are copying and pasting from here. Instead of that, type these out.
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
  9. Dieter (Dick) B. Kaufmann

    Joined:
    Sep 19, 2017
    Messages:
    2
    Likes Received:
    0
    Still wondering about the symbols/formula for the S&P - NASDQ _DJIA PREMARKET FUTURES. Thanks
     

Share This Page