[smf_addin] Digest Number 3004

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3004

1a

is there an easy way to determine if a website is available? by "Kermit W. Prather" kermitpra

1b

Re: is there an easy way to determine if a website is available? by "Randy Harmelink" rharmelink

1c

Re: is there an easy way to determine if a website is available? by "Kermit W. Prather" kermitpra

Messages

1a

is there an easy way to determine if a website is available?

Thu Mar 13, 2014 1:08 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I have a spreadsheet that uses www.getsplithistory.com to obtain the slit
history for a stock such as PCAR.

Normally, the response is great but today the site is down. The spreadsheet
hangs forever. In fact now going on 20 minutes.

I need a way to test if the site is available before I insert a symbol value
into B2. Have any suggestions?

I'm using an array with this value
=RCHGetHTMLTable("http://getsplithistory.com/"&$B$2,"",1,"",1)
Where B2 has the symbol the array is defined as 5 columns and 46 rows

Kermit

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: is there an easy way to determine if a website is available?

Thu Mar 13, 2014 1:19 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've used this in the past, but it seems a little flaky today:

http://www.isitdownrightnow.com

How about going to MorningStar for the data?

=RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/split-history.action?t=
"&$B$2,"",1,"",1)

On Thu, Mar 13, 2014 at 1:08 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I have a spreadsheet that uses www.getsplithistory.com to obtain the slit
> history for a stock such as PCAR.
>
>
>
> Normally, the response is great but today the site is down. The
> spreadsheet hangs forever. In fact now going on 20 minutes.
>
>
>
> I need a way to test if the site is available before I insert a symbol
> value into B2. Have any suggestions?
>
>
>
> I'm using an array with this value =RCHGetHTMLTable("
> http://getsplithistory.com/"&$B$2,"",1,"",1)
>
> Where B2 has the symbol the array is defined as 5 columns and 46 rows
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: is there an easy way to determine if a website is available?

Thu Mar 13, 2014 2:37 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, I may try the Morningstar approach.

I checked the isitdownnow site. Not sure that will work

Thanks again,
Kermit


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, March 13, 2014 4:20 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] is there an easy way to determine if a website is available?


I've used this in the past, but it seems a little flaky today:

http://www.isitdownrightnow.com
How about going to MorningStar for the data?

=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/split-history.action?t="&$B$2,"",1,"",1)
On Thu, Mar 13, 2014 at 1:08 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I have a spreadsheet that uses www.getsplithistory.com to obtain the slit history for a stock such as PCAR.

Normally, the response is great but today the site is down. The spreadsheet hangs forever. In fact now going on 20 minutes.

I need a way to test if the site is available before I insert a symbol value into B2. Have any suggestions?

I'm using an array with this value =RCHGetHTMLTable("http://getsplithistory.com/"&$B$2,"",1,"",1)
Where B2 has the symbol the array is defined as 5 columns and 46 rows

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

Visit Your Group

• New Members 35

• Privacy • Unsubscribe • Terms of Use