Selasa, 25 Oktober 2011

[smf_addin] Digest Number 1996

Messages In This Digest (10 Messages)

Messages

1a.

Re: StockHouse data errors

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Mon Oct 24, 2011 7:15 am (PDT)



Keep in mind these are resistance /support pivot points and not previous price support and resistance.

You can get previous price support and resistance at this link-
http://www.stockta.com/cgi-bin/analysis.pl?symb=MMM <http://www.stockta.com/cgi-bin/analysis.pl?symb=MMM&num1=6&cobrand=&mode=stock> &num1=6&cobrand=&mode=stock

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of A B
Sent: Saturday, October 22, 2011 8:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] StockHouse data errors


Wow - Thanks so much!!!!

_____

From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, October 22, 2011 8:28 PM
Subject: Re: [smf_addin] StockHouse data errors

Try something like:

Value
Formula

81.59
=RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym=MMM",1,"2nd Level Resistance")

81.03
=RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym=MMM",1,"1st Level Resistance")

79.45
=RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym=MMM",1,"1st Level Support")

78.43
=RCHGetTableCell("http://www.barchart.com/cheatsheet.php?sym=MMM",1,"2nd Level Support")

On Sat, Oct 22, 2011 at 5:20 PM, A B <morvornagh@yahoo.com> wrote:

A question for all members. I was also using quite a few of the stockhouse indicators that are now 'moved'. I have found work arounds for most of the ones I was using except the 1 / 2 day support / resistance. Which I think are very useful. While looking for suitable alternatives I noticed that Barchart on their cheat sheet have this page http://www.barchart.com/cheatsheet.php?sym=MMM (#'s 1215 - 1284) and http://www.barchart.com/opinions/stocks/MMM (#'s 702-717) to so I am thinking this should be fairly easy for me to configure for myself (if they dont already exist).

I did try to figure it out prior to this note but could not quite get to grips with how the code worked. i.e. to configure the url get and post and then assign it to an element number (I am a coder but a VBA developer I am not).



Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1b.

Re: StockHouse data errors

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Mon Oct 24, 2011 11:46 am (PDT)



When entering  =RCHGetTableCell("http://www.stockhouse.com/financialtools/sn_technicalanalysis.aspx?qm_symbol=MMM",1,"Current Average Recommendation")
 
I get "Error". Is there something wrong in the formula, or is it that SMF cannot extract from the WEB page?

Regards,
Jose L. Jacob

________________________________
From: A B <morvornagh@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Saturday, October 22, 2011 8:20:58 PM
Subject: Re: [smf_addin] StockHouse data errors

 
Randy - First I would like to say what a great piece of development the add-in and follow up on this group is, really amazed.

Secondly - A question for all members. I was also using quite a few of the stockhouse indicators that are now 'moved'. I have found work arounds for most of the ones I was using except the 1 / 2 day support / resistance. Which I think are very useful.   While looking for suitable alternatives I noticed that Barchart on their cheat sheet have this page http://www.barchart.com/cheatsheet.php?sym=MMM. 
Does anyone know If I wanted to configure the addin to pull say the one and two day pivot prices from this page which documentation should I read?
The RCHGetelementnumber already supports the other technical pages from barchart i.e http://www.barchart.com/technicals/stocks/MMM (#'s 1215 - 1284) and http://www.barchart.com/opinions/stocks/MMM (#'s 702-717) to  so I am thinking this should be fairly easy for me to configure for myself (if they dont already exist).

I did try to figure it out prior to this note but could not quite get to grips with how the code worked. i.e. to configure the url get and post and then assign it to an element number (I am a coder but a  VBA developer I am not).

Many thanks

N

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, October 22, 2011 12:47 AM
Subject: Re: [smf_addin] StockHouse data errors

 
Looks like they dropped the data elements. What used to be a "technical analysis page" is now an "analysts' page":

http://www.stockhouse.com/financialtools/sn_technicalanalysis.aspx?qm_symbol=MMM

On Fri, Oct 21, 2011 at 8:15 PM, Bike bum <ttwilt@mchsi.com> wrote:

