Jumat, 05 Oktober 2018

[smf_addin] Digest Number 4407

5 Messages

Digest #4407
1
Important: New E-mail Address by "Stan Freifeld" optionstan
3b
Re: Problem Getting Option Quotes by "Randy Harmelink" rharmelink

Messages

Thu Oct 4, 2018 5:53 am (PDT) . Posted by:

"Stan Freifeld" optionstan

Greetings, Our Motto: No Ridiculous Claims, No Sales Hype!

I am no longer using this address. Please use my new e-mail address:
optionstan@gmail.com

I look forward to hearing from you. Thank you!

Have a profitable day,

Stan Freifeld
(973) 362-4558


Too busy to manage your money, we can do it for you. ASK ME HOW.
Get to know me, see Stocks and Commodities article by
<http://tinyurl.com/jedk2sl> clicking here,
and interview by
<http://tinyurl.com/l59vhn2> clicking here

11. Know Thy Options!

logo-blue2


Thu Oct 4, 2018 7:30 am (PDT) . Posted by:

tonyestep

Belated thanks, Randy. Much appreciated.

Thu Oct 4, 2018 9:35 am (PDT) . Posted by:

bob_15861586

The following does not work:
=smfGetYahooOptionQuote("AMD","C","1/18/19",32,"a")
I also tried this:
smfGetBarChartOptionQuote("AMD","C","1/18/19",32,"a")
It did not work either. I do see the quote at the following URL:
https://finance.yahoo.com/quote/AMD190118C00032000?p=AMD190118C00032000 https://finance.yahoo.com/quote/AMD190118C00032000?p=AMD190118C00032000


Is it working for other people?


Bob

Thu Oct 4, 2018 12:17 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Barchart is no longer viable as a data source because they protected the
JSON files that were providing the data for the add-in.

However, your first function works fine for me. Try it again and if it
still doesn't work, run the smfForceRecalculation macro. Maybe you had a
bad web page from Yahoo.

Alternatively, you can use the smfGetYahooPortfolioView() function. It can
get multiple option quotes at once, with different underlying, different
expiration dates, and different strike prices...

On Thu, Oct 4, 2018 at 9:39 AM bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> The following does not work:
>
> =smfGetYahooOptionQuote("AMD","C","1/18/19",32,"a")
>
> I also tried this:
>
> smfGetBarChartOptionQuote("AMD","C","1/18/19",32,"a")
>
> It did not work either. I do see the quote at the following URL:
>
> https://finance.yahoo.com/quote/AMD190118C00032000?p=AMD190118C00032000
>
> Is it working for other people?
>
>
>

Thu Oct 4, 2018 3:26 pm (PDT) . Posted by:

bob_15861586

Randy,

It is now working. Thank you very much.


Bob
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar