4 Messages
Digest #3111
Messages
Thu Jul 3, 2014 10:35 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Sorry, I'm stumped, again.
Gurufocus, again.
Ticker: QCOR, 10-Y Financials page. Looking at Revenue and a couple others
like EPS (Diluted). I can get data just fine for all the columns except the
TTM column. It comes back zero, even though there's a number there.
And I haven't noticed it on other tickers, although there may be some that
do this. I usually pull the TTM column all the time, as well as the previous
5 years.
You mind taking a look behind the secret curtain and telling me what's going
on with this?
Thanks,
Jim
=RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fisc
al Period",">Revenue<") Getting 0.00 instead of 890.90
(where F44 = 0 for the TTM)
Same for:
=RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fisc
al Period",">EPS (Diluted)") Getting 0.00 instead of 5.28
Sorry, I'm stumped, again.
Gurufocus, again.
Ticker: QCOR, 10-Y Financials page. Looking at Revenue and a couple others
like EPS (Diluted). I can get data just fine for all the columns except the
TTM column. It comes back zero, even though there's a number there.
And I haven't noticed it on other tickers, although there may be some that
do this. I usually pull the TTM column all the time, as well as the previous
5 years.
You mind taking a look behind the secret curtain and telling me what's going
on with this?
Thanks,
Jim
=RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fisc
al Period",">Revenue<") Getting 0.00 instead of 890.90
(where F44 = 0 for the TTM)
Same for:
=RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),"
al Period"
Thu Jul 3, 2014 10:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like a temporary glitch on the part of GuruFocus. I just went to:
http://www.gurufocus.com/financials/QCOR
...and the entire column for "TTM" shows "--", on every single line item.
Which is why you're getting the zero. The page you're looking at in the
browser must have been brought up before the glitch, while the page
retrieved by the add-in was after the glitch. Until the glitch is fixed,
you should get zeroes.
Hmmm. Interesting. I just checked a few other tickers -- MMM and IBM -- and
they do have numbers in the "TTM" column. Just not QCOR. Strange.
On Thu, Jul 3, 2014 at 10:35 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Sorry, I'm stumped, again.
>
>
>
> Gurufocus, again.
>
> Ticker: QCOR, 10-Y Financials page. Looking at Revenue and a couple others
> like EPS (Diluted). I can get data just fine for all the columns except the
> TTM column. It comes back zero, even though there's a number there.
>
> And I haven't noticed it on other tickers, although there may be some that
> do this. I usually pull the TTM column all the time, as well as the
> previous 5 years.
>
>
>
> You mind taking a look behind the secret curtain and telling me what's
> going on with this?
>
>
>
> Thanks,
>
> Jim
>
>
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fiscal
> Period",">Revenue<") Getting 0.00 instead of 890.90
>
> (where F44 = 0 for the TTM)
>
> Same for:
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fiscal
> Period",">EPS (Diluted)") Getting 0.00 instead of 5.28
>
>
>
>
>
>
>
http://www.gurufocus.com/financials/QCOR
...and the entire column for "TTM" shows "--", on every single line item.
Which is why you're getting the zero. The page you're looking at in the
browser must have been brought up before the glitch, while the page
retrieved by the add-in was after the glitch. Until the glitch is fixed,
you should get zeroes.
Hmmm. Interesting. I just checked a few other tickers -- MMM and IBM -- and
they do have numbers in the "TTM" column. Just not QCOR. Strange.
On Thu, Jul 3, 2014 at 10:35 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Sorry, I'm stumped, again.
>
>
>
> Gurufocus, again.
>
> Ticker: QCOR, 10-Y Financials page. Looking at Revenue and a couple others
> like EPS (Diluted). I can get data just fine for all the columns except the
> TTM column. It comes back zero, even though there's a number there.
>
> And I haven't noticed it on other tickers, although there may be some that
> do this. I usually pull the TTM column all the time, as well as the
> previous 5 years.
>
>
>
> You mind taking a look behind the secret curtain and telling me what's
> going on with this?
>
>
>
> Thanks,
>
> Jim
>
>
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),">Fiscal
> Period",">Revenue<") Getting 0.00 instead of 890.90
>
> (where F44 = 0 for the TTM)
>
> Same for:
>
> =RCHGetTableCell("http://www.gurufocus.com/financials/QCOR,(11-$F$44),"
> Period"
>
>
>
>
>
>
>
Thu Jul 3, 2014 11:40 am (PDT) . Posted by:
sihlai
When using smfGetOptionQuotes and "Y" operator to obtain option quotes from Yahoo, longer dated options such as those in Jan of 2016 shows up as "Error". Any idea the reason for this?
Thu Jul 3, 2014 1:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Since you didn't give specific examples, I can only make guesses. Two
possibilities come to mind:
1. Yahoo isn't carrying the data.
2. The January, 2016 options have a non-traditional expiration, so if
you're using "Jan 2016", it won't work. You'll need to specify the
expiration date, such as "1/15 2016"
On Thu, Jul 3, 2014 at 11:40 AM, sihlai@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> When using smfGetOptionQuotes and "Y" operator to obtain option quotes
> from Yahoo, longer dated options such as those in Jan of 2016 shows up as
> "Error". Any idea the reason for this?
>
possibilities come to mind:
1. Yahoo isn't carrying the data.
2. The January, 2016 options have a non-traditional expiration, so if
you're using "Jan 2016", it won't work. You'll need to specify the
expiration date, such as "1/15 2016"
On Thu, Jul 3, 2014 at 11:40 AM, sihlai@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> When using smfGetOptionQuotes and "Y" operator to obtain option quotes
> from Yahoo, longer dated options such as those in Jan of 2016 shows up as
> "Error"
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar