Senin, 06 Februari 2012

[smf_addin] Digest Number 2106

Messages In This Digest (4 Messages)

Messages

1a.

Re: RCHGetHTMLTable - big safe dividends

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 8:38 pm (PST)



The best thing to do is to find a unique search term just before the table,
or within the table headers. You can't rely on something like that to
always being the 47th table on the page. If they add or delete an
advertisement, it can easily change the number of tables on the page.

For this web page, I think the easiest, is to pick up one of the headers
BEFORE the table:

=RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Overall
Quadrix",1,"",1,)

However, note the "printer friendly" link. I think that is the easiest
place to extract the table, since it only has the one table on the page:

=RCHGetHTMLTable("http://www.bigsafedividends.com/printerfriendly.aspx
","",1,"",1)

On Sun, Feb 5, 2012 at 9:06 PM, hashky <hashky@yahoo.com> wrote:

>
> Once again I am baffled by this function.
>
> I am trying to get this table.
>
> http://www.bigsafedividends.com/quadchartie.aspx
>
> I am logged in, which is free BTW.
>
> I am using
>
> =RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Big
> Safe Dividends",47,"",47,)
>
> I got it. But the only way I know to do it is trial and error. Going one
> at a time took me a long time to get to 47. I found it first by using
> "Click" and 41 tries.
>
> =RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx
> ","Click",41,"",41,)
>
> Is there some easy way to count <TABLE tags? My HTML is zippo.
>
1b.

Re: RCHGetHTMLTable - big safe dividends

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Feb 5, 2012 8:40 pm (PST)



Well, if you can't read HTML at all it's hard to provide parameters that
tell SMF where to look in the HTML to find something - as you've discovered.

But, reading HTML isn't that hard. Just use your browser's "View Source"
command to see the html source (Firefox and IE just right-click).

Then, use the browser Find command to locate the text you are interested in
retrieving (or just scroll till you see it). Then, look for unique text
that appears just before that and use that unique text as the Find string
for your RCH parameter.

In your case, you used "Big Safe Dividends" which happens to be in the title
of the page - which is no where near the table data you actually wanted.

Had you used the string "panel1" instead your iteration count would have
been 1.

=RCHGetHTMLTable(" <http://www.bigsafedividends.com/quadchartie.aspx>
http://www.bigsafedividends.com/quadchartie.aspx","panel1",1,"",1,)

Perhaps if you look at the html source for this page with this in mind you
can see how it all fits together better.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of hashky
Sent: Sunday, February 05, 2012 11:07 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetHTMLTable - big safe dividends

Randy -

Once again I am baffled by this function.

I am trying to get this table.

http://www.bigsafedividends.com/quadchartie.aspx

I am logged in, which is free BTW.

I am using

=RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Big
Safe Dividends",47,"",47,)

I got it. But the only way I know to do it is trial and error. Going one at
a time took me a long time to get to 47. I found it first by using "Click"
and 41 tries.

=RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Click",
41,"",41,)

Is there some easy way to count <TABLE tags? My HTML is zippo.

Ron Spruell

2a.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 8:41 pm (PST)



Earnings.com may not go back far enough. For example, on MMM, it lists only
one split, in 2003. But the Yahoo "basic chart" page for MMM shows four
splits, going back to 1972.

On Sun, Feb 5, 2012 at 9:25 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> Yes, you certainly could. Or, you could retrieve split info and manually
> adjust Yahoo's historical "raw close". Earnings.com seems to have pretty
> good split info. Example:
>
> http://www.earnings.com/company.asp?client=cb&ticker=tjx
>
3a.

quotes-plus replacement, fundamental data, local database

Posted by: "leif_85" gondoliere2@web.de   leif_85

Mon Feb 6, 2012 12:16 am (PST)



Hi pharnesbe,

you sent a very interesting list of offers, which I did not yet completely evaluate.
It seems that XLQ with AAII might even be better than Quotes Plus has been. AAII table of fundamental issues is outright impressive and subscription is cheap. Dont miss XLQ's video of a spreadsheet holding an AAII application. All the videos are worth while viewing. The product comes with sample worksheets for AAII, which could be very valuable. XLQ can setup a local database as far as I understand.
In the faq they discuss Excel versions, which should be used.

On the other hand smf_addin might offer the same functionality. I would be very interested to view sample worksheets of this one, especially using AAII data.

Of course I shall post again, when I tested smf_addin and XLQ respectively.

regards,

leif_85

--- In smf_addin@yahoogroups.com, "pharnsbe" <harnsberger@...> wrote:
>
> Hi Leif,
>
> I am also in the ongoing process of finding a replacement to Quotes-Plus. I've sent dozens of emails to many different vendors... many of whom have part of the solution but none have it all.
>
> For fundamental data (which seems more difficult to come by) it's looking like XLQ with AAII might work (http://www.qmatix.com/XLQ.htm). Requires a subscription to AAII. (http://www.aaii.com/store/sipro)
>
> Reuters Datalink also might be a good solution, but I haven't tried it yet and their sales team didn't know if they had excel connectivity.
> http://www.equis.com/products/endofday/reutersdatalink/?overview
>
> Their more expensive real-time feed (QuoteCenter) definitely has excel abilities, but I don't think the data is stored locally.
> Here are the data fields (http://www.equis.com/products/brochures/MKWDatafields.pdf)
>
> High Growth Stock Investor (HGSI) (http://www.highgrowthstock.com/Software/database.htm) Used to be powered by quotes-plus but has since built their own database. Not sure how their data is stored but if it is in metastock format or ACSII then the smf_addin might be able to read it into excel. Also HGSI said they are planning on building an Excel addin in the next 6 months.
>
> If you end up testing any of these please post your experience here, I'd be interested in hearing about any solutions you find.
>

Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Tidak ada komentar:

Posting Komentar