Sabtu, 21 November 2015

[smf_addin] Digest Number 3564[1 Attachment]

4 Messages

Digest #3564

Messages

Fri Nov 20, 2015 10:09 am (PST) . Posted by:

matthewpdobbins

Could you let me know where the SMFfixlinks macro is? I'm searching for it, but can't seem to find it.

Fri Nov 20, 2015 10:12 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's in the add-in. If you have it activated, it's available. Just go to
the macro dialog (alt+F8), type the name in, and then click on "Run" when
the button is available.

On Fri, Nov 20, 2015 at 9:43 AM, matthewpdobbins@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Could you let me know where the SMFfixlinks macro is? I'm searching for
> it, but can't seem to find it.
>

Fri Nov 20, 2015 8:31 pm (PST) . Posted by:

jterrenceho

Hi Randy,


I have been have trouble with RCHGetYahooQuotes. It recently download a quarter of the data points I am requesting.


I tried Force Recalculate and I also tried to set my Internet Browser to check for newer version of stored page. When I tried the latter, it always return to automatically setting. Both does not fix the problem.


I have attached my file for you to see. The problem is in the Download tab.


Could it be that I am temporarily kicked out of the Yahoo server?


Thanks Randy.
Attachment(s) from
1 of 1 File(s)

Fri Nov 20, 2015 11:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Oh, man. Change all of those individual RCHGetYahooQuotes() functions into
just a few array-entered ones over ranges. You can get multiple data items
on up to 200 tickers symbols at once. Your recalculation will run MUCH
faster. Probably seconds instead of the LOOOONG time it's taking now.

Nothing I do is anywhere near as large as that. I just don't understand why
everyone wants to grab all the data at once, when they can only look at
small pieces of it at once anyway. Just grab the data you're gonna look at,
and grab the other later when you're gonna look at it.

If you're doing some type of screening, you should get an appropriate tool.

On Fri, Nov 20, 2015 at 9:31 PM, jterrenceho@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have been have trouble with RCHGetYahooQuotes. It recently download a
> quarter of the data points I am requesting.
>
> I tried Force Recalculate and I also tried to set my Internet Browser to
> check for newer version of stored page. When I tried the latter, it always
> return to automatically setting. Both does not fix the problem.
>
> I have attached my file for you to see. The problem is in the Download tab.
>
> Could it be that I am temporarily kicked out of the Yahoo server
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar