Selasa, 20 Oktober 2015

[smf_addin] Digest Number 3537

10 Messages

Digest #3537
2b
Re: Earnings Whisper data pull by "Randy Harmelink" rharmelink
3a
Error =RCHGetElementNumber() by onetrickpony_1990
3b
Re: Error =RCHGetElementNumber() by "Randy Harmelink" rharmelink
3c
3d
Re: Error =RCHGetElementNumber() by "Randy Harmelink" rharmelink
4b
Re: RCHGetYahooQuotes for Indexes by "Randy Harmelink" rharmelink

Messages

Sun Oct 18, 2015 6:10 am (PDT) . Posted by:

Thanks for the response Randy.
I separate out Capital appreciation/depreciation,dividend/income and total return. I utilize each of these criteria/metrics to calculate volatility,beta,drawdowns. When building income producing portfolios these metrics are beneficial in comparing and evaluated qualifying dividends income, non qualified and free tax consequences affecting total return. Lastly when utilizing/calculating hedging techniques for capital preservation and Capital at risk.
Thanks again randy
Darryl

Sent from my iPhone

> On Oct 17, 2015, at 9:57 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> You can grab the individual unadjusted closing prices using RCHGetYahooHistory().
>
> I'm not sure any returns calculated with them would have any meaning though...
>
>> On Sat, Oct 17, 2015 at 6:36 PM, dmb7111@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>> Is there another source or way to obtain price by dates that does not adjust for dividend to calculate absolute returns?
>
>

Sun Oct 18, 2015 6:23 pm (PDT) . Posted by:

sirons1962

I am trying to get some info from here to color a box in my spreadsheet letting me know if earning are confirmed for the date listed.

Trying to extract if from here which is the line: "ewtip icon-checkmark color-yes" on this particular stock which is confirmed but would be "ewtip icon-checkmark color-no" on a stock that is not confirmed.

I was trying to get it with:
=smfstrExtr(smfGetTagContent("https://www.earningswhispers.com/stocks/"&B1,"div",-1,"ewtip icon"),"-","~") but all I get in the cell is a blank.

Here is where the string is located:
<div id="whisperbox" class="topbox"><div class="boxhead">Earnings Whisper ®</div><div class="mainitem">N/A</div><div id="qtrend">3rd Quarter September 2015</div><div id="consensus">Consensus:  $1.41</div><div id="revest">Revenue:  $1.66 Bil</div></div>
<div id="datebox" class="topbox"><div class="boxhead">Wednesday</div><div id="epsconfirmed" title="We last confirmed the release date with the company on Thursday, October 08, 2015" class="ewtip icon-checkmark color-yes"></div><div class="mainitem" onclick="location.href='/calendar?d=3&t=all'">Oct 21</div><div id="earningstime">7:00 AM ET</div><a id="ical" class="icon-addcalendar ewtip" href="webcal://beta.earningswhispers.com/jsdata/ical.aspx?symbol=ABG" title="add to your calendar"></a></div>



Regards,


Steve

Sun Oct 18, 2015 6:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The problem is that the data you're trying to extract is not contained
within the DIV tag, but is part of the DIV tag itself. That particular DIV
tag contains nothing, so you'll always get a blank.

Try:

