Sabtu, 05 April 2014

[smf_addin] Digest Number 3032

9 Messages

Digest #3032
1a
Futures Options Qoutes by "Muhamand Wilkes" 506a0b14356aab29d46fcd963b5d7ce2
1b
Re: Futures Options Qoutes by "Randy Harmelink" rharmelink
2b
Re: Google option quotes by "Randy Harmelink" rharmelink
2d
Re: Google option quotes by "Randy Harmelink" rharmelink

Messages

Fri Apr 4, 2014 4:27 am (PDT) . Posted by:

"Muhamand Wilkes" 506a0b14356aab29d46fcd963b5d7ce2

Hello, does anyone know know how to pull futures options quotes? An example
would be greatly appreciated.

V/r,
Mo

Fri Apr 4, 2014 8:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get them from barchart.com -- check out this template in the FILES
area of the Yahoo Group:

RCHGetWebData-Template-BarChart-Quotes-Extract.xls

On Fri, Apr 4, 2014 at 4:27 AM, Muhamand Wilkes
<muhamand.wilkes@gmail.com>wrote:

>
> Hello, does anyone know know how to pull futures options quotes? An
> example would be greatly appreciated.
>

Fri Apr 4, 2014 7:59 am (PDT) . Posted by:

sheydon

Thanks for replying Randy. I directed the query to the Google site because I have found that Yahoo doesn't do a good job or reliably providing Google option prices. Here's my new formula (using Yahoo) that returns an error:


=smfGetOptionQuotes("GOOG 1/15 2016 900. Call", "a")



Any thoughts?

Fri Apr 4, 2014 8:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, Yahoo doesn't currently have any options quotes for GOOG
either.

On Fri, Apr 4, 2014 at 7:59 AM, <scott.heydon.tu97@alum.dartmouth.org>wrote:

>
> Thanks for replying Randy. I directed the query to the Google site
> because I have found that Yahoo doesn't do a good job or reliably providing
> Google option prices. Here's my new formula (using Yahoo) that returns an
> error:
>
> =smfGetOptionQuotes("GOOG 1/15 2016 900. Call", "a")
>
> Any thoughts?
>

Fri Apr 4, 2014 9:36 am (PDT) . Posted by:

sheydon

So, any idea where to get them? I've tried OX, G, and Yahoo.

Fri Apr 4, 2014 11:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to use the new ticker symbol for the A shares to get the (old)
options though, right?

This appears to work for me:

=smfGetOptionQuotes("GOOGL 1/15 2016 $900 Call","a",,"OX")

On Fri, Apr 4, 2014 at 9:35 AM, <scott.heydon.tu97@alum.dartmouth.org>wrote:

>
> So, any idea where to get them? I've tried OX, G, and Yahoo.
>

Fri Apr 4, 2014 4:12 pm (PDT) . Posted by:

sheydon

Thanks!! Got it working now. I thought I tried that, but I must have been off somehow.

Thank you!

Fri Apr 4, 2014 11:19 am (PDT) . Posted by:

alanmoore1966

RCHGetElementNumber 976 and 975 52 Week Low and High recently started returning N/A. Anyone have any idea why or what the fix is?

Regards
Ronnie Moore

Fri Apr 4, 2014 11:34 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, that's what Yahoo is populating the Key Statistics web page
with...

They seem to be OK on the CSV file they send out for RCHGetYahooQuotes():

=RCHGetYahooQuotes("MMM","jk")

On Fri, Apr 4, 2014 at 11:19 AM, <alanmoore1966@yahoo.com> wrote:

>
> RCHGetElementNumber 976 and 975 52 Week Low and High recently started
> returning N/A. Anyone have any idea why or what the fix is?
>

Tidak ada komentar:

Posting Komentar