2 Messages

Digest #3842

smfGetOptionsQuote-Example_ITM-OTM - More expiration dates? by "Johnny" drolk

Re: smfGetOptionsQuote-Example_ITM-OTM - More expiration dates? by "Randy Harmelink" rharmelink

Messages

1a

smfGetOptionsQuote-Example_ITM-OTM - More expiration dates?

Mon Nov 14, 2016 2:10 am (PST) . Posted by:

"Johnny" drolk

Hello Dear Group,
First of all, I really want to thank you for this group and the efforts put into this Excel add in. I do have a question regarding the option expiration dates for the example template (smfGetOptionsQuote-Example_ITM-OTM). What would I need to do in order to be able to select more expiration dates? For example, for AAPL, I am only able to see the one for 2016-11-18, and then the next available date is 2017-01-20. All the December options were missing. What do I need to do in order to be able to select those dates?
Also I noticed OX, and Y doesn't work anymore but G still works. What does G stand for anyways? :)
Example picture of the excel drop downExample of available dates in Yahoo Finance

Thanks a ton!Johnny

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

1b

Re: smfGetOptionsQuote-Example_ITM-OTM - More expiration dates?

Mon Nov 14, 2016 2:34 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This would get the data from Yahoo:

=smfGetOptionExpirations("AAPL","Y")

...and works fine for me and returns:

2016-11-18
2016-11-25
2016-12-02
2016-12-09
2016-12-16
2016-12-23
2016-12-30
2017-01-20
2017-02-17
2017-03-17
2017-04-21
2017-06-16
2017-07-21
2017-11-17
2018-01-19
2019-01-18

At the moment, that's the same thing "OX" returns. "G" for Google returns a
smaller set of dates, but it does have everything they show on their
website. At the time I wrote the function, Google was more reliable than
Yahoo, so I made it the default source. These days, Google is severely
lacking.

On Mon, Nov 14, 2016 at 2:34 AM, Johnny drolk@
... wrote:

>
> First of all, I really want to thank you for this group and the efforts
> put into this Excel add in. I do have a question regarding the option
> expiration dates for the example template (smfGetOptionsQuote-Example_ITM-OTM).
> What would I need to do in order to be able to select more expiration
> dates? For example, for AAPL, I am only able to see the one for
> 2016-11-18, and then the next available date is 2017-01-20. All the
> December options were missing. What do I need to do in order to be able to
> select those dates?
>
> Also I noticed OX, and Y doesn't work anymore but G still works. What
> does G stand for anyways? :)
>
> Example picture of the excel drop down
> [image: Inline image]
> Example of available dates in Yahoo Finance
>
> [image: Inline image]
>
>
>