9 Messages
Digest #4170
Messages
Thu Oct 12, 2017 7:15 pm (PDT) . Posted by:
atb1023
Years ago, I used the SMF extensively on a Windows Machine and Excel. No problems once I learned 'where' to install the Add-In. Now I'd like to return to using the Add-In with Excel installed on a Mac. I have already loaded some other Add-Ins, but they seemed to automatically install in the right place. So I know that Excel for Mac can run Add-Ins. Are there any tricks or techniques for getting the SMF to work with Excel for Mac? Where do I install it?
-Tommy
-Tommy
Fri Oct 13, 2017 1:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that the add-in uses Windows DLL files for communication
with the Internet.
Another Mac user convinced me to make some changes and wrote a CURL routine
to replace the communication routines. The instructions he wrote up:
http://ogres-crypt.com/SMF/Works-In-Progress/MAC-Instructions.html
Some people have reported success. Others not. Knowing little about Macs,
not much I can do.
On Thu, Oct 12, 2017 at 7:15 PM, atbrown1023@
...
wrote:
> Years ago, I used the SMF extensively on a Windows Machine and Excel. No
> problems once I learned 'where' to install the Add-In. Now I'd like to
> return to using the Add-In with Excel installed on a Mac. I have already
> loaded some other Add-Ins, but they seemed to automatically install in the
> right place. So I know that Excel for Mac can run Add-Ins. Are there any
> tricks or techniques for getting the SMF to work with Excel for Mac? Where
> do I install it?
>
>
>
with the Internet.
Another Mac user convinced me to make some changes and wrote a CURL routine
to replace the communication routines. The instructions he wrote up:
http://ogres-crypt.com/SMF/Works-In-Progress/MAC-Instructions.html
Some people have reported success. Others not. Knowing little about Macs,
not much I can do.
On Thu, Oct 12, 2017 at 7:15 PM, atbrown1023@
...
wrote:
> Years ago, I used the SMF extensively on a Windows Machine and Excel. No
> problems once I learned 'where&#
> return to using the Add-In with Excel installed on a Mac. I have already
> loaded some other Add-Ins, but they seemed to automatically install in the
> right place. So I know that Excel for Mac can run Add-Ins. Are there any
> tricks or techniques for getting the SMF to work with Excel for Mac? Where
> do I install it?
>
>
>
Thu Oct 12, 2017 9:27 pm (PDT) . Posted by:
johnross999
Yes, me too. Not to mention that if you want all the available options Yahoo taking ages to retrieve and not all are shown.
Fri Oct 13, 2017 9:15 am (PDT) . Posted by:
e_bartsch
Are the GetOptionQuotes functions now not working? I've attempted Barchart, Google, Yahoo, and 888 and none of them are returning bid/ask options information.
Thanks for the help.
Eric
Thanks for the help.
Eric
Fri Oct 13, 2017 10:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo and Barchart worked for me:
=smfGetOptionQuotes("MMM 10/13 2017 $200 Call","b",,"Y")
=smfGetOptionQuotes("MMM 10/13 2017 $200 Call","b",,"B")
Google didn't, because they're missing the data on their web site.
On Fri, Oct 13, 2017 at 9:15 AM, eabartsch@
...
wrote:
>
> Are the GetOptionQuotes functions now not working? I've attempted
> Barchart, Google, Yahoo, and 888 and none of them are returning bid/ask
> options information.
>
>
>
=smfGetOptionQuotes
=smfGetOptionQuotes
Google didn't, because they're missing the data on their web site.
On Fri, Oct 13, 2017 at 9:15 AM, eabartsch@
...
wrote:
>
> Are the GetOptionQuotes functions now not working? I've attempted
> Barchart, Google, Yahoo, and 888 and none of them are returning bid/ask
> options information.
>
>
>
Fri Oct 13, 2017 12:35 pm (PDT) . Posted by:
e_bartsch
Yeah, I'm getting intermittent results. It doesn't look like the "u", or Underlying quote function, is working on Yahoo. And, Yahoo seems to be returning "Error" for put "last price" quotes.
This is the array entered formula I'm using:
=smfGetOptionQuotes(J21:J40,"lsu",1,"Y")
Where J21:J42 are cells formatted with data that looks like this:
LOW 10/20 2017 73 Put
This is the array entered formula I'm using:
=smfGetOptionQuotes
Where J21:J42 are cells formatted with data that looks like this:
LOW 10/20 2017 73 Put
Fri Oct 13, 2017 1:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
"u" isn't supported right now on Yahoo...
What I get with your formula and the sample option ticker symbol:
Ticker Last Price Strike Price Underlying Price
LOW 10/20 2017 73 Put 0.1 73 Unrecognized item ID: U
...which is what I'd expect to see. I get this using Barchart:
Ticker Last Price Strike Price Underlying Price
LOW 10/20 2017 73 Put 0.1 73 82.46
I am looking at changing the Yahoo option quote extractions over to their
JSON data file. For example:
https://query1.finance.yahoo.com/v7/finance/options/MMM?date=1511481600
I'm currently using the Portfolio view JSON files for most of my equity and
option quotes. It allows me to get a variety of them with one Internet
access, plus the equity quotes are real-time. Unfortunately, not easily
convertible to a function. Right now I use custom-designed workbooks. The
problem is results are positional, based on what is available, so not
necessarily a one-to-one correspondence between input and output.
For example, to get the above underlying and option quote above, you could
use:
=smfGetYahooJSONField("LOW,LOW171020P00073000", "portfolioView",
"quoteResponse.result.0.regularMarketPrice")
=smfGetYahooJSONField("LOW,LOW171020P00073000", "portfolioView",
"quoteResponse.result.1.regularMarketPrice")
Even though it's two functions, it's only one Internet access. And you
could do more ticker symbols, and there are a large variety of field names
available besides "regularMarketPrice". All with the single Internet
access, as long as the ticker list didn't change.
On Fri, Oct 13, 2017 at 12:35 PM, eabartsch@
...
wrote:
>
> Yeah, I'm getting intermittent results. It doesn't look like the "u", or
> Underlying quote function, is working on Yahoo. And, Yahoo seems to be
> returning "Error" for put "last price" quotes.
>
> This is the array entered formula I'm using:
>
> =smfGetOptionQuotes(J21:J40,"lsu",1,"Y")
>
> Where J21:J42 are cells formatted with data that looks like this:
>
> LOW 10/20 2017 73 Put
>
What I get with your formula and the sample option ticker symbol:
Ticker Last Price Strike Price Underlying Price
LOW 10/20 2017 73 Put 0.1 73 Unrecognized item ID: U
...which is what I'd expect to see. I get this using Barchart:
Ticker Last Price Strike Price Underlying Price
LOW 10/20 2017 73 Put 0.1 73 82.46
I am looking at changing the Yahoo option quote extractions over to their
JSON data file. For example:
https://query1.finance.yahoo.com/v7/finance/options/MMM?date=1511481600
I'm currently using the Portfolio view JSON files for most of my equity and
option quotes. It allows me to get a variety of them with one Internet
access, plus the equity quotes are real-time. Unfortunately, not easily
convertible to a function. Right now I use custom-designed workbooks. The
problem is results are positional, based on what is available, so not
necessarily a one-to-one correspondence between input and output.
For example, to get the above underlying and option quote above, you could
use:
=smfGetYahooJSONFie
"quoteResponse
=smfGetYahooJSONFie
"quoteResponse
Even though it's two functions, it's only one Internet access. And you
could do more ticker symbols, and there are a large variety of field names
available besides "regularMarket
access, as long as the ticker list didn't change.
On Fri, Oct 13, 2017 at 12:35 PM, eabartsch@
...
wrote:
>
> Yeah, I'm getting intermittent results. It doesn't look like the "u"
> Underlying quote function, is working on Yahoo. And, Yahoo seems to be
> returning "Error" for put "last price" quotes.
>
> This is the array entered formula I'm using:
>
> =smfGetOptionQuotes
>
> Where J21:J42 are cells formatted with data that looks like this:
>
> LOW 10/20 2017 73 Put
>
Fri Oct 13, 2017 7:19 pm (PDT) . Posted by:
e_bartsch
Randy:
Thanks. That is fascinating. I wonder. . .how do you crunch the Portfolio view across a larger set of standardized data? Let's say you have:
LOW 10/20 2017 73 Put
MMM 10/20 2017 110 Put
etc. etc.
in a column. Right now, I just pull the data from the column in an array entered GetOptionQuotes function and see the results. But, with Yahoo data being limited to only a small number of queries per IP address (and otherwise behaving intermittently), and the Barchart data (for some reason) not pulling up prices on my spreadsheet (although underlying returns a value), I'm intrigued by your JSON fix.
Eric
Thanks. That is fascinating. I wonder. . .how do you crunch the Portfolio view across a larger set of standardized data? Let's say you have:
LOW 10/20 2017 73 Put
MMM 10/20 2017 110 Put
etc. etc.
in a column. Right now, I just pull the data from the column in an array entered GetOptionQuotes function and see the results. But, with Yahoo data being limited to only a small number of queries per IP address (and otherwise behaving intermittently)
Eric
Thu Oct 12, 2017 11:55 pm (PDT) . Posted by:
badihis
Yes, As a matter of fact, that is my choice by default, as I write some small VBA codes myself, and like to know when I break anything.
Will now turn that off when I am not writing anything.
Will now turn that off when I am not writing anything.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar