Jumat, 19 Agustus 2011

[smf_addin] Digest Number 1928

Messages In This Digest (24 Messages)

1a.
Re: Problem with RCHGetElementNumber() From: igorkravetsky
1b.
Re: Problem with RCHGetElementNumber() From: Randy Harmelink
2a.
Re: question.... From: Mike
2b.
Re: question.... From: Martin Topper
2c.
Re: question.... From: Randy Harmelink
2d.
Re: question.... From: Mike
2e.
Re: question.... From: Randy Harmelink
3a.
Problems calculating with the numbers returned from smfGetADVFNEleme From: zenodk_2
3b.
Re: Problems calculating with the numbers returned from smfGetADVFNE From: Randy Harmelink
4a.
Re: How to derive realtime google data From: sptrendtrading
4b.
Re: How to derive realtime google data From: Randy Harmelink
4c.
Re: How to derive realtime google data From: sptrendtrading
4d.
Re: How to derive realtime google data From: Randy Harmelink
5a.
Refresh Button From: thtabe
5b.
Re: Refresh Button From: Randy Harmelink
5c.
Re: Refresh Button From: thtabe
5d.
Re: Refresh Button From: Randy Harmelink
5e.
Re: Refresh Button From: thtabe
5f.
Re: Refresh Button From: Randy Harmelink
5g.
Re: Refresh Button From: dguillett1
6a.
What set up are you using to have this tool work right? From: ed_in_dallas
6b.
Re: What set up are you using to have this tool work right? From: Randy Harmelink
7a.
Re: 5y Tax Cost Ratio From: nate_lalala
7b.
Re: 5y Tax Cost Ratio From: Randy Harmelink

Messages

1a.

Re: Problem with RCHGetElementNumber()

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

Thu Aug 18, 2011 4:12 am (PDT)



Ah I see, is there a way to get YTD data for stock tickers? Thanks for your input.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I suspect you're trying to use a stock ticker? The web page that data comes
> from is for Mutual Funds. That element works for me when I use ticker symbol
> VFINX.
>
> On Wed, Aug 17, 2011 at 9:50 PM, igorkravetsky <igorkravetsky@...>wrote:
>
> >
> > I'm having an issue with the RCHGetElementNumber() command. I'm trying to
> > get YTD data from morningstar and it keeps giving me errors. An example of
> > the command im using is =RCHGetElementNumber(C2,4892) and then im dragging
> > the formula down across all tickers that are listed in the C column. I'm
> > pretty sure I'm using the most up-to-date definitions and add-on. Any ideas
> > on how to fix this?
> >
>

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

Re: Problem with RCHGetElementNumber()

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

Thu Aug 18, 2011 10:08 am (PDT)



If you have a source, you can probably use the RCHGetTableCell() function to
grab the data.

I typically just grab the necessary prices using smfPricesByDates() and
compute it myself.

On Thu, Aug 18, 2011 at 4:11 AM, igorkravetsky <igorkravetsky@yahoo.com>wrote:

> Ah I see, is there a way to get YTD data for stock tickers?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2a.

Re: question....

Posted by: "Mike" mikesadd@hotmail.com   morpheusca8

Thu Aug 18, 2011 6:20 am (PDT)



How does the RHCGetYahooQuote function work?? because it like IE8 doesnt return some values???

--- In smf_addin@yahoogroups.com, "Mike" <mikesadd@...> wrote:
>
> Has anyone else noticed that different browers return different info...
> eg ie doesnt return 52 high and low for some stocks but fire fox does.
> anyone else run in to this....and know ways around it??
>
> Thanks
> mike
>

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

Re: question....

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Thu Aug 18, 2011 8:55 am (PDT)



an example of what it "doesn't return" would be helpful.  also the formula you used (exactly)

Marty

________________________________
From: Mike <mikesadd@hotmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, August 18, 2011 9:20 AM
Subject: [smf_addin] Re: question....

 
How does the RHCGetYahooQuote function work?? because it like IE8 doesnt return some values???

--- In smf_addin@yahoogroups.com, "Mike" <mikesadd@...> wrote:
>
> Has anyone else noticed that different browers return different info...
> eg ie doesnt return 52 high and low for some stocks but fire fox does.
> anyone else run in to this....and know ways around it??
>
> Thanks
> mike
>

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

