[smf_addin] Digest Number 1952

EXCEL Stock Market Functions Add-in

Messages In This Digest (17 Messages)

1a.

try to understand From: paulino

1b.

Re: try to understand From: Randy Harmelink

1c.

Re: try to understand From: d_k@picknowl.com.au

2a.

Re: Is SMF using IE proxy? From: Ron Spruell

3.1.

Re: RCHGetElementNumber From: jmilum

3.2.

Re: RCHGetElementNumber From: Randy Harmelink

3.3.

Re: RCHGetElementNumber From: jmilum

3.4.

Re: RCHGetElementNumber From: investor952

3.5.

Re: RCHGetElementNumber From: Randy Harmelink

4a.

Re: MSN Money 5 yr growth rate From: MikeM

4b.

Re: MSN Money 5 yr growth rate From: Randy Harmelink

4c.

Re: MSN Money 5 yr growth rate From: Scott Jackson

4d.

Re: MSN Money 5 yr growth rate From: MikeM

5a.

confused From: paulino

5b.

Re: confused From: Randy Harmelink

6a.

"Error" With RCHGetElementNumber from Google Site From: Cornelius

6b.

Re: "Error" With RCHGetElementNumber from Google Site From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

try to understand

Posted by: "paulino" pchuitcheu@yahoo.fr   pchuitcheu

Sun Sep 11, 2011 8:21 am (PDT)

Hi Guys

As an analyst i am looking to be familiarised with the smf add-in. i installed it but curious on how i will get data from the internet.
Anyone please to provide the analytical process?

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

1b.

Re: try to understand

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

Sun Sep 11, 2011 8:23 am (PDT)

You'll have to be more specific. There are literally thousands of ways you
could do analysis on the data you retrieve...

As far as actually getting data, read through the documentation. All have
examples of their use.

On Sun, Sep 11, 2011 at 7:49 AM, paulino <pchuitcheu@yahoo.fr> wrote:

>
> As an analyst i am looking to be familiarised with the smf add-in. i
> installed it but curious on how i will get data from the internet.
> Anyone please to provide the analytical process?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

1c.

Re: try to understand

Posted by: "d_k@picknowl.com.au" d_k@picknowl.com.au   es00749

Sun Sep 11, 2011 4:54 pm (PDT)

rtfm ?

On Mon, Sep 12th, 2011 at 12:49 AM, paulino <pchuitcheu@yahoo.fr> wrote:

> Hi Guys
>
> As an analyst i am looking to be familiarised with the smf add-in. i
> installed it but curious on how i will get data from the internet.
> Anyone please to provide the analytical process?
>
> Thanks
>
>
>
>

David

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.

Re: Is SMF using IE proxy?

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Sun Sep 11, 2011 9:23 am (PDT)

I use a proxy with IE.  I have not had a problem.  XP SP3, Excel 2003

Excel uses the same connections and routing as IE.

Ron

>________________________________
>From: gz_cp <gz_cp@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Saturday, September 10, 2011 3:07 PM
>Subject: [smf_addin] Re: Is SMF using IE proxy?
>
>
> 
>Yes I meant the proxy set in IE.
>Thanks.
>
>--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>>
>> I don't know anything about IE proxy. Never heard the term before.
>>
>> The add-in uses the same Microsoft engine that IE uses (XMLHTTP), so it does
>> share the IE cookies and Temporary Internet Files and their settings.
>>
>> On Sat, Sep 10, 2011 at 12:10 PM, gz_cp <gz_cp@...> wrote:
>>
>> >
>> > How to avoid it?
>> > If I have IE proxy setup, how to let SMF use direct connection?
>> >
>>
>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3.1.

Re: RCHGetElementNumber

Posted by: "jmilum" jeff.milum@gmail.com   jmilum

Sun Sep 11, 2011 9:29 am (PDT)

I'm no expert at RCH* but am also having troubles with MSN data. I am currently getting errors for all values with numerous tickers.

The MSN website appears to be fine, when I cut and paste the URL from the smf*.txt file for MSN data using IBM (http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM) the webpage appears to be returning valid data.

However, the spreadsheet function only returns "error" when the function is entered as '=RCHGetElementNumber("IBM",1)'. I do not

If anyone has any suggestions, please help!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The MSN website is *NOT* working.
>
> http://moneycentral.msn.com/investor/research/sreport.asp?symbol=MMM&QD=1&OP=1&Y1=1&CR=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity
>
> ...gives me "Ticker not found". The add-in gets the data from the "Print
> Report" page.
>
> On Sat, Sep 10, 2011 at 1:30 PM, investor952 <investor952@...> wrote:
>
> > I just got the same problem. When I go to the MSN Stock Scouter
> > website..that seems to be working, however, I get the same error as you
> > describe below when using the Excel formula.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)

3.2.

Re: RCHGetElementNumber

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

Sun Sep 11, 2011 9:37 am (PDT)

I just tried:

=RCHGetElementNumber("IBM",1)

...and it worked fine for me. If you tried it when MSN was not working
properly and giving "Error", you may still have that copy of the web page
saved. You'll continue to get "Error" until you get a fresh copy of the web
page by either exiting and restarting EXCEL or running the
smfForceRecalculation macro to purge the saved web pages.

On Sun, Sep 11, 2011 at 9:03 AM, jmilum <jeff.milum@gmail.com> wrote:

> I'm no expert at RCH* but am also having troubles with MSN data. I am
> currently getting errors for all values with numerous tickers.
>
> The MSN website appears to be fine, when I cut and paste the URL from the
> smf*.txt file for MSN data using IBM (
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM)
> the webpage appears to be returning valid data.
>
> However, the spreadsheet function only returns "error" when the function is
> entered as '=RCHGetElementNumber("IBM",1)'. I do not
>
> If anyone has any suggestions, please help!
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)

3.3.

Re: RCHGetElementNumber

Posted by: "jmilum" jeff.milum@gmail.com   jmilum

Sun Sep 11, 2011 10:41 am (PDT)

The age old solution of rebooting (or in this case closing and reopening) Excel solved the issue. Odd, but thank you!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried:
>
> =RCHGetElementNumber("IBM",1)
>
> ...and it worked fine for me. If you tried it when MSN was not working
> properly and giving "Error", you may still have that copy of the web page
> saved. You'll continue to get "Error" until you get a fresh copy of the web
> page by either exiting and restarting EXCEL or running the
> smfForceRecalculation macro to purge the saved web pages.
>
> On Sun, Sep 11, 2011 at 9:03 AM, jmilum <jeff.milum@...> wrote:
>
> > I'm no expert at RCH* but am also having troubles with MSN data. I am
> > currently getting errors for all values with numerous tickers.
> >
> > The MSN website appears to be fine, when I cut and paste the URL from the
> > smf*.txt file for MSN data using IBM (
> > http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM)
> > the webpage appears to be returning valid data.
> >
> > However, the spreadsheet function only returns "error" when the function is
> > entered as '=RCHGetElementNumber("IBM",1)'. I do not
> >
> > If anyone has any suggestions, please help!
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)

3.4.

Re: RCHGetElementNumber

Posted by: "investor952" investor952@yahoo.com   investor952

Sun Sep 11, 2011 1:25 pm (PDT)

"(http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM)"

WOW!! Randy, did you create this somehow? It shows LOTS of info and I can get it for other companies just by changing the ticker symbol at the end. This link gets it ALL on one page? Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried:
>
> =RCHGetElementNumber("IBM",1)
>
> ...and it worked fine for me. If you tried it when MSN was not working
> properly and giving "Error", you may still have that copy of the web page
> saved. You'll continue to get "Error" until you get a fresh copy of the web
> page by either exiting and restarting EXCEL or running the
> smfForceRecalculation macro to purge the saved web pages.
>
> On Sun, Sep 11, 2011 at 9:03 AM, jmilum <jeff.milum@...> wrote:
>
> > I'm no expert at RCH* but am also having troubles with MSN data. I am
> > currently getting errors for all values with numerous tickers.
> >
> > The MSN website appears to be fine, when I cut and paste the URL from the
> > smf*.txt file for MSN data using IBM (
> > http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM)
> > the webpage appears to be returning valid data.
> >
> > However, the spreadsheet function only returns "error" when the function is
> > entered as '=RCHGetElementNumber("IBM",1)'. I do not
> >
> > If anyone has any suggestions, please help!
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)

3.5.

Re: RCHGetElementNumber

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

Sun Sep 11, 2011 1:41 pm (PDT)

MSN creates it. When looking at a stock:

http://investing.money.msn.com/investments/stock-price?symbol=MMM

...click on the printer icon to the right of the "Trade" button. Then click
on "Select All" and "Generate Report". That's the URL I'm using. It's their
"Print Report" page.

I have the add-in get the data from there because it IS all on one web page,
and I don't have to waste time getting each individual web page for the
different pieces of data. Although the layout and some of the content is
quite different today than it was a few years ago...

On Sun, Sep 11, 2011 at 1:25 PM, investor952 <investor952@yahoo.com> wrote:

> "(
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=IBM
> )"
>
> WOW!! Randy, did you create this somehow? It shows LOTS of info and I can
> get it for other companies just by changing the ticker symbol at the end.
> This link gets it ALL on one page? Thanks.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (32)

4a.

Re: MSN Money 5 yr growth rate

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Sun Sep 11, 2011 10:01 am (PDT)

Randy, I tried getting this cell just as you describe and just get "error". I looked and looked but just can't see why. Here's my function - can you see the error?

=RCHGetTableCell("http://investing.money.msn.com/investments/earnings-estimates?symbol=ibm",4,"Next 5 Yrs","Company")

To Jackson, if you don't mind using Yahoo data, this function works fine and is a bit easier:

=RCHGetElementNumber(D6,621)

Where D6 is the cell of your ticker. Change 621 to 613 for next year's earnings growth.

Review data on this page (for IBM):
http://finance.yahoo.com/q/ae?s=IBM+Analyst+Estimates

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Your function invocation doesn't make sense -- you only have a single
> parameter to the function, this URL:
>
> "http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a
> "&C6&",3,""Company"
>
> ...because you are concatenating three items:
>
> "http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a"
> C6
> ",3,""Company"
>
> I think you want something like:
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/earnings-estimates?symbol="&C6,4,"Next
> 5 Yrs","Company")
>
> ...because "Company" alone is NOT a good search term. It's found all over
> the source code of the web page, because there are a lot of links with the
> word "company" in it.
>
> On Tue, Sep 6, 2011 at 1:45 PM, scottandrewjackson <
> scottandrewjackson@...> wrote:
>
> > I am calculating portfolio statistics and using the RCHgettablecell
> > function I can't pull the 5 yr growth rate.
> >
> > =RCHGetTableCell("
> > http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a
> > "&C6&",3,""Company")
> >
> > http://investing.money.msn.com/investments/earnings-estimates?symbol=wen
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

4b.

Re: MSN Money 5 yr growth rate

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

Sun Sep 11, 2011 10:23 am (PDT)

That function works fine for me...

What happens if you go to that web page in the EXCEL Web Query dialog? Can
you see the data? Have you tried smfForceRecalculation to get a fresh copy
of the web page? Do you have Internet Options set to always get a new copy
of the web page?

On Sun, Sep 11, 2011 at 10:01 AM, MikeM <mikemcq802@yahoo.com> wrote:

> Randy, I tried getting this cell just as you describe and just get "error".
> I looked and looked but just can't see why. Here's my function - can you
> see the error?
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/earnings-estimates?symbol=ibm",4,"Next
> 5 Yrs","Company")
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

4c.

Re: MSN Money 5 yr growth rate

Posted by: "Scott Jackson" scottandrewjackson@yahoo.com   scottandrewjackson

Sun Sep 11, 2011 10:32 am (PDT)

Thanks Mike, I'll mess around with it later today.

I don't really have a preference between the data coming from yahoo or msn, they both get their data from Reuters.

Scott Jackson

Sent from my iPhone

On Sep 11, 2011, at 10:01 AM, "MikeM" <mikemcq802@yahoo.com> wrote:

> Randy, I tried getting this cell just as you describe and just get "error". I looked and looked but just can't see why. Here's my function - can you see the error?
>
> =RCHGetTableCell("http://investing.money.msn.com/investments/earnings-estimates?symbol=ibm",4,"Next 5 Yrs","Company")
>
> To Jackson, if you don't mind using Yahoo data, this function works fine and is a bit easier:
>
> =RCHGetElementNumber(D6,621)
>
> Where D6 is the cell of your ticker. Change 621 to 613 for next year's earnings growth.
>
> Review data on this page (for IBM):
> http://finance.yahoo.com/q/ae?s=IBM+Analyst+Estimates
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Your function invocation doesn't make sense -- you only have a single
> > parameter to the function, this URL:
> >
> > "http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a
> > "&C6&",3,""Company"
> >
> > ...because you are concatenating three items:
> >
> > "http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a"
> > C6
> > ",3,""Company"
> >
> > I think you want something like:
> >
> > =RCHGetTableCell("
> > http://investing.money.msn.com/investments/earnings-estimates?symbol="&C6,4,"Next
> > 5 Yrs","Company")
> >
> > ...because "Company" alone is NOT a good search term. It's found all over
> > the source code of the web page, because there are a lot of links with the
> > word "company" in it.
> >
> > On Tue, Sep 6, 2011 at 1:45 PM, scottandrewjackson <
> > scottandrewjackson@...> wrote:
> >
> > > I am calculating portfolio statistics and using the RCHgettablecell
> > > function I can't pull the 5 yr growth rate.
> > >
> > > =RCHGetTableCell("
> > > http://investing.money.msn.com/investments/earnings-estimates?symbol=US%3a
> > > "&C6&",3,""Company")
> > >
> > > http://investing.money.msn.com/investments/earnings-estimates?symbol=wen
> > >
> >
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

4d.

Re: MSN Money 5 yr growth rate

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Sun Sep 11, 2011 10:44 am (PDT)

Hmmm. In Excel Query it gave me the IE prompt for "Do you want to see only data that was returned securely" message (or something to that affect. I clicked "NO" and saw the page just fine. I then re-entered the GetTableCell function and it worked fine. I even exited Excel and re-started and GetTableCell is still working fine.

Thanks

ps: Yes, I had tried ForceRecalc and my IE is set to refresh each time.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That function works fine for me...
>
> What happens if you go to that web page in the EXCEL Web Query dialog? Can
> you see the data? Have you tried smfForceRecalculation to get a fresh copy
> of the web page? Do you have Internet Options set to always get a new copy
> of the web page?
>
> On Sun, Sep 11, 2011 at 10:01 AM, MikeM <mikemcq802@...> wrote:
>
> > Randy, I tried getting this cell just as you describe and just get "error".
> > I looked and looked but just can't see why. Here's my function - can you
> > see the error?
> >
> > =RCHGetTableCell("
> > http://investing.money.msn.com/investments/earnings-estimates?symbol=ibm",4,"Next
> > 5 Yrs","Company")
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

5a.

confused

Posted by: "paulino" pchuitcheu@yahoo.fr   pchuitcheu

Sun Sep 11, 2011 2:22 pm (PDT)

Hi

i have managed to open some templates but i keep seeing names, names etc...
when i try to enter a ticker, still no change. can i have please have an example of what ticker to install?
thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

5b.

Re: confused

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

Sun Sep 11, 2011 2:30 pm (PDT)

Check out the "Links" area of the group -- there is an item there on the
#NAME? issue. A template won't work properly if it has unresolved links.

Did you get the functions to work in a new workbook? You should be doing
some of that before trying to use the templates.

On Sun, Sep 11, 2011 at 2:22 PM, paulino <pchuitcheu@yahoo.fr> wrote:

>
> i have managed to open some templates but i keep seeing names, names etc...
> when i try to enter a ticker, still no change. can i have please have an
> example of what ticker to install?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

6a.

"Error" With RCHGetElementNumber from Google Site

Posted by: "Cornelius" mcpeak241@gmail.com   mcpeak241

Sun Sep 11, 2011 7:59 pm (PDT)

Randy,

Thank you creating this group and add-in. I have been using RCHGetElementNumber formula to get Financial Statements for the past year. Just recently, it stopped working and now simply returns "Error." I have narrowed it down to the Google site because the Yahoo RCHGetElementNumber formulas work. Also the formulas =RCHGetElementNumber("Source",3345), "Element", and "Web Page" work correctly, but when I input a ticker, "IBM", I get the message "Error."

Thank you.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

6b.

Re: "Error" With RCHGetElementNumber from Google Site

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

Sun Sep 11, 2011 8:03 pm (PDT)

Element #3345 is working with ticker IBM just fine for me.

You probably just need the new Google element definitions in the
smf-elements-3.txt file from the "Works in Progress" folder. I had to change
the URL for all of the element definitions because of a change Google made
to their website earlier this year.

You need to either exit and re-enter EXCEL, or run the smfForceRecalculation
macro, once you replace the element definitions file. That tells the add-in
to reload the definitions. While you're at it, you may want to pick up the
other update element definitions files from that folder as well...

On Sun, Sep 11, 2011 at 7:58 PM, Cornelius <mcpeak241@gmail.com> wrote:

> Randy,
>
> Thank you creating this group and add-in. I have been using
> RCHGetElementNumber formula to get Financial Statements for the past year.
> Just recently, it stopped working and now simply returns "Error." I have
> narrowed it down to the Google site because the Yahoo RCHGetElementNumber
> formulas work. Also the formulas =RCHGetElementNumber("Source",3345),
> "Element", and "Web Page" work correctly, but when I input a ticker, "IBM",
> I get the message "Error."
>
> Thank you.
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  91
  New Members
•  1
  New Files

Visit Your Group

Yahoo! News

Get it all here

Breaking news to

entertainment news

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

Messages | Files | Photos | Polls

MARKETPLACE

A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

---

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

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe