15 New Messages
Digest #2468
1a
Re: RCHGetTableCell has almost completely stopped working on web sit by "twopourdrummer" twopourdrummer
Messages
Tue Jan 15, 2013 5:42 am (PST) . Posted by:
"twopourdrummer" twopourdrummer
I don't have the add in, that's why I was asking if it worked the way I had it. I'm not sure why it won't work for me. I've tried it on several computers so I know it's not the network.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The most likely reason for #NAME? is that the add-in isn't active any more.
> Go to the add-in manager and make sure it's still got a check box on it.
>
> I did use your RCHGetTableCell() function, as you had it written. I just
> did a copy and paste...
>
> On Mon, Jan 14, 2013 at 1:13 PM, twopourdrummer wrote:
>
> > I get #name when I put it in, however, I noticed you are using
> > RCHGetWebData and I use RCHGetTableCell. Did you use RCHGetTableCell when
> > you tested mine.
> >
>
--- In smf_addin@yahoogrou
>
> The most likely reason for #NAME? is that the add-in isn't active any more.
> Go to the add-in manager and make sure it's still got a check box on it.
>
> I did use your RCHGetTableCell(
> did a copy and paste...
>
> On Mon, Jan 14, 2013 at 1:13 PM, twopourdrummer wrote:
>
> > I get #name when I put it in, however, I noticed you are using
> > RCHGetWebData and I use RCHGetTableCell. Did you use RCHGetTableCell when
> > you tested mine.
> >
>
Tue Jan 15, 2013 7:12 am (PST) . Posted by:
"fythras" fythras
Hello All,
Thanks for the help the last time on the Econ Data. Still making finishing touches to it so I'll upload it when I'm finished. I think people will find it interesting.
I'm having trouble using RCHGetElementNumber(SPY,5184) to get the Average P/E from Yahoo. I'm receiving an error. I'm thinking that it could be because they've changed the url to be http://finance.yahoo.com/q/hl?s=SPY+Holdings, but I'm not sure if the "+Holdings" is already factored into the function. All other functions work so it isn't a matter of not setting up the add-in right or something.
Any help on this would be greatly appreciated.
thanks!
Justin
Thanks for the help the last time on the Econ Data. Still making finishing touches to it so I'll upload it when I'm finished. I think people will find it interesting.
I'm having trouble using RCHGetElementNumber
Any help on this would be greatly appreciated.
thanks!
Justin
Tue Jan 15, 2013 7:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The reason it's not working is that the holdings elements are defined for a
mutual fund web page. The ETF holdings page is laid out differently than a
mutual fund holdings page.
Try using VFINX instead. It's the most popular mutual fund based on the S&P
500 index.
On Tue, Jan 15, 2013 at 8:12 AM, fythras fythras@yahoo.com > wrote:
>
> I'm having trouble using RCHGetElementNumber(SPY,5184) to get the Average
> P/E from Yahoo. I'm receiving an error. I'm thinking that it could be
> because they've changed the url to be
> http://finance.yahoo.com/q/hl?s=SPY+Holdings, but I'm not sure if the
> "+Holdings" is already factored into the function. All other functions
> work so it isn't a matter of not setting up the add-in right or something.
>
mutual fund web page. The ETF holdings page is laid out differently than a
mutual fund holdings page.
Try using VFINX instead. It's the most popular mutual fund based on the S&P
500 index.
On Tue, Jan 15, 2013 at 8:12 AM, fythras fythras@yahoo.
>
> I'm having trouble using RCHGetElementNumber
> P/E from Yahoo. I'm receiving an error. I'm thinking that it could be
> because they've changed the url to be
> http://finance.
> "+Holdings&quo
> work so it isn't a matter of not setting up the add-in right or something.
>
Tue Jan 15, 2013 7:28 am (PST) . Posted by:
"fythras" fythras
Oh ok, thanks! Also is there a way to check to see if the symbol is an ETF or Mutual Fund or Company? Is see in Profile it mentions something about Legal Type: Exchange Traded Fund, but it could even be from another website or somewhere. Do you know of any site that clearly labels it?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> The reason it's not working is that the holdings elements are defined for a
> mutual fund web page. The ETF holdings page is laid out differently than a
> mutual fund holdings page.
>
> Try using VFINX instead. It's the most popular mutual fund based on the S&P
> 500 index.
>
> On Tue, Jan 15, 2013 at 8:12 AM, fythras wrote:
>
> >
> > I'm having trouble using RCHGetElementNumber(SPY,5184) to get the Average
> > P/E from Yahoo. I'm receiving an error. I'm thinking that it could be
> > because they've changed the url to be
> > http://finance.yahoo.com/q/hl?s=SPY+Holdings, but I'm not sure if the
> > "+Holdings" is already factored into the function. All other functions
> > work so it isn't a matter of not setting up the add-in right or something.
> >
>
--- In smf_addin@yahoogrou
>
> The reason it's not working is that the holdings elements are defined for a
> mutual fund web page. The ETF holdings page is laid out differently than a
> mutual fund holdings page.
>
> Try using VFINX instead. It's the most popular mutual fund based on the S&P
> 500 index.
>
> On Tue, Jan 15, 2013 at 8:12 AM, fythras wrote:
>
> >
> > I'm having trouble using RCHGetElementNumber
> > P/E from Yahoo. I'm receiving an error. I'm thinking that it could be
> > because they've changed the url to be
> > http://finance.
> > "+Holdings&quo
> > work so it isn't a matter of not setting up the add-in right or something.
> >
>
Tue Jan 15, 2013 7:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Mutual funds are easy to recognize by ticker symbol -- they are almost
always 5-character ticker symbols with an "X" as the 5th character.
That profile page on Yahoo is laid out differently for mutual funds,
exchange-traded funds, and equities, so you could do something there.
FinViz assigns an industry group of "Exchange Traded Fund", so you could
identify them there. They don't carry data on mutual funds.
On Tue, Jan 15, 2013 at 8:28 AM, fythras fythras@yahoo.com > wrote:
> Oh ok, thanks! Also is there a way to check to see if the symbol is an
> ETF or Mutual Fund or Company? Is see in Profile it mentions something
> about Legal Type: Exchange Traded Fund, but it could even be from another
> website or somewhere. Do you know of any site that clearly labels it?
>
always 5-character ticker symbols with an "X" as the 5th character.
That profile page on Yahoo is laid out differently for mutual funds,
exchange-traded funds, and equities, so you could do something there.
FinViz assigns an industry group of "Exchange Traded Fund", so you could
identify them there. They don't carry data on mutual funds.
On Tue, Jan 15, 2013 at 8:28 AM, fythras fythras@yahoo.
> Oh ok, thanks! Also is there a way to check to see if the symbol is an
> ETF or Mutual Fund or Company? Is see in Profile it mentions something
> about Legal Type: Exchange Traded Fund, but it could even be from another
> website or somewhere. Do you know of any site that clearly labels it?
>
Tue Jan 15, 2013 12:14 pm (PST) . Posted by:
"fythras" fythras
Thanks for the help. I achieved it by recognizing whether there was a Key Statistics page or Holdings page. That was good enough for me.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Mutual funds are easy to recognize by ticker symbol -- they are almost
> always 5-character ticker symbols with an "X" as the 5th character.
>
> That profile page on Yahoo is laid out differently for mutual funds,
> exchange-traded funds, and equities, so you could do something there.
>
> FinViz assigns an industry group of "Exchange Traded Fund", so you could
> identify them there. They don't carry data on mutual funds.
>
> On Tue, Jan 15, 2013 at 8:28 AM, fythras wrote:
>
> > Oh ok, thanks! Also is there a way to check to see if the symbol is an
> > ETF or Mutual Fund or Company? Is see in Profile it mentions something
> > about Legal Type: Exchange Traded Fund, but it could even be from another
> > website or somewhere. Do you know of any site that clearly labels it?
> >
>
--- In smf_addin@yahoogrou
>
> Mutual funds are easy to recognize by ticker symbol -- they are almost
> always 5-character ticker symbols with an "X" as the 5th character.
>
> That profile page on Yahoo is laid out differently for mutual funds,
> exchange-traded funds, and equities, so you could do something there.
>
> FinViz assigns an industry group of "Exchange Traded Fund", so you could
> identify them there. They don't carry data on mutual funds.
>
> On Tue, Jan 15, 2013 at 8:28 AM, fythras wrote:
>
> > Oh ok, thanks! Also is there a way to check to see if the symbol is an
> > ETF or Mutual Fund or Company? Is see in Profile it mentions something
> > about Legal Type: Exchange Traded Fund, but it could even be from another
> > website or somewhere. Do you know of any site that clearly labels it?
> >
>
Tue Jan 15, 2013 11:28 am (PST) . Posted by:
"Tran Le Hung" tranlehung2008
I have a question: what are the best websites to do research on stocks' financial conditions for the last 10 years?
Thank you.
Thank you.
Tue Jan 15, 2013 11:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The best would probably be AdvFN. Second would be MorningStar. Most others
don't have 10 years of data.
For AdvFN, I'd suggest using the RCHGetElementNumber() functions. For
Morningstar, see:
http://finance.groups.yahoo.com/group/smf_addin/message/20506
On Tue, Jan 15, 2013 at 12:18 PM, Tran Le Hung tranlehung2008@yahoo.com >wrote:
>
> I have a question: what are the best websites to do research on stocks'
> financial conditions for the last 10 years?
>
don't have 10 years of data.
For AdvFN, I'd suggest using the RCHGetElementNumber
Morningstar, see:
http://finance.
On Tue, Jan 15, 2013 at 12:18 PM, Tran Le Hung tranlehung2008@
>
> I have a question: what are the best websites to do research on stocks'
> financial conditions for the last 10 years?
>
Tue Jan 15, 2013 1:05 pm (PST) . Posted by:
"d.sweitzer22" d.sweitzer22
Is there a way to add certain SMF add-in functions (such as RCHGetYahooQuotes and RCHGetYahooHistory) into a work book so that I could use the spread sheet on other computers without having to install the add-in on each machine?
-David
-David
Tue Jan 15, 2013 1:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to copy over the necessary VBA modules into the workbook, so
that it doesn't need the external functions from the add-in. There are
examples of such workbooks here:
Files > Templates and Examples > SMFLite
..although they are based on older versions of add-in functions. But that's
the problem with not using the add-in -- modules don't get updated
automatically.
On Tue, Jan 15, 2013 at 2:05 PM, d.sweitzer22 d.sweitzer22@yahoo.com >wrote:
> Is there a way to add certain SMF add-in functions (such as
> RCHGetYahooQuotes and RCHGetYahooHistory) into a work book so that I could
> use the spread sheet on other computers without having to install the
> add-in on each machine?
>
that it doesn't need the external functions from the add-in. There are
examples of such workbooks here:
Files > Templates and Examples > SMFLite
..although they are based on older versions of add-in functions. But that's
the problem with not using the add-in -- modules don't get updated
automatically.
On Tue, Jan 15, 2013 at 2:05 PM, d.sweitzer22 d.sweitzer22@
> Is there a way to add certain SMF add-in functions (such as
> RCHGetYahooQuotes and RCHGetYahooHistory) into a work book so that I could
> use the spread sheet on other computers without having to install the
> add-in on each machine?
>
Tue Jan 15, 2013 1:51 pm (PST) . Posted by:
"Jon" jonhof10
I am trying some of the templates and it keeps filling each cell with NAME? Is there something I need to do to get it to reference the Stock?
Tue Jan 15, 2013 1:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That either means you don't have the add-in activated, or it's activated in
a different location than the one the workbook uses and links need to be
updated manually. Check out the "Location errors" item in the LINKS area of
the Yahoo group for more info.
On Tue, Jan 15, 2013 at 2:18 PM, Jon HofJ@bv.com> wrote:
> I am trying some of the templates and it keeps filling each cell with
> NAME? Is there something I need to do to get it to reference the Stock?
>
a different location than the one the workbook uses and links need to be
updated manually. Check out the "Location errors" item in the LINKS area of
the Yahoo group for more info.
On Tue, Jan 15, 2013 at 2:18 PM, Jon HofJ@bv.com> wrote:
> I am trying some of the templates and it keeps filling each cell with
> NAME? Is there something I need to do to get it to reference the Stock?
>
Tue Jan 15, 2013 4:33 pm (PST) . Posted by:
"sjagers" sjagers
Thanks for the clarification. I appreciate your help.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Since all of them do one Internet access per function invocation,
> smfPricesByDates() would be the fastest, as long as you can do multiple
> dates in one function invocation. Otherwise, RCHGetYahooHistory() would be
> about as fast, as long as you retrieved all of the history first, and then
> did a lookup on the downloaded data to pull out the data for each date (but
> that can be a hassle to do for multiple stocks).
>
> You cannot do multiple ticker symbols in a single function -- there would
> be no reason for me to write the function that way, since it would still
> require a separate Internet access for each ticker symbol.
>
> Note that if you use a volatile function like NOW() as your "DateX", it
> will cause all of the functions to become volatile as well -- meaning they
> will recalculate with any change to the workbook.
>
> If this is something you would use regularly, I would set up a trigger cell
> for calculation. Otherwise, it will calculate them all when you open the
> workbook, and then again when you change the "DateX". For example, instead
> of:
>
> =smfPricesByDates(...)
>
> ...you could do:
>
> =IF($A$1<>"Y","--",smfPricesByDates(...))
>
> That way, the smfPricesByDates() will only execute if cell A1 contains a
> string of "Y". So, set it to "N" when you save the workbook. Then, when you
> open it, it will open quickly, filled with "--" strings.
>
> On Fri, Jan 11, 2013 at 6:57 AM, sjagers wrote:
>
> > Hi Randy. Your functions are great. Thanks for making them available.
> >
> > Question for you: Do you know which stock quote retrieval function
> > (RCHGetYahooHistory, smfLastPrice, smfPricesByDates, or smfPricesBetween)
> > would be the fastest for retrieving the closing prices of multiple stock
> > symbols (let's say 150) for several dates. The dates would be the same for
> > all stock symbols, but the dates may not be consecutive.
> >
> > For example:
> > KR... 12/21/12, 12/20/12, 12/19/12, 12/14/12, 11/30/12, and 11/2/12.
> > AA... " " " " " "
> > etc. 150 symbols with same dates above.
> >
> > The date method is: Date"X", DateX - 1 day, DateX - 2 days, DateX - 7
> > days, DateX - 30 days, DateX - 60 days.
> >
> > Does each symbol require its own internet query (or lookup), or is there a
> > way to retrieve all symbols in one lookup (one array)?
> >
>
--- In smf_addin@yahoogrou
>
> Since all of them do one Internet access per function invocation,
> smfPricesByDates(
> dates in one function invocation. Otherwise, RCHGetYahooHistory(
> about as fast, as long as you retrieved all of the history first, and then
> did a lookup on the downloaded data to pull out the data for each date (but
> that can be a hassle to do for multiple stocks).
>
> You cannot do multiple ticker symbols in a single function -- there would
> be no reason for me to write the function that way, since it would still
> require a separate Internet access for each ticker symbol.
>
> Note that if you use a volatile function like NOW() as your "DateX"
> will cause all of the functions to become volatile as well -- meaning they
> will recalculate with any change to the workbook.
>
> If this is something you would use regularly, I would set up a trigger cell
> for calculation. Otherwise, it will calculate them all when you open the
> workbook, and then again when you change the "DateX"
> of:
>
> =smfPricesByDates(
>
> ...you could do:
>
> =IF($A$1<
>
> That way, the smfPricesByDates(
> string of "Y"
> open it, it will open quickly, filled with "--" strings.
>
> On Fri, Jan 11, 2013 at 6:57 AM, sjagers wrote:
>
> > Hi Randy. Your functions are great. Thanks for making them available.
> >
> > Question for you: Do you know which stock quote retrieval function
> > (RCHGetYahooHistory
> > would be the fastest for retrieving the closing prices of multiple stock
> > symbols (let's say 150) for several dates. The dates would be the same for
> > all stock symbols, but the dates may not be consecutive.
> >
> > For example:
> > KR... 12/21/12, 12/20/12, 12/19/12, 12/14/12, 11/30/12, and 11/2/12.
> > AA... " " " " " "
> > etc. 150 symbols with same dates above.
> >
> > The date method is: Date"X"
> > days, DateX - 30 days, DateX - 60 days.
> >
> > Does each symbol require its own internet query (or lookup), or is there a
> > way to retrieve all symbols in one lookup (one array)?
> >
>
Tue Jan 15, 2013 4:51 pm (PST) . Posted by:
"mff2805" mff2805
hi,
is there a way to interrogate the IBD from their screen center page? i'm a member and know all about being logged in to their site. the web page is
http://research.investors.com/screen-center/?screen=9172
but i don't know if the 9172 number is static or dynamic.
then, part 2, is there a way to get, say, the top sector performers list from
http://research.investors.com/screen-center/?screen=9171
etc, etc for their other lists.
thanks,
mike
is there a way to interrogate the IBD from their screen center page? i'm a member and know all about being logged in to their site. the web page is
http://research.
but i don't know if the 9172 number is static or dynamic.
then, part 2, is there a way to get, say, the top sector performers list from
http://research.
etc, etc for their other lists.
thanks,
mike
Tue Jan 15, 2013 5:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't see a way to get the data from the screen center. Those pages are
dynamically generated, and the Export and EXCEL output options are
incomplete when I use the links they generate.
I grab the IBD50 table from the eTables page, with something like:
=RCHGetTableCell("
http://research.investors.com/etables/IBD50XLS.aspx?tabView=IBD50&from=etables&columnsort1=ibd50rank&columnsorttype1=DESC&columnsort2=&columnsorttype2=DESC ",2," About
IBD",,"--")
...where I vary the "pCells" and "pRows" parameters as needed.
On Tue, Jan 15, 2013 at 5:51 PM, mff2805 mff3429@comcast.net > wrote:
> hi,
> is there a way to interrogate the IBD from their screen center page? i'm
> a member and know all about being logged in to their site. the web page is
> http://research.investors.com/screen-center/?screen=9172
> but i don't know if the 9172 number is static or dynamic.
>
> then, part 2, is there a way to get, say, the top sector performers list
> from
> http://research.investors.com/screen-center/?screen=9171
>
> etc, etc for their other lists.
>
dynamically generated, and the Export and EXCEL output options are
incomplete when I use the links they generate.
I grab the IBD50 table from the eTables page, with something like:
=RCHGetTableCell(
http://research.
IBD",,"
...where I vary the "pCells" and "pRows" parameters as needed.
On Tue, Jan 15, 2013 at 5:51 PM, mff2805 mff3429@comcast.
> hi,
> is there a way to interrogate the IBD from their screen center page? i'm
> a member and know all about being logged in to their site. the web page is
> http://research.
> but i don't know if the 9172 number is static or dynamic.
>
> then, part 2, is there a way to get, say, the top sector performers list
> from
> http://research.
>
> etc, etc for their other lists.
>
Tidak ada komentar:
Posting Komentar