Selasa, 07 Februari 2012

[smf_addin] Digest Number 2107

Messages In This Digest (8 Messages)

Messages

1a.

Re: RCHGetHTMLTable - big safe dividends

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Mon Feb 6, 2012 5:27 am (PST)



Or, if allowed an external query and then vba FIND to locate what is needed?

Don Guillett
SalesAid Software
dguillett1@gmail.com

From: Mike McQuaid
Sent: Sunday, February 05, 2012 10:41 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RCHGetHTMLTable - big safe dividends

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","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

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

ERROR with fetching "Last Price"

Posted by: "mac_questions" d_folino@yahoo.com   mac_questions

Mon Feb 6, 2012 2:06 pm (PST)



I updated all of the latest SMF files and I am still getting an ERROR. Can you please let me know what the problem is?

=RCHGetTableCell("http://finance.yahoo.com/q?s="&A2,1,"Last Trade:")

Thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2b.

Re: ERROR with fetching "Last Price"

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

Mon Feb 6, 2012 2:13 pm (PST)



There is no "Last Trade:" string to find on the web page since they changed
the format of the web page.

Just use the RCHGetYahooQuotes() function to get the last traded price.

On Mon, Feb 6, 2012 at 3:06 PM, mac_questions <d_folino@yahoo.com> wrote:

> I updated all of the latest SMF files and I am still getting an ERROR.
> Can you please let me know what the problem is?
>
> =RCHGetTableCell("http://finance.yahoo.com/q?s="&A2,1,"Last Trade:")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.

Re: ERROR with fetching "Last Price"

Posted by: "mac_questions" d_folino@yahoo.com   mac_questions

Mon Feb 6, 2012 2:24 pm (PST)



Excellent! Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> There is no "Last Trade:" string to find on the web page since they changed
> the format of the web page.
>
> Just use the RCHGetYahooQuotes() function to get the last traded price.
>
> On Mon, Feb 6, 2012 at 3:06 PM, mac_questions <d_folino@...> wrote:
>
> > I updated all of the latest SMF files and I am still getting an ERROR.
> > Can you please let me know what the problem is?
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q?s="&A2,1,"Last Trade:")
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

I would like to get unadjusted data. Is this possible?

Posted by: "c078342" c078342@yahoo.com   c078342

Mon Feb 6, 2012 2:19 pm (PST)





Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: I would like to get unadjusted data. Is this possible?

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

Mon Feb 6, 2012 2:22 pm (PST)



If you're talking about historical quotes, RCHGetYahooHistory() gives
unadjusted prices unless you tell it to adjust them. If you mean something
else, you'll need to be more specific.

On Mon, Feb 6, 2012 at 3:18 PM, c078342 <c078342@yahoo.com> wrote:

> I would like to get unadjusted data. Is this possible?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

new vervion of smfGetADVFNElement() is not working, but the previos

Posted by: "dkarbayev" dkarbayev@yahoo.com   dkarbayev

Mon Feb 6, 2012 8:24 pm (PST)



Hi, Randy!

Your addin is OUTSTANDING. Thank you for this!

As far as I understand from the message history, in the most recent version of the addin 'www' was changed for 'us' in the smfGetADVFNElement() function. But this seems not to be working now (last checked on Feb 7 2012).

I've tried to reinstall the previous version of the addin, and smfGetADVFNElement()is still working fine. But this previous version of the addin does not contain your last developments and bug fixes. I can imagine that you are overloaded with messages of the SMF group, but could you have a look at it once again?

Thank you!

Dias

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: new vervion of smfGetADVFNElement() is not working, but the prev

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

Mon Feb 6, 2012 8:32 pm (PST)



Which new version are you using? 2.1.2012.01.30 used "us", but I changed
it back to "www" in 2.1.2012.02.02, after AdvFN flip-flopped back. So,
the "most recent version" should be using "www", not "us".

You can find out the version you are using with:

=RCHGetElementNumber("Version")

On Mon, Feb 6, 2012 at 9:24 PM, dkarbayev <dkarbayev@yahoo.com> wrote:
Hi, Randy!

Your addin is OUTSTANDING. Thank you for this!

As far as I understand from the message history, in the most recent
version of the addin 'www' was changed for 'us' in the
smfGetADVFNElement() function. But this seems not to be working now
(last checked on Feb 7 2012).

I've tried to reinstall the previous version of the addin, and
smfGetADVFNElement()is still working fine. But this previous version of
the addin does not contain your last developments and bug fixes. I can
imagine that you are overloaded with messages of the SMF group, but
could you have a look at it once again?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
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
Diposting oleh EXCEL FEED LEARNING di 02.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)