Kamis, 08 September 2016

[smf_addin] Digest Number 3793

11 Messages

Digest #3793
2c
Re: Mutual Fund data / attributes by "Randy Harmelink" rharmelink
3a
smf  addins keep unistalling by "Dennis Sesar" dennis@zis.com
3b
Re: smf addins keep unistalling by "Randy Harmelink" rharmelink
3c
Is the Download Table the best method? by andrew.hills@hunterfield.com.au
3d
Re: Is the Download Table the best method? by "Randy Harmelink" rharmelink
3e
Re: Is the Download Table the best method? by "Andrew Hills" andrew.hills@hunterfield.com.au
3f
Re: Is the Download Table the best method? by "Randy Harmelink" rharmelink

Messages

Wed Sep 7, 2016 1:28 pm (PDT) . Posted by:

millerd1_smf

Trying to open a file that ran ok last Wednesday or even just starting a blank file I see
2016-09-07_1359 - millerd1's library http://screencast.com/t/8bNq8UfNbJWX


http://screencast.com/t/8bNq8UfNbJWX

2016-09-07_1359 - millerd1's library http://screencast.com/t/8bNq8UfNbJWX


View on screencast.com http://screencast.com/t/8bNq8UfNbJWX
Preview by Yahoo


Both a yes and no response 2016-09-07_1402 - millerd1's library http://screencast.com/t/TYZau2ZFb5bA or


http://screencast.com/t/TYZau2ZFb5bA

2016-09-07_1402 - millerd1's library http://screencast.com/t/TYZau2ZFb5bA


View on screencast.com http://screencast.com/t/TYZau2ZFb5bA
Preview by Yahoo


2016-09-07_1403 - millerd1's library http://screencast.com/t/oOoNQy9y


http://screencast.com/t/oOoNQy9y

2016-09-07_1403 - millerd1's library http://screencast.com/t/oOoNQy9y


View on screencast.com http://screencast.com/t/oOoNQy9y
Preview by Yahoo


the stalls with hour glass here. http://screencast.com/t/H9NEYQc9Hn http://screencast.com/t/H9NEYQc9Hn


http://screencast.com/t/H9NEYQc9Hn

2016-09-07_1403 - millerd1's library http://screencast.com/t/H9NEYQc9Hn


View on screencast.com http://screencast.com/t/H9NEYQc9Hn
Preview by Yahoo


Any suggestions?

Wed Sep 7, 2016 3:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Before I looked at your images, I thought your issue would probably be the
Microsoft security update issue from July, but those images don't give me a
clue as to what might be going on, other than that there's some issue with
your Solver add-in...

I don't see anything related to the SMF add-in there?

You could try starting up EXCEL in safe mode:

https://support.office.com/en-us/article/Open-Office-apps-in-safe-mode-on-a-Windows-PC-dedf944a-5f4b-4afb-a453-528af4f7ac72

On Wed, Sep 7, 2016 at 1:28 PM, millerd1_airmail_net@
​...wrote:

>
>
> Trying to open a file that ran ok last Wednesday or even just starting a
> blank file I see
>
> 2016-09-07_1359 - millerd1's library
> <http://screencast.com/t/8bNq8UfNbJWX>
> [image: image] <http://screencast.com/t/8bNq8UfNbJWX>
> 2016-09-07_1359 - millerd1's library
> <http://screencast.com/t/8bNq8UfNbJWX>
> View on screencast.com <http://screencast.com/t/8bNq8UfNbJWX>
> Preview by Yahoo
>
> Both a yes and no response 2016-09-07_1402 - millerd1's library
> <http://screencast.com/t/TYZau2ZFb5bA> or
> [image: image] <http://screencast.com/t/TYZau2ZFb5bA>
> 2016-09-07_1402 - millerd1's library
> <http://screencast.com/t/TYZau2ZFb5bA>
> View on screencast.com <http://screencast.com/t/TYZau2ZFb5bA>
> Preview by Yahoo
>
> 2016-09-07_1403 - millerd1's library <http://screencast.com/t/oOoNQy9y>
> [image: image] <http://screencast.com/t/oOoNQy9y>
> 2016-09-07_1403 - millerd1's library <http://screencast.com/t/oOoNQy9y>
> View on screencast.com <http://screencast.com/t/oOoNQy9y>
> Preview by Yahoo
>
> the stalls with hour glass here. http://screencast.com/t/H9NEYQc9Hn
> [image: image] <http://screencast.com/t/H9NEYQc9Hn>
> 2016-09-07_1403 - millerd1's library <http://screencast.com/t/H9NEYQc9Hn>
> View on screencast.com <http://screencast.com/t/H9NEYQc9Hn>
> Preview by Yahoo
>
> Any suggestions?
>
>

