Rabu, 23 Desember 2015

[smf_addin] Digest Number 3588

2 Messages

Digest #3588
1a
Option Prices by tomknorring
1b
Re: Option Prices by "Randy Harmelink" rharmelink

Messages

Tue Dec 22, 2015 1:11 pm (PST) . Posted by:

tomknorring

Any idea how to load option quotes & prices into Excel?

Tue Dec 22, 2015 1:19 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just use the smfGetOptionQuotes() function. For example:

=smfGetOptionQuotes("SPY 12/24 2015 $200 Call ,SPY 12/24 2015 $200
Put","ba")

...would get the "b"id and "a"sk prices on those two contracts. Or, those
text strings could be put into cells and referred to as ranges, with
something like:

=smfGetOptionQuotes(A3:A4,B1:C1)

See the function documentation for more details and additional parameters.

On Tue, Dec 22, 2015 at 2:07 PM, tomknorring@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Any idea how to load option quotes & prices into Excel?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar