Kiltacular Posted May 1, 2013 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.
racemize Posted May 1, 2013 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.
writser Posted May 1, 2013 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
Kiltacular Posted May 1, 2013 Author Posted May 1, 2013 Racemize and wrister -- Thanks to both of you!
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