Messages In This Digest (13 Messages)
- 1a.
- Re: Ex Div Date in History? From: jeanxsteinmetz
- 1b.
- Re: Ex Div Date in History? From: Kermit W. Prather
- 1c.
- Re: Ex Div Date in History? From: Randy Harmelink
- 1d.
- Re: Ex Div Date in History? From: Randy Harmelink
- 2a.
- move to/save in a memory stick From: bloteczka
- 2b.
- Re: move to/save in a memory stick From: dguillett1
- 2c.
- Re: move to/save in a memory stick From: Randy Harmelink
- 2d.
- Re: move to/save in a memory stick From: bloteczka
- 2e.
- Re: move to/save in a memory stick From: bloteczka
- 2f.
- Re: move to/save in a memory stick From: george
- 2g.
- Re: move to/save in a memory stick From: Randy Harmelink
- 2h.
- Re: move to/save in a memory stick From: bloteczka
- 3.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
Messages
- 1a.
-
Re: Ex Div Date in History?
Posted by: "jeanxsteinmetz" jxstein@sympatico.ca jeanxsteinmetz
Mon Jan 2, 2012 6:25 am (PST)
I have been able to make a table with the Div information from MMM
thanks to the formula:
=RCHGetHTMLTable("http://www.nasdaq. com/symbol/ mmm/dividend- history
","Ex/Ef",-1,"",1)
Now I would like to automatically change the ticker symbol to permit me
to get the Div history of other stocks.
Could you be so kind in helping me?
These add –in formulas are really a time saving feature once you get
them set up properly.
Thank you
J.S.
--- In smf_addin@yahoogroups.com , "Pete A" <optionzz@...> wrote:
>
> 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.
> > >
> >
>
- 1b.
-
Re: Ex Div Date in History?
Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra
Mon Jan 2, 2012 7:02 am (PST)
Therein lies my problem. I am not sure how to do an array.
Any help would be greatly appreciated.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Mike McQuaid
Sent: Sunday, January 01, 2012 10:30 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Re: Ex Div Date in History?
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 Ex/ <http://www.nasdaq.com/symbol/ > 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: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 2, 2012 7:15 am (PST)
See: http://finance.groups.yahoo. com/group/ smf_addin/ message/16761
On Mon, Jan 2, 2012 at 7:19 AM, jeanxsteinmetz <jxstein@sympatico.ca > wrote:
>
> I have been able to make a table with the Div information from MMM thanks
> to the formula:
>
> =RCHGetHTMLTable("http://www.nasdaq. com/symbol/ ","Ex/Ef",-1,mmm/dividend- history "",1)
>
>
>
> Now I would like to automatically change the ticker symbol to permit me to
> get the Div history of other stocks. Could you be so kind in helping me?
>
- 1d.
-
Re: Ex Div Date in History?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 2, 2012 7:15 am (PST)
Check the function documentation. There's an explanation of the process
there.
On Mon, Jan 2, 2012 at 8:02 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I am not sure how to do an array.
>
>
>
- 2a.
-
move to/save in a memory stick
Posted by: "bloteczka" akol@rogers.com bloteczka
Mon Jan 2, 2012 8:33 am (PST)
I have created a bunch of spreadsheets full of the RCH and smf formulas - cell and array entered. When I save or move them to another computer or, lately, a memory stick and after opening them and going to "Edit Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new location on the stick I am getting #NAME?,... all over the places.
How can I move to/save in a memory stick for example to be able to use my spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and smf-elements files on the stick and updating their locations in spreadsheets involved does not do the trick. How can it be done painlessly?
Andrzej
- 2b.
-
Re: move to/save in a memory stick
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Mon Jan 2, 2012 9:52 am (PST)
I always recommend that you COPY/PASTE to any removable data such as a memory stick. Then copy/paste to the other computer.
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: bloteczka
Sent: Monday, January 02, 2012 10:33 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] move to/save in a memory stick
I have created a bunch of spreadsheets full of the RCH and smf formulas - cell and array entered. When I save or move them to another computer or, lately, a memory stick and after opening them and going to "Edit Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new location on the stick I am getting #NAME?,... all over the places.
How can I move to/save in a memory stick for example to be able to use my spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and smf-elements files on the stick and updating their locations in spreadsheets involved does not do the trick. How can it be done painlessly?
Andrzej
- 2c.
-
Re: move to/save in a memory stick
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 2, 2012 11:33 am (PST)
The add-in can be located almost anywhere. However, if the add-in is in a
different location between the time a workbook is saved and the time it is
opened, you'll need to manually edit all of the links. That's the way EXCEL
handles it. I usually just do a "Find and Replace All" and fix them all at
one time -- see the item on location errors in the "Links" area of the
group for more information.
Note that you don't want to UPDATE the location in the formula. You want to
REMOVE it.
On Mon, Jan 2, 2012 at 9:33 AM, bloteczka <akol@rogers.com > wrote:
> I have created a bunch of spreadsheets full of the RCH and smf formulas -
> cell and array entered. When I save or move them to another computer or,
> lately, a memory stick and after opening them and going to "Edit
> Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new
> location on the stick I am getting #NAME?,... all over the places.
>
> How can I move to/save in a memory stick for example to be able to use my
> spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and
> smf-elements files on the stick and updating their locations in
> spreadsheets involved does not do the trick. How can it be done painlessly?
>
- 2d.
-
Re: move to/save in a memory stick
Posted by: "bloteczka" akol@rogers.com bloteczka
Mon Jan 2, 2012 11:38 am (PST)
Thank you, Don!
But ... that's not the problem. I've done them both...
Good news I found what the problem was, I think!
I had copied Randy's RCH_Stock_Market_Functions. xla and smf-elements to a new location on the stick. Then I found out that I had to:
1. remove the original (C drive location) of these files (Excel Options/Add-ins/Manage/ Go (and Save/OK),
2. return once again and locate a new address on the stick (and Save/OK)
All my formulas work flawlessly now!. As soon as I finish this message I will go to my laptop to check if everything is ok, but I think it should be!
Yes, it is!
Andrzej
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> I always recommend that you COPY/PASTE to any removable data such as a memory stick. Then copy/paste to the other computer.
>
> Don Guillett
> SalesAid Software
> dguillett1@...
>
> From: bloteczka
> Sent: Monday, January 02, 2012 10:33 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] move to/save in a memory stick
>
>
> I have created a bunch of spreadsheets full of the RCH and smf formulas - cell and array entered. When I save or move them to another computer or, lately, a memory stick and after opening them and going to "Edit Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new location on the stick I am getting #NAME?,... all over the places.
>
> How can I move to/save in a memory stick for example to be able to use my spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and smf-elements files on the stick and updating their locations in spreadsheets involved does not do the trick. How can it be done painlessly?
>
> Andrzej
>
- 2e.
-
Re: move to/save in a memory stick
Posted by: "bloteczka" akol@rogers.com bloteczka
Mon Jan 2, 2012 11:49 am (PST)
Thank you Randy!
I did not know this possibility exists (Find and Replace), can you do it for array entered formulas as well? As my new and mobile files work now (see my previous message) I'm scared to touch them :), but I will test it later.
(I hope this problem described and solved will provide some guidelines for other group members.)
Andrzej
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can be located almost anywhere. However, if the add-in is in a
> different location between the time a workbook is saved and the time it is
> opened, you'll need to manually edit all of the links. That's the way EXCEL
> handles it. I usually just do a "Find and Replace All" and fix them all at
> one time -- see the item on location errors in the "Links" area of the
> group for more information.
>
> Note that you don't want to UPDATE the location in the formula. You want to
> REMOVE it.
>
> On Mon, Jan 2, 2012 at 9:33 AM, bloteczka <akol@...> wrote:
>
> > I have created a bunch of spreadsheets full of the RCH and smf formulas -
> > cell and array entered. When I save or move them to another computer or,
> > lately, a memory stick and after opening them and going to "Edit
> > Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new
> > location on the stick I am getting #NAME?,... all over the places.
> >
> > How can I move to/save in a memory stick for example to be able to use my
> > spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and
> > smf-elements files on the stick and updating their locations in
> > spreadsheets involved does not do the trick. How can it be done painlessly?
> >
>
- 2f.
-
Re: move to/save in a memory stick
Posted by: "george" panax@fuse.net simon_of_iernot
Mon Jan 2, 2012 1:58 pm (PST)
It depends on how you use the memory stick. I have a whole host of programs/queries that I wrote in excel and access that are all mapped to run around inside the V drive memory stick. These use the V drive because I wanted the software to run on any computer without leaving any personal information behind. One would only run into a problem if the computer he was using had an application required to be used on the V drive.
I also store on the memory stick a copy of an excel file that has all the SMF queries in it. I simply drag a copy of that one excel file to the desktop, update it normally and edit-copy/paste values into the workbook on the V drive that I want to update. I can then delete the SMF query file workbook from the desktop and there will be no residual data left on the computer except for the add-in in the Program Files folder. I suppose one could delete that too, but it wouldn't be necessary.
I only use one workbook for all SMF equations, so that makes it easy to move about. It also makes it totally portable to any other computer that will take a memory stick.
I used to just Export to Excel (right click on the mouse) from the yahoo web site, but they disabled that ability a whiles back so we had to develop (using SMF) an alternate solution
simon
----- Original Message -----
From: bloteczka
To: smf_addin@yahoogroups.com
Sent: Monday, January 02, 2012 14:49
Subject: [smf_addin] Re: move to/save in a memory stick
Thank you Randy!
I did not know this possibility exists (Find and Replace), can you do it for array entered formulas as well? As my new and mobile files work now (see my previous message) I'm scared to touch them :), but I will test it later.
(I hope this problem described and solved will provide some guidelines for other group members.)
Andrzej
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can be located almost anywhere. However, if the add-in is in a
> different location between the time a workbook is saved and the time it is
> opened, you'll need to manually edit all of the links. That's the way EXCEL
> handles it. I usually just do a "Find and Replace All" and fix them all at
> one time -- see the item on location errors in the "Links" area of the
> group for more information.
>
> Note that you don't want to UPDATE the location in the formula. You want to
> REMOVE it.
>
> On Mon, Jan 2, 2012 at 9:33 AM, bloteczka <akol@...> wrote:
>
> > I have created a bunch of spreadsheets full of the RCH and smf formulas -
> > cell and array entered. When I save or move them to another computer or,
> > lately, a memory stick and after opening them and going to "Edit
> > Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new
> > location on the stick I am getting #NAME?,... all over the places.
> >
> > How can I move to/save in a memory stick for example to be able to use my
> > spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and
> > smf-elements files on the stick and updating their locations in
> > spreadsheets involved does not do the trick. How can it be done painlessly?
> >
>
- 2g.
-
Re: move to/save in a memory stick
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 2, 2012 2:04 pm (PST)
The "Find and Replace All" method works for array-entered formulas as well.
I actually have a macro in the add-in that I use -- smfFixLinks. The old
version is very specific, but I updated the copy in the beta version of the
add-in (in the "Works in Progress" folder) to be as generic as possible. It
changes:
"'*\RCH_Stock_Market_Functions .xla'!"
...to nothing. I think that should handle all situations. In any case, I
have the macro saved to a button on my toolbar, so any time I open up a
workbook with link issues, I just run the macro. But it only works on the
active worksheet.
On Mon, Jan 2, 2012 at 12:49 PM, bloteczka <akol@rogers.com > wrote:
>
> I did not know this possibility exists (Find and Replace), can you do it
> for array entered formulas as well? As my new and mobile files work now
> (see my previous message) I'm scared to touch them :), but I will test it
> later.
>
> (I hope this problem described and solved will provide some guidelines for
> other group members.)
>
- 2h.
-
Re: move to/save in a memory stick
Posted by: "bloteczka" akol@rogers.com bloteczka
Mon Jan 2, 2012 2:05 pm (PST)
Simon,
V (or X, Y, Z for the matter) as a drive letter is a very good idea. I have already bumped into D:/E: drive letters confusion playing with my sticks!
Thank you
--- In smf_addin@yahoogroups.com , "george" <panax@...> wrote:
>
> It depends on how you use the memory stick. I have a whole host of programs/queries that I wrote in excel and access that are all mapped to run around inside the V drive memory stick. These use the V drive because I wanted the software to run on any computer without leaving any personal information behind. One would only run into a problem if the computer he was using had an application required to be used on the V drive.
>
> I also store on the memory stick a copy of an excel file that has all the SMF queries in it. I simply drag a copy of that one excel file to the desktop, update it normally and edit-copy/paste values into the workbook on the V drive that I want to update. I can then delete the SMF query file workbook from the desktop and there will be no residual data left on the computer except for the add-in in the Program Files folder. I suppose one could delete that too, but it wouldn't be necessary.
>
> I only use one workbook for all SMF equations, so that makes it easy to move about. It also makes it totally portable to any other computer that will take a memory stick.
>
> I used to just Export to Excel (right click on the mouse) from the yahoo web site, but they disabled that ability a whiles back so we had to develop (using SMF) an alternate solution
>
> simon
>
>
> ----- Original Message -----
> From: bloteczka
> To: smf_addin@yahoogroups.com
> Sent: Monday, January 02, 2012 14:49
> Subject: [smf_addin] Re: move to/save in a memory stick
>
>
>
> Thank you Randy!
>
> I did not know this possibility exists (Find and Replace), can you do it for array entered formulas as well? As my new and mobile files work now (see my previous message) I'm scared to touch them :), but I will test it later.
>
> (I hope this problem described and solved will provide some guidelines for other group members.)
>
> Andrzej
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The add-in can be located almost anywhere. However, if the add-in is in a
> > different location between the time a workbook is saved and the time it is
> > opened, you'll need to manually edit all of the links. That's the way EXCEL
> > handles it. I usually just do a "Find and Replace All" and fix them all at
> > one time -- see the item on location errors in the "Links" area of the
> > group for more information.
> >
> > Note that you don't want to UPDATE the location in the formula. You want to
> > REMOVE it.
> >
> > On Mon, Jan 2, 2012 at 9:33 AM, bloteczka <akol@> wrote:
> >
> > > I have created a bunch of spreadsheets full of the RCH and smf formulas -
> > > cell and array entered. When I save or move them to another computer or,
> > > lately, a memory stick and after opening them and going to "Edit
> > > Links/Change Source" to change RCH_Stock_Market_Functions. xla to a new
> > > location on the stick I am getting #NAME?,... all over the places.
> > >
> > > How can I move to/save in a memory stick for example to be able to use my
> > > spreadsheets wherever I want? Saving RCH_Stock_Market_Functions. xla and
> > > smf-elements files on the stick and updating their locations in
> > > spreadsheets involved does not do the trick. How can it be done painlessly?
> > >
> >
>
- 3.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Mon Jan 2, 2012 9:38 am (PST)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Documentation/SMF-Addin- Combined- Documentation- 010212.pdf
Uploaded by : kermitpra <kermitp@tampabay.rr.com >
Description : Single PDF file of all document files as of Jan 2nd, 2012. Should make it easier to seach for functions at least it did for me.
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Documentation/ SMF-Addin- Combined- Documentation- 010212.pdf
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
kermitpra <kermitp@tampabay.rr.com >
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