Re: question....

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

Thu Aug 18, 2011 10:15 am (PDT)



As Martin notes, an example of your specific function invocation would
help.

I'm confused by your comment about IE8. At best, both IE and the add-in can
only return the data that Yahoo provides. For example, Yahoo does populate
many fields with "N/A" from time to time.

But, in general, RCHGetYahooQuotes() sends a request to Yahoo, Yahoo
prepares a CSV file containing the requested information, and then the
add-in parses the CSV file and places the data into the range over which you
have entered the function.

On Thu, Aug 18, 2011 at 6:20 AM, Mike <mikesadd@hotmail.com> wrote:

> How does the RHCGetYahooQuote function work?? because it like IE8 doesnt
> return some values???
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2d.

Re: question....

Posted by: "Mike" mikesadd@hotmail.com   morpheusca8

Thu Aug 18, 2011 10:40 am (PDT)



So if open my browser IE8 with
http://finance.yahoo.com/q?s=dh.to&ql=1

and then open firefox with the same
http://finance.yahoo.com/q?s=dh.to&ql=1

the IE8 has the 52 week high and low....the firefox doesnt....the getyahooquote function doesnt return a value for me.

So then i opened ie8 again and pasted the url...and this time it didnt give me the 53 week high low....so i have one window that has it and one that doesnt..both with ie8.....seems inconsistent ....anyone else encountered this??

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As Martin notes, an example of your specific function invocation would
> help.
>
> I'm confused by your comment about IE8. At best, both IE and the add-in can
> only return the data that Yahoo provides. For example, Yahoo does populate
> many fields with "N/A" from time to time.
>
> But, in general, RCHGetYahooQuotes() sends a request to Yahoo, Yahoo
> prepares a CSV file containing the requested information, and then the
> add-in parses the CSV file and places the data into the range over which you
> have entered the function.
>
> On Thu, Aug 18, 2011 at 6:20 AM, Mike <mikesadd@...> wrote:
>
> > How does the RHCGetYahooQuote function work?? because it like IE8 doesnt
> > return some values???
> >
>

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

Re: question....

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

Thu Aug 18, 2011 10:44 am (PDT)



It probably just depends on which servers are returning the information.

On Thu, Aug 18, 2011 at 10:40 AM, Mike <mikesadd@hotmail.com> wrote:

> So if open my browser IE8 with
> http://finance.yahoo.com/q?s=dh.to&ql=1
>
> and then open firefox with the same
> http://finance.yahoo.com/q?s=dh.to&ql=1
>
> the IE8 has the 52 week high and low....the firefox doesnt....the
> getyahooquote function doesnt return a value for me.
>
> So then i opened ie8 again and pasted the url...and this time it didnt give
> me the 53 week high low....so i have one window that has it and one that
> doesnt..both with ie8.....seems inconsistent ....anyone else encountered
> this??
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3a.

Problems calculating with the numbers returned from smfGetADVFNEleme

Posted by: "zenodk_2" madsdsl@gmail.com   zenodk_2

Thu Aug 18, 2011 8:15 am (PDT)



Hi,

Cell A1 "=smfGetADVFNElement("K";"A";1;">Total Revenue<")" returns 12,397.0 as expected.

When I then move the cursor to say A2 and do the command "=A1*2", I get the message "#VALUE!".

Any clues?

Thanks in advance,

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

Re: Problems calculating with the numbers returned from smfGetADVFNE

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

Thu Aug 18, 2011 10:12 am (PDT)



I suspect it has some to do with your computer system's regional settings
(see "Links" area of group for more info).

But you may be getting #VALUE! because the "12,397.0" is text instead of a
number. That is a formatted value -- did you place the format on it?

On Thu, Aug 18, 2011 at 8:14 AM, zenodk_2 <madsdsl@gmail.com> wrote:

>
> Cell A1 "=smfGetADVFNElement("K";"A";1;">Total Revenue<")" returns 12,397.0
> as expected.
>
> When I then move the cursor to say A2 and do the command "=A1*2", I get the
> message "#VALUE!".
>
> Any clues?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: How to derive realtime google data

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

Thu Aug 18, 2011 9:09 am (PDT)



Are you saying open the template and click crtl H and find 'C:\User Name\Application Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'! and replace with nothing? The message say microsoft could not find any data

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

Re: How to derive realtime google data

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

Thu Aug 18, 2011 10:16 am (PDT)



That path was just an example of one possible value. You'd need to get rid
of whatever path is in your worksheet cells.

On Thu, Aug 18, 2011 at 9:08 AM, sptrendtrading <sptrendtrading@yahoo.com>wrote:

> Are you saying open the template and click crtl H and find 'C:\User
> Name\Application Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'! and
> replace with nothing? The message say microsoft could not find any data
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4c.

Re: How to derive realtime google data

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

Thu Aug 18, 2011 2:41 pm (PDT)



Did not really understand what to get rid of

The 2.0 link doc is saying the user is using the file on another computer and thus the problem but currently opening the template on one computer and not on other computer

What to get rid of? The path to the RCH xla file? Is not the path to the xla has to be on the formula?

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

Re: How to derive realtime google data

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

Thu Aug 18, 2011 3:38 pm (PDT)



If there is a path to the XLA file on the formula, it is an unresolved link
and needs to be removed. If it was the location of your installed version of
the add-in, EXCEL would have automatically resolved the link and removed the
path.

On Thu, Aug 18, 2011 at 2:41 PM, sptrendtrading <sptrendtrading@yahoo.com>wrote:

> Did not really understand what to get rid of
>
> The 2.0 link doc is saying the user is using the file on another computer
> and thus the problem but currently opening the template on one computer and
> not on other computer
>
> What to get rid of? The path to the RCH xla file? Is not the path to the
> xla has to be on the formula?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
5a.

Refresh Button

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

Thu Aug 18, 2011 9:31 am (PDT)



Hello all,

How do I build a refresh button into my spread sheet? I have read the FAQ for the "smfforcerecalculation macro and how to use it" and cannot get it to work for me.

Thanks
Tarry

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

Re: Refresh Button

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

Thu Aug 18, 2011 10:19 am (PDT)



You just need to assign the macro to a button.

On Thu, Aug 18, 2011 at 9:31 AM, thtabe <thtabe@yahoo.com> wrote:

>
> How do I build a refresh button into my spread sheet? I have read the FAQ
> for the "smfforcerecalculation macro and how to use it" and cannot get it to
> work for me.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
5c.

Re: Refresh Button

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

Thu Aug 18, 2011 12:34 pm (PDT)



I don't know how to do that and can't find the answer here. That's why I am asking the question How do I build a refresh button into my spread sheet. Can you tell me how to do it or provide a link that can?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You just need to assign the macro to a button.
>
> On Thu, Aug 18, 2011 at 9:31 AM, thtabe <thtabe@...> wrote:
>
> >
> > How do I build a refresh button into my spread sheet? I have read the FAQ
> > for the "smfforcerecalculation macro and how to use it" and cannot get it to
> > work for me.
> >
>

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

Re: Refresh Button

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

Thu Aug 18, 2011 12:41 pm (PDT)



Google is your friend -- if I use Google and search on:

excel assign macro to button

...the first link is:

http://www.mrexcel.com/tip068.shtml

On Thu, Aug 18, 2011 at 12:34 PM, thtabe <thtabe@yahoo.com> wrote:

> I don't know how to do that and can't find the answer here. That's why I
> am asking the question How do I build a refresh button into my spread sheet.
> Can you tell me how to do it or provide a link that can?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
5e.

Re: Refresh Button

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

Thu Aug 18, 2011 1:42 pm (PDT)



What is this Google you speak of? JK

I cannot get the macro to work, after typing in rchgetyahooquotes() in to the macro dialog window I get the following message "reference is not valid" when I click the run button.
Is there something else I need to down load and install?
Am I using the correct macro to refresh the data?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Google is your friend -- if I use Google and search on:
>
> excel assign macro to button
>
> ...the first link is:
>
> http://www.mrexcel.com/tip068.shtml
>
> On Thu, Aug 18, 2011 at 12:34 PM, thtabe <thtabe@...> wrote:
>
> > I don't know how to do that and can't find the answer here. That's why I
> > am asking the question How do I build a refresh button into my spread sheet.
> > Can you tell me how to do it or provide a link that can?
> >
>

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

