Messages In This Digest (8 Messages)
- 1a.
- Re: Ex Div Date in History? From: Kermit W. Prather
- 1b.
- Re: Ex Div Date in History? From: Mike McQuaid
- 1c.
- Re: Ex Div Date in History? From: Pete A
- 2a.
- SMF_Addin From: mac_questions
- 2b.
- Re: SMF_Addin From: Randy Harmelink
- 2c.
- Re: [Bulk] [smf_addin] SMF_Addin From: Mike McQuaid
- 2d.
- Re: SMF_Addin From: Dfolino@bellsouth.net
- 2e.
- Re: [Bulk] [smf_addin] SMF_Addin From: Dfolino@bellsouth.net
Messages
- 1a.
-
Re: Ex Div Date in History?
Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra
Sun Jan 1, 2012 7:28 am (PST)
Randy, can you expand on this a little more. All I get when I put this in a cell is <http://www.nasdaq.com/symbol/ > Ex/Eff Datemmm/dividend- history
Clicking on it takes me to the webpage. However, I would like to load it into the excel spreadsheet.
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Saturday, December 31, 2011 4:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Ex Div Date in History?
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/ ","Ex/Ef",-1,mmm/dividend- history "",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.
- 1b.
-
Re: Ex Div Date in History?
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Sun Jan 1, 2012 7:31 am (PST)
You need to enter this as an array formula.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Kermit W. Prather
Sent: Sunday, January 01, 2012 10:29 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Re: Ex Div Date in History?
Randy, can you expand on this a little more. All I get when I put this in a
cell is <http://www.nasdaq.com/symbol/ > Ex/Eff Datemmm/dividend- history
Clicking on it takes me to the webpage. However, I would like to load it
into the excel spreadsheet.
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Saturday, December 31, 2011 4:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Ex Div Date in History?
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/ ","Ex/Ef"mmm/dividend- history
,-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.
- 1c.
-
Re: Ex Div Date in History?
Posted by: "Pete A" optionzz@gmail.com option2z
Sun Jan 1, 2012 5:12 pm (PST)
That works. Thanks for the idea. I've decided that the cash flow difference for the simulation is tiny, so I'll ignore it for now. Got it working to include dividends this morning. THanks for your help!
Pete A
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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.
-
SMF_Addin
Posted by: "mac_questions" d_folino@yahoo.com mac_questions
Sun Jan 1, 2012 9:43 am (PST)
I am trying to set up a new MacBook and have already created a fully functioning program using the SMF addin if I purchase a new MAC, do you know if the SMF addin will be able to be used without a windows partition?
- 2b.
-
Re: SMF_Addin
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jan 1, 2012 9:47 am (PST)
As far as I know, it definitely will not work without the Windows partition
-- it uses a Windows reference library.
On Sun, Jan 1, 2012 at 10:42 AM, mac_questions <d_folino@yahoo.com > wrote:
> I am trying to set up a new MacBook and have already created a fully
> functioning program using the SMF addin if I purchase a new MAC, do you
> know if the SMF addin will be able to be used without a windows partition?
>
- 2c.
-
Re: [Bulk] [smf_addin] SMF_Addin
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Sun Jan 1, 2012 9:48 am (PST)
See Randy's previous comment on this here:
http://finance.groups.yahoo. com/group/ smf_addin/ message/16524
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of mac_questions
Sent: Sunday, January 01, 2012 12:43 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] [smf_addin] SMF_Addin
I am trying to set up a new MacBook and have already created a fully
functioning program using the SMF addin if I purchase a new MAC, do you know
if the SMF addin will be able to be used without a windows partition?
- 2d.
-
Re: SMF_Addin
Posted by: "Dfolino@bellsouth.net" dfolino@bellsouth.net dfolino@bellsouth.net
Sun Jan 1, 2012 2:07 pm (PST)
Ok, thanks I was hoping for a different answer, but I guess not...
www.VistaFA.com
Important Disclosure Information:
This electronic mail message, any attached files, and hyperlinks are confidential. The information is exclusively for the sole use of the individual or entity intended as the recipient and may include information that is confidential or privileged. If you are not the intended recipient, please do not copy, distribute or otherwise disseminate the message or its contents. Instead, please notify the sender immediately, either by return email or by telephone at (904)880-8010, and destroy the message, attachments and all copies.
Vista Financial Advisors, Inc. is not an attorney or accountant please consult with your attorney or CPA regarding specific legal or tax related advice. The content of this message is for informational purposes only and should not be construed as a solicitation or an offer. Any reference to performance data is not warranted as accurate or complete, but based on unaudited figures computed by Vista. Past performance is not indicative of future results. Please refer to your individual account statements for more detailed information.
All e-mail sent to or from the Vista Financial Advisors e-mail system is subject to archiving, monitoring and/or review by Vista personnel.
On Jan 1, 2012, at 12:47 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> As far as I know, it definitely will not work without the Windows partition -- it uses a Windows reference library.
>
>
> On Sun, Jan 1, 2012 at 10:42 AM, mac_questions <d_folino@yahoo.com > wrote:
> I am trying to set up a new MacBook and have already created a fully functioning program using the SMF addin if I purchase a new MAC, do you know if the SMF addin will be able to be used without a windows partition?
>
>
- 2e.
-
Re: [Bulk] [smf_addin] SMF_Addin
Posted by: "Dfolino@bellsouth.net" dfolino@bellsouth.net dfolino@bellsouth.net
Sun Jan 1, 2012 6:19 pm (PST)
Have you tried this? Does it work in this manner?
Diana Folino
Senior Vice President/ COO
Vista Financial Advisors
2931 Plummer Cove Road
Jacksonville, FL 32223
Phone: (904) 880-8010
Fax: (904) 880-0097
www.VistaFA.com
Important Disclosure Information:
This electronic mail message, any attached files, and hyperlinks are confidential. The information is exclusively for the sole use of the individual or entity intended as the recipient and may include information that is confidential or privileged. If you are not the intended recipient, please do not copy, distribute or otherwise disseminate the message or its contents. Instead, please notify the sender immediately, either by return email or by telephone at (904)880-8010, and destroy the message, attachments and all copies.
Vista Financial Advisors, Inc. is not an attorney or accountant please consult with your attorney or CPA regarding specific legal or tax related advice. The content of this message is for informational purposes only and should not be construed as a solicitation or an offer. Any reference to performance data is not warranted as accurate or complete, but based on unaudited figures computed by Vista. Past performance is not indicative of future results. Please refer to your individual account statements for more detailed information.
All e-mail sent to or from the Vista Financial Advisors e-mail system is subject to archiving, monitoring and/or review by Vista personnel.
On Jan 1, 2012, at 12:49 PM, "Mike McQuaid" <mikemcq802@yahoo.com > wrote:
> See Randy's previous comment on this here:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/16524
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of mac_questions
> Sent: Sunday, January 01, 2012 12:43 PM
> To: smf_addin@yahoogroups.com
> Subject: [Bulk] [smf_addin] SMF_Addin
>
>
> I am trying to set up a new MacBook and have already created a fully functioning program using the SMF addin if I purchase a new MAC, do you know if the SMF addin will be able to be used without a windows partition?
>
>
>
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