5 Messages
Digest #4386
Messages
Tue Aug 28, 2018 12:06 am (PDT) . Posted by:
johnross999
When using the smfGetOptionStrikes function to retrieve the PUT options strikes for AAPL 18 April 2019 expiry the function is retrieving the CALL options instead!
=smfGetOptionStrikes("AAPL","18/04/19","P","Y")
Picture attached
Tx
=smfGetOptionStrike
Picture attached
Tx
Attachment(s) from
1 of 1 Photo(s)
Tue Aug 28, 2018 12:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
As written, it just grabs the call strike prices.
The "P" parameter doesn't specify which strikes to retrieve. It specifies
the type of ticker symbols to create if they are requested.
Not sure what to do there...
On Tue, Aug 28, 2018 at 12:06 AM johnrr9@
....
wrote:
>
> When using the smfGetOptionStrikes function to retrieve the PUT options
> strikes for AAPL 18 April 2019 expiry the function is retrieving the CALL
> options instead!
>
> =smfGetOptionStrikes("AAPL","18/04/19","P","Y")
>
>
>
The "P" parameter doesn't specify which strikes to retrieve. It specifies
the type of ticker symbols to create if they are requested.
Not sure what to do there...
On Tue, Aug 28, 2018 at 12:06 AM johnrr9@
....
wrote:
>
> When using the smfGetOptionStrikes function to retrieve the PUT options
> strikes for AAPL 18 April 2019 expiry the function is retrieving the CALL
> options instead!
>
> =smfGetOptionStrike
>
>
>
Tue Aug 28, 2018 12:58 am (PDT) . Posted by:
johnross999
Hmmm, can you recommend other function that can retrieve the whole Calls and Puts strikes?
Tx.
Tx.
Tue Aug 28, 2018 1:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but Yahoo is now the only source being used by the
function...Google, OptionsXPress, and 888 are all gone now as sources of
option quotes data.
I don't think it would take much to parse out a separate call or put list,
but the issue is the parameter. Right now, the processing defaults to
extracting call strike prices (with the bad assumption that puts would
match), but the parameter defaults to "P" for outputting symbols. So, if I
require a "C" for call strikes, anyone using the current default would get
the wrong strike prices...
On Tue, Aug 28, 2018 at 12:58 AM johnrr9@
....
wrote:
>
> Hmmm, can you recommend other function that can retrieve the whole Calls
> and Puts strikes?
>
>
function...Google, OptionsXPress, and 888 are all gone now as sources of
option quotes data.
I don't think it would take much to parse out a separate call or put list,
but the issue is the parameter. Right now, the processing defaults to
extracting call strike prices (with the bad assumption that puts would
match), but the parameter defaults to "P" for outputting symbols. So, if I
require a "C" for call strikes, anyone using the current default would get
the wrong strike prices...
On Tue, Aug 28, 2018 at 12:58 AM johnrr9@
....
wrote:
>
> Hmmm, can you recommend other function that can retrieve the whole Calls
> and Puts strikes?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar