Jump to content

S&P 500 Total return -- question?


Kiltacular
 Share

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
 Share

×
×
  • Create New...