Rabu, 28 Desember 2011

[smf_addin] Digest Number 2059

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

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

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

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

Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Tidak ada komentar:

Posting Komentar