Selasa, 15 November 2016

[smf_addin] Digest Number 3842

2 Messages

Digest #3842

Messages

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

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]
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar