Selasa, 23 Oktober 2012

[smf_addin] Digest Number 2381

3 New Messages

Digest #2381
1a
Not pulling in text values from web by "twopourdrummer" twopourdrummer
1b
Re: Not pulling in text values from web by "Randy Harmelink" rharmelink
2

Messages

Mon Oct 22, 2012 8:32 am (PDT) . Posted by:

"twopourdrummer" twopourdrummer

Got an interesting issue. On my work computer, any text field that I'm trying to pull off a website creates a #value error. It use to work fine, then one day, it didn't. It works fine at home so I know they still work correctly. My guess is there is some type of setting on my Excel at work that is causing this, but I can't find it. I saw one post that talked about changing the transition formula entry option but that didn't work. Any ideas would be helpful. Thanks.

Mon Oct 22, 2012 11:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For a stand-alone function, a #VALUE! error typically is the cause of
passing an improper parameter to the function. Can you give me an example
of a function invocation that gives you that error?

On Mon, Oct 22, 2012 at 6:17 AM, twopourdrummer <twopourdrummer@yahoo.com>wrote:

> Got an interesting issue. On my work computer, any text field that I'm
> trying to pull off a website creates a #value error. It use to work fine,
> then one day, it didn't. It works fine at home so I know they still work
> correctly. My guess is there is some type of setting on my Excel at work
> that is causing this, but I can't find it. I saw one post that talked about
> changing the transition formula entry option but that didn't work. Any
> ideas would be helpful. Thanks.
>

Tue Oct 23, 2012 1:18 am (PDT) . Posted by:

"boo1712" boo1712

Hi guys,

I discovered a new google API:
http://www.google.com/finance/info?infotype=infoquoteall&q=BTU,JPM,AIG

It has more variables such as beta, 52wk high, premarket quotes etc.

However I do not know how to handle the numerous """.

Previously we had a spreadsheet using another google API
smfStrExtr(RCHGetWebData("http://www.google.com/ig/api?stock="&smfJoin($C$4:$C$33,"&stock="),"<symbol data="""&$C4&"""",5000),"<"&E$3&" data=""","""")

It is useful and fast for getting multiple quotes.

Can anyone help to provide the formula to the new API with more variables?

Thanks alot

Tidak ada komentar:

Posting Komentar