Messages In This Digest (5 Messages)
- 1a.
- Re: ^GSPC vs VFINX v SPY From: MikeM
- 1b.
- Re: ^GSPC vs VFINX v SPY From: Randy Harmelink
- 1c.
- Re: ^GSPC vs VFINX v SPY From: lexstar
- 2a.
- Morningstar Indexes From: addison.ingle
- 2b.
- Re: Morningstar Indexes From: Randy Harmelink
Messages
- 1a.
-
Re: ^GSPC vs VFINX v SPY
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Fri Jun 22, 2012 4:51 am (PDT)
If you use Yahoo to chart ^gspc and compare it to SPY and VFINX they line up exactly.
How are you calculating the returns for them?
--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@...> wrote:
>
> Does anyone know why ^GSPC have returns different from VFINX and SPY? My assumption is that ^GSPC is a total return index, and therefore, should give a return similar to (or should be MORE) than VFINX and SPY. But, my calculations show that the returns for ^GSPC are always LOWER than VFINX and SPY.
>
> What's the reason behind that, anyone know?
>
- 1b.
-
Re: ^GSPC vs VFINX v SPY
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 22, 2012 5:59 am (PDT)
That's because the provider of the charts data for Yahoo doesn't always
adjust for dividends. I've noticed that in the past. It's one reason I'm
not real fond of their charts.
^GSPC has no dividend adjustments. VFINX and SPY do.
The total return index for the S&P 500 is ^PXTY, but Yahoo doesn't carry
historical quotes for it.
On Fri, Jun 22, 2012 at 4:51 AM, MikeM <mikemcq802@yahoo.com > wrote:
> If you use Yahoo to chart ^gspc and compare it to SPY and VFINX they line
> up exactly.
>
> How are you calculating the returns for them?
>
- 1c.
-
Re: ^GSPC vs VFINX v SPY
Posted by: "lexstar" lexstar@yahoo.com lexstar
Fri Jun 22, 2012 6:27 am (PDT)
Thanks everyone for your observations and comments. Greatly appreciated.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's because the provider of the charts data for Yahoo doesn't always
> adjust for dividends. I've noticed that in the past. It's one reason I'm
> not real fond of their charts.
>
> ^GSPC has no dividend adjustments. VFINX and SPY do.
>
> The total return index for the S&P 500 is ^PXTY, but Yahoo doesn't carry
> historical quotes for it.
>
> On Fri, Jun 22, 2012 at 4:51 AM, MikeM <mikemcq802@...> wrote:
>
> > If you use Yahoo to chart ^gspc and compare it to SPY and VFINX they line
> > up exactly.
> >
> > How are you calculating the returns for them?
> >
>
- 2a.
-
Morningstar Indexes
Posted by: "addison.ingle" addison.ingle@gmail.com addison.ingle
Fri Jun 22, 2012 11:58 am (PDT)
Randy,
I found this page at Morningstar; the great thing is that it reports the S&P 500 Total Return and the MSCI EAFE index, both of which are very good indexes for mutual fund benchmarking.
http://news.morningstar. com/index/ indexReturn. html?msection= IdxReturns
My question: Can I somehow either extract the data for the two indexes (YTD, 1 Yr, 3 Yr, 5 Yr, etc) or create new elements for inclusion in the add-in?
Thanks for your help and your patience.
- 2b.
-
Re: Morningstar Indexes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jun 22, 2012 12:40 pm (PDT)
Either of these should get you the YTD return of the Large Cap index:
=RCHGetTableCell("
http://news.morningstar. com/index/ indexReturn. html?msection= IdxReturns
",4,"$MLCP")
=RCHGetTableCell("
http://news.morningstar. ",4,">com/index/ indexReturn. html?msection= IdxReturns
Large Cap")
On Fri, Jun 22, 2012 at 11:58 AM, addison.ingle <addison.ingle@gmail.com >wrote:
>
> I found this page at Morningstar; the great thing is that it reports the
> S&P 500 Total Return and the MSCI EAFE index, both of which are very good
> indexes for mutual fund benchmarking.
>
> http://news.morningstar. com/index/ indexReturn. html?msection= IdxReturns
>
> My question: Can I somehow either extract the data for the two indexes
> (YTD, 1 Yr, 3 Yr, 5 Yr, etc) or create new elements for inclusion in the
> add-in?
>
> Thanks for your help and your patience.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar