Messages In This Digest (3 Messages)

1a.: Force recalc From: Marty
1b.: Re: Force recalc From: Mike McQuaid
1c.: Re: Force recalc From: Martin Topper

View All Topics | Create New Topic

Messages

1a.: Force recalc

Posted by: "Marty" mtopper@yahoo.com mtopper

Tue Dec 27, 2011 9:19 am (PST)

Hi

I am using the following functions to get the DJIA (delayed) price and change from prior close:

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")-RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Prev Close:")

These functions works, but do not refresh when I run the SMFForeceRecalculation macro.

The macro does however, refresh my array entered GetYahooQuotes invocation.

Obviously, I am doing something wrong (or not understanding something).

thanks

Marty

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.: Re: Force recalc

Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802

Tue Dec 27, 2011 9:34 am (PST)

I pasted your first =RCHGet... function into a spreadsheet of mine and it
refreshes along with all my others.

Have you set the Internet Explorer cache options properly? That's all I can
think of. See here:
http://finance.groups.yahoo.com/group/smf_addin/message/13523

There are some other bits here:
http://finance.groups.yahoo.com/group/smf_addin/links

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Marty
Sent: Tuesday, December 27, 2011 12:20 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Force recalc

Hi

I am using the following functions to get the DJIA (delayed) price and
change from prior close:

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index Value:")

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index
Value:")-RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Prev
Close:")

These functions works, but do not refresh when I run the
SMFForeceRecalculation macro.

The macro does however, refresh my array entered GetYahooQuotes invocation.

Obviously, I am doing something wrong (or not understanding something).

thanks

Marty

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.: Re: Force recalc

Posted by: "Martin Topper" mtopper@yahoo.com mtopper

Tue Dec 27, 2011 10:21 am (PST)

thanks Mike

I had a problem with my computer - IT reinstalled Excel and IE. I had not yet changed the option back to refresh every time i visit the page.

thanks

Marty

________________________________
From: Mike McQuaid <mikemcq802@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, December 27, 2011 12:35 PM
Subject: RE: [smf_addin] Force recalc

I pasted your first =RCHGet... function into a spreadsheet of
mine and it refreshes along with all my others.

Have you set the Internet Explorer cache options
properly? That's all I can think of. See here:
http://finance.groups.yahoo.com/group/smf_addin/message/13523

There are some other bits here:
http://finance.groups.yahoo.com/group/smf_addin/links

________________________________
From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com] On Behalf Of Marty
Sent: Tuesday, December 27, 2011 12:20 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Force
recalc

Hi

I am using the following functions to get the DJIA (delayed) price
and change from prior close:

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index
Value:")

=RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Index
Value:")-RCHGetTableCell("http://finance.yahoo.com/q?s=^DJI",1,"Prev
Close:")

These functions works, but do not refresh when I run the
SMFForeceRecalculation macro.

The macro does however, refresh my array
entered GetYahooQuotes invocation.

Obviously, I am doing something wrong
(or not understanding something).

thanks

Marty

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)