Wed Sep 7, 2016 5:04 pm (PDT) . Posted by:

msimmsx

http://finance.yahoo.com/quote/SGENX/?p=SGENX http://finance.yahoo.com/quote/SGENX/?p=SGENX
I've given up....yahoo engineers are making it nearly impossible to scrape and grab Mutual Fund data from this URL.
It's all mostly all dynamic HTML and Javascript.....really sucks.
They obviously did this intentionally.

Wed Sep 7, 2016 5:07 pm (PDT) . Posted by:

msimmsx

I've given up...Yahoo Finance makes it nearly impossible to scrape any data.
They're using dynamic HTML and Javascript heavily with CSS formatting.....
it really stinks.

Wed Sep 7, 2016 6:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

​Yeah. The source code of the new Yahoo web pages can be a terror to go
through. I've given up a few times myself.

However, most (all?) of the mutual fund data on Yahoo comes from
MorningStar. Why not just go to the source?

On Wed, Sep 7, 2016 at 5:04 PM, marksimms@
​... w​
rote:

> ​​
>
> http://finance.yahoo.com/quote/SGENX/?p=SGENX
>

I've given up....yahoo engineers are making it nearly impossible to scrape
> and grab Mutual Fund data from this URL.
> It's all mostly all dynamic HTML and Javascript.....really sucks.
> They obviously did this intentionally.
>

On Wed, Sep 7, 2016 at 5:07 PM, marksimms@
​...wrote:

>
> I've given up...Yahoo Finance makes it nearly impossible to scrape any
> data.
> They're using dynamic HTML and Javascript heavily with CSS formatting.....
> it really stinks.
>
>

Wed Sep 7, 2016 6:10 pm (PDT) . Posted by:

"Dennis Sesar" dennis@zis.com

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\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.

Dennis Sesar

18757 Burbank Blvd., STE 116

Tarzana CA 91356

TEL: 310.826.8634 ˚ 818.206.8634 EXT 114

<mailto:dennis@zis.com> dennis@zis.com

Wed Sep 7, 2016 6:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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.
>
>
>
>
>

Wed Sep 7, 2016 6:24 pm (PDT) . Posted by:

andrew.hills@hunterfield.com.au

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&#39; messages for some companies but not all, for eg, WOW.AX and WES.AX. Has Yahoo changed the Element #'s? Lots of thanks.

Wed Sep 7, 2016 7:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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 doesn't work because it doesn't have an analyst estimates web page.
But 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&#39; messages for some companies but not
> all, for eg, WOW.AX and WES.AX. Has Yahoo changed the Element #'s? Lots
> of thanks.
>

Wed Sep 7, 2016 8:11 pm (PDT) . Posted by:

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

Many thanks Randy.

Is it possible that Yahoo has removed the WOW.AX analyst estimates page? It worked yesterday.

Regards

Andrew

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.

Wed Sep 7, 2016 8:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That seems the most likely explanation.

On Wed, Sep 7, 2016 at 8:11 PM, 'Andrew Hills' andrew.hills@
​... wrote:

>
> Is it possible that Yahoo has removed the WOW.AX analyst estimates page?
> It worked yesterday.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)