Jumat, 09 September 2016

[smf_addin] Digest Number 3794

6 Messages

Digest #3794
2a
Re: Is the Download Table the best method? by "Andrew Hills" andrew.hills@hunterfield.com.au
2b
Re: Is the Download Table the best method? by "Randy Harmelink" rharmelink
3a
Re: smf addins keep unistalling by "Dennis Sesar" dennis@zis.com
4a
Sent from Snipping Tool by "Dennis Sesar" dennis@zis.com
4b
Re: Sent from Snipping Tool by "Randy Harmelink" rharmelink

Messages

Thu Sep 8, 2016 7:21 am (PDT) . Posted by:

msimmsx

Briallant minds think alike Randy....
and that's exactly what I did last night.

A cheap Morningstar account is likely the solution for my client, a Portfolio Management Company.

Thanks for your thoughts and advice.

Thu Sep 8, 2016 9:10 am (PDT) . Posted by:

"Andrew Hills" andrew.hills@hunterfield.com.au

Hi Randy, can you still see a populated 'analyst estimates' web page for WES.AX? it appears to have been removed as well?

Thanks and Regards,

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, September 08, 2016 12:44 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Is the Download Table the best method?

For something like that, yes, I would use the smfUpdateDownloadTable process. Because you can download the data piecemeal, and have values returned. No worries about recalculations when the worksheet is opened or being worked on.

WOW.AX <http://WOW.AX> doesn't work because it doesn't have an analyst estimates web page. But WES.AX <http://WES.AX> works for me.

It could be you ran into the 1000 web page limit per "session" of the add-in. That's because the add-in is intended for ad hoc usage, not database building. The add-in saves the web page to an array, and then extracts the data from that saved web page. But that array only has 1000 slots.

That data would require 500 web page retrievals. According to my log, they take under a third of a second each. But that still means about 3 minutes to get all the data.

The download table process adds SOME overhead, but not much. I would suspect it was taking a long time simply because of the number of web pages you were retrieving data from. With the download table process, it's almost too easy to add more tickers or more data items.

On Wed, Sep 7, 2016 at 6:24 PM, andrew.hills@

​...wrote:

Hi Randy, i hope you are well. What is the best way to download into Excel, Element #s 559, 567, 571, 609, 560, 699 and 700 for about 500 companies? i have used a 'download table' in the past but it is slow. Also, I have started receiving 'Error' messages for some companies but not all, for eg, WOW.AX <http://WOW.AX> and WES.AX <http://WES.AX> . Has Yahoo changed the Element #'s? Lots of thanks.

Thu Sep 8, 2016 9:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's gone for me today as well.

To tell the truth, I was surprised to see something yesterday. I wasn't
aware that many analysts followed Australia stocks...

On Thu, Sep 8, 2016 at 9:10 AM, 'Andrew Hills' andrew.hills@
​... ​
wrote:

>
> Hi Randy, can you still see a populated 'analyst estimates' web page for
> WES.AX? it appears to have been removed as well?
>
>
>
>

Thu Sep 8, 2016 9:53 am (PDT) . Posted by:

"Dennis Sesar" dennis@zis.com

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, September 07, 2016 6:15 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] smf addins keep unistalling

This was discussed in a number of message threads back in July and August. The problem appears to be related to a July MicroSoft security update. It's not letting EXCEL load the add-in when EXCEL starts up. As a result, you are getting link errors, because EXCEL can't resolve the links to the add-in.

For a workaround suggested by Microsoft, until they fix the issue, see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568

On Wed, Sep 7, 2016 at 4:16 PM, 'Dennis Sesar' dennis@

​...wrote:

I have been running a spread sheet for a long time that uses the SMF add-ins with no issues. A couple of months ago it stopped working properly. Each time I open the spread sheet I have to open excel options uncheck the smf add-ins then close the window and open again and check the smf add-in. once I have followed this procedure the functions act normally.

For example I have a cell the contains =RCHGetYahooQuotes(C91,"l1") where C91 contains the sticker symbol. If I do not follow the procedure outlined above the cell contains

='C:\Downloads&#92;RCH_STOCK_MARKET_FUNCTIONS\RCH_Stock_Market_Functions-2.1.2014.01.30\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(C91,"l1")

I cannot figure out what is happening.

Thu Sep 8, 2016 3:20 pm (PDT) . Posted by:

"Dennis Sesar" dennis@zis.com

I unblocked all of these and experienced no difference

Thu Sep 8, 2016 3:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only file you need to unblock is the XLA file.

On Thu, Sep 8, 2016 at 3:20 PM, 'Dennis Sesar' dennis@zis.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I unblocked all of these and experienced no difference
>
>
>
>
>
>
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar