Stock data for S&P 500

%3CLINGO-SUB%20id%3D%22lingo-sub-3523569%22%20slang%3D%22en-US%22%3EStock%20data%20for%20S%26amp%3BP%20500%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3523569%22%20slang%3D%22en-US%22%3E%3CP%3EEXCEL%20365%20Stock%20data...%20Cannot%20retrieve%20S%26amp%3BP%20500%20(SPX)%20data.%20It%20instead%20retrieves%20an%20unwanted%20stock.%20I%20can%20get%20all%20other%20stocks%20including%20DOW%20and%20Nasdaq.%20How%20do%20I%20get%26nbsp%3BS%26amp%3BP%20500%20(SPX)%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3523569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3523855%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20data%20for%20S%26amp%3BP%20500%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3523855%22%20slang%3D%22en-US%22%3EThat's%20happened%20for%20me%20with%20BRKB.%20The%20STOCKHISTORY%20function%20needs%20BRK.B%20even%20though%20my%20broker%20uses%20BRKB.%3CBR%20%2F%3ETry%20INDEXSP%3A%20.INX%20to%20see%20if%20it%20gets%20S%26amp%3BP%20500.%20Look%20around%20at%20Yahoo%20Finance%20or%20Google%20Finance%20to%20see%20how%20they%20reference%20the%20S%26amp%3BP.%20You'll%20find--as%20I%20did%20just%20a%20few%20minutes%20ago--that%20SPX%2C%20yes%2C%20gets%20data%20on%20some%20organization%20named%20Spenda.Ltd.%20It's%20not%20just%20Excel%2C%20in%20short.%3C%2FLINGO-BODY%3E
New Contributor

EXCEL 365 Stock data... Cannot retrieve S&P 500 (SPX) data. It instead retrieves an unwanted stock. I can get all other stocks including DOW and Nasdaq. How do I get S&P 500 (SPX) data.

1 Reply
That's happened for me with BRKB. The STOCKHISTORY function needs BRK.B even though my broker uses BRKB.
Try INDEXSP: .INX to see if it gets S&P 500. Look around at Yahoo Finance or Google Finance to see how they reference the S&P. You'll find--as I did just a few minutes ago--that SPX, yes, gets data on some organization named Spenda.Ltd. It's not just Excel, in short.