Jump to content

S&P 500 Total return -- question?


Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...