4 Messages
Digest #3223
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
I am still having problems related to BRK-B. The following is not working for me:
=smfGetOptionQuotes
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.
>
>
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@
> I am still having problems related to BRK-B. The following is not
> working for me:
>
> =smfGetOptionQuotes
>
> 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
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.
>
>
should be doing):
=RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=0&lstMarket=0&ChainType=3&lstMonths=
"&TEXT(
...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@
>
> Thanks for the response. However, this is not working either:
> =smfGetOptionQuotes
>
> 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:
Posting Komentar