3 New Messages
Digest #2381
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.
>
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@
> 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
I discovered a new google API:
http://www.google.
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(RCHGetWe
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