=smfStrExtr(smfGetTagContent("https://www.earningswhispers.com/stocks/"&B1,"section",-1,"ewtip
icon"),"We last confirmed the release date with the company on ","""")

On Sun, Oct 18, 2015 at 6:23 PM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am trying to get some info from here to color a box in my spreadsheet
> letting me know if earning are confirmed for the date listed.
>
> Trying to extract if from here which is the line: "ewtip icon-checkmark
> color-yes" on this particular stock which is confirmed but would be "ewtip
> icon-checkmark color-no" on a stock that is not confirmed.
>
> I was trying to get it with:
> =smfstrExtr(smfGetTagContent("https://www.earningswhispers.com/stocks/"&B1,"div",-1,"ewtip
> icon"),"-","~") but all I get in the cell is a blank.
>
> Here is where the string is located:
>
> <div id="whisperbox" class="topbox"><div class="boxhead">Earnings Whisper ®</div><div class="mainitem">N/A</div><div id="qtrend">3rd Quarter September 2015</div><div id="consensus">Consensus:  $1.41</div><div id="revest">Revenue:  $1.66 Bil</div></div> <div id="datebox" class="topbox"><div class="boxhead">Wednesday</div><div id="epsconfirmed" title="We last confirmed the release date with the company on Thursday, October 08, 2015" class="ewtip icon-checkmark color-yes"></div><div class="mainitem" onclick="location.href='/calendar?d=3&t=all'">Oct 21</div><div id="earningstime">7:00 AM ET</div><a id="ical" class="icon-addcalendar ewtip" href="webcal://beta.earningswhispers.com/jsdata/ical.aspx?symbol=ABG" title="add to your calendar"></a></div>
>
>
>

Sun Oct 18, 2015 7:08 pm (PDT) . Posted by:

sirons1962

Thanks Randy not only for the things to try but the education that goes alone with your reponses!

That works to get what I needed to make the cells show a confirmed or not confirmed status.


Regards,

Steve

Sun Oct 18, 2015 6:31 pm (PDT) . Posted by:

onetrickpony_1990

Hey Guys.


I use the SMF add-in since half a year now and I am quite happy!
Yesterday I updated my stockscreener and suddenly loads of symbols turned out as "error". Then I checked a fiew independently and was really surprised that Ticker symbols like "IBM" "MSFT" and "KO" gave me an "Error" when I requested the trailing P/E.
So I downloaded the latest version of SMF and there you go: it works for them now. But now the suprising fact: Before the update I got the P/E from e.g. "BMW.DE", but now after the update it gives me an Error for this stock.


I am confused and would be grateful if someone can help me!


Kind regards

Sun Oct 18, 2015 6:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'll assume you were using element #943?

If so, it appears to be working now for all the ticker symbols you mention.
My assumption is that Yahoo was doing some updating over the weekend and
the Key Statistics web pages weren't available...

On Sun, Oct 18, 2015 at 5:13 PM, onetrickpony_1990@...wrote:

> I use the SMF add-in since half a year now and I am quite happy!
>
> Yesterday I updated my stockscreener and suddenly loads of symbols turned
> out as "error". Then I checked a fiew independently and was really
> surprised that Ticker symbols like "IBM" "MSFT" and "KO" gave me an "Error"
> when I requested the trailing P/E.
>
> So I downloaded the latest version of SMF and there you go: it works for
> them now. But now the suprising fact: Before the update I got the P/E from
> e.g. "BMW.DE", but now after the update it gives me an Error for this
> stock.
>
> I am confused and would be grateful if someone can help me!
>
>

Mon Oct 19, 2015 1:17 am (PDT) . Posted by:

onetrickpony_1990

Hey Randy.

Thanks for the fast reply!
It still doesn't work for several stocks... also BMW.DE still does not work.
and now it appears that Bloomberg is doing some changes on their websites as well.
What a mess ! :-(


Any suggestions?

Mon Oct 19, 2015 12:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. BMW.DE is working here.

You may need to either (or both):

1. Run the smfForceRecalculation macro. The add-in saves a copy of the web
page before it extracts data from it. If you're still trying to extract it
from a previously saved copy of the web page that gave you "Error", you'll
still get "Error". The smfForceRecalculation macro purges all saved web
pages and gets a fresh copy.

2. The MicroSoft Internet engine may be returning a cached copy of the web
page. You should have your Internet Options set to always get a fresh copy
of the web page when you visit them.

On Mon, Oct 19, 2015 at 1:17 AM, onetrickpony_1990@...wrote:

>
> Hey Randy.
>
> Thanks for the fast reply!
> It still doesn't work for several stocks... also BMW.DE still does not
> work.
> and now it appears that Bloomberg is doing some changes on their websites as
> well.
> What a mess ! :-(
>
> Any suggestions?
>

Sun Oct 18, 2015 7:20 pm (PDT) . Posted by:

sirons1962

Using =RCHGetYahooQuotes(ticker,"x") most stocks are now coming back as either NYQ or NMS instead of Nasdaq or NYSE. Did they possibly change something at Yahoo?

Regards,

Steve



Sun Oct 18, 2015 7:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not in a position to confirm or deny, but seems like a good guess.

The big question is whether it's temporary or permanent.

On Sun, Oct 18, 2015 at 7:20 PM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Using =RCHGetYahooQuotes(ticker,"x") most stocks are now coming back as
> either NYQ or NMS instead of Nasdaq or NYSE. Did they possibly change
> something at Yahoo?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar