14 Messages
Digest #3788
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
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>
>
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
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
>
>
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,"
> Ending"
>
> 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.
>
>
=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.
>
>
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!
=smfGetGoogleOption
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.
>
>
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:
>
> =
>
> smfGetGoogleOptionQ
>
> 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?
=smfGetGoogleOption
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?
>
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:
> =smfGetGoogleOption
>
> 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.
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:
Posting Komentar