Messages In This Digest (5 Messages)
- 1a.
- Re: Error using RCHGetTableElement From: Randy Harmelink
- 2a.
- Re: RCHGetTableCell explanation From: Ashish Mukerji
- 3a.
- Why does RCHGetYahooQuotes() with Now() slows down Excel so much? From: lightaiyee
- 3b.
- Re: Why does RCHGetYahooQuotes() with Now() slows down Excel so much From: Mike McQuaid
- 3c.
- Re: Why does RCHGetYahooQuotes() with Now() slows down Excel so much From: Randy Harmelink
Messages
- 1a.
-
Re: Error using RCHGetTableElement
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 16, 2012 5:24 pm (PST)
I'll assume you mean the RCHGetElementNumber() function.
In any case, an "Undefined" result means you didn't unzip all of the files
into the add-in folder. The element definitions are in files external to
the XLA file.
On Mon, Jan 16, 2012 at 6:11 PM, Venu <vn95118@yahoo.com > wrote:
>
> I am trying to use RCHGetTableElement to calculate some fundamental valuse
> for some ticker symbols. I am trying to get the data from Yahoo Key
> Statistics, but I get an undefined value for everything.
>
> I backed off and tried to put =RCHGetTableElement("Source" ,941) into a
> cell and get undefined value.
>
> What could I be doing wrong?
>
- 2a.
-
Re: RCHGetTableCell explanation
Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm
Mon Jan 16, 2012 5:26 pm (PST)
Thx. Randy ... yes it is "Easy Peasy" for me too ... now that you have told me ... I knew it !!!!
Ashish
>____________________ _________ ___
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Monday, January 16, 2012 7:42 PM
>Subject: Re: [smf_addin] RCHGetTableCell explanation
>
>
>
>Easy Peasy. Here's what the smfGetOptionQuotes() function ends up using to extract the data:
>
>=RCHGetTableCell("http://finance. yahoo.com/ ",3,"120121C0003750q/op?s=JPM 0")
>
>Basically, look for the date/Call/Strike string portion of the ticker symbol, and then get the 3rd table cell following it.
>
>
>On Mon, Jan 16, 2012 at 5:29 PM, Ashish <ashishkm@yahoo.com > wrote:
>
>I am having problem in interpreting the use of RCHGetTableCell syntax ... I wonder if someone who understands this syntax can take a look, for example at, JPM Option Quote Table in Yahoo and provide the proper syntax (purely as an example, for learning purpose)) for accessing Jan 37.50 Call Option "bid" value (which is 0.06) ...The URL for the table is http://finance.yahoo.com/ ... Thanks in advance ...q/op?s=JPM+ Options
>>
>
>
>
>
- 3a.
-
Why does RCHGetYahooQuotes() with Now() slows down Excel so much?
Posted by: "lightaiyee" lightaiyee@gmail.com lightaiyee
Mon Jan 16, 2012 8:14 pm (PST)
I am using RCHGetYahooQuotes() with Now() as one of the parameters to download price quotes from Yahoo. It is used as in an array formula. However, using Now() will slow down Excel when I work on other worksheets. The cells on other worksheets are updated much more slowly after calculation. Removing Now() will return the speed to normal. But this creates another problem. The price quotes do not update when F9 is pressed and I do not know how else to update the price quotes.
Is there any way to use RCHGetYahooQuotes() without slowing down other worksheets?
Thank you.
- 3b.
-
Re: Why does RCHGetYahooQuotes() with Now() slows down Excel so much
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Mon Jan 16, 2012 8:23 pm (PST)
I use the smfForceRecalculation macro to resolve that problem.
I don't use NOW but instead assign this smf macro to a button I create on
the worksheet. I creatively call the button "Refresh" :)
See Randy's info here on how to use it:
http://finance.groups.yahoo. com/group/ smf_addin/ message/7625
Randy's instructions talk about assigning the macro to a keyboard shortcut -
which is fine too. To use a button like I do, Google will provide many
helpful articles.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of lightaiyee
Sent: Monday, January 16, 2012 11:15 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Why does RCHGetYahooQuotes() with Now() slows down
Excel so much?
I am using RCHGetYahooQuotes() with Now() as one of the parameters to
download price quotes from Yahoo. It is used as in an array formula.
However, using Now() will slow down Excel when I work on other worksheets.
The cells on other worksheets are updated much more slowly after
calculation. Removing Now() will return the speed to normal. But this
creates another problem. The price quotes do not update when F9 is pressed
and I do not know how else to update the price quotes.
Is there any way to use RCHGetYahooQuotes() without slowing down other
worksheets?
Thank you.
- 3c.
-
Re: Why does RCHGetYahooQuotes() with Now() slows down Excel so much
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jan 16, 2012 8:25 pm (PST)
Because NOW() is a volatile function, which recalculates EVERY time
something changes in the workbook, which also triggers all related formulas
to recalculate as well.
I always use the smfForceRecalculation macro to do my updates (see "Links"
area of group for more info).
Another thing you can do is point the refresh parameter of the add-in
function to a particular cell in your worksheet. Then, whenever you change
the value in that cell, it will force the add-in function to recalculate.
For example, you could just toggle it between 1 and 0.
On Mon, Jan 16, 2012 at 9:14 PM, lightaiyee <lightaiyee@gmail.com > wrote:
> I am using RCHGetYahooQuotes() with Now() as one of the parameters to
> download price quotes from Yahoo. It is used as in an array formula.
> However, using Now() will slow down Excel when I work on other worksheets.
> The cells on other worksheets are updated much more slowly after
> calculation. Removing Now() will return the speed to normal. But this
> creates another problem. The price quotes do not update when F9 is pressed
> and I do not know how else to update the price quotes.
>
> Is there any way to use RCHGetYahooQuotes() without slowing down other
> worksheets?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar