10 New Messages
Digest #2451
Messages
Sat Dec 29, 2012 11:03 am (PST) . Posted by:
"rjemery7" rjemery7
Randy,
Some of the RCHGetElementNumber calls do work, others do not, typically the ones added most recently. The ones that do not work return "Error".
I am using the latest SMF addin exclusively. Within Excel, the file RCH_Stock_Market_Functions.xla has a create date of 2/15/2012.
My master spreadsheet consists of about 600 rows, one symbol per row, and about 30 columns. I have exactly 1463 RCHGetElementNumber calls, mostly to report Beta and Dividend Growth Rates one by one, items I cannot obtain by any other method known to me. I'm not aware of a method to put these individual calls into a range array, which I would do if I could.
The problem may not be the SMF addin, but a limitation by Excel 2007 on the number of function calls. It is something I am investigating.
Are you aware of any Excel limitation on the number of SMF function calls one could have associated with any one sheet or book, regardless if some are range arrays or not?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Offhand, I'm at a loss. But you haven't explained what "not working" means?
>
> Is it possible the "master spreadsheet" is pointing to an older version of
> the add-in -- do you have two different copies installed? That element
> number uses a new method of element definition.
>
> On Fri, Dec 28, 2012 at 1:35 PM, rjemery7 <rjemery@...> wrote:
>
> > I have a master spreadsheet in which the function
> > "=RCHGetElementNumber("T", 13863)", meant to retrieve Company Name, is not
> > working. That same command put into a fresh workbook works just fine.
> >
> > What could be the cause of this problem? How might I track down the
> > cause? What suggestions do you have for overcoming the problem?
> >
>
Some of the RCHGetElementNumber calls do work, others do not, typically the ones added most recently. The ones that do not work return "Error".
I am using the latest SMF addin exclusively. Within Excel, the file RCH_Stock_Market_
My master spreadsheet consists of about 600 rows, one symbol per row, and about 30 columns. I have exactly 1463 RCHGetElementNumber calls, mostly to report Beta and Dividend Growth Rates one by one, items I cannot obtain by any other method known to me. I'm not aware of a method to put these individual calls into a range array, which I would do if I could.
The problem may not be the SMF addin, but a limitation by Excel 2007 on the number of function calls. It is something I am investigating.
Are you aware of any Excel limitation on the number of SMF function calls one could have associated with any one sheet or book, regardless if some are range arrays or not?
--- In smf_addin@yahoogrou
>
> Offhand, I'm at a loss. But you haven't explained what "not working" means?
>
> Is it possible the "master spreadsheet" is pointing to an older version of
> the add-in -- do you have two different copies installed? That element
> number uses a new method of element definition.
>
> On Fri, Dec 28, 2012 at 1:35 PM, rjemery7 <rjemery@...
>
> > I have a master spreadsheet in which the function
> > "=RCHGetElementNumb
> > working. That same command put into a fresh workbook works just fine.
> >
> > What could be the cause of this problem? How might I track down the
> > cause? What suggestions do you have for overcoming the problem?
> >
>
Sat Dec 29, 2012 11:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There is a limitation by the add-in of only being able to access 1000 web
pages in a "session" -- but that should give you an expanded message, more
than just "Error".
Have you looked at the smfUpdateDownloadTable process? That places values
into cells, instead of using formulas that recalculate. Then, YOU are in
control of when things update. And you can update piecemeal, since it
updates row by row until it finds a blank cell for the ticker symbol. You
can even add a time stamp so you know when each row was last updated. That
can be handy to sort things, so the oldest items can then be updated.
By the way, you can get Beta on multiple tickers from FinViz. But I'm not
sure if that Beta is based on the definition you want...
I'd suggest going to the LINKS area of the group and check out the items on
smfUpdateDownloadTable, smfForceRecalculation, and FinViz. I think all
three could help with your process.
On Sat, Dec 29, 2012 at 12:03 PM, rjemery7 <rjemery@gmail.com > wrote:
>
> Some of the RCHGetElementNumber calls do work, others do not, typically
> the ones added most recently. The ones that do not work return "Error".
>
> I am using the latest SMF addin exclusively. Within Excel, the file
> RCH_Stock_Market_Functions.xla has a create date of 2/15/2012.
>
> My master spreadsheet consists of about 600 rows, one symbol per row, and
> about 30 columns. I have exactly 1463 RCHGetElementNumber calls, mostly to
> report Beta and Dividend Growth Rates one by one, items I cannot obtain by
> any other method known to me. I'm not aware of a method to put these
> individual calls into a range array, which I would do if I could.
>
> The problem may not be the SMF addin, but a limitation by Excel 2007 on
> the number of function calls. It is something I am investigating.
>
> Are you aware of any Excel limitation on the number of SMF function calls
> one could have associated with any one sheet or book, regardless if some
> are range arrays or not?
>
pages in a "session" -- but that should give you an expanded message, more
than just "Error".
Have you looked at the smfUpdateDownloadTa
into cells, instead of using formulas that recalculate. Then, YOU are in
control of when things update. And you can update piecemeal, since it
updates row by row until it finds a blank cell for the ticker symbol. You
can even add a time stamp so you know when each row was last updated. That
can be handy to sort things, so the oldest items can then be updated.
By the way, you can get Beta on multiple tickers from FinViz. But I'm not
sure if that Beta is based on the definition you want...
I'd suggest going to the LINKS area of the group and check out the items on
smfUpdateDownloadTa
three could help with your process.
On Sat, Dec 29, 2012 at 12:03 PM, rjemery7 <rjemery@gmail.
>
> Some of the RCHGetElementNumber calls do work, others do not, typically
> the ones added most recently. The ones that do not work return "Error".
>
> I am using the latest SMF addin exclusively. Within Excel, the file
> RCH_Stock_Market_
>
> My master spreadsheet consists of about 600 rows, one symbol per row, and
> about 30 columns. I have exactly 1463 RCHGetElementNumber calls, mostly to
> report Beta and Dividend Growth Rates one by one, items I cannot obtain by
> any other method known to me. I'm not aware of a method to put these
> individual calls into a range array, which I would do if I could.
>
> The problem may not be the SMF addin, but a limitation by Excel 2007 on
> the number of function calls. It is something I am investigating.
>
> Are you aware of any Excel limitation on the number of SMF function calls
> one could have associated with any one sheet or book, regardless if some
> are range arrays or not?
>
Sat Dec 29, 2012 8:29 pm (PST) . Posted by:
"Pete A" option2z
Don't have time to look, but "=RCHGetElementNumber("T", 13863)" retrieves a longer version of the name; I use "=RCHGetElementNumber("T", 13862)." For ABT you get:
Abbott Laboratories (13862)
Abbott Laboratories Common Stoc (13963)
And sometimes one or the other doesn't have anything in it...
Pete A
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Offhand, I'm at a loss. But you haven't explained what "not working" means?
>
> Is it possible the "master spreadsheet" is pointing to an older version of
> the add-in -- do you have two different copies installed? That element
> number uses a new method of element definition.
>
> On Fri, Dec 28, 2012 at 1:35 PM, rjemery7 <rjemery@...> wrote:
>
> > I have a master spreadsheet in which the function
> > "=RCHGetElementNumber("T", 13863)", meant to retrieve Company Name, is not
> > working. That same command put into a fresh workbook works just fine.
> >
> > What could be the cause of this problem? How might I track down the
> > cause? What suggestions do you have for overcoming the problem?
> >
>
Abbott Laboratories (13862)
Abbott Laboratories Common Stoc (13963)
And sometimes one or the other doesn't have anything in it...
Pete A
--- In smf_addin@yahoogrou
>
> Offhand, I'm at a loss. But you haven't explained what "not working" means?
>
> Is it possible the "master spreadsheet" is pointing to an older version of
> the add-in -- do you have two different copies installed? That element
> number uses a new method of element definition.
>
> On Fri, Dec 28, 2012 at 1:35 PM, rjemery7 <rjemery@...
>
> > I have a master spreadsheet in which the function
> > "=RCHGetElementNumb
> > working. That same command put into a fresh workbook works just fine.
> >
> > What could be the cause of this problem? How might I track down the
> > cause? What suggestions do you have for overcoming the problem?
> >
>
Sat Dec 29, 2012 2:57 pm (PST) . Posted by:
"smf_addin@yahoogroups.com"
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Documentation/
Uploaded by : rharmelink <rharmelink@gmail.
Description :
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Sat Dec 29, 2012 2:59 pm (PST) . Posted by:
"smf_addin@yahoogroups.com"
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Add-In Files/RCH_Stock_
Uploaded by : rharmelink <rharmelink@gmail.
Description : Compressed file containing the add-in and its supplementary files. You would extract all of the files into the "C:\Program Files\SMF Add-in" file folder on your computer. This is version 2.1 as of 2012-12-29.
You can access this file at the URL:
http://groups.
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Sat Dec 29, 2012 3:02 pm (PST) . Posted by:
"Randy H" rharmelink
I just uploaded a new official version of the add-in ZIP archive. It
contains all the latest element definitions, as well as several new
functions and fixed functions.
Changes made to the add-in since the 2012-02-02 release:
Date Routine Description 2012-02-04
RCHGetElementNumber
smfGetAdvFNElement Allow external text file to override the default
of "www" as the prefix for the AdvFN domain. 2012-02-12
RCHGetElementNumber Obsoleted a number of Morningstar element
definitions in file smf-elements-4.txt because the web pages they were
on are now dynamically generated:
-- Elements #14058-14211
-- Elements #13935-13950 2012-02-17 smfGetOptionQuotes
smfGetMSNOptionQuote Changed the URL of the MSN options page
2012-04-07 smfConvertData Add conversion of amount fields with "
Bill" and " Mill" suffixes. 2012-04-27 RCHGetElementNumber
Redefined a large number element definitions in file smf-elements-1.txt
because of URL and web page layout changes made by MSN. 2012-05-13
RCHGetElementNumber Change placement of smfConvertYahooTicker() for
EVALUATE() functions. 2012-05-13 smfConvertYahooTicker Add
".V" translations for Vancouver Stock Exchange 2012-06-11
RCHGetYahooQuotes Ignore the server ID parameter, since Yahoo no
longer supports 2012-07-06 RCHGetYahooHistory Allow
returned dividend data to be resorted 2012-07-06
RCHGetYahooHistory Ignore data of first date when date repeats
2012-07-09 RCHGetYahooHistory Fix ignore data of first date when
date repeats 2012-07-12 smfStrExtr Add tilda character to
represent start/end of input string 2012-07-13
smfConvertYahooTicker Add "-" conversion to "." for Canadian ticker
symbols going from Yahoo to MSN 2012-07-14
smfUpdateDownloadTable Fix element number processing for
formula-based element definitions 2012-12-02
RCHGetElementNumber Redefined all Zacks element definitions in file
smf-elements-6.txt because of URL and web page layout changes
2012-12-07 RCHGetElementNumber Redefined Morningstar element
definitions for elements #877 thru #883 in file smf-elements-4.txt
because of URL changes 2012-12-11 smfYahooAPIData Created
this new function to retrieve data from Yahoo API feeds
contains all the latest element definitions, as well as several new
functions and fixed functions.
Changes made to the add-in since the 2012-02-02 release:
Date Routine Description 2012-02-04
RCHGetElementNumber
smfGetAdvFNElement Allow external text file to override the default
of "www" as the prefix for the AdvFN domain. 2012-02-12
RCHGetElementNumber Obsoleted a number of Morningstar element
definitions in file smf-elements-
on are now dynamically generated:
-- Elements #14058-14211
-- Elements #13935-13950 2012-02-17 smfGetOptionQuotes
smfGetMSNOptionQuot
2012-04-07 smfConvertData Add conversion of amount fields with "
Bill" and " Mill" suffixes. 2012-04-27 RCHGetElementNumber
Redefined a large number element definitions in file smf-elements-
because of URL and web page layout changes made by MSN. 2012-05-13
RCHGetElementNumber Change placement of smfConvertYahooTick
EVALUATE() functions. 2012-05-13 smfConvertYahooTick
".V" translations for Vancouver Stock Exchange 2012-06-11
RCHGetYahooQuotes Ignore the server ID parameter, since Yahoo no
longer supports 2012-07-06 RCHGetYahooHistory Allow
returned dividend data to be resorted 2012-07-06
RCHGetYahooHistory Ignore data of first date when date repeats
2012-07-09 RCHGetYahooHistory Fix ignore data of first date when
date repeats 2012-07-12 smfStrExtr Add tilda character to
represent start/end of input string 2012-07-13
smfConvertYahooTick
symbols going from Yahoo to MSN 2012-07-14
smfUpdateDownloadTa
formula-based element definitions 2012-12-02
RCHGetElementNumber Redefined all Zacks element definitions in file
smf-elements-
2012-12-07 RCHGetElementNumber Redefined Morningstar element
definitions for elements #877 thru #883 in file smf-elements-
because of URL changes 2012-12-11 smfYahooAPIData Created
this new function to retrieve data from Yahoo API feeds
Sat Dec 29, 2012 5:58 pm (PST) . Posted by:
"bizmark_ee" bizmark_ee
I can't seem to get any tickers to load (even one) with the formula below. Anyone know if format changed? Thanks.
--- In smf_addin@yahoogroups.com , "yakahookey" <brian.laws@...> wrote:
>
> I am using VALUE(smfGetTagContent("http://caps.fool.com/Ticker/ "&$B1&".aspx","span",1,">All Players<"))
>
> I have a list of 100 stocks. What I have found is the ticker symbol is not the issue. For some reason it allows a limited number to download and the rest just give #VALUE!.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > WFM works fine for me, except that you have the old formula for the Caps
> > Rating -- see:
> >
> > http://finance.groups.yahoo.com/group/smf_addin/message/12856
> >
> > If you have some ticker symbols not working, you might want to check for
> > trailing blanks.
> >
> > On Thu, Apr 5, 2012 at 1:23 PM, yakahookey <brian.laws@> wrote:
> >
> > > This works great for some ticker symbols and not at all for others. I
> > > cannot get WFM to work. Any suggestions?
> > >
> >
>
--- In smf_addin@yahoogrou
>
> I am using VALUE(smfGetTagCont
>
> I have a list of 100 stocks. What I have found is the ticker symbol is not the issue. For some reason it allows a limited number to download and the rest just give #VALUE!.
>
> --- In smf_addin@yahoogrou
> >
> > WFM works fine for me, except that you have the old formula for the Caps
> > Rating -- see:
> >
> > http://finance.
> >
> > If you have some ticker symbols not working, you might want to check for
> > trailing blanks.
> >
> > On Thu, Apr 5, 2012 at 1:23 PM, yakahookey <brian.laws@
> >
> > > This works great for some ticker symbols and not at all for others. I
> > > cannot get WFM to work. Any suggestions?
> > >
> >
>
Sat Dec 29, 2012 8:04 pm (PST) . Posted by:
"Randy H" rharmelink
It looks like TMF has done something to the web page -- the add-in can't even retrieve the source code of the web page any longer.
--- In smf_addin@yahoogrou
>
> I can't seem to get any tickers to load (even one) with the
> formula below. Anyone know if format changed? Thanks.
Sun Dec 30, 2012 1:40 am (PST) . Posted by:
"oryxius" oryxius
Anyone knows which site is the faster in updating its multiples ratios like P/E, P/S, etc.?
Sun Dec 30, 2012 2:31 am (PST) . Posted by:
"jcarlosd" jcarlosd
Hello, Randy
I don't find anyway to get data from https://fundlab.credit-suisse.com/index.cfm?nav=list (it doesn't matter what country is selected in the disclaimer page).
It seems stupid, because I see in the page and in the source code the table I want below the text "Show performance figures". But when I use a standard procedure:
myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
There is no content there! I check in the macro code, and at
iSel1 = InStr(sdata2, UCase(pFind1))
The result is equal to 0, so it doesn't find those words in the page source code. It seems that the content of "sdata2" variable is different from the actual page. It is strange to me.
What other procedure do you recommend me to use instead of RCHGetHTMLTable?
J. Carlos
I don't find anyway to get data from https://fundlab.
It seems stupid, because I see in the page and in the source code the table I want below the text "Show performance figures". But when I use a standard procedure:
myURL = "https://fundlab.
myData = RCHGetHTMLTable(
There is no content there! I check in the macro code, and at
iSel1 = InStr(sdata2, UCase(pFind1)
The result is equal to 0, so it doesn't find those words in the page source code. It seems that the content of "sdata2" variable is different from the actual page. It is strange to me.
What other procedure do you recommend me to use instead of RCHGetHTMLTable?
J. Carlos
Tidak ada komentar:
Posting Komentar