2 Messages

Digest #3479

Ebay options by joshi_mandar

Re: Ebay options by "Randy Harmelink" rharmelink

Messages

1a

Hi Randy,

I used to have EBAY Jan 16 $60 call in my TDA account. Now it's been replaced with non-standard EBAY Jan 16 $60 call (thanks to the recent Paypal spin-off). Seems like yahoo doesn't have non-standard EBAY options. Therefore the formula from my spreadsheet no longer works. This is my formula smfGetOptionQuotes("ebay Jan 16 60 call","l",0,"Y"). Any idea how I can fix the problem and get the quote for non-standard EBAY options again?

Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Ebay options

Sun Aug 9, 2015 12:14 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The Yahoo data source is the only one the add-in is set up to get
non-standard or mini options. If Yahoo isn't carrying the data, you'd need
to find a different data source and do your own manual extraction. It may
just take some time before Yahoo has it in their web pages. At that time, I
hope this or something similar would work:

=smfGetOptionQuotes("EBAY1 Jan 16 60 call","l",0,"Y")

On Sat, Aug 8, 2015 at 11:58 PM, joshi_mandar@... wrote:

> Hi Randy,
>
> I used to have EBAY Jan 16 $60 call in my TDA account. Now it's been
> replaced with non-standard EBAY Jan 16 $60 call (thanks to the recent
> Paypal spin-off). Seems like yahoo doesn't have non-standard EBAY
> options. Therefore the formula from my spreadsheet no longer works. This
> is my formula smfGetOptionQuotes("ebay Jan 16 60 call","l",0,"Y"). Any
> idea how I can fix the problem and get the quote for non-standard EBAY
> options again?
>
>