13 New Messages
Digest #2426
5b
Re: Randy, function RCHGetElementNumber(ticker,14320 ) not working by "Randy Harmelink" rharmelink
Messages
Thu Dec 6, 2012 6:22 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Zacks for fine for me but it is very slow at times. Most of the time it is
really fast but occasionally it takes several seconds for just 2 elements.
Especially, the first call.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of lawrence.leesh
Sent: Wednesday, December 05, 2012 7:56 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Zacks -- seems to have switched over to their Beta
system
Is there an update to the SMF Addin to allow downloading of 848 Zacks rank?
I don't think it is the symbol problem. They symbols that I could get for
848 are now not possible to download.
Another ticker that seems to have the same problem is 13888 analyst price
target.
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. When I try to access the web page for POOSF in FireFox, I get an
> error with the following message:
>
> *"Firefox has detected that the server is redirecting the request for
> this address in a way that will never complete."*
>
> Note the "never complete" part there -- that could be why the add-in
> is hanging. It's constantly being redirected in a way that the request
> can never get the web page.
>
> On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > After the latest element defininition update, Excel hangs trying to
> > pull the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
> >
>
------------------------------------
Yahoo! Groups Links
really fast but occasionally it takes several seconds for just 2 elements.
Especially, the first call.
-----Original Message-----
From: smf_addin@yahoogrou
Of lawrence.leesh
Sent: Wednesday, December 05, 2012 7:56 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Zacks -- seems to have switched over to their Beta
system
Is there an update to the SMF Addin to allow downloading of 848 Zacks rank?
I don't think it is the symbol problem. They symbols that I could get for
848 are now not possible to download.
Another ticker that seems to have the same problem is 13888 analyst price
target.
thanks
--- In smf_addin@yahoogrou
>
> Hmmm. When I try to access the web page for POOSF in FireFox, I get an
> error with the following message:
>
> *"Firefox has detected that the server is redirecting the request for
> this address in a way that will never complete."*
>
> Note the "never complete" part there -- that could be why the add-in
> is hanging. It's constantly being redirected in a way that the request
> can never get the web page.
>
> On Mon, Dec 3, 2012 at 8:59 PM, carmine288 <carmine.nicoletta@
>
> > After the latest element defininition update, Excel hangs trying to
> > pull the "848 - Zacks Rank" for ticker "POOSF" for me. Anyone else?
> >
>
------------
Yahoo! Groups Links
Thu Dec 6, 2012 6:26 am (PST) . Posted by:
"fredwwright" fredwwright
Randy,
Thanks a lot for so quickly updating the Zacks elements.
Could you please take a look at element 13873 (Zacks Recommendation). It is currently pulling the equivalent text for Zacks Rank (2=Buy/3=Hold etc) rather than the Zacks Recommendation (outperform/neutral/Underperfom) which is a longer term view than the Rank. I tried to look at the source code for the page and am worried that the Recommendation is somehow generated dynamically which makes it beyond my ability to figure out.
Thanks again for all your help.
Fred
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See recent messages on Zacks and a recent file upload for updates on Zacks
> element definitions.
>
> On Wed, Dec 5, 2012 at 5:56 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> > Is there an update to the SMF Addin to allow downloading of 848 Zacks
> > rank? I don't think it is the symbol problem. They symbols that I could get
> > for 848 are now not possible to download.
> >
> > Another ticker that seems to have the same problem is 13888 analyst price
> > target.
> >
>
Thanks a lot for so quickly updating the Zacks elements.
Could you please take a look at element 13873 (Zacks Recommendation)
Thanks again for all your help.
Fred
--- In smf_addin@yahoogrou
>
> See recent messages on Zacks and a recent file upload for updates on Zacks
> element definitions.
>
> On Wed, Dec 5, 2012 at 5:56 PM, lawrence.leesh <lawrence.leesh@
>
> > Is there an update to the SMF Addin to allow downloading of 848 Zacks
> > rank? I don't think it is the symbol problem. They symbols that I could get
> > for 848 are now not possible to download.
> >
> > Another ticker that seems to have the same problem is 13888 analyst price
> > target.
> >
>
Thu Dec 6, 2012 6:56 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, I can no longer define any element definitions based on
Zacks premium elements, as I no longer have a premium subscription. Is the
recommendation available on some other web page of theirs that is free? I
did find most of the others on one page or another.
On Thu, Dec 6, 2012 at 7:26 AM, fredwwright <fredwwright@yahoo.com > wrote:
>
> Could you please take a look at element 13873 (Zacks Recommendation). It
> is currently pulling the equivalent text for Zacks Rank (2=Buy/3=Hold etc)
> rather than the Zacks Recommendation (outperform/neutral/Underperfom) which
> is a longer term view than the Rank. I tried to look at the source code
> for the page and am worried that the Recommendation is somehow generated
> dynamically which makes it beyond my ability to figure out.
>
Zacks premium elements, as I no longer have a premium subscription. Is the
recommendation available on some other web page of theirs that is free? I
did find most of the others on one page or another.
On Thu, Dec 6, 2012 at 7:26 AM, fredwwright <fredwwright@
>
> Could you please take a look at element 13873 (Zacks Recommendation)
> is currently pulling the equivalent text for Zacks Rank (2=Buy/3=Hold etc)
> rather than the Zacks Recommendation (outperform/
> is a longer term view than the Rank. I tried to look at the source code
> for the page and am worried that the Recommendation is somehow generated
> dynamically which makes it beyond my ability to figure out.
>
Thu Dec 6, 2012 10:53 am (PST) . Posted by:
"eric_siegel@rocketmail.com" eric_siegel@rocketmail.com
how do i look up daily trading volumes, Or average monthly trading volumes for a given stock?
Thu Dec 6, 2012 10:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the documentation for the RCHGetYahooQuotes() function. It has
data codes for the daily volume and the 3-month average volume.
Or, check out FinViz (see items on it in the LINKS area), which has daily
volume, average daily volume, and relative volume, all available on their
free screening page.
On Thu, Dec 6, 2012 at 11:32 AM, eric_siegel@rocketmail.com <
eric_siegel@rocketmail.com > wrote:
> how do i look up daily trading volumes, Or average monthly trading volumes
> for a given stock?
>
data codes for the daily volume and the 3-month average volume.
Or, check out FinViz (see items on it in the LINKS area), which has daily
volume, average daily volume, and relative volume, all available on their
free screening page.
On Thu, Dec 6, 2012 at 11:32 AM, eric_siegel@
eric_siegel@
> how do i look up daily trading volumes, Or average monthly trading volumes
> for a given stock?
>
Thu Dec 6, 2012 3:58 pm (PST) . Posted by:
"eric_siegel@rocketmail.com" eric_siegel@rocketmail.com
Thank you Randy. I'm looking for daily volume for each day over the past three years. Is that doable?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Check out the documentation for the RCHGetYahooQuotes() function. It has
> data codes for the daily volume and the 3-month average volume.
>
> Or, check out FinViz (see items on it in the LINKS area), which has daily
> volume, average daily volume, and relative volume, all available on their
> free screening page.
>
> On Thu, Dec 6, 2012 at 11:32 AM, eric_siegel@... <
> eric_siegel@...> wrote:
>
> > how do i look up daily trading volumes, Or average monthly trading volumes
> > for a given stock?
> >
>
--- In smf_addin@yahoogrou
>
> Check out the documentation for the RCHGetYahooQuotes(
> data codes for the daily volume and the 3-month average volume.
>
> Or, check out FinViz (see items on it in the LINKS area), which has daily
> volume, average daily volume, and relative volume, all available on their
> free screening page.
>
> On Thu, Dec 6, 2012 at 11:32 AM, eric_siegel@
> eric_siegel@
>
> > how do i look up daily trading volumes, Or average monthly trading volumes
> > for a given stock?
> >
>
Thu Dec 6, 2012 4:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the RCHGetYahooQuotes() function.
On Thu, Dec 6, 2012 at 4:58 PM, eric_siegel@rocketmail.com <
eric_siegel@rocketmail.com > wrote:
> I'm looking for daily volume for each day over the past three years. Is
> that doable?
>
On Thu, Dec 6, 2012 at 4:58 PM, eric_siegel@
eric_siegel@
> I'm looking for daily volume for each day over the past three years. Is
> that doable?
>
Thu Dec 6, 2012 4:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Oops...I meant RCHGetYahooHistory()....
On Thu, Dec 6, 2012 at 5:24 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> Take a look at the RCHGetYahooQuotes() function.
>
> On Thu, Dec 6, 2012 at 4:58 PM, eric_siegel@rocketmail.com <
> eric_siegel@rocketmail.com > wrote:
>
>> I'm looking for daily volume for each day over the past three years. Is
>> that doable?
>>
>
>
On Thu, Dec 6, 2012 at 5:24 PM, Randy Harmelink <rharmelink@gmail.
> Take a look at the RCHGetYahooQuotes(
>
> On Thu, Dec 6, 2012 at 4:58 PM, eric_siegel@
> eric_siegel@
>
>> I'm looking for daily volume for each day over the past three years. Is
>> that doable?
>>
>
>
Thu Dec 6, 2012 11:14 am (PST) . Posted by:
"sudhir agarwal" sudhir_agarwal1
Hi,
I am looking for a template to download Options for Multiple Stocks.
Was wondering if someone has a sheet to download Options Premium price for
multiple stocks..
Thanks,
Sudhir
I am looking for a template to download Options for Multiple Stocks.
Was wondering if someone has a sheet to download Options Premium price for
multiple stocks..
Thanks,
Sudhir
Thu Dec 6, 2012 1:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I think there are way too many permutations of strike prices, expiration
dates, puts vs calls, and uses of options, for a single template to be
useful for anything other than a specific purpose, much less doing one for
multiple stocks. Designing a template for multiple stocks where one stock
might have 2 strike prices and other dozens can leave a lot of open space
on a worksheet. Plus, the more web pages you access to get data, the slower
the template would be to calculate.
In any case, take a look at item 2.2 in the LINKS area of the group. It
discusses how to use some of the basic option functions to "roll your own".
They should be able to get you to something you can use.
On Thu, Dec 6, 2012 at 12:14 PM, sudhir agarwal <Agarwal.sudhir@gmail.com >wrote:
> I am looking for a template to download Options for Multiple Stocks.
> Was wondering if someone has a sheet to download Options Premium price for
> multiple stocks..
>
>
dates, puts vs calls, and uses of options, for a single template to be
useful for anything other than a specific purpose, much less doing one for
multiple stocks. Designing a template for multiple stocks where one stock
might have 2 strike prices and other dozens can leave a lot of open space
on a worksheet. Plus, the more web pages you access to get data, the slower
the template would be to calculate.
In any case, take a look at item 2.2 in the LINKS area of the group. It
discusses how to use some of the basic option functions to "roll your own".
They should be able to get you to something you can use.
On Thu, Dec 6, 2012 at 12:14 PM, sudhir agarwal <Agarwal.sudhir@
> I am looking for a template to download Options for Multiple Stocks.
> Was wondering if someone has a sheet to download Options Premium price for
> multiple stocks..
>
>
Thu Dec 6, 2012 8:07 pm (PST) . Posted by:
"T" thomas777crown
Thanks, I have everything I need now.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's a normal EXCEL operation -- concatenation. For example:
>
> =A1&"string1"
> ="string1"&A1
> ="string1"&A1&"string2"
>
> On Wed, Dec 5, 2012 at 11:38 PM, T <thomas777crown@...> wrote:
>
> > Thanks, just one more question how do I get it too look at a cell instead.
> > Instead of just writing in the ticker I do I get it to look at a certain
> > cell where the ticker will be.
> >
> > =RCHGetTableCell("http://www.barchart.com/quotes/stocks/ ",1,">Stock
> > > Price Quote",">High")
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Close isn't in a table, but the others are. For example:
> > >
> > > =0+smfGetTagContent("http://www.barchart.com/quotes/stocks/AAPL
> > > ","span",-1,"id=""dtaLast""")
> > > =RCHGetTableCell("http://www.barchart.com/quotes/stocks/AAPL ",1,">Stock
> > > Price Quote",">High")
> >
>
--- In smf_addin@yahoogrou
>
> That's a normal EXCEL operation -- concatenation. For example:
>
> =A1&"string1"
> ="string1"&A1
> ="string1"&A1&
>
> On Wed, Dec 5, 2012 at 11:38 PM, T <thomas777crown@
>
> > Thanks, just one more question how do I get it too look at a cell instead.
> > Instead of just writing in the ticker I do I get it to look at a certain
> > cell where the ticker will be.
> >
> > =RCHGetTableCell(
> > > Price Quote",">High"
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Close isn't in a table, but the others are. For example:
> > >
> > > =0+smfGetTagContent
> > > ","span",-1,
> > > =RCHGetTableCell(
> > > Price Quote",">High"
> >
>
Thu Dec 6, 2012 11:10 pm (PST) . Posted by:
"zbgb952" zbgb952
Randy, I am finding several are returning me an 'error' message in all cases. This one is supposed to return eps 3 yr growth. Any idea why?
Thu Dec 6, 2012 11:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The M* web page it came from no longer exists. They've added it to a
dynamically generated web page, which means there is no data in the source
code of that web page to extract.
I've been suggesting people use this on a separate worksheet, and grab the
data from it:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
On Fri, Dec 7, 2012 at 12:10 AM, zbgb952 <mb0329@msn.com> wrote:
> Randy, I am finding several are returning me an 'error' message in all
> cases. This one is supposed to return eps 3 yr growth. Any idea why?
>
dynamically generated web page, which means there is no data in the source
code of that web page to extract.
I've been suggesting people use this on a separate worksheet, and grab the
data from it:
=smfGetCSVFile(
http://financials.
On Fri, Dec 7, 2012 at 12:10 AM, zbgb952 <mb0329@msn.com> wrote:
> Randy, I am finding several are returning me an 'error' message in all
> cases. This one is supposed to return eps 3 yr growth. Any idea why?
>
Tidak ada komentar:
Posting Komentar