Greetings, is any one besides myself unable to extract data from StockHouse?  Specifically item numbers 802, 825,790 and 789.  I have been using this data for quite a while but it has began returning error messages recently.  Just wondering if it is on my end or if others are having the same problem.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1c.

Re: StockHouse data errors

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 24, 2011 1:47 pm (PDT)



The problem is that the data is not within the source code of the web page
for the URL you're using. There is a URL on the web page the data can be
retrieved from. However, one of the parameters is a "webMasterID" and I'm
not sure if that varies from user to user or day to day. Without it, I get
an authentication error.

On Mon, Oct 24, 2011 at 11:46 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> When entering =RCHGetTableCell("
> http://www.stockhouse.com/financialtools/sn_technicalanalysis.aspx?qm_symbol=MMM",1,"CurrentAverage Recommendation")
>
> I get "Error". Is there something wrong in the formula, or is it that SMF
> cannot extract from the WEB page?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2a.

Problem using the RCHGetTableCell function

Posted by: "akc1903uk" akc1903@gmail.com   akc1903uk

Mon Oct 24, 2011 8:13 am (PDT)



Hi there, I'm not sure if I'm being stupid but I'm having trouble with the above function and would welcome any help.

I'm trying to retrieve shares in issue information on German stocks for the Deutsche Boerse website. Some stocks have this information in the "Master Data" tab of their quotes page and I can get the information I need using the function call:-

=RCHGetTableCell("http://www.boerse-frankfurt.de/EN/index.aspx?pageID=39&ISIN=DE0007074007",1,"Capital Stock / Shares")

However, not all stocks have data in the master data tab but they all have the data in the "Key Figures" page so I try to use the following function to retrieve the data but it only returns "Error":-

=RCHGetTableCell("http://www.boerse-frankfurt.de/EN/index.aspx?pageID=223&ISIN=DE000BASF111",1,"Number of Shares")

Any thoughts?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2b.

Re: Problem using the RCHGetTableCell function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 24, 2011 8:38 am (PDT)



Not sure what to tell you -- both of those formulas work fine for me...

On Mon, Oct 24, 2011 at 6:21 AM, akc1903uk <akc1903@gmail.com> wrote:

> Hi there, I'm not sure if I'm being stupid but I'm having trouble with the
> above function and would welcome any help.
>
> I'm trying to retrieve shares in issue information on German stocks for the
> Deutsche Boerse website. Some stocks have this information in the "Master
> Data" tab of their quotes page and I can get the information I need using
> the function call:-
>
> =RCHGetTableCell("
> http://www.boerse-frankfurt.de/EN/index.aspx?pageID=39&ISIN=DE0007074007",1,"Capital
> Stock / Shares")
>
> However, not all stocks have data in the master data tab but they all have
> the data in the "Key Figures" page so I try to use the following function to
> retrieve the data but it only returns "Error":-
>
> =RCHGetTableCell("
> http://www.boerse-frankfurt.de/EN/index.aspx?pageID=223&ISIN=DE000BASF111",1,"Number
> of Shares")
>
> Any thoughts?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: Problem using the RCHGetTableCell function

Posted by: "akc1903uk" akc1903@gmail.com   akc1903uk

Mon Oct 24, 2011 1:58 pm (PDT)



Thanks Randy, at least that reassures me that there's nothing wrong with my method. I'm running on a 32-bit machine, is yours 64 by any chance? I wondered whether it's something odd like there a maximum data size that can be retrieved by this function which is exceeded on my machine. I can't think of other rational explanations at this stage.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what to tell you -- both of those formulas work fine for me...
>
> On Mon, Oct 24, 2011 at 6:21 AM, akc1903uk <akc1903@...> wrote:
>
> > Hi there, I'm not sure if I'm being stupid but I'm having trouble with the
> > above function and would welcome any help.
> >
> > I'm trying to retrieve shares in issue information on German stocks for the
> > Deutsche Boerse website. Some stocks have this information in the "Master
> > Data" tab of their quotes page and I can get the information I need using
> > the function call:-
> >
> > =RCHGetTableCell("
> > http://www.boerse-frankfurt.de/EN/index.aspx?pageID=39&ISIN=DE0007074007",1,"Capital
> > Stock / Shares")
> >
> > However, not all stocks have data in the master data tab but they all have
> > the data in the "Key Figures" page so I try to use the following function to
> > retrieve the data but it only returns "Error":-
> >
> > =RCHGetTableCell("
> > http://www.boerse-frankfurt.de/EN/index.aspx?pageID=223&ISIN=DE000BASF111",1,"Number
> > of Shares")
> >
> > Any thoughts?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2d.

Re: Problem using the RCHGetTableCell function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 24, 2011 2:00 pm (PDT)



Have you tried just running smfForceRecalculation? It could be you just had
a page time out or a similar issue and got a bad copy of the web page.

Are you using the beta version of the add-in from the "Works in Progress"
folder? I can't think of any changes that would have affected this, but who
knows...

On Mon, Oct 24, 2011 at 1:58 PM, akc1903uk <akc1903@gmail.com> wrote:

> Thanks Randy, at least that reassures me that there's nothing wrong with my
> method. I'm running on a 32-bit machine, is yours 64 by any chance? I
> wondered whether it's something odd like there a maximum data size that can
> be retrieved by this function which is exceeded on my machine. I can't think
> of other rational explanations at this stage.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2e.

Re: Problem using the RCHGetTableCell function

Posted by: "akc1903uk" akc1903@gmail.com   akc1903uk

Mon Oct 24, 2011 2:22 pm (PDT)



Thanks again. I'm using the version from the Add-Ins folder but can switch to the "Works in Progress" one if you recommend that?

I haven't seen any documentation on the smfForceRecalculation. Could you please fill me in on how I run that please?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you tried just running smfForceRecalculation? It could be you just had
> a page time out or a similar issue and got a bad copy of the web page.
>
> Are you using the beta version of the add-in from the "Works in Progress"
> folder? I can't think of any changes that would have affected this, but who
> knows...
>
> On Mon, Oct 24, 2011 at 1:58 PM, akc1903uk <akc1903@...> wrote:
>
> > Thanks Randy, at least that reassures me that there's nothing wrong with my
> > method. I'm running on a 32-bit machine, is yours 64 by any chance? I
> > wondered whether it's something odd like there a maximum data size that can
> > be retrieved by this function which is exceeded on my machine. I can't think
> > of other rational explanations at this stage.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2f.

Re: Problem using the RCHGetTableCell function

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Oct 24, 2011 2:34 pm (PDT)



You can check the change log in the "Works in Progress" folder to see if any
updates might be of use. There are several new utility functions for data
extraction, and a lot of element definition updates.

Check the "Links" area of the group for several links to information related
to smfForceRecalculation.

On Mon, Oct 24, 2011 at 2:22 PM, akc1903uk <akc1903@gmail.com> wrote:

> Thanks again. I'm using the version from the Add-Ins folder but can switch
> to the "Works in Progress" one if you recommend that?
>
> I haven't seen any documentation on the smfForceRecalculation. Could you
> please fill me in on how I run that please?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2g.

Re: Problem using the RCHGetTableCell function

Posted by: "akc1903uk" akc1903@gmail.com   akc1903uk

Mon Oct 24, 2011 2:40 pm (PDT)



Thanks again Randy, great work. I've just gone ahead and installed the version from "Works in Progress" anyway and the whole thing is working fine now. I'll check out the change log too but I have what I want for now

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can check the change log in the "Works in Progress" folder to see if any
> updates might be of use. There are several new utility functions for data
> extraction, and a lot of element definition updates.
>
> Check the "Links" area of the group for several links to information related
> to smfForceRecalculation.
>
> On Mon, Oct 24, 2011 at 2:22 PM, akc1903uk <akc1903@...> wrote:
>
> > Thanks again. I'm using the version from the Add-Ins folder but can switch
> > to the "Works in Progress" one if you recommend that?
> >
> > I haven't seen any documentation on the smfForceRecalculation. Could you
> > please fill me in on how I run that please?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.12

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)