Minggu, 08 Maret 2015

[smf_addin] Digest Number 3348

9 Messages

Digest #3348
1b
Re: Getting Data From finviz.com by "Randy Harmelink" rharmelink
2a
Print View by rjemery7
2b
Re: Print View by "Randy Harmelink" rharmelink
4a
Beta by rjemery7
4b
Re: Beta 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.
>

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?
>

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.



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&quot;).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
>
>
>
>
>

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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar