Selasa, 23 Desember 2014

[smf_addin] Digest Number 3272

5 Messages

Digest #3272

Messages

Mon Dec 22, 2014 7:19 pm (PST) . Posted by:

shtravis

Is there a way to retrieve PUT option prices beyond the front month?







For the bid on the JAN 2015 CZR 15 Put


These work and return 1.75


=smfGetOptionQuotes("CZR Jan 2015 $15 Put","b")



=smfGetYAHOOOptionQuote("CZR","P",DATE(2015,1,1),15,"b")



----------------------------------------------------------


For the bid on the MAR 2015 CZR 15 Put



These return "Error"


=smfGetOptionQuotes("CZR Mar 2015 $15 Put","b")



=smfGetYAHOOOptionQuote("CZR","P",DATE(2015,3,1),15,"b")



Yahoo itself works:


CZR Mar 2015 16.000 put (CZR150320P00016000) -OPR  Watchlist

3.59 0.00(0.00%) 3:53PM EST








Prev Close: 5.30 Open: 3.50 Bid: 3.00 Ask: 3.70 Strike: 16.00 Expire Date: 20-Mar-15






Mon Dec 22, 2014 7:34 pm (PST) . Posted by:

shtravis

Just checked. Same problem with CALL options - front month = Jan 2015 only

Mon Dec 22, 2014 7:40 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sigh. Options are a big issue right now, because:

1. Yahoo changed over to a new format, so I changed the add-in. Then they
backed out the changes. FireFox and Chrome show the new option table
format, but IE (and thus EXCEL and the add-in) currently show the old
option table format. I haven't decided what to do here yet. I'm thinking
that since FireFox and Chrome still have the new format, eventually IE will
as well.

2. MSN recently revamped all of their financial web pages, so none of the
functions that grab data from MSN are working. As it is now, I'll probably
obsolete all functions referencing MSN. Not an issue for you.

3. As of Feb 1, 2015, all monthly option expirations are changing to be
Fridays instead of Saturdays, in order to align them with the weekly
options expirations. This is fixed in my version of the add-in, but it also
has the Yahoo changes that Yahoo backed out.

But, to address your specific issue -- because of (3) above, using the
month (i.e. "Mar 2015" or DATE(2015,3,1)) won't work for the date you want.
The latter hasn't been valid for monthly expirations since weeklies went
in, since the weekly expirations can now fall on the 1st of the month.
Instead, try either:

=smfGetOptionQuotes("CZR 3/20 2015 $15 Put","b")
=smfGetYahooOptionQuote("CZR","P",DATE(2015,3,20),15,"b")

Unfortunately, I can't verify the formulas here, since my version of the
add-in is looking for a different web page layout. *sigh*

On Mon, Dec 22, 2014 at 8:12 PM, shtravis@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Is there a way to retrieve PUT option prices beyond the front month?
>
> For the bid on the JAN 2015 CZR 15 Put
>
> These work and return 1.75
>
> =smfGetOptionQuotes("CZR Jan 2015 $15 Put","b")
>
> =smfGetYAHOOOptionQuote("CZR","P",DATE(2015,1,1),15,"b")
>
>
> ----------------------------------------------------------
>
> For the bid on the MAR 2015 CZR 15 Put
>
> These return "Error"
>
> =smfGetOptionQuotes("CZR Mar 2015 $15 Put","b")
>
> =smfGetYAHOOOptionQuote("CZR","P",DATE(2015,3,1),15,"b")
>
> Yahoo itself works:
>
> CZR Mar 2015 16.000 put (CZR150320P00016000) -OPR  Watchlist
> 3.59 0.00(0.00%) 3:53PM EST
>
> Prev Close:5.30Open:3.50Bid:3.00Ask:3.70Strike:16.00Expire Date:20-Mar-15
>
>
>
>
>
> ------------------------------
>

Mon Dec 22, 2014 8:02 pm (PST) . Posted by:

shtravis

Thanks Randy - understand may be a temporary fix, but my spreadsheet is working again

Tue Dec 23, 2014 1:09 am (PST) . Posted by:

wongkayau

Hi Randy,


Just a follow up on the "SMF-Template-Google-Income-Statement-Tables.xls". It works for ticker "IBM", but does not for HK stocks (e.g. HKG:1043). Could you pls advise me?


Thank you so much.


Cheers,L

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 03.05

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)