Messages In This Digest (4 Messages)
- 1a.
- Re: Ex Div Date in History? From: Pete A
- 1b.
- Re: Ex Div Date in History? From: Randy Harmelink
- 2a.
- pSort problem From: Pete A
- 2b.
- Re: pSort problem From: Randy Harmelink
Messages
- 1a.
-
Re: Ex Div Date in History?
Posted by: "Pete A" optionzz@gmail.com option2z
Sat Dec 31, 2011 12:49 pm (PST)
Sorry, I assumed that the date would be the PAY DATE. Seems like it would be usefult to get both of these dates, as it would make the simulation more realistic. If I could only have one, of course, it would be the Ex-Div date, as at least I would then know that a holding has rights to the dividend, but then I'd have to assume payment on the same day, or use some algorythm to approximate the actual payment date. Assuming, of course, that there is no easy way to bet both Ex-Div AND scheduled payment date.
Thanks to all who responded...
Pete A
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The two columns being returned are the ex-dividend date and the amount of
> the dividend...?
>
> On Fri, Dec 30, 2011 at 7:37 PM, Pete A <optionzz@...> wrote:
>
> >
> > Is there an easy way to add the ex div date when using the "v" option in
> > RCHGetYahooHistory()? I recall that you somehow got a table that has the
> > div history in it. My simulation of the TtP-S operation needs to have
> > dividends added to it for more realizm. Ideas appreciated. Thanks!
> >
>
- 1b.
-
Re: Ex Div Date in History?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 31, 2011 1:22 pm (PST)
Payment date is irrelevant in terms of when to adjust the historical stock
price. But it is important when constructing a cash flow scenario.
In any case, how about from the NASDAQ web site:
=RCHGetHTMLTable("http://www.nasdaq. com/symbol/ mmm/dividend- history
","Ex/Ef",-1,"",1)
On Sat, Dec 31, 2011 at 1:49 PM, Pete A <optionzz@gmail.com > wrote:
> Sorry, I assumed that the date would be the PAY DATE. Seems like it would
> be usefult to get both of these dates, as it would make the simulation more
> realistic. If I could only have one, of course, it would be the Ex-Div
> date, as at least I would then know that a holding has rights to the
> dividend, but then I'd have to assume payment on the same day, or use some
> algorythm to approximate the actual payment date. Assuming, of course,
> that there is no easy way to bet both Ex-Div AND scheduled payment date.
>
- 2a.
-
pSort problem
Posted by: "Pete A" optionzz@gmail.com option2z
Sat Dec 31, 2011 2:02 pm (PST)
Using values of 0 or 1 for pSort: doesn't seem to have any effect; the date order remains Newest to Oldest. I've inserted a sort routine after updating the data, but thought I'd ask if I'm just doing something wrong.
Range(oCell.Offset(16, -1), oCell.Offset( iObservations + 15, 0)) = _
RCHGetYahooHistory(oCell.Value2, pResort:=1, pPeriod:="v" , pDim1:=iObservation s, pDim2:=2)
Thanks!
Pete A
- 2b.
-
Re: pSort problem
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Dec 31, 2011 2:08 pm (PST)
Not you. Resorting is specifically ignored for the dividends option -- I
don't recall why I did that.
On Sat, Dec 31, 2011 at 3:02 PM, Pete A <optionzz@gmail.com > wrote:
> Using values of 0 or 1 for pSort: doesn't seem to have any effect; the
> date order remains Newest to Oldest. I've inserted a sort routine after
> updating the data, but thought I'd ask if I'm just doing something wrong.
>
> Range(oCell.Offset(16, -1), oCell.Offset( iObservations + 15, 0)) = _
> RCHGetYahooHistory(oCell.Value2, pResort:=1, pPeriod:="v" ,
> pDim1:=iObservations, pDim2:=2)
>
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