Messages In This Digest (6 Messages)
- 1a.
- Re: Total return From: chaim422
- 1b.
- Re: Total return From: paul messerschmidt
- 2a.
- Re: Yahoo History From: Randy Harmelink
- 3a.
- Extracting a Graph from a Web Site From: GaryFera
- 3b.
- Re: Extracting a Graph from a Web Site From: Randy Harmelink
- 4a.
- Re: Question Regarding Morningstar Data Feed From: Randy Harmelink
Messages
- 1a.
-
Re: Total return
Posted by: "chaim422" chaim422@gmail.com chaim422
Tue Jul 5, 2011 6:00 am (PDT)
Thanks Randy!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I typically just use the smfPricesByDates() function to get the prices for
> the given dates. Because the prices being returned are adjusted for splits
> and dividends, you should get a total return.
>
> On Mon, Jul 4, 2011 at 8:00 PM, chaim422 <chaim422@...> wrote:
>
> > How do you calculate total return (including dividends) between 2 dates?
> >
>
- 1b.
-
Re: Total return
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Tue Jul 5, 2011 7:27 am (PDT)
be careful about just plugging data for a total return calculation.
there are several assumptions and calculations that may not be
representative of real-world events.
> the day a stock goes ex-div, may not be the day the dividend gets paid.
(e.g., SPY) the delay can be upwards of 30-days -- or more.
http://www.dividendinvestor. com/?chk= ecc2b1309874364& symbol=spy& submit=GO
<http://www.dividendinvestor. >SPYcom/?chk= ecc2b1309874364& symbol=spy& submit=GO
ex-div = 17june; div payment = 29july
how do you treat this six week spread of price appreciation without the
dividend or dividend payment?
> when the dividend does get paid, what assumptions are made regarding the
dividend reinvestment price (open, mid, close, vwap)?
> do you include commissions on the reinvestment?
> how do you handle fractional shares? (e.g., hold in cash at 0% interest
until you can purchase and integral number of shares -- in an odd-lot)
do your own homework...
On Mon, Jul 4, 2011 at 11:00 PM, chaim422 <chaim422@gmail.com > wrote:
> **
>
>
> How do you calculate total return (including dividends) between 2 dates?
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 2a.
-
Re: Yahoo History
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jul 5, 2011 9:10 am (PDT)
Not quite sure what you're asking, but you can specify the dates that you
want retrieved using the function's parameters...
On Fri, Jul 1, 2011 at 1:57 PM, Michael Thomas <thomas91112@yahoo.com >wrote:
>
> Use RCHGetYahooHistory to retrieve end-of-month stock market prices.
> Noticed yesterday, June 30 (after market close), that while Yahoo posted the
> closing value for that day in its Historical Prices, RCHGetYahooHistory was
> retrieving the value of two days earlier for all securities. Now today, it
> is doing just fine. Is there a way to get the EOM values before the first
> day of the following month through GetYahooHistory which otherwise works
> just fine?
>
- 3a.
-
Extracting a Graph from a Web Site
Posted by: "GaryFera" gfera@shaw.ca GaryFera
Tue Jul 5, 2011 12:17 pm (PDT)
Randy, the SMF Add In has been working extremely well for me recently and surely has settled down after all my initial questions. Great facility.
Do you know if there is a way to extract the graph from the web site listed below? Thanks
Gary
http://www.marketwatch.com/investin g/stock/AAPL/ option/AAPLA2112 3300000
- 3b.
-
Re: Extracting a Graph from a Web Site
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jul 5, 2011 12:20 pm (PDT)
Sorry, but the image URL is far too long -- EXCEL has a 99-byte limitation.
On Tue, Jul 5, 2011 at 12:14 PM, GaryFera <gfera@shaw.ca> wrote:
> Randy, the SMF Add In has been working extremely well for me recently and
> surely has settled down after all my initial questions. Great facility.
>
> Do you know if there is a way to extract the graph from the web site listed
> below? Thanks
>
> Gary
>
> http://www.marketwatch.com/investin g/stock/AAPL/ option/AAPLA2112 3300000
>
- 4a.
-
Re: Question Regarding Morningstar Data Feed
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jul 5, 2011 3:49 pm (PDT)
On Thu, Jun 30, 2011 at 12:20 PM, guilldan <guilldan@yahoo.com > wrote:
>
> First, thank you Randy for making this add-in. I am doing some fund
> analysis on Morningstar and have noticed that some of the data links are
> incorrect. Mainly total returns and trailing returns... The fund pulls the
> correct data point but "relative to index" and "relative to category" are
> not pulling the correct data point. I tried downloading the updated .txt
> file from the "in progress" folder but it is still pulling the wrong return.
>
Examples, please. I tried it on a few funds and they looked OK to me.
> Also, is it possible to add the following info from Morningstar that is
> found on the upper right table under the "quote" tab?
>
> o Yield
> o Load
> o Total Assets
> o Expenses
> o Turnover
> o Status
>
Not easily -- the data would need to be extracted out of Javascript coding.
For example:
=0+smfStrExtr(RCHGetWebData( "http://quote. morningstar. com/fund/ f.aspx?t=
"&C4,"TitleMorningstarRating: "),"Yield: ""","""")
The reliability would be suspect.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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