9 Messages
Digest #3348
3a
Re: Need a website where I can retrieve dividend history at least la by "Kermit W. Prather" kermitpra
3b
Re: Need a website where I can retrieve dividend history at least la by "Randy Harmelink" rharmelink
Messages
Sat Mar 7, 2015 5:36 am (PST) . Posted by:
rjemery7
Where and how does one access this "Tips and FAQs" web page? Please provide the URL.
Sat Mar 7, 2015 6:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It should be in the footer of every message you get from this group...
"For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF"
On Sat, Mar 7, 2015 at 6:36 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Where and how does one access this "Tips and FAQs" web page? Please
> provide the URL.
>
"For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF"
On Sat, Mar 7, 2015 at 6:36 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Where and how does one access this "Tips and FAQs" web page? Please
> provide the URL.
>
Sat Mar 7, 2015 8:02 am (PST) . Posted by:
rjemery7
In my case, the footer does not appear, but I thank you for the URL.
Sat Mar 7, 2015 5:57 am (PST) . Posted by:
rjemery7
Does this forum offer a Print View option, where a thread could be displayed suitable for printing? If so, how does one go about printing a thread (without the headers) such that no part of a message is lost?
Sat Mar 7, 2015 7:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Not that I'm aware of. You can tell it to "show" all the messages in a
topic, then, if necessary, use the "View" drop-down button to "Expand
messages", and print the results. But it will just be the normal web page
print.
On Sat, Mar 7, 2015 at 6:57 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does this forum offer a Print View option, where a thread could be
> displayed suitable for printing? If so, how does one go about printing a
> thread (without the headers) such that no part of a message is lost?
>
topic, then, if necessary, use the "View" drop-down button to "Expand
messages", and print the results. But it will just be the normal web page
print.
On Sat, Mar 7, 2015 at 6:57 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does this forum offer a Print View option, where a thread could be
> displayed suitable for printing? If so, how does one go about printing a
> thread (without the headers) such that no part of a message is lost?
>
Sat Mar 7, 2015 8:01 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
The Morningstar one works just fine without any logon required, Thank You,
The Gurufocus requires a user logon. I do have a gurufocus userid/password but not all of my 7 adult children that I provide my spreadsheet to has gurufocus.
Which brings me to a question:
Do you have VBA code in SMF ADDIN to do a logon to a given site such as gurufocus?
Or is it even possible to do it from VBA? I searched Excel help but found no useful information
Thanks again,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, March 06, 2015 7:33 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need a website where I can retrieve dividend history at least last 40 payouts
Do any of these get you what you need?
=smfGetCSVFile("http://www.gurufocus.com/download_dividend.php?symbol=MMM"," ")
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &t=MMM","",1,"",1)
On Fri, Mar 6, 2015 at 5:13 PM, 'Kermit W. Prather' kermitp@... wrote:
The website I was using to pull dividend history appears to have switched to a JavaScript for the dividend history.
Site I tried are (they all use Javascript) Now:
www.dividend.com
www.dividendchannel.com
www.nasdaq.com __,
www.dividend.com Fee based
Anyone have a site they use, preferably one that is free, such as yahoo.com.
They provide free dividend payouts and yield. But I have found their data not that reliable sometimes.
I need to pull the last 40 payouts using the RCHGetHTMLTable function. Unless someone has a better idea.
I'm open to suggestions.
The Gurufocus requires a user logon. I do have a gurufocus userid/password but not all of my 7 adult children that I provide my spreadsheet to has gurufocus.
Which brings me to a question:
Do you have VBA code in SMF ADDIN to do a logon to a given site such as gurufocus?
Or is it even possible to do it from VBA? I searched Excel help but found no useful information
Thanks again,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, March 06, 2015 7:33 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need a website where I can retrieve dividend history at least last 40 payouts
Do any of these get you what you need?
=smfGetCSVFile("http://www.gurufocus.com/download_dividend.php?symbol=MMM"," ")
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &t=MMM"
On Fri, Mar 6, 2015 at 5:13 PM, 'Kermit W. Prather' kermitp@... wrote:
The website I was using to pull dividend history appears to have switched to a JavaScript for the dividend history.
Site I tried are (they all use Javascript) Now:
www.dividend.
www.dividendchannel
www.nasdaq.com __,
www.dividend.
Anyone have a site they use, preferably one that is free, such as yahoo.com.
They provide free dividend payouts and yield. But I have found their data not that reliable sometimes.
I need to pull the last 40 payouts using the RCHGetHTMLTable function. Unless someone has a better idea.
I'm open to suggestions.
Sat Mar 7, 2015 8:19 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I used to. The problem is that the process changes depending on which
combination of versions of EXCEL or IE you have on your machine, because it
requires use of the IE object in EXCEL. So now I avoid that processing
altogether, since I can only test one combination of versions.
And, to tell the truth, since getting my new machine and upgrading to EXCEL
2007 from EXCEL 2003, none of my old routines for that processing have
worked, and I've not been able to get them to work. I think it has to do
with when they added multiple tabs to IE.
In any case, I wouldn't feel comfortable with the add-in having access to
userid and password information.
It used to be as simple as something like:
Sub internetlogon()
With CreateObject("InternetExplorer.Application")
.Navigate "http://enter web page here"
Do until .ReadyState = 4
DoEvents
Loop
DoEvents
With .document
.items("username")="whatever"
.items("password")="whatever"
.items("usernamesend").submit
End With
End With
End Sub
On Sat, Mar 7, 2015 at 9:01 AM, 'Kermit W. Prather' kermitp@... wrote:
>
>
> Do you have VBA code in SMF ADDIN to do a logon to a given site such as
> gurufocus?
>
>
>
> Or is it even possible to do it from VBA? I searched Excel help but found
> no useful information
>
>
>
>
>
combination of versions of EXCEL or IE you have on your machine, because it
requires use of the IE object in EXCEL. So now I avoid that processing
altogether, since I can only test one combination of versions.
And, to tell the truth, since getting my new machine and upgrading to EXCEL
2007 from EXCEL 2003, none of my old routines for that processing have
worked, and I've not been able to get them to work. I think it has to do
with when they added multiple tabs to IE.
In any case, I wouldn't feel comfortable with the add-in having access to
userid and password information.
It used to be as simple as something like:
Sub internetlogon()
With CreateObject("InternetExplorer.Application")
.Navigate "http://enter web page here"
Do until .ReadyState = 4
DoEvents
Loop
DoEvents
With .document
.items("
.items("
.items("
End With
End With
End Sub
On Sat, Mar 7, 2015 at 9:01 AM, 'Kermit W. Prather' kermitp@... wrote:
>
>
> Do you have VBA code in SMF ADDIN to do a logon to a given site such as
> gurufocus?
>
>
>
> Or is it even possible to do it from VBA? I searched Excel help but found
> no useful information
>
>
>
>
>
Sat Mar 7, 2015 2:19 pm (PST) . Posted by:
rjemery7
What would be the most expedient way to capture the beta value for any stock?
Sat Mar 7, 2015 3:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Element #972 is the beta from Yahoo's Key Statistics page. But I don't
recall how many years it is based on. Check their documentation. Some
sources carry it as a 1-year statistic. Others as 3-year or 5-year. So it
depends on what you want to use beta for.
On Sat, Mar 7, 2015 at 3:19 PM, rjemery@... wrote:
>
> What would be the most expedient way to capture the beta value for any
> stock?
>
recall how many years it is based on. Check their documentation. Some
sources carry it as a 1-year statistic. Others as 3-year or 5-year. So it
depends on what you want to use beta for.
On Sat, Mar 7, 2015 at 3:19 PM, rjemery@... wrote:
>
> What would be the most expedient way to capture the beta value for any
> stock?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar