Senin, 09 Maret 2015

[smf_addin] Digest Number 3351

15 Messages

Digest #3351
1a
Re: Referencing my addin to RCH addin by "Randy Harmelink" rharmelink
3a
GF WACC by soemoe.theinwin
3b
Re: GF WACC by "Randy Harmelink" rharmelink
4a
login for Mstar by indinvestor111
4b
Re: login for Mstar by "Randy Harmelink" rharmelink
5c
Re: smfstrExtr and quotes? by "Randy Harmelink" rharmelink
5d
Re: smfstrExtr and quotes? by "Randy Harmelink" rharmelink
6a
Yield from LQD by "Jose Jacob" pepecan47
6b
Re: Yield from LQD by "Randy Harmelink" rharmelink

Messages

Mon Mar 9, 2015 2:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Go to the upper menu in VBA and choose the > Tools > References drop-down,
and set the reference to the library.

On Sun, Mar 8, 2015 at 11:16 PM, boo1712@yahoo.co.uk [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yes Randy, that's the question I am asking. How do I reference my personal
> addin to your RCH addin?
>

Mon Mar 9, 2015 4:02 am (PDT) . Posted by:

boo1712

Dear Randy, Thank you for you kind reply.
Done.

Mon Mar 9, 2015 7:48 am (PDT) . Posted by:

boo1712

Hi Guys,
Saw a long ago answer for the question above:
When in Print Preview, click on the "Page Setup" button and then on
the "Sheet" tab within the dialog box. On that tab, there is a
drop-down box for "Comments"; -- you want to select the drop-down
option that says "As Displayed on Sheet". The typical default is
"None", which is why you're probably not seeing the comment in Print
Preview.


However it does not work for my case. I am using Window 7 with office 2007

I am unable to adjust the "Comments";" drop down box.
Anyone facing the same problem and has a solution?


Thanks.
Terry

Mon Mar 9, 2015 9:24 am (PDT) . Posted by:

soemoe.theinwin

Hi Randy,


Firstly, thanks so much for everything that you do here - do you know how to extract the WACC from the Summary page on GF?


Thanks,


Soemoe

Mon Mar 9, 2015 9:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=smfConvertData(smfStrExtr(smfGetTagContent("
http://www.gurufocus.com/stock/MMM","div",1,">WACC vs ROIC"),">","~"))

On Mon, Mar 9, 2015 at 9:24 AM, soemoe.theinwin@... wrote:

> Firstly, thanks so much for everything that you do here - do you know
> how to extract the WACC from the Summary page on GF?
>

Mon Mar 9, 2015 9:27 am (PDT) . Posted by:

indinvestor111

Hi,


Was wondering why I need to constantly log into Morningstar every morning now in order to retrieve 10 years of data, where as I didn't have to do this a few months ago. Is there a cookie my computer is deleting that it didn't used then?


I recently upgraded to a new MS Office package, but remember having to do it with my old Excel as well.


Thanks

Mon Mar 9, 2015 9:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure. I don't need to log in every day.

However, I do sometimes need to visit the web site with IE before I can use
it. M* sometimes does some redirection on the first visit of the day, to
possibly do some "pop up" advertising. Only the browser updating of the
cookie, to indicate that the "first visit of the day" has occurred, can
prevent that redirection.

On Mon, Mar 9, 2015 at 9:27 AM, elandry@... wrote:

> Was wondering why I need to constantly log into Morningstar every
> morning now in order to retrieve 10 years of data, where as I didn't have
> to do this a few months ago. Is there a cookie my computer is deleting that
> it didn't used then?
>
> I recently upgraded to a new MS Office package, but remember having to do
> it with my old Excel as well.
>
>

Mon Mar 9, 2015 11:04 am (PDT) . Posted by:

jharlan

How do I use the smfstrExtr() function with quotation marks in the output?

Data at URL - :"ABC":

E.G., smfstrExtr(SAMPLE_URL,":",":") will display "ABC", but how to I get just ABC (w/o the quotation marks)?

I tried smfstrExtr(SAMPLE_URL,":"","":") and even smfstrExtr(smfstrExtr(SAMPLE_URL,":",":"),""",""")

but neither work.

Please help. Thanks,


Mon Mar 9, 2015 11:09 am (PDT) . Posted by:

jharlan

Technically, I use RCHGetWebData embedded in the smfstrExtr function to get the :"ABC": data, so if there was a way with the RCHGetWebData, function, that would be the cleanest.

Thanks,

Mon Mar 9, 2015 11:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need two double quotes with a text string to represent a single double
quote, as in:

=smfStrExtr(SAMPLE_URL,"""","""")

...would get you everything after the first double quote and before the
second double quote.

On Mon, Mar 9, 2015 at 11:04 AM, jharlan@... wrote:

>
> How do I use the smfstrExtr() function with quotation marks in the output?
>
> Data at URL - :"ABC":
>
> E.G., smfstrExtr(SAMPLE_URL,":",":") will display "ABC", but how to I get
> just ABC (w/o the quotation marks)?
>
> I tried smfstrExtr(SAMPLE_URL,":"","":") and even
> smfstrExtr(smfstrExtr(SAMPLE_URL,":",":"),""",""")
>
> but neither work.
>
> Please help. Thanks,
>

Mon Mar 9, 2015 11:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetWebData() is just a crude extraction tool. I avoid it whenever
possible. If you can go to smfGetTagContent(), that's usually a lot
cleaner, although you still probably need to use smfStrExtr() and possibly
smfConvertData() if numeric data.

On Mon, Mar 9, 2015 at 11:09 AM, jharlan@... wrote:

>
> Technically, I use RCHGetWebData embedded in the smfstrExtr function to
> get the :"ABC": data, so if there was a way with the RCHGetWebData,
> function, that would be the cleanest.
>

Mon Mar 9, 2015 12:13 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

I am trying to get the Dividend Yield of the ETF LQD from Yahoo. I am getting "error".

=RCHGetTableCell("http://finance.yahoo.com/q/?s=LQD&ql=1",1,"Yield (ttm)")

Is the formula wrong?

Regards,
Jose L. Jacob

Mon Mar 9, 2015 12:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because the web page has HTML coding around the "ttm" string:

<th scope="row" width="48%">Yield <span
class="small">(ttm)</span>²:</th>

Instead, try:

=RCHGetTableCell("http://finance.yahoo.com/q/?s=LQD",1,">Yield")

On Mon, Mar 9, 2015 at 12:13 PM, Jose Jacob pepecan47@... wrote:

> I am trying to get the Dividend Yield of the ETF LQD from Yahoo. I am
> getting "error".
>
> =RCHGetTableCell("http://finance.yahoo.com/q/?s=LQD&ql=1",1,"Yield (ttm)")
>
> Is the formula wrong?
>

Mon Mar 9, 2015 1:06 pm (PDT) . Posted by:

rjemery7

For any symbol, RCHGetYahooQuotes() needs to be overhauled to return values that are actually displayed on the main Yahoo Finance Page. It ought to be WYSIWYG. It is anything but.

RCHGetYahooQuotes("SLY","y") return N/A, when the webpage shows the yield TTM as 1.13%. SPY returns 1.85% when the webpage shows 1.82%. The data returned by RCHGetYahooQuotes() are simply untrustworthy. There are too many instances of erroneous data, and I feel that is an issue that needs to be addressed promptly.

Mon Mar 9, 2015 1:10 pm (PDT) . Posted by:

marco.deen

If I pull RCHgetyahoohistory for ^GSPC the data for 3/6/2015 is missing. Other tickers and indices do not appear to have this issue. Can you verify this?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar