Kamis, 02 Juli 2015

[smf_addin] Digest Number 3447[1 Attachment]

11 Messages

Digest #3447

Messages

Wed Jul 1, 2015 9:48 am (PDT) . Posted by:

alberto.ratti

I couldn't deploy smfGetOptionQuotes function, under different settings.
Even the template instruction from DOCUMENTATION (shortened to "Bid price") gets ERROR:
=smfGetOptionQuotes("SPY 12/19 2015 $190 Call","b")

What's wrong, from me of course?
Thanks a lot!
Alberto



Attachment(s) from
1 of 1 File(s)

Wed Jul 1, 2015 10:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I tried your formula here, and it works fine. I opened your attachment, and
it worked fine as well. As they should, they're the same thing.

It's possible you retrieved a bad web page from Yahoo. If so, running the
smfForceRecalculation might fix the problem.

Or, you may have a bad web page cached by Internet Explorer. Make sure your
Internet Options are set up to always get a new copy of a web page each
time the web page is visited.

Lastly, you may need to be running the beta version of the add-in. There
were several sets of changes necessary while Yahoo was changing the format
of their option quotes pages.

One thing I found interesting was that Yahoo had different bid prices for
that call on these pages under FireFox:

http://finance.yahoo.com/q/op?s=SPY&strike=190.00
http://finance.yahoo.com/q/op?s=SPY&date=1450483200
http://finance.yahoo.com/q?s=SPY151219C00190000

On Wed, Jul 1, 2015 at 9:48 AM, alberto.ratti@tin.it [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I couldn't deploy smfGetOptionQuotes function, under different settings.
>
> Even the template instruction from DOCUMENTATION (shortened to "Bid
> price") gets ERROR:
>
> =smfGetOptionQuotes("SPY 12/19 2015 $190 Call","b")
>
> What's wrong, from me of course?
>
>

Wed Jul 1, 2015 12:56 pm (PDT) . Posted by:

alberto.ratti

Thanks a lot for your fast, and accurate diagnosis (as usual).
I think the problem arises from the add-in version.
I will work it around asap.




Wed Jul 1, 2015 3:28 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Your attachment worked for me after I change the SMF ADDIN links to my location for the addin.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, July 01, 2015 12:48 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] ERROR from smfGetOptionQuotes function [1 Attachment]

[Attachment(s) from alberto.ratti@tin.it [smf_addin] included below]

I couldn't deploy smfGetOptionQuotes function, under different settings.
Even the template instruction from DOCUMENTATION (shortened to "Bid price") gets ERROR:
=smfGetOptionQuotes("SPY 12/19 2015 $190 Call","b")
What's wrong, from me of course?
Thanks a lot!
Alberto



Wed Jul 1, 2015 11:11 am (PDT) . Posted by:

cariley2000@ymail.com

I have been using this function with code a2 to collect Average Daily Volume.


I have noticed that it pulls the correct volume for US stocks such as IBM, but it is incorrect for the UK stocks I am looking at e.g. CNKS.L or CLIG.L.


I tried changing the server ID to "UK" but this still doesn't work.


Is there any way to get RchGetYahooQuotes to pull the correct average daily volume for UK Stocks?

Wed Jul 1, 2015 11:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "server ID" parameter is no longer valid. I keep it around in case
Yahoo changes their mind and goes back to individual servers.

As long as Yahoo sends incorrect data in the CSV file, there's not really
anything that RCHGetYahooQuotes() can do to fix it. The add-in just reports
what it's sent.

On Wed, Jul 1, 2015 at 10:37 AM, cariley2000@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have been using this function with code a2 to collect Average Daily
> Volume.
>
> I have noticed that it pulls the correct volume for US stocks such as IBM,
> but it is incorrect for the UK stocks I am looking at e.g. CNKS.L or
> CLIG.L.
>
> I tried changing the server ID to "UK" but this still doesn't work.
>
> Is there any way to get RchGetYahooQuotes to pull the correct average
> daily volume for UK Stocks?
>
>

Wed Jul 1, 2015 12:21 pm (PDT) . Posted by:

cariley2000@ymail.com

Hi Randy,

Do you know why the AVG Vol would be correct for US stocks, but wrong for UK.


If we look at CNKS.L, Yahoo is reporting the correct AVG volume on the summary screen- but the number in the CSV is different.


Is there any way I can access the CSV file that Yahoo is sending to investigate further?


Regards,
Chris






Wed Jul 1, 2015 1:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you go to the summary page:

http://finance.yahoo.com/q?s=CNKS.L

...you'll notice a link on the lower right ("Download data (delayed)").
That is the basis of the CSV file. The link looks like this:

http://download.finance.yahoo.com/d/quotes.csv?s=CNKS.L&f=sl1d1t1c1ohgv&e=.csv

The "&f" parameter is the set of Yahoo codes. If you just want the average
volume, you'd use:

http://download.finance.yahoo.com/d/quotes.csv?s=CNKS.L&f=a2&e=.csv

Oddly enough, that appears to be correct right now. Was your problem a
temporary issue? I know I was getting a much different result when I looked
at it this morning.

On Wed, Jul 1, 2015 at 12:21 PM, cariley2000@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Do you know why the AVG Vol would be correct for US stocks, but wrong for
> UK.
>
> If we look at CNKS.L, Yahoo is reporting the correct AVG volume on the
> summary screen- but the number in the CSV is different.
>
> Is there any way I can access the CSV file that Yahoo is sending to
> investigate further?
>
>
>

Wed Jul 1, 2015 1:52 pm (PDT) . Posted by:

cariley2000@ymail.com

Hi Randy,

It's now working. Great.


Thanks for your time,
Chris

Wed Jul 1, 2015 1:03 pm (PDT) . Posted by:

DefelRadar


Randy,

First I want to thank you for your great add-in and all the information it puts at our finger tips! I do have a question about how/when the Piotroski Scores are update/calculated. He's my example:
Stock Symbol HNI
Last week (6/26/15) the Piotroski Score for it was a 8.
This week (7/1/15) the Piotroski Score for it was a 7.

The change in score was due to an increase in outstanding shares of stock for HNI.

I dug though your elements files and found you calculated all your Piotroski scores. Then I dug through the VB code and found you calculated the Piotroski scores from the Advfn site.

Case "Piotroski 7 (No increase in outstanding shares)"
n1 = RCHGetElementNumber(pTicker, 8066) ' FQ1, Ending Quarter
If n1 = 4 Then
n2 = RCHGetElementNumber(pTicker, 6646) ' FY1, Total Common Shares Out
n3 = RCHGetElementNumber(pTicker, 6647) ' FY2, Total Common Shares Out
Else
n2 = RCHGetElementNumber(pTicker, 10906) ' FQ1, Total Common Shares Out
n3 = RCHGetElementNumber(pTicker, 6646) ' FY1, Total Common Shares Out
End If

So then I decided to look to see when the most recent fiscal year data and most recent quarter data was loaded in on ADVFN's site.

I found the most recent fiscal year was loaded on 03/09/15 and the most recent quarter was loaded on 5/9/15.

HNI does not report its next quarterly earnings until 7/14/15

So I'm trying to figure out if the data did not change of advfn how the P-Score was changed for HNI with in a few days?

Thanks!

Aaron


Wed Jul 1, 2015 1:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just a guess, but if you look at this web page:

http://www.advfn.com/stock-market/NYSE/HNI/financials?btn=quarterly_reports&mode=company_data

...you'll see:

quarter end date2014/032014/062014/092014/122015/03 date preliminary data
loaded4/18/20156/27/20156/27/20156/27/20155/9/2015 total common shares out
45.14544.444.244.5
...so there is a reported increase in shares outstanding. However, the 6/27
dates above bother me, since they would be after your 6/26 check. But the
shares outstanding comparison would have been to the annual financials,
which appear to have an old "date loaded" value. So not sure if those new
dates are relevant to a shares outstanding comparison?

However, are you sure this is where it lost a Piotroski point? If the
quarterly values of 2nd, 3rd, and 4th quarter of last year have apparently
been restated, as of 6/27, it could be one of the other Piotroski points
was lost because of a change in the quarterly values used in computing them?

Oddly enough, GuruFocus calculates Piotroski as a 6. They have a
comprehensive historical reporting as well:

http://www.gurufocus.com/term/fscore/NYSE:HNI/Piotroski%2BF-Score/HNI+Corp

However, their calculation of shares outstanding is always based on a
fiscal TTM change, while I chose to implement it as a fiscal YTD change. If
I remember correctly, Piotroski ONLY used annual financial statements.

Note that on the table I cite above, a fiscal TTM change would show shares
dropping, from 45.1 to 44.5...

I haven't done any formal comparison to GuruFocus calculations and/or
values.

Aren't financial manipulations fun!?? :)

Long story short -- I'm pretty sure the 6/27 reloads of data had something
to do with the change in value.

On Wed, Jul 1, 2015 at 1:02 PM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> First I want to thank you for your great add-in and all the information it
> puts at our finger tips! I do have a question about how/when the Piotroski
> Scores are update/calculated. He's my example:
>
> Stock Symbol HNI
>
> Last week (6/26/15) the Piotroski Score for it was a 8.
>
> This week (7/1/15) the Piotroski Score for it was a 7.
>
> The change in score was due to an increase in outstanding shares of stock
> for HNI.
>
> I dug though your elements files and found you calculated all your
> Piotroski scores. Then I dug through the VB code and found you calculated
> the Piotroski scores from the Advfn site.
>
> Case "Piotroski 7 (No increase in outstanding shares)"
> n1 = RCHGetElementNumber(pTicker, 8066) ' FQ1, Ending
> Quarter
> If n1 = 4 Then
> n2 = RCHGetElementNumber(pTicker, 6646) ' FY1, Total
> Common Shares Out
> n3 = RCHGetElementNumber(pTicker, 6647) ' FY2, Total
> Common Shares Out
> Else
> n2 = RCHGetElementNumber(pTicker, 10906) ' FQ1, Total
> Common Shares Out
> n3 = RCHGetElementNumber(pTicker, 6646) ' FY1, Total
> Common Shares Out
> End If
>
> So then I decided to look to see when the most recent fiscal year data
> and most recent quarter data was loaded in on ADVFN's site.
>
> I found the most recent fiscal year was loaded on 03/09/15 and the most
> recent quarter was loaded on 5/9/15.
>
> HNI does not report its next quarterly earnings until 7/14/15
>
> So I'm trying to figure out if the data did not change of advfn how the
> P-Score was changed for HNI with in a few days?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.11

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)