Kamis, 06 Oktober 2016

[smf_addin] Digest Number 3812

4 Messages

Digest #3812
1a
1b
Re: Dividends included by "Randy Harmelink" rharmelink
2a
Index Calls by bob_15861586
2b
Re: Index Calls by "Randy Harmelink" rharmelink

Messages

Wed Oct 5, 2016 9:19 am (PDT) . Posted by:

ehstats

I see in prior messages that the smfpricesbydates function includes dividends. I assume that the function is subject to Yahoo Finance updating the data. I have GIREX that payed a dividend on 9/30 of 0.35, but Yahoo Finance doesn't show that dividend. Does that mean the SMF price will not be adjusted for the dividend until Yahoo Finance updates the data?

Wed Oct 5, 2016 12:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Correct. The data being retrieved by the add-in will be what Yahoo
provides, and the Yahoo data is currently incorrect. The fund went
ex-dividend on 9/23, and I don't see any difference between the closing
price and the adjusted closing price prior to that date.

On Wed, Oct 5, 2016 at 9:19 AM, ericstats@
​...wrote:

> I see in prior messages that the smfpricesbydates function includes
> dividends. I assume that the function is subject to Yahoo Finance updating
> the data. I have GIREX that payed a dividend on 9/30 of 0.35, but Yahoo
> Finance doesn't show that dividend. Does that mean the SMF price will not
> be adjusted for the dividend until Yahoo Finance updates the data?
>
>

Wed Oct 5, 2016 5:51 pm (PDT) . Posted by:

bob_15861586

I was expecting the following to produce a quote on the SPX put at 1775 with an expiration of March 31, 2017.
=smfGetOptionQuotes("SPX 3/31 2017 $1775 Put","A",,"OX2")
However, I get an Error. What am I doing wrong? The following does work:
=smfGetOptionQuotes("SPX 1/20 2017 $1500 Put","A",,"OX2")


Thanks
Bob

Wed Oct 5, 2016 5:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Nope, because SPX is not a valid ticker symbol on Yahoo.

What web page are you seeing the put and call options on?

On Wed, Oct 5, 2016 at 5:51 PM, bob_15861586@
​...wrote:

> I was expecting the following to produce a quote on the SPX put at 1775
> with an expiration of March 31, 2017.
>
> =smfGetOptionQuotes("SPX 3/31 2017 $1775 Put","A",,"OX2")
>
> However, I get an Error. What am I doing wrong? The following does work:
>
> =smfGetOptionQuotes("SPX 1/20 2017 $1500 Put","A",,"OX2")
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar