5 Messages
Digest #2986
Messages
Fri Feb 28, 2014 7:56 am (PST) . Posted by:
mitresourcesinc
Randy: Thank you for prompt answer. I am new to this. I guess "MMM" is the stock symbol. What does"I1" stand for?
Thks & rgds,
Alvaro Pena
Thks & rgds,
Alvaro Pena
Fri Feb 28, 2014 9:01 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I suggest you read the documentation before you ask question or try using the addin.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of pena.alvaro@icloud.com
Sent: Friday, February 28, 2014 10:56 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetElementNumber
Randy:
Thank you for prompt answer. I am new to this. I guess "MMM" is the stock symbol. What does"I1" stand for?
Thks & rgds,
Alvaro Pena
Kermit
From: smf_addin@yahoogrou
Sent: Friday, February 28, 2014 10:56 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RCHGetElementNumber
Randy:
Thank you for prompt answer. I am new to this. I guess "MMM" is the stock symbol. What does"I1" stand for?
Thks & rgds,
Alvaro Pena
Fri Feb 28, 2014 10:17 am (PST) . Posted by:
"Pete A" option2z
One of my monitoring pages accesses a bunch of the "Market Stats" from
YAHOO.
A few weeks ago, most of them quit working. I saw that Randy was working on
them, so I waited awhile.
This morning I downloaded the latest version and all the "Works-in-Progress";
files, restarted excel and.
Totally fixed!
Thanks Randy. Imagine if we ALL had to EACH make changes when YAHOO
changes.or any of our other sources.
Randy.you're weight in diamonds.
Pete A
<http://www.ttp-s.com/php/toolsmenu.php>
YAHOO.
A few weeks ago, most of them quit working. I saw that Randy was working on
them, so I waited awhile.
This morning I downloaded the latest version and all the "Works-
files, restarted excel and.
Totally fixed!
Thanks Randy. Imagine if we ALL had to EACH make changes when YAHOO
changes.or any of our other sources.
Randy.you'
Pete A
<http://www.ttp-
Fri Feb 28, 2014 10:08 pm (PST) . Posted by:
gryemann
Hello,
Greetings,
Is there an SMF Options Data Retriever template similar in format to what is specified below? Basically, as you can see, one option per row with 12 data items in columns, 6 are user input and 6 are retrieved via smf udfs. Also which source would have the fastest retrieval for this?
I have looked at several templates and like the expire format i.e. "03/22/2014" in smfGetOptionQuotes-Example-Table-Building-Exercise. This template does not include the current underlying price and so is missing item in C9: Current Price of Underlying
B9: Ticker Symbol of Underlying Equity - User inputC9: Current Price of Underlying –SMF retrieved
D9:E9: Expire year YYYY "2014" - User inputF9: Expire Month MM "03" - User inputG9: Expire date dd "22" - User inputH9: Strike Price "185.00" - User inputI9: Put or Call - "P" or "C" - User inputJ9: Last Price–SMF retrievedK9: Bid Price–SMF retrievedL9: Ask Price–SMF retrievedM9: Open interest–SMF retrievedN9: Volume–SMF retrievedO9:P9: Thanks JBSeattle
Greetings,
Is there an SMF Options Data Retriever template similar in format to what is specified below? Basically, as you can see, one option per row with 12 data items in columns, 6 are user input and 6 are retrieved via smf udfs. Also which source would have the fastest retrieval for this?
I have looked at several templates and like the expire format i.e. "03/22/2014" in smfGetOptionQuotes-
B9: Ticker Symbol of Underlying Equity - User inputC9: Current Price of Underlying –SMF retrieved
D9:E9: Expire year YYYY "2014" - User inputF9: Expire Month MM "03" - User inputG9: Expire date dd "22" - User inputH9: Strike Price "185.00" - User inputI9: Put or Call - "P" or "C" - User inputJ9: Last Price–SMF retrievedK9: Bid Price–SMF retrievedL9: Ask Price–SMF retrievedM9: Open interest–SMF retrievedN9: Volume–SMF retrievedO9:
Fri Feb 28, 2014 11:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I guess I don't see where there's a problem?
If you want, you can just use the cited template and place a "u" in cell
G7, you'll get the underlying price.
Or, if you want to create your own format as described, I still don't see
the problem. For example:
B9: IWM
C9: =RCHGetYahooQuotes(B9,"l1")
D9: 2014
E9: What is this column for?
F9: 3
G9: 22
H9: 120
I9: C
J9: =smfGetOptionQuotes($B9&" "&$F9&"/"&$G9&" "&$D9&" "&$H9&" "&$I9,"l")
K9: =smfGetOptionQuotes($B9&" "&$F9&"/"&$G9&" "&$D9&" "&$H9&" "&$I9,"b")
L9: =smfGetOptionQuotes($B9&" "&$F9&"/"&$G9&" "&$D9&" "&$H9&" "&$I9,"a")
M9: =smfGetOptionQuotes($B9&" "&$F9&"/"&$G9&" "&$D9&" "&$H9&" "&$I9,"i")
N9: =smfGetOptionQuotes($B9&" "&$F9&"/"&$G9&" "&$D9&" "&$H9&" "&$I9,"v")
O9: What is this column for?
P9: What is this column for?
Yahoo is probably the fastest. I use OptionsXpress -- slower, but more
accurate and reliable.
On Fri, Feb 28, 2014 at 11:08 PM, <gryemann@yahoo.com> wrote:
>
> Is there an SMF Options Data Retriever template similar in format to what
> is specified below? Basically, as you can see, one option per row with
> 12 data items in columns, 6 are user input and 6 are retrieved via smf
> udfs. Also which source would have the fastest retrieval for this?
>
> I have looked at several templates and like the expire format i.e.
> "03/22/2014" in smfGetOptionQuotes-Example-Table-Building-Exercise. This
> template does not include the current underlying price and so is missing
> item in C9: Current Price of Underlying
>
> B9: Ticker Symbol of Underlying Equity - User inputC9: Current Price of
> Underlying –SMF retrieved
> D9:E9: Expire year YYYY "2014" - User inputF9: Expire Month MM "03" -
> User inputG9: Expire date dd "22" - User inputH9: Strike Price "185.00"
> - User inputI9: Put or Call - "P" or "C" - User inputJ9: Last
> Price–SMF retrievedK9: Bid Price–SMF retrievedL9: Ask Price–SMF
> retrievedM9: Open interest–SMF retrievedN9: Volume–SMF retrievedO9:P9:Thanks JBSeattle
>
If you want, you can just use the cited template and place a "u" in cell
G7, you'll get the underlying price.
Or, if you want to create your own format as described, I still don't see
the problem. For example:
B9: IWM
C9: =RCHGetYahooQuotes(
D9: 2014
E9: What is this column for?
F9: 3
G9: 22
H9: 120
I9: C
J9: =smfGetOptionQuotes
K9: =smfGetOptionQuotes
L9: =smfGetOptionQuotes
M9: =smfGetOptionQuotes
N9: =smfGetOptionQuotes
O9: What is this column for?
P9: What is this column for?
Yahoo is probably the fastest. I use OptionsXpress -- slower, but more
accurate and reliable.
On Fri, Feb 28, 2014 at 11:08 PM, <gryemann@yahoo.
>
> Is there an SMF Options Data Retriever template similar in format to what
> is specified below? Basically, as you can see, one option per row with
> 12 data items in columns, 6 are user input and 6 are retrieved via smf
> udfs. Also which source would have the fastest retrieval for this?
>
> I have looked at several templates and like the expire format i.e.
> "03/22/2014" in smfGetOptionQuotes-
> template does not include the current underlying price and so is missing
> item in C9: Current Price of Underlying
>
> B9: Ticker Symbol of Underlying Equity - User inputC9: Current Price of
> Underlying –SMF retrieved
> D9:E9: Expire year YYYY "2014" - User inputF9: Expire Month MM "03" -
> User inputG9: Expire date dd "22" - User inputH9: Strike Price "185.00"
> - User inputI9: Put or Call - "P" or "C" - User inputJ9: Last
> Price–SMF retrievedK9: Bid Price–SMF retrievedL9: Ask Price–SMF
> retrievedM9: Open interest–SMF retrievedN9: Volume–SMF retrievedO9:
>
Tidak ada komentar:
Posting Komentar