Rabu, 19 Desember 2012

[smf_addin] Digest Number 2440

10 New Messages

Digest #2440
1a
Re: SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 200 by "ecwmba@sbcglobal.net" ecwmba@sbcglobal.net
2
(no subject) by "morteritos@yahoo.com" morteritos

Messages

Tue Dec 18, 2012 8:29 am (PST) . Posted by:

"ecwmba@sbcglobal.net" ecwmba@sbcglobal.net

got it to work with the smfForceRecalc procedure. thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:

Did you look at the suggestions earlier in this thread? Were they relevant
to your situation?

My first thoughts are what was mentioned there -- Temporary Internet Files,
unresolved links, or regional settings.

On Mon, Dec 17, 2012 at 12:06 PM, ecwmba@... wrote:

I am having troulbe with F9 not working. I am using Excel 2010. Any tips
or suggestions?
Eric

--- In smf_addin@yahoogroups.com, "iamruf" wrote:

SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 2007
A template with an example of using the RCHGetYahooQuotes() function.
I have downloaded this template to Excel 2010 but it will not run with
either F9 or Shift F9.
Please advise if there is something else I need to do.


Tue Dec 18, 2012 8:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That shouldn't be what made it work -- for a volatile version of the
RCHGetYahooQuotes() function, smfForceRecalculation just tells EXCEL to
recalculate it. More or less, the equivalent of F9. The primary reason for
smfForceRecalculation is to reset things for other functions that save
copies of web pages.

I suspect you have IE settings that don't tell it to get a new copy of a
web page every time it is visited. So it will only update when IE decided
to update it, not when you tell EXCEL to recalculate.

On Tue, Dec 18, 2012 at 9:29 AM, ecwmba@sbcglobal.net
<ecwmba@sbcglobal.net>wrote:

> got it to work with the smfForceRecalc procedure. thanks.
>

Tue Dec 18, 2012 12:32 pm (PST) . Posted by:

"jorge" jagonzb

Thank you Randy … I appreciate your prompt response.

The code "=RCHGetTableCell( "http://www.zacks.com/stock/quote/"&D4,1,"Next Earnings Report Date")" works fine.

Thanks again

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, December 17, 2012 9:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Earnings Datecode Return "Error"

Zack's just changed the structure of their website, so most URLs will
probably need to be changed. Try:

=RCHGetTableCell( "http://www.zacks.com/stock/quote/"&D4,1,"Next
Earnings Report Date")

On Mon, Dec 17, 2012 at 7:19 PM, Jorge <jagonzbe@bellsouth.net <mailto:jagonzbe%40bellsouth.net> > wrote:
>
> The following code is returning "Error":
> =RCHGetTableCell( "http://www.zacks.com/research/report.php? type=estimates& t="&A3,1,"Next Report Date")

Tue Dec 18, 2012 2:20 pm (PST) . Posted by:

"rr76012" rr76012

Hello Randy,

I extracted the updated smf addin to my C:\Program Files\SMF Add-In directory today.

NOw the rchgetelementnumber functon is now displaying "error" on all cells, on all my spreadsheets ex: =RCHGetElementNumber($A$13,B7, now shows "error".

IN my EXCEL 2007:

Edit links show:

1)RCH_Stock_Market_Functions.xla, Type - Worksheet, Updaate A, Status Unknown.
2)RCH_Stock_Market_Functions.xla, Type= Remote file, Update A, Status Unknown.

Workbook Connections
RCHGetElementNumber-Elements-Definintions

Location: C:\Program Files\SMF Add-In

I tried re-starting the computer? that did not help.

What should I do?

Can you help, what do I do?

thanks,

Tue Dec 18, 2012 2:33 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Did you get the updated element definitions from the "Works in Progress"
folder of the files area? Since you didn't mention any element numbers, I
don't know if they are applicable or not. Updates had to be done for MSN,
Morningstar, and Zacks elements this year...

On Tue, Dec 18, 2012 at 3:20 PM, rr76012 <rr76012@yahoo.com> wrote:

>
> I extracted the updated smf addin to my C:\Program Files\SMF Add-In
> directory today.
>
> NOw the rchgetelementnumber functon is now displaying "error" on all
> cells, on all my spreadsheets ex: =RCHGetElementNumber($A$13,B7, now shows
> "error".
>
> IN my EXCEL 2007:
>
> Edit links show:
>
> 1)RCH_Stock_Market_Functions.xla, Type - Worksheet, Updaate A, Status
> Unknown.
> 2)RCH_Stock_Market_Functions.xla, Type= Remote file, Update A, Status
> Unknown.
>
> Workbook Connections
> RCHGetElementNumber-Elements-Definintions
>
> Location: C:\Program Files\SMF Add-In
>
>
> I tried re-starting the computer? that did not help.
>
> What should I do?
>
> Can you help, what do I do?
>

Tue Dec 18, 2012 2:57 pm (PST) . Posted by:

"rr76012" rr76012

Hi Randy,

I used the Files > Add-In Files , RCH_Stock_Market_Functions-2.1.2012.02.02.zip.

then extracted them to this directory C:\Program Files\SMF Add-In
this morning. Then later this morning I started getting error messages?

I think all my errors are just for msn??? examples:

=RCHGetElementNumber($B13,$193), error
=RCHGetElementNumber($B$13,D16), error
=RCHGetElementNumber($B$13,D19), error

Randy, do you thing I just need to replace my element definitions from the "Works in Progress folder" to fix my problem?

Thanks, I know it must not be easy helping so may people.

Randy, before I forget my manners, "Happy Holidays and Merry Christmas to you and your family".

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:

Did you get the updated element definitions from the "Works in Progress"
folder of the files area? Since you didn't mention any element numbers, I
don't know if they are applicable or not. Updates had to be done for MSN,
Morningstar, and Zacks elements this year...

On Tue, Dec 18, 2012 at 3:20 PM, rr76012 wrote:


I extracted the updated smf addin to my C:\Program Files\SMF Add-In
directory today.

NOw the rchgetelementnumber functon is now displaying "error" on all
cells, on all my spreadsheets ex: =RCHGetElementNumber($A$13,B7, now shows
"error".

IN my EXCEL 2007:

Edit links show:

1)RCH_Stock_Market_Functions.xla, Type - Worksheet, Updaate A, Status
Unknown.
2)RCH_Stock_Market_Functions.xla, Type= Remote file, Update A, Status
Unknown.

Workbook Connections
RCHGetElementNumber-Elements-Definintions

Location: C:\Program Files\SMF Add-In


I tried re-starting the computer? that did not help.

What should I do?

Can you help, what do I do?


Tue Dec 18, 2012 3:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Happy Holidays to you and yours too.

It sounds like all you need to do is update the element definition files.
All three of them have been updated since the 2012.02.02 version of the
add-in. Best done when EXCEL is not open.

On Tue, Dec 18, 2012 at 3:57 PM, rr76012 <rr76012@yahoo.com> wrote:

>
> I used the Files > Add-In Files ,
> RCH_Stock_Market_Functions-2.1.2012.02.02.zip.
>
> then extracted them to this directory C:\Program Files\SMF Add-In
> this morning. Then later this morning I started getting error messages?
>
> I think all my errors are just for msn??? examples:
>
> =RCHGetElementNumber($B13,$193), error
> =RCHGetElementNumber($B$13,D16), error
> =RCHGetElementNumber($B$13,D19), error
>
> Randy, do you thing I just need to replace my element definitions from the
> "Works in Progress folder" to fix my problem?
>
> Thanks, I know it must not be easy helping so may people.
>
> Randy, before I forget my manners, "Happy Holidays and Merry Christmas to
> you and your family".
>

Tue Dec 18, 2012 3:06 pm (PST) . Posted by:

"rr76012" rr76012

Hi Randy,

here are some more error examples

=RCHGetElementNumber($B$4,5886), error
=RCHGetElementNumber($B$4,5896), error
=RCHGetElementNumber($B$4,7686), error

--- In smf_addin@yahoogroups.com, "rr76012" wrote:

Hi Randy,

I used the Files Add-In Files , RCH_Stock_Market_Functions-2.1.2012.02.02.zip.

then extracted them to this directory C:\Program Files\SMF Add-In
this morning. Then later this morning I started getting error messages?

I think all my errors are just for msn??? examples:

=RCHGetElementNumber($B13,$193), error
=RCHGetElementNumber($B$13,D16), error
=RCHGetElementNumber($B$13,D19), error

Randy, do you thing I just need to replace my element definitions from the "Works in Progress folder" to fix my problem?

Thanks, I know it must not be easy helping so may people.

Randy, before I forget my manners, "Happy Holidays and Merry Christmas to you and your family".


--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:

Did you get the updated element definitions from the "Works in Progress"
folder of the files area? Since you didn't mention any element numbers, I
don't know if they are applicable or not. Updates had to be done for MSN,
Morningstar, and Zacks elements this year...

On Tue, Dec 18, 2012 at 3:20 PM, rr76012 wrote:


I extracted the updated smf addin to my C:\Program Files\SMF Add-In
directory today.

NOw the rchgetelementnumber functon is now displaying "error" on all
cells, on all my spreadsheets ex: =RCHGetElementNumber($A$13,B7, now shows
"error".

IN my EXCEL 2007:

Edit links show:

1)RCH_Stock_Market_Functions.xla, Type - Worksheet, Updaate A, Status
Unknown.
2)RCH_Stock_Market_Functions.xla, Type= Remote file, Update A, Status
Unknown.

Workbook Connections
RCHGetElementNumber-Elements-Definintions

Location: C:\Program Files\SMF Add-In


I tried re-starting the computer? that did not help.

What should I do?

Can you help, what do I do?

Tue Dec 18, 2012 3:18 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Those are AdvFN elements. I haven't updated any of those recently. However,
there is a change you may need to make to your Internet Options -- check
out the AdvFN entry in the LINKS area of the Yahoo group.

On Tue, Dec 18, 2012 at 4:05 PM, rr76012 <rr76012@yahoo.com> wrote:

>
> here are some more error examples
>
> =RCHGetElementNumber($B$4,5886), error
> =RCHGetElementNumber($B$4,5896), error
> =RCHGetElementNumber($B$4,7686), error
>

Tidak ada komentar:

Posting Komentar