Sabtu, 03 September 2016

[smf_addin] Digest Number 3788

14 Messages

Digest #3788
1b
Re: Request for data field from Yahoo Finstats by "Randy Harmelink" rharmelink
1e
Re: Request for data field from Yahoo Finstats by "Randy Harmelink" rharmelink
1f
Re: Request for data field from Yahoo Finstats by "Randy Harmelink" rharmelink
1i
Re: Request for data field from Yahoo Finstats by "Randy Harmelink" rharmelink
2a
2b
Re: Missing Option price by "Randy Harmelink" rharmelink
2d
Re: Missing Option price by "Randy Harmelink" rharmelink

Messages

Fri Sep 2, 2016 4:28 am (PDT) . Posted by:

mokwit

Randy,

Respectful and grateful request:

Would it be possible to add a Smf field for 'Adjustments To Net Income' from the Yahoo Cash Flow from Operations (next item down after 'depreciation' - see below). It might not be in all cases, but for some this represents a breakout of stock option expense which is generally not broken out as a line item in the Income statement. I am thinking it would be useful in looking at a few things - just the last FY or TTM number would be OK if last 3 years or quarterlies is a bit much to ask.

I could not find Stock Option expense broken out as a line item with ADvFN, if it is there or another data source has it please advise.

* whatever matches time period in Yahoo Key statistics excel template for e.g Revenue, Net Income

PFPT Cash Flow | Proofpoint, Inc. Stock - Yahoo! Canada Finance https://ca.finance.yahoo.com/q/cf?s=PFPT&annual



PFPT Cash Flow | Proofpoint, Inc. Stock - Yahoo! Canada Finance https://ca.finance.yahoo.com/q/cf?s=PFPT&annual Understand the cash flow statement for Proofpoint, Inc. (PFPT), learn where the money comes from and how the company spends it.



View on ca.finance.yahoo.com https://ca.finance.yahoo.com/q/cf?s=PFPT&annual
Preview by Yahoo




Fri Sep 2, 2016 5:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

At this point, I'm not doing anything with Yahoo Financial Statements.
Since they changed the structure of the web page, it's nearly impossible to
parse anything out. The current template is still working, because it's
accessing old pages that are similar to the Canadian site. But I'm not sure
how much longer those deprecated web pages will continue to exist (or to be
updated).

You can extract it from the Canadian site, as it is right now, with
something like:

=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=PFPT&annual",1,"Period
Ending","Adjustments To Net Income",,,,"Add to Portfolio")

You could get the data from GuruFocus. It has a line item called "Stock
Based Compensation". The above value could be retrieved from GuruFocus with:

=smfGetGuruFocusItem("PFPT",114,"A",0)

GuruFocus is my preferred source of data right now. So much so, I even
subscribed so premium data would be available.

On Fri, Sep 2, 2016 at 4:28 AM, pmanz@usa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Randy,
>
> Respectful and grateful request:
>
> Would it be possible to add a Smf field for 'Adjustments To Net Income'
> from the Yahoo Cash Flow from Operations (next item down after
> 'depreciation' - see below). It might not be in all cases, but for some
> this represents a breakout of stock option expense which is generally not
> broken out as a line item in the Income statement. I am thinking it would
> be useful in looking at a few things - just the last FY or TTM number would
> be OK if last 3 years or quarterlies is a bit much to ask.
>
> I could not find Stock Option expense broken out as a line item with
> ADvFN, if it is there or another data source has it please advise.
>
> * whatever matches time period in Yahoo Key statistics excel template for
> e.g Revenue, Net Income
>
> PFPT Cash Flow | Proofpoint, Inc. Stock - Yahoo! Canada Finance
> <https://ca.finance.yahoo.com/q/cf?s=PFPT&annual>
>

Fri Sep 2, 2016 6:10 pm (PDT) . Posted by:

mokwit

=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=PFPT&annual https://ca.finance.yahoo.com/q/cf?s=PFPT&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to Portfolio")

Randy, the above works for PFPT but I am having trouble with syntax to allow a cell reference e.g. B2 in place of ticker

Fri Sep 2, 2016 6:11 pm (PDT) . Posted by:

mokwit

Forgot to mention I get "error" with guru focus string.

Fri Sep 2, 2016 6:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's just normal EXCEL concatenation -- you have three strings to
concatenate:

"https://ca.finance.yahoo.com/q/cf?s="
B2
"&annual"

So:

=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & B2 &
"&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to
Portfolio")

On Fri, Sep 2, 2016 at 6:10 PM, pmanz@
​...wrote:

>
> =
> ​​
> RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=PFPT&annual",1,"Period
> Ending","Adjustments To Net Income",,,,"Add to Portfolio")
>
> Randy, the above works for PFPT but I am having trouble with syntax to
> allow a cell reference e.g. B2 in place of ticker
>
>

Fri Sep 2, 2016 6:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. What version of the add-in are you using?

=RCHGetElementNumber("Version")

On Fri, Sep 2, 2016 at 6:11 PM, pmanz@usa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Forgot to mention I get "error" with guru focus string.
>
>

Fri Sep 2, 2016 6:32 pm (PDT) . Posted by:

mokwit

Stock Market Functions add-in, Version 2.1.2016.06.20 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 5.01; 11.0; www; Local; 1)

Fri Sep 2, 2016 7:11 pm (PDT) . Posted by:

mokwit

Randi, now working Ok with your string example. many thanks - missed reply because of strange Yahoo web board behaviour

Fri Sep 2, 2016 7:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Wow. Talk about timing. It was working when I sent you the email earlier.
Not any longer. Turns out they made some changes to the web pages, so I had
to change my extraction code in the add-in.

I just uploaded version 2016.09.02 of the add-in, with the necessary coding
changes.

On Fri, Sep 2, 2016 at 6:11 PM, pmanz@
​...wrote:

>
> Forgot to mention I get "error" with guru focus string.
>
>

Fri Sep 2, 2016 2:01 pm (PDT) . Posted by:

jdsboston

Does anyone have an idea why the following formula is not returning a price:


=smfGetGoogleOptionQuote( "X", "P","11/18/2016",20, "a")



Also I don't get a bid price when specifying "b" in this formula.


Thanks for any help!


Fri Sep 2, 2016 2:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see any "X" options with a November expiration date on Google.

https://www.google.com/finance/option_chain?q=X

On Fri, Sep 2, 2016 at 12:32 PM, jschantz@
​...wrote:

> Does anyone have an idea why the following formula is not returning a
> price:
>
> =
> ​​
> smfGetGoogleOptionQuote( "X", "P","11/18/2016",20, "a")
>
> Also I don't get a bid price when specifying "b" in this formula.
>
>

Fri Sep 2, 2016 3:11 pm (PDT) . Posted by:

jdsboston

X is US Steel and there are about 15 calls and 15 puts actively traded for November 18, 2016 expiration. I currently hold one of them: X161118P00020000. This formula works to retrieve the symbol:
=smfGetGoogleOptionQuote( "X", "P","11/18/2016",20, "z")

Is there any reason Google wouldn't have actively traded options on their site?

Fri Sep 2, 2016 6:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They've been spotty in the past. I don't use them any more because of that.

The "z" data item is the ticker quote symbol the add-in creates to search
the Google option quotes data. So it does that without even getting any
data from the Internet.

On Fri, Sep 2, 2016 at 3:11 PM, jschantz@
​...wrote:

>
> X is US Steel and there are about 15 calls and 15 puts actively traded for
> November 18, 2016 expiration. I currently hold one of them:
> X161118P00020000. This formula works to retrieve the symbol:
> =smfGetGoogleOptionQuote( "X", "P","11/18/2016",20, "z")
>
> Is there any reason Google wouldn't have actively traded options on their
> site?
>

Fri Sep 2, 2016 7:47 pm (PDT) . Posted by:

rharmelink

I just uploaded version 2016.09.02 of the add-in to the web site:

http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/

Because GuruFocus made changes to their web pages, I had to change the extraction process I had hard-coded in the add-in.




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar