[smf_addin] Digest Number 3812

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3812

1a

Dividends included by ehstats

1b

Re: Dividends included by "Randy Harmelink" rharmelink

2a

Index Calls by bob_15861586

2b

Re: Index Calls by "Randy Harmelink" rharmelink

Messages

1a

Dividends included

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?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Dividends included

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?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Index Calls

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Index Calls

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")
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 13

• Privacy • Unsubscribe • Terms of Use