3 Messages
Digest #4635
Messages
Fri Oct 25, 2019 12:36 pm (PDT) . Posted by:
bob_15861586
The following produces an error. I do not understand why:
=smfGetYahooOptionQuote("AVB","C",DATE(2020,1,17),210,"a")
Thanks,
Bob
=smfGetYahooOptionQ
Thanks,
Bob
Fri Oct 25, 2019 1:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Possibly a temporary glitch on Yahoo? It works fine here.
By the way, have you tried getting option quotes using
smfGetYahooPortfolioView()? By array-entering the function over a range,
you can grab a number of data fields for a number of ticker symbols, all
with one quick Internet retrieval.
You can either use the Yahoo option ticker symbol, or generate it using a
version of the formula you have below:
=smfGetYahooOptionQuote("AVB","C",DATE(2020,1,17),210,"z")
....which creates the Yahoo option ticker symbol without accessing the
Internet.
On Fri, Oct 25, 2019 at 12:37 PM bob_15861586@... wrote:
> The following produces an error. I do not understand why:
>
> =smfGetYahooOptionQuote("AVB","C",DATE(2020,1,17),210,"a")
>
>
>
By the way, have you tried getting option quotes using
smfGetYahooPortfoli
you can grab a number of data fields for a number of ticker symbols, all
with one quick Internet retrieval.
You can either use the Yahoo option ticker symbol, or generate it using a
version of the formula you have below:
=smfGetYahooOptionQ
....which creates the Yahoo option ticker symbol without accessing the
Internet.
On Fri, Oct 25, 2019 at 12:37 PM bob_15861586@
> The following produces an error. I do not understand why:
>
> =smfGetYahooOptionQ
>
>
>
Fri Oct 25, 2019 4:57 pm (PDT) . Posted by:
bob_15861586
Randy,
Thanks for the response. It is now working fine for me.
By the way, I am currently using smfGetYahooPortfolioView to get my stock quotes. I did not realize that
it did options also.
Bob
Thanks for the response. It is now working fine for me.
By the way, I am currently using smfGetYahooPortfoli
it did options also.
Bob
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar