2 Messages
Digest #3588
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?
>
>
=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:
Posting Komentar