Senin, 15 Februari 2016

[smf_addin] Digest Number 3637[1 Attachment]

11 Messages

Digest #3637
1a
3a
(no subject) by "Darryl Bonfessuto"
3b
Re: by "Randy Harmelink" rharmelink
3c
Re: by "Darryl Bonfessuto"
3d
Re: by "Randy Harmelink" rharmelink
3e
Re: by "Darryl Bonfessuto"
3f
Re: [1 Attachment] by "Randy Harmelink" rharmelink

Messages

Sun Feb 14, 2016 4:51 am (PST) . Posted by:

dcabler

Excellent - that works great! Thanks Randy!


Dru

Sun Feb 14, 2016 8:16 am (PST) . Posted by:

pete_cook2001

You might also want to try changing your router's DNS settings. I switched from my ISP's default DNS server to a much faster one, and some of my lookups (and most of my web browsing) sped up significantly.

You can run Namebench to find the fastest DNS servers. https://code.google.com/archive/p/namebench/

Sun Feb 14, 2016 2:22 pm (PST) . Posted by:

"Darryl Bonfessuto"

Hello Randy

I am trying to get the US Treasury Table Form Yahoo into excel with each
headline title and content.

URL.. http://finance.yahoo.com/bonds/composite_bond_rates

I have tried =smfGetTagContent

And RCHGetTableCell

RCHGetHTMLTable

Any Thoughts?

Thanks Again,

Darryl

Sun Feb 14, 2016 3:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US
Treasury Bonds")

On Sun, Feb 14, 2016 at 3:22 PM, Darryl Bonfessuto dmb7111@... wrote:

>
> I am trying to get the US Treasury Table Form Yahoo into excel with each
> headline title and content.
>
> URL.. http://finance.yahoo.com/bonds/composite_bond_rates
>
> I have tried =smfGetTagContent
>
> And RCHGetTableCell
>
> RCHGetHTMLTable
>
> Any Thoughts?
>
>

Sun Feb 14, 2016 5:27 pm (PST) . Posted by:

"Darryl Bonfessuto"

Thanks Randy…. I get # value in blue.

Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 14, 2016 6:52 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

Try:

=RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US Treasury Bonds")

On Sun, Feb 14, 2016 at 3:22 PM, Darryl Bonfessuto dmb7111@... wrote:

I am trying to get the US Treasury Table Form Yahoo into excel with each headline title and content.

URL.. http://finance.yahoo.com/bonds/composite_bond_rates

I have tried =smfGetTagContent

And RCHGetTableCell

RCHGetHTMLTable

Any Thoughts?

Sun Feb 14, 2016 6:44 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I have no idea what that means...

To check, I just cut and pasted it from the message below and it works fine
here?

On Sun, Feb 14, 2016 at 6:27 PM, Darryl Bonfessuto dmb7111@... wrote:

>
> Thanks Randy…. I get # value in blue.
>
> Darryl
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Sunday, February 14, 2016 6:52 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin]
>
>
>
>
>
> Try:
>
> =RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US
> Treasury Bonds")
>
>
>
>

Sun Feb 14, 2016 7:53 pm (PST) . Posted by:

"Darryl Bonfessuto"

Randy

Here is the file

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 14, 2016 9:44 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

I have no idea what that means...

To check, I just cut and pasted it from the message below and it works fine here?

On Sun, Feb 14, 2016 at 6:27 PM, Darryl Bonfessuto dmb7111@... wrote:

Thanks Randy…. I get # value in blue.

Darryl

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ]
Sent: Sunday, February 14, 2016 6:52 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin]

Try:

=RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US Treasury Bonds")

Attachment(s) from Darryl Bonfessuto
1 of 1 File(s)

Sun Feb 14, 2016 9:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You pasted the formula incorrectly -- as HTML, into a single cell.

You need to array-enter an RCHGetHTMLTable() formula over a range if you
want it to return anything more than one cell's worth of data.

On Sun, Feb 14, 2016 at 8:53 PM, Darryl Bonfessuto dmb7111@... wrote:

>
> Randy
>
> Here is the file
>
>
>

Mon Feb 15, 2016 1:09 am (PST) . Posted by:

perseuslim11

Kermit, I see, I thought the photo was sufficient, sorry..

oh ya, the other stuffs got them sorted out after much trial and error
but still working on yahoo price history one now =)


And to Randy.. sorry for the trouble previously.. I really appreciated your help ^_^
sorry for asking so many questions.. as I'm learning my dentistry stuff + investment stuff + these excel stuff all at once (btw dentistry course in my country is 5 years as opposed to 7 years in most developed countries, as such, the curriculum is tightly packed, and we are indeed very busy.)
.. hence it is rather hard on me also.. didn't mean to take advantage or be a nuisance..


I deeply apologise if what I did made you or anyone else to have felt that way.. Really sorry to everyone here :)


I will try my best to learn whatever I can and only ask if i still couldn't figure it out

Mon Feb 15, 2016 1:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Did you try the example I gave you?

On Mon, Feb 15, 2016 at 2:09 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> but still working on yahoo price history one now =)
>
>
>

Mon Feb 15, 2016 1:54 am (PST) . Posted by:

perseuslim11

Yes, Randy, I've succesfully gotten the yahoo data as well.. as for the data last time you asked me to use the substitute function, it didnt work, but i googled for long time then found a solution that is, to copy a zero, the use paste special [add] to that cell, after that, it works ^^


thanks Randy :)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)