Forum Discussion

SterlingD's avatar
SterlingD
Copper Contributor
Jul 30, 2020

Stocks Data Type

I have the DOW 30, S&P 500, NASDAQ 100, and Emerging Markets Indices. My question is what is the symbol for the Russell 2000 and EuroStoxx 50 indices? I cannot find them for the data selector to import into excel. Thanks!

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Silver Contributor
    Jul 30, 2020
    You've heard of Google, I presume? Russell 2000 -- RUT EuroStoxx 50--SX5E
    • SterlingD's avatar
      SterlingD
      Copper Contributor
      Jul 30, 2020

      mathetes 

       

      Data input doesn't recognize those symbols. I know the symbols to look it up on my own but I need the symbols that pulls real-time data into the cell for the stock data type function

       

    • MarkConner_77's avatar
      MarkConner_77
      Copper Contributor
      Apr 29, 2024
      You've heard of checking first to see if RUT works in Excel for importing data, I presume?...
  • Scott Rogerson's avatar
    Scott Rogerson
    Copper Contributor
    Jul 30, 2020
    The Russell 2000 has several different indices. They are Russell 2000 Growth Index (RUO Index), Russell 2000 Total Return (RU20INTR Index), and Russell 2000 Value Index (RUJ Index). Hope this helps.
    • public_name's avatar
      public_name
      Copper Contributor
      Nov 20, 2020

      Scott Rogerson 

      these are not recognized by excel.  are you able to use these in excel>data>data types>stocks?

      They are Russell 2000 Growth Index (RUO Index), Russell 2000 Total Return (RU20INTR Index), and Russell 2000 Value Index (RUJ Index).
  • markpbarry's avatar
    markpbarry
    Copper Contributor
    Jul 02, 2021

    SterlingD , have you been able to solve this problem? I used Power Query to connect to tables of historical data for two Russell 1000 indices that I need to reference. It was simple to implement and the same data refresh all command that updates stock prices updates the tables

Resources