Selasa, 28 Oktober 2014

[smf_addin] Digest Number 3223

4 Messages

Digest #3223
1a
Calls on BRK-B by bob_15861586
1b
Re: Calls on BRK-B by "Randy Harmelink" rharmelink
1c
Re: Calls on BRK-B by bob_15861586
1d
Re: Calls on BRK-B by "Randy Harmelink" rharmelink

Messages

Mon Oct 27, 2014 7:11 am (PDT) . Posted by:

bob_15861586

Randy,


I am still having problems related to BRK-B. The following is not working for me:
=smfGetOptionQuotes("BRKB Jan 2015 $120 Call","5",,"OX")
Is this to be expected? I also tried it with BRK-B and BRK.B.


Bob

Mon Oct 27, 2014 7:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I only fixed unusual ticker symbols with hyphens and uptickes for Yahoo. OX
uses BRK/B as the equity symbol, but BRKB on the contracts. To tell the
truth, I'm not feeling inclined to fix all of the routines for every
special type of ticker symbol -- especially since I'd end up doing them one
at a time, as they are discovered.

On Mon, Oct 27, 2014 at 7:11 AM, bob_15861586@...wrote:

> I am still having problems related to BRK-B. The following is not
> working for me:
>
> =smfGetOptionQuotes("BRKB Jan 2015 $120 Call","5",,"OX")
>
> Is this to be expected? I also tried it with BRK-B and BRK.B.
>
>

Mon Oct 27, 2014 10:33 am (PDT) . Posted by:

bob_15861586

Thanks for the response. However, this is not working either: =smfGetOptionQuotes("BRK/B Jan 2015 $115 Call","5",,"OX")


If this is something that your product does not support, I understand.


Bob

Mon Oct 27, 2014 11:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Here's a work-around (basically the call the smfGetOptionQuotes() function
should be doing):

=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=0&lstMarket=0&ChainType=3&lstMonths=
"&TEXT(E8,"m/d/yyyy")&";1&Symbol="&E7,-6,LEFT(SUBSTITUTE(E7,"/","")&"^^^^^^",6)&TEXT(E8,"yymmdd")&"C"&TEXT(1000*E10,"00000000"))

...where E7 is ticker symbol, E8 is expiration date, E10 is strike price,
and the "-6" is a hard-coded pointer to the Delta column.

On Mon, Oct 27, 2014 at 10:33 AM, bob_15861586@...wrote:

>
> Thanks for the response. However, this is not working either:
> =smfGetOptionQuotes("BRK/B Jan 2015 $115 Call","5",,"OX")
>
> If this is something that your product does not support, I understand.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar