Messages In This Digest (4 Messages)
- 1a.
- Re: RCHGetHTMLTable - big safe dividends From: Randy Harmelink
- 1b.
- Re: RCHGetHTMLTable - big safe dividends From: Mike McQuaid
- 2a.
- Re: Is yahoo VOLUME split-adjusted? From: Randy Harmelink
- 3a.
- quotes-plus replacement, fundamental data, local database From: leif_85
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.bigsafed ividends. ","Overallcom/quadchartie. aspx
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.bigsafed ividends. com/printerfrien dly.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.bigsafed ividends. ","Bigcom/quadchartie. aspx
> 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.bigsafed ividends. 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.bigsafed ividends. >com/quadchartie. aspx
http://www.bigsafedividends. ","panel1",1,com/quadchartie. aspx "",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.bigsafed ividends. ","Bigcom/quadchartie. aspx
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.bigsafed ividends. ","Click",com/quadchartie. aspx
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/ ) 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.Software/ database. htm
>
> If you end up testing any of these please post your experience here, I'd be interested in hearing about any solutions you find.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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