This is working here:

=RCHGetElementNumber("MMM";,848)

On Sat, Dec 21, 2013 at 12:35 AM, <mb0329@msn.com> wrote:

>
> For all the stock tickers on my spreadsheet, I am getting an error message
> when I use:
> =rchgetelementnumber(F8,848), f8 has the stock ticker. i am not getting an
> error message when looking at other values other than the Zacks rating. It
> is currently 11:35 pm on Friday night on the West Coast.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1c

Re: why am i getting 'error' for zacks rating?

Sat Dec 21, 2013 9:37 am (PST) . Posted by:

zbgb952

I pasted your equation in an Excel spreadsheet and still get an error message. I am using Excel 2013 . It was working a few days ago so something has changed somewhere. Would it help for me to delete the smf software and reload it?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2.1 Re: Yahoo Quotes

Sat Dec 21, 2013 2:18 am (PST) . Posted by:

markclippitt

Randy,

Thanks for the pointer to the Location Errors explanation in the LINKS area !

It looked promising. But before I had a chance to apply the recommendation the problem fixed itself. Without editing any of the cells, all of them reverted to a location free reference the following day and the smf functions were back in business. It's all magic to me.
Thanks again,

Mark

Reply to sender . Reply to group . Reply via Web Post . All Messages (34) . Top ^

2.2 Re: Yahoo Quotes

Sat Dec 21, 2013 7:56 am (PST) . Posted by:

"lucas_scanlon" lucas_scanlon

How do you run the SMFForceRecalculation?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> smfForceRecalculation would update all open worksheets and workbooks. I
> usually run it whenever I close down the workbook I'm working on, so that
> everything is initialized for the next workbook I open.
>
> If you've just started EXCEL, there would be no reason to run the macro.
>
> On Sat, Jan 15, 2011 at 7:48 AM, lexstar <lexstar@...> wrote:
>
> > If I set up ONE worksheet with, say 10 symbols, and I use this function to
> > invoke the last 60-week's data for each symbol...
> >
> > What happens when 1 WEEK has gone by and I need to invoke the function to
> > get the latest data going back 60-weeks...
> >
> > Do I have to invoke for each symbol individually? Or, should I be fore to
> > use smfRecalculation?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (34) . Top ^

2.3 Re: Yahoo Quotes

Sat Dec 21, 2013 8:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

See the LINKS area of the group for more info on the macro...

On Sat, Dec 21, 2013 at 8:50 AM, lucas_scanlon <lucas_scanlon@yahoo.com> wrote:
> How do you run the SMFForceRecalculation?

Reply to sender . Reply to group . Reply via Web Post . All Messages (34) . Top ^

2.4 Re: Yahoo Quotes

Sat Dec 21, 2013 8:39 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

As always in Excel there are several ways to do something.

The SMFForceRecalculation is a subroutine in the ModUtilies module

What I did was add a button to the EXCEL quick access toolbar and assign
macro to that button. I did not know how to do this so I used the Excel help
facility, which by the way is excellent, and I searched on quick access.

I try to search for the solution before I bug Randy. I have learn a lot just
reading some of the hits even when they did not address my particular
problem.

I think this link will help:

http://www.learnexcelmacro.com/wp/2013/06/assign-shortcut-key-to-a-macro

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of lucas_scanlon
Sent: Saturday, December 21, 2013 10:51 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Quotes

How do you run the SMFForceRecalculation?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> smfForceRecalculation would update all open worksheets and workbooks.
> I usually run it whenever I close down the workbook I'm working on, so
> that everything is initialized for the next workbook I open.
>
> If you've just started EXCEL, there would be no reason to run the macro.
>
> On Sat, Jan 15, 2011 at 7:48 AM, lexstar <lexstar@...> wrote:
>
> > If I set up ONE worksheet with, say 10 symbols, and I use this
> > function to invoke the last 60-week's data for each symbol...
> >
> > What happens when 1 WEEK has gone by and I need to invoke the
> > function to get the latest data going back 60-weeks...
> >
> > Do I have to invoke for each symbol individually? Or, should I be
> > fore to use smfRecalculation?
> >
>

------------------------------------

Yahoo Groups Links

Reply to sender . Reply to group . Reply via Web Post . All Messages (34) . Top ^

2.5 Re: Yahoo Quotes

Sat Dec 21, 2013 8:54 am (PST) . Posted by:

"lucas_scanlon" lucas_scanlon

Hi Guys, I'm seeing an error not yet mentioned, so I wanted to add for triage.

I'm running a virtual machine on a mac, using Windows 8 and Excel 2013. Up until last week getYahooQuote was solid, but now I will simple get the ticket back or "obsolete";. usually not even error.

any ideas? I've removed and added the SMF add in and the files in my SMF folder a couple of times (using both the 2012 standard and the 2013 beta version in Working Files), and same experience with both.

Any ideas?

Thanks Randy - this is awesome
Luke

--- In smf_addin@yahoogroups.com, "flangeneral" <jefff@...> wrote:
>
> Thanks all for confirming that there is an issue, and not just me. A little more info, I am running Windows XP Professional (ugh) and Excel 2007. I believe it is/was a yahoo issue. Occasionally, the first cell in my array entered formula would return "Error" and the rest of the array entered cells would return blank. Having said this, today so far (knock on wood) seems to be back to normal.
>
> --- In smf_addin@yahoogroups.com, <jeff.wortman@> wrote:
> >
> > I have the same problem which started in the same timeframe. I am using Windows 7 Professional - 64 bit, and Excel 2010. Beyond my control there were new upgrades made to Excel this weekend which is when the problem go so bad that spreadsheets are unable to load approx. 150 data values from Yahoo. Also, about 10 days before that EXCEL was upgraded to Service Pack 2 - I can't say that it was slower at that point but it was not failing like it is now. Does this match with any software maintenance you have recently completed? I am think that I may try to get last weekend's changes backed out.
> > Jeff
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (34) . Top ^

3a

Re: Morningstar Template

Sat Dec 21, 2013 4:31 am (PST) . Posted by:

"Ton Sieverding" amsiev

Randy where can I find a list with all the stock tickers that are in the MorningStar database ? Downloading the data with your formula's is one thing but where can I find a list with all the stock tickers in the MorningStar database ? As far as I know the list should have about 16.500 Tickers ... I want to automate the downloadproces and get a database ( Delphi, VisualFox or VisualBasic etc. ) with all the data from MorningStar. For this reason I need a list with all the tickers that will be used in MorningStar to update the requested data every night ...

Kind regards, Ton.

----- Original Message -----
From: weekeewawa
To: smf_addin@yahoogroups.com
Sent: Sunday, April 07, 2013 12:24 PM
Subject: [smf_addin] Re: Morningstar Template

hello randy,

we have discussed it over at the other post and thanks to your great lesson, i have understood the theory behind it

here is another question.

you were mentioning that morningstar is dynamically generated for the

http://financials.morningstar.com/valuation/price-ratio.html?t=GOOG®ion=USA&culture=en-us

however, i was wondering, what do u mean by dynamically generated and the difference between similar looking table cells that i saw over at yahoo finance or msn.

could i use

=RCHGetHTMLTable("http://financials.morningstar.com/valuation/price-ratio.html?t="&A1,"®ion=USA&culture=en-us>Current Valulation",1,"",1)

would it be the right direction to extract data from it?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You have the &A1 as PART of the string. It needs to be concatenated to the
> other string.
>
> On Sun, Apr 7, 2013 at 1:27 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > i tried the formula and did some tweak which points the symbol to cell A1
> >
> > however, it returns me with a ) no matter what symbol i key into cell A1
> >
> > this is the code
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=&A1",4,">Valuation
> > Ratios","Price/Earnings")
> >
> > is there something wrong to it?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (23) . Top ^

3b

Re: Morningstar Template

Sat Dec 21, 2013 5:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Off-hand, I haven't a clue...

Sounds like you need to research data providers.

On Sat, Dec 21, 2013 at 5:31 AM, Ton Sieverding
<ton.sieverding@scarlet.be>wrote:

>
> Randy where can I find a list with all the stock tickers that are in the
> MorningStar database ? Downloading the data with your formula's is one
> thing but where can I find a list with all the stock tickers in the
> MorningStar database ? As far as I know the list should have about 16.500
> Tickers ... I want to automate the downloadproces and get a database (
> Delphi, VisualFox or VisualBasic etc. ) with all the data from MorningStar.
> For this reason I need a list with all the tickers that will be used in
> MorningStar to update the requested data every night ...
>
>