Re: Refresh Button

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

Thu Aug 18, 2011 1:53 pm (PDT)



RCHGetYahooQuotes() is a function, not a macro.

You mentioned smfForceRecalculation earlier -- *THAT* is the macro to assign
to a button. Check out the "Links" area items again.

On Thu, Aug 18, 2011 at 1:42 PM, thtabe <thtabe@yahoo.com> wrote:

> What is this Google you speak of? JK
>
> I cannot get the macro to work, after typing in rchgetyahooquotes() in to
> the macro dialog window I get the following message "reference is not valid"
> when I click the run button.
> Is there something else I need to down load and install?
> Am I using the correct macro to refresh the data?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
5g.

Re: Refresh Button

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Thu Aug 18, 2011 3:30 pm (PDT)



Randy, you have a lot of patience

From: Randy Harmelink
Sent: Thursday, August 18, 2011 3:53 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Refresh Button

RCHGetYahooQuotes() is a function, not a macro.

You mentioned smfForceRecalculation earlier -- *THAT* is the macro to assign to a button. Check out the "Links" area items again.

On Thu, Aug 18, 2011 at 1:42 PM, thtabe <thtabe@yahoo.com> wrote:

What is this Google you speak of? JK

I cannot get the macro to work, after typing in rchgetyahooquotes() in to the macro dialog window I get the following message "reference is not valid" when I click the run button.
Is there something else I need to down load and install?
Am I using the correct macro to refresh the data?

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

What set up are you using to have this tool work right?

Posted by: "ed_in_dallas" eas_trader@att.net   ed_in_dallas

Thu Aug 18, 2011 9:50 am (PDT)



Hi
I am using windows 7 x64 pro and excel 2010 and can not get this add in to work pulling any data. So wondering what others are using.

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

Re: What set up are you using to have this tool work right?

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

Thu Aug 18, 2011 10:22 am (PDT)



Please give me a better description of "can not get this add in to work".
What function invocations did you use? What results did you get? How far did
you get in the documentation?

On Thu, Aug 18, 2011 at 6:09 AM, ed_in_dallas <eas_trader@att.net> wrote:

> I am using windows 7 x64 pro and excel 2010 and can not get this add in to
> work pulling any data. So wondering what others are using.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: 5y Tax Cost Ratio

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

Thu Aug 18, 2011 12:39 pm (PDT)



I am also interested in getting the tax cost ratio, but all I get is an error

=RCHGetTableCell("http://quicktake.morningstar.com/FundNet/Tax.aspx?Symbol=PRWCX",5,"Tax Cost Ratio","PRWCX")

I want to return .68

Tax Cost Ratio
PRWCX — — — — 0.68

Any ideas?

Thanks,
Nathan Wells

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't think there is an element for it. Try something like:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/FundNet/Tax.aspx?Symbol=VFINX",2,">Tax Cost
> Ratio")
>
> On Wed, Mar 3, 2010 at 1:32 PM, tbrown92282 <tbrown92282@...> wrote:
>
> > Anybody know the element # for what Morningstar calls their Tax Ratio?
> >
>

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

Re: 5y Tax Cost Ratio

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

Thu Aug 18, 2011 12:56 pm (PDT)



Sorry, but data cannot be extracted from that web page -- the data is
displayed dynamically instead of being delivered within the source code of
the web page.

However, you can extract data from the "Print" versions of the web page, but
they aren't as detailed. For example, it doesn't contain the 1-year value
you want, but does have the 3-year average:

=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PRWCX",1,">Tax
Cost Ratio")

On Thu, Aug 18, 2011 at 11:59 AM, nate_lalala <nate_lalala@yahoo.com> wrote:

> I am also interested in getting the tax cost ratio, but all I get is an
> error
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/FundNet/Tax.aspx?Symbol=PRWCX",5,"Tax
> Cost Ratio","PRWCX")
>
> I want to return .68
>
> Tax Cost Ratio
> PRWCX — — — — 0.68
>
> Any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
A better credit score can save you thousands. See yours at freecreditscore.com.
Diposting oleh EXCEL FEED LEARNING di 04.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)