Kiltacular Posted May 1, 2013 Share Posted May 1, 2013 Bloomberg (the website, not the subscription terminal) used to allow me as recently as last month to enter the symbol: "SPTR" and get the S&P 500 total return (the 500 with dividends). Bloomberg's website no longer has such a ticker as far as I can tell. Does anyone know where I can get a daily or month end return for this? I didn't find it on Standard and Poor's website but I might have overlooked it. I do NOT need a bunch of historical data. Thanks in advance. Link to comment Share on other sites More sharing options...
racemize Posted May 1, 2013 Share Posted May 1, 2013 It is on the S&P website and is updated daily, here is how I get the TR for my google spreadsheet: =(Index(ImportHtml("http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l--", "table", 7),4,7)) Here is how I get the TR updated throughout the day: =(Index(ImportHtml("http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l--", "table", 7),4,7)) - (Index(ImportHtml("http://www.standardandpoors.com/indices/sp-500/en/us/?indexId=spusa-500-usduf--p-us-l--", "table", 7),6,7))+E3 where E3 is the change in S&P index from beginning of year to now. Link to comment Share on other sites More sharing options...
writser Posted May 1, 2013 Share Posted May 1, 2013 Looks like they removed a bunch of indices from their (free) website. This still seems to work: http://ycharts.com/indices/%5ESPXTR Link to comment Share on other sites More sharing options...
Kiltacular Posted May 1, 2013 Author Share Posted May 1, 2013 Racemize and wrister -- Thanks to both of you! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now