Selasa, 09 Februari 2016

[smf_addin] Digest Number 3631[2 Attachments]

10 Messages

Digest #3631
2a
Fw: Error message in worksheet by "Charlie" ocormican
2b

Messages

Mon Feb 8, 2016 4:37 am (PST) . Posted by:

jimmymc00

Agreed. Enough already!


-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 8, 2016 3:24 am
Subject: Re: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..

Then you're using it wrong. Unless you show me what you're doing, it's hard to tell what #VALUE! is coming from. Did you use the evaluate formula process? It should have told you where the error originates.

My patience is wearing thin. Too many of these are simple EXCEL things. You need to take a class on EXCEL before tackling something like this with the add-in, which requires advanced concepts.

On Mon, Feb 8, 2016 at 1:20 AM, perseuslim11@... wrote:

and i've tried the substitute function, but still it is returning #value!

Mon Feb 8, 2016 4:40 am (PST) . Posted by:

"joo zhi" perseuslim11

Sorry.. I just need this last part to complete my template though .... 

Sent from Yahoo Mail on Android

On Mon, 8 Feb, 2016 at 20:37, jmcatee133@aol.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  
Agreed.  Enough already!



-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 8, 2016 3:24 am
Subject: Re: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..

  Then you're using it wrong. Unless you show me what you're doing, it's hard to tell what #VALUE! is coming from. Did you use the evaluate formula process? It should have told you where the error originates.

My patience is wearing thin. Too many of these are simple EXCEL things. You need to take a class on EXCEL before tackling something like this with the add-in, which requires advanced concepts.

On Mon, Feb 8, 2016 at 1:20 AM, perseuslim11@... wrote:

and i've tried the substitute function, but still it is returning #value!

Mon Feb 8, 2016 7:17 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

We all take advantage of Randy's generosity. But you have gone to extremes.
You need to do an internet search for "excel education free"
Tons of it out there.
You have ask over 50 questions and have not provided any worthwhile supporting data.

Give us all a break and quit asking basic excel questions. Take the time to learn

Sorry for the bluntness but you got to do your homework, then ask questions.
Provide examples.

Good luck

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 08, 2016 7:41 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..


Sorry.. I just need this last part to complete my template though ....
Sent from Yahoo Mail on Android <https://overview.mail.yahoo.com/mobile/?.src=Android>

On Mon, 8 Feb, 2016 at 20:37, jmcatee133@aol.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:

Agreed. Enough already!



-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Mon, Feb 8, 2016 3:24 am
Subject: Re: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..

Then you're using it wrong. Unless you show me what you're doing, it's hard to tell what #VALUE! is coming from. Did you use the evaluate formula process? It should have told you where the error originates.
My patience is wearing thin. Too many of these are simple EXCEL things. You need to take a class on EXCEL before tackling something like this with the add-in, which requires advanced concepts.

On Mon, Feb 8, 2016 at 1:20 AM, perseuslim11@... wrote:

and i've tried the substitute function, but still it is returning #value!


Mon Feb 8, 2016 7:56 am (PST) . Posted by:

perseuslim11

I did provide a photo above, with the formulas I've used as well in case you didnt notice..

Mon Feb 8, 2016 4:51 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

Yep, I saw your photos
Unfortunately they don't tell that much. Better if you attach the spreadsheet. That way more folks may offer assistance

You might want to print the addin documentation it was a big help to me. I prefer hard copy so I can make note in it.

Good luck, hope it is working for you now.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 08, 2016 10:57 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..


I did provide a photo above, with the formulas I've used as well in case you didnt notice..

Mon Feb 8, 2016 1:29 pm (PST) . Posted by:

"Charlie" ocormican



From: Charlie
Sent: Monday, February 08, 2016 10:55 AM
To: smf_addin@yahoogroups.com
Subject: Error message in worksheet

Hi Randy,

First, let me thank you for all your hard work building this wonderful add in.

I am having trouble, however, with the RCHGetElementNumber (Yahoo Finance) function. It is inconsistent in that it brings back the data for some stocks, but others it does not, even though I have verified on Yahoo Finance that the stock is listed. Please see the attachment. I have tried everything I can find to fix the problem, including settings in Internet Explorer, etc. I am using Windows 7 64 bit with Excel 2010. I would appreciate any feedback you might be able to provide. It behaves identically regardless of browser used (Chrome or IE).

Thanks,

Charlie

Attachment(s) from Charlie
2 of 2 Photo(s)

Mon Feb 8, 2016 1:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I tired all of the IRDM items, and they worked fine.

One thought -- how much data are you retrieving? The add-in is designed for
ad hoc data retrieval, not wholesale database building, so any requests
that go beyond 1000 web pages will return "Error".

That's because the add-in retrieves and stores a saved copy of a web page
first, then extracts the data from that saved copy of the web page -- so
that it only needs to get the web page once if 10 extractions come from the
same web page. However, there are ONLY 1000 slots for saving web pages. So,
anything above that will fail to retrieve a web page, and any extractions
based on it will result in "Error".

BTW, the browser you use is irrelevant. It's just that the add-in uses the
MicroSoft Internet engines, so shares all of the same libraries and
settings as IE -- another MicroSoft product.

On Mon, Feb 8, 2016 at 11:31 AM, 'Charlie' cburton@ipa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> First, let me thank you for all your hard work building this wonderful add
> in.
>
> I am having trouble, however, with the RCHGetElementNumber (Yahoo Finance)
> function. It is inconsistent in that it brings back the data for some
> stocks, but others it does not, even though I have verified on Yahoo
> Finance that the stock is listed. Please see the attachment. I have tried
> everything I can find to fix the problem, including settings in Internet
> Explorer, etc. I am using Windows 7 64 bit with Excel 2010. I would
> appreciate any feedback you might be able to provide. It behaves
> identically regardless of browser used (Chrome or IE).
>
>
>

Mon Feb 8, 2016 11:15 pm (PST) . Posted by:

gwlunceford

The formula using OptionSource had been working fine. All of the sudden it does not work with any of my options. It gives me Error probably because I am using IFerror as the formula. I have tried Yahoo and Google as the source but nothing seems to work.

Mon Feb 8, 2016 11:17 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'll need an example of a function invocation that is returning error...

On Tue, Feb 9, 2016 at 12:07 AM, gwlunceford@... wrote:

> The formula using OptionSource had been working fine. All of the sudden
> it does not work with any of my options. It gives me Error probably because
> I am using IFerror as the formula. I have tried Yahoo and Google as the
> source but nothing seems to work.
>

Mon Feb 8, 2016 11:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It does appear that Yahoo options pages are returning no options data right
now for XMLHTTP calls, but I did get something from Google:

=smfGetOptionQuotes("MMM 2/12 2016 $150 Call","a",,"Y")
=smfGetOptionQuotes("MMM 2/12 2016 $150 Call","a",,"G")

The first returned "Error", the second returned 4.45.

Hopefully, just a temporary issue for Yahoo.

On Tue, Feb 9, 2016 at 12:07 AM, gwlunceford@... wrote:

> The formula using OptionSource had been working fine. All of the sudden
> it does not work with any of my options. It gives me Error probably because
> I am using IFerror as the formula. I have tried Yahoo and Google as the
> source but nothing seems to work.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.20

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)