Kamis, 15 September 2011

[smf_addin] Digest Number 1955

Messages In This Digest (11 Messages)

Messages

1a.

Incorrect data returned

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

Wed Sep 14, 2011 11:04 am (PDT)



Hi Randy,

I'm seeing something unusual and I don't understand why it's happening.
When I try to retrieve data using this formula:

=RCHGetWebData("http://www.census.gov/retail/marts/www/download/text/adv44000.txt",2576,6)

the data I get is 347669. However, if you look at the web page, the correct value is 347349. The formula is not returning what I see in the source code. Why would this happen? Thanks in advance for all your help.

kk

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

Re: Incorrect data returned

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

Wed Sep 14, 2011 1:00 pm (PDT)



I get a result of "28" with your formula.

Extracting something by position from that file isn't a good idea -- it may
have carriage returns, line feeds, tab characters, etc.

Have you run the smfForceRecalculation macro to make sure you have a fresh
copy of the web page? Do you have your Internet Options set to get a new
copy of the web page each time it is used?

On Wed, Sep 14, 2011 at 11:04 AM, kkkutty <kkkutty@yahoo.com> wrote:

>
> I'm seeing something unusual and I don't understand why it's happening.
> When I try to retrieve data using this formula:
>
> =RCHGetWebData("
> http://www.census.gov/retail/marts/www/download/text/adv44000.txt",2576,6)
>
> the data I get is 347669. However, if you look at the web page, the
> correct value is 347349. The formula is not returning what I see in the
> source code. Why would this happen? Thanks in advance for all your help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2.1.

question for Randy Re: RCHGetElementNumber

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

Wed Sep 14, 2011 11:38 am (PDT)



Thanks Randy..this worked...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =smfGetTagContent("
> http://investing.money.msn.com/investments/stock-ratings?symbol=SDRL
> ","div",-2,">Scouter")
>
> On Tue, Sep 13, 2011 at 11:48 AM, investor952 <investor952@...> wrote:
>
> >
> > There seems to be a problem with the data at this MSN website, the one you
> > use where it has all the information together...
> >
> > Here is one example...I am looking for the MSN Stock Scouter Rating for the
> > stock SDRL
> >
> >
> > 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=SDRL
> >
> > The above website, the one you say you use, shows N/A.
> >
> > However, If I go to the MSN Stock Scouter site,
> >
> > http://investing.money.msn.com/investments/stock-ratings?symbol=SDRL&
> >
> > ...it shows me that the MSN Stock Scouter rating is 7.
> >
> > This is one example. There are other examples.
> >
> > Question: How would I use your tools to get the '7' from this website?
> > Pls show formula, and I could change it for other stock tickers. Thanks a
> > lot.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (35)
3a.

Error handling?

Posted by: "lang.toby" lang.toby@yahoo.com   lang.toby

Wed Sep 14, 2011 1:01 pm (PDT)



When I call =RCHGetElementNumber("IBM",1) I get a result when I call
=RCHGetElementNumber("IBM",13626)

I get "error"

Some more info as to the cause would greatly help either debug or error handle. Any info as to the cause of this specific issue. Or how to debug for myself would be greatly appreciated.

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

Re: Error handling?

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

Wed Sep 14, 2011 1:07 pm (PDT)



Did you look at all the parameters that drive the RCHGetElementNumber()
extraction? They're all available. Since most element definitions are just
the RCHGetTableCell() function parameters, the Troubleshooter file for that
function can be of help.

However, I would suspect what you need is the new smf-elements-5.txt element
definition file from the "Works in Progress" folder in the files area.
Reuters changed their website earlier this year, so I needed to update the
element definitions.

On Wed, Sep 14, 2011 at 11:45 AM, lang.toby <lang.toby@yahoo.com> wrote:

> When I call =RCHGetElementNumber("IBM",1) I get a result when I call
> =RCHGetElementNumber("IBM",13626)
>
> I get "error"
>
> Some more info as to the cause would greatly help either debug or error
> handle. Any info as to the cause of this specific issue. Or how to debug for
> myself would be greatly appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.

Re: Error handling?

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

Wed Sep 14, 2011 1:17 pm (PDT)



My apologies -- it appears the RCHGetTableCell() parameter queries of
RCHGetElementNumber() are undocumented:

Example Formula Value Returned Description
=RCHGetElementNumber("Version") Stock
Market Functions add-in, Version 2.1.2011.07.03 (C:\SMF Add-in; 1) Tells you
which version of the add-in you are using.
=RCHGetElementNumber("Source",941) YahooKS Gives you the data source for
element number 941 =RCHGetElementNumber("Element",941) Market Cap Gives you
the element name for element number 941 =RCHGetElementNumber("Web
Page",941) http://finance.yahoo.com/q/ks?s=~~~~~ Gives you the web page
element number 941 is retrieved from ("~~~~~" is the ticker symbol)
=RCHGetElementNumber("IBM",
941) 200290000 Market Capitalization from data source "YahooKS" for ticker
"IBM" =RCHGetElementNumber("IBM", 1541) 2.0023E+11 Market Capitalization
from data source "MSN" for ticker "IBM" =RCHGetElementNumber("P-URL",941)
http://finance.yahoo.com/q/ks?s=~~~~~ RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Cells",941) 1 RCHGetTableCell() function parameter
=RCHGetElementNumber("P-Find1",941) VALUATION MEASURES RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Find2",941) MARKET CAP
RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Find3",941) RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Find4",941) RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Rows",941) 0 RCHGetTableCell()
function parameter =RCHGetElementNumber("P-End",941) 0 RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Look",941) 0 RCHGetTableCell()
function parameter =RCHGetElementNumber("P-Type",941) 0 RCHGetTableCell()
function parameter

On Wed, Sep 14, 2011 at 11:45 AM, lang.toby <lang.toby@yahoo.com> wrote:

> When I call =RCHGetElementNumber("IBM",1) I get a result when I call
> =RCHGetElementNumber("IBM",13626)
>
> I get "error"
>
> Some more info as to the cause would greatly help either debug or error
> handle. Any info as to the cause of this specific issue. Or how to debug for
> myself would be greatly appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4a.

Randy H. - Option Examples Updated???

Posted by: "tseiter2000" aseiter@verizon.net   tseiter2000

Wed Sep 14, 2011 1:17 pm (PDT)



Randy, at one time there were a number of option function examples which you had developed using the SMF AddIn, which were available on the SMF Yahoo Group. Examples: Yahoo-Options-CC-List-Returns; Yahoo-Options-CC-Rolling; and Yahoo-Options-Calls-and-Puts. These were in the old option format. By chance have you updated them for your own use, but not posted back to the Yahoo Group? If so would you be willing to share?

Thanks for all of your outstanding efforts on the SMF AddIn, and in your posts in other Yahoo Groups.

Best Regards,

Tony Seiter
aseiter@verizon.net

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

Re: Randy H. - Option Examples Updated???

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

Wed Sep 14, 2011 1:32 pm (PDT)



The CC-List and CC-Returns were never available on this group. They are on
the JustCoveredCalls Yahoo group. I think they're all updated now. Let me
know if that is not the case. I no longer use the CC-Rolling, so they were
never updated.

Calls-and-Puts is in the "Requested Samples" folder of this group, but has
not been updated since I don't use it. I think it still works?

On Wed, Sep 14, 2011 at 1:17 PM, tseiter2000 <aseiter@verizon.net> wrote:

> Randy, at one time there were a number of option function examples which
> you had developed using the SMF AddIn, which were available on the SMF Yahoo
> Group. Examples: Yahoo-Options-CC-List-Returns; Yahoo-Options-CC-Rolling;
> and Yahoo-Options-Calls-and-Puts. These were in the old option format. By
> chance have you updated them for your own use, but not posted back to the
> Yahoo Group? If so would you be willing to share?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4c.

Re: Randy H. - Option Examples Updated???

Posted by: "tseiter2000" aseiter@verizon.net   tseiter2000

Wed Sep 14, 2011 9:37 pm (PDT)



Randy,

Thanks for the update and joggling my memory (it's that SomeTimers kicking in again)! I found them in the JustCoveredCalls Yahoo Group and all is now OK.

Best Regards,

Tony

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The CC-List and CC-Returns were never available on this group. They are on
> the JustCoveredCalls Yahoo group. I think they're all updated now. Let me
> know if that is not the case. I no longer use the CC-Rolling, so they were
> never updated.
>
> Calls-and-Puts is in the "Requested Samples" folder of this group, but has
> not been updated since I don't use it. I think it still works?
>
> On Wed, Sep 14, 2011 at 1:17 PM, tseiter2000 <aseiter@...> wrote:
>
> > Randy, at one time there were a number of option function examples which
> > you had developed using the SMF AddIn, which were available on the SMF Yahoo
> > Group. Examples: Yahoo-Options-CC-List-Returns; Yahoo-Options-CC-Rolling;
> > and Yahoo-Options-Calls-and-Puts. These were in the old option format. By
> > chance have you updated them for your own use, but not posted back to the
> > Yahoo Group? If so would you be willing to share?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5a.

SMF-Template-Reuters-Ratios-Comparison.xls  Percentage Errors

Posted by: "Peter C" pcalinski@yahoo.com   pcalinski

Wed Sep 14, 2011 6:19 pm (PDT)



I was looking at SMF-Template-Reuters-Ratios-Comparison.xls and discovered that some (if not all) values that are formatted as percent are too high by a factor of 100.

I gather the value returned is already a percent value and when formatted "percent" it gets double applied.

If there is not already a corrected version I can correct this one and upload it.

Let me know please,

Pete

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

Re: SMF-Template-Reuters-Ratios-Comparison.xls Percentage Errors

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

Wed Sep 14, 2011 6:30 pm (PDT)



Just the dividends section, right? The version on my hard drive already had
the changes, so I must have forgotten to upload the changes. I just uploaded
the new file. Thanks!

On Wed, Sep 14, 2011 at 6:19 PM, Peter C <pcalinski@yahoo.com> wrote:

> I was looking at SMF-Template-Reuters-Ratios-Comparison.xls and discovered
> that some (if not all) values that are formatted as percent are too high by
> a factor of 100.
>
> I gather the value returned is already a percent value and when formatted
> "percent" it gets double applied.
>
> If there is not already a corrected version I can correct this one and
> upload it.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in 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.

A bad score is 596. A good idea is checking yours at freecreditscore.com.
Diposting oleh EXCEL FEED LEARNING di 03.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)