13 New Messages
Digest #2340
| |
Messages
Sat Sep 8, 2012 5:22 am (PDT) . Posted by:
"hcl0903@sbcglobal.net" hcl0903@sbcglobal.net
Hi Randy,
Is there an official function released to get Option quotes?
Thanks for your help.
H
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The smfGetOptionQuote() function is not an officially released function. It
> was something I was playing around with. So far, only Zacks is in it, and
> it's the only one that accesses Zacks.
>
> See the two smfForceRecalculation items in the LINKS area of the group for
> why quotes may appear to be not current.
>
> On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@... <
> rajk2302@...> wrote:
>
> >
> > When I use smfGetOptionQuote("SBUX", "C", "9/22/2012", 48, "L") to get the
> > last option price, I get 3.1 (from default Zacks source), which different
> > from the Yahoo / Google finance web page, which show 3.31 as the last price
> > (as of 9/7/12 close)
> >
> > Also, in the version I have looks like Zacks is the only source for Option
> > prices.
> >
> > What am I doing wrong or am I missing something here?
> >
>
Is there an official function released to get Option quotes?
Thanks for your help.
H
--- In smf_addin@yahoogrou
>
> The smfGetOptionQuote(
> was something I was playing around with. So far, only Zacks is in it, and
> it's the only one that accesses Zacks.
>
> See the two smfForceRecalculati
> why quotes may appear to be not current.
>
> On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@... <
> rajk2302@...
>
> >
> > When I use smfGetOptionQuote(
> > last option price, I get 3.1 (from default Zacks source), which different
> > from the Yahoo / Google finance web page, which show 3.31 as the last price
> > (as of 9/7/12 close)
> >
> > Also, in the version I have looks like Zacks is the only source for Option
> > prices.
> >
> > What am I doing wrong or am I missing something here?
> >
>
Sat Sep 8, 2012 5:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
A number of them -- check for their documentation in the DOCUMENTATION
folder of the FILES area of the group.
On Sat, Sep 8, 2012 at 5:22 AM, hcl0903@sbcglobal.net <
rajk2302@sbcglobal.net > wrote:
>
> Is there an official function released to get Option quotes?
>
folder of the FILES area of the group.
On Sat, Sep 8, 2012 at 5:22 AM, hcl0903@sbcglobal.
rajk2302@sbcglobal.
>
> Is there an official function released to get Option quotes?
>
Sat Sep 8, 2012 6:08 am (PDT) . Posted by:
"hcl0903@sbcglobal.net" hcl0903@sbcglobal.net
Randy,
Never mind..I found the modGetOptionQuotes.smfGetGoogleOptionQuote that gets the Google data.
Thanks.
H
--- In smf_addin@yahoogroups.com , "hcl0903@..." <rajk2302@...> wrote:
>
> Hi Randy,
>
> Is there an official function released to get Option quotes?
>
> Thanks for your help.
>
> H
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The smfGetOptionQuote() function is not an officially released function. It
> > was something I was playing around with. So far, only Zacks is in it, and
> > it's the only one that accesses Zacks.
> >
> > See the two smfForceRecalculation items in the LINKS area of the group for
> > why quotes may appear to be not current.
> >
> > On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@ <
> > rajk2302@> wrote:
> >
> > >
> > > When I use smfGetOptionQuote("SBUX", "C", "9/22/2012", 48, "L") to get the
> > > last option price, I get 3.1 (from default Zacks source), which different
> > > from the Yahoo / Google finance web page, which show 3.31 as the last price
> > > (as of 9/7/12 close)
> > >
> > > Also, in the version I have looks like Zacks is the only source for Option
> > > prices.
> > >
> > > What am I doing wrong or am I missing something here?
> > >
> >
>
Never mind..I found the modGetOptionQuotes.
Thanks.
H
--- In smf_addin@yahoogrou
>
> Hi Randy,
>
> Is there an official function released to get Option quotes?
>
> Thanks for your help.
>
> H
>
> --- In smf_addin@yahoogrou
> >
> > The smfGetOptionQuote(
> > was something I was playing around with. So far, only Zacks is in it, and
> > it's the only one that accesses Zacks.
> >
> > See the two smfForceRecalculati
> > why quotes may appear to be not current.
> >
> > On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@ <
> > rajk2302@> wrote:
> >
> > >
> > > When I use smfGetOptionQuote(
> > > last option price, I get 3.1 (from default Zacks source), which different
> > > from the Yahoo / Google finance web page, which show 3.31 as the last price
> > > (as of 9/7/12 close)
> > >
> > > Also, in the version I have looks like Zacks is the only source for Option
> > > prices.
> > >
> > > What am I doing wrong or am I missing something here?
> > >
> >
>
Sat Sep 8, 2012 7:26 am (PDT) . Posted by:
"Ron Spruell" hashky
I couldn't find any documentation for smfGetOptionQuote(). Where is it?
I use smfGetOptionQuotes() almost every day.
Ron Spruell
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, September 7, 2012 9:53 PM
>Subject: Re: [smf_addin] Different option price values
>
>
>
>The smfGetOptionQuote() function is not an officially released function. It was something I was playing around with. So far, only Zacks is in it, and it's the only one that accesses Zacks.
>
>See the two smfForceRecalculation items in the LINKS area of the group for why quotes may appear to be not current.
>
>
>On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@sbcglobal.net <rajk2302@sbcglobal.net > wrote:
>
>
>>When I use smfGetOptionQuote("SBUX", "C", "9/22/2012", 48, "L") to get the last option price, I get 3.1 (from default Zacks source), which different from the Yahoo / Google finance web page, which show 3.31 as the last price (as of 9/7/12 close)
>>
>>Also, in the version I have looks like Zacks is the only source for Option prices.
>>
>>What am I doing wrong or am I missing something here?
>>
>
>
>
>
I use smfGetOptionQuotes(
Ron Spruell
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, September 7, 2012 9:53 PM
>Subject: Re: [smf_addin] Different option price values
>
>
>
>The smfGetOptionQuote(
>
>See the two smfForceRecalculati
>
>
>On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@sbcglobal.
>
>
>>When I use smfGetOptionQuote(
>>
>>Also, in the version I have looks like Zacks is the only source for Option prices.
>>
>>What am I doing wrong or am I missing something here?
>>
>
>
>
>
Sat Sep 8, 2012 12:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is none. As I said, it's not been officially released.
On Sat, Sep 8, 2012 at 7:26 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I couldn't find any documentation for smfGetOptionQuote(). Where is it?
>
> I use smfGetOptionQuotes() almost every day.
>
On Sat, Sep 8, 2012 at 7:26 AM, Ron Spruell <hashky@yahoo.
>
> I couldn't find any documentation for smfGetOptionQuote(
>
> I use smfGetOptionQuotes(
>
Sat Sep 8, 2012 8:42 am (PDT) . Posted by:
"Rosendo Manuel" rosendojose
Despite being an old user of SMF add-in I'm having a strange problem
after doing an update with the latest version of 2 February (certainly
for my mistake).For your reference, firstly, I have the add-in files in
the folder C: \ SMF and have Excel configured in accordance Options \
Suiplementos.As you can see from the Excel image, the formulas
RCHGetElementNumber (and others) have all "Error".Can you help identify
the possible error? I do not know what more to try ...Thanks for your
help.Rosendo José (Lisbon)
Excel image <http://www.2shared.com/photo/q_yJ-QgV/Excel_image.html >
C:\SMF
<http://www.2shared.com/photo/q_yJ-QgV/Excel_image.html%20http://www.2sh\
ared.com/photo/QRdROLOz/Disk_C_-_SMF.html >
after doing an update with the latest version of 2 February (certainly
for my mistake).For your reference, firstly, I have the add-in files in
the folder C: \ SMF and have Excel configured in accordance Options \
Suiplementos.
RCHGetElementNumber (and others) have all "Error".Can you help identify
the possible error? I do not know what more to try ...Thanks for your
help.Rosendo José (Lisbon)
Excel image <http://www.2shared.
C:\SMF
<http://www.2shared.
ared.com/photo/
Sat Sep 8, 2012 9:07 am (PDT) . Posted by:
"Rosendo Manuel" rosendojose
Well, it seems to be a problem of MSN (and also of Morningstar example number 877), because the references to Yahoo (example number 562) or Zacks (example number 848)work well.
What'd be wrong?
Rosendo José
--- In smf_addin@yahoogroups.com , "Rosendo Manuel" <rosendo.jose@...> wrote:
>
> Despite being an old user of SMF add-in I'm having a strange problem
> after doing an update with the latest version of 2 February (certainly
> for my mistake).For your reference, firstly, I have the add-in files in
> the folder C: \ SMF and have Excel configured in accordance Options \
> Suiplementos.As you can see from the Excel image, the formulas
> RCHGetElementNumber (and others) have all "Error".Can you help identify
> the possible error? I do not know what more to try ...Thanks for your
> help.Rosendo José (Lisbon)
> Excel image <http://www.2shared.com/photo/q_yJ-QgV/Excel_image.html >
> C:\SMF
> <http://www.2shared.com/photo/q_yJ-QgV/Excel_image.html%20http://www.2sh\
> ared.com/photo/QRdROLOz/Disk_C_-_SMF.html>
>
What'd be wrong?
Rosendo José
--- In smf_addin@yahoogrou
>
> Despite being an old user of SMF add-in I'm having a strange problem
> after doing an update with the latest version of 2 February (certainly
> for my mistake).For your reference, firstly, I have the add-in files in
> the folder C: \ SMF and have Excel configured in accordance Options \
> Suiplementos.
> RCHGetElementNumber (and others) have all "Error".Can you help identify
> the possible error? I do not know what more to try ...Thanks for your
> help.Rosendo José (Lisbon)
> Excel image <http://www.2shared.
> C:\SMF
> <http://www.2shared.
>
Sat Sep 8, 2012 12:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I suspect you just need the updated element definitions for MSN, since they
have changed their web page structure since the last official release of
the add-in -- see:
http://finance.groups.yahoo.com/group/smf_addin/message/18529
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL
Element #877 works fine here, if I make sure to visit the Morningstar
website first with the EXCEL Web Query process or with IE (not with
FireFox). MorningStar does some advertising redirections upon the first
visit of the day, so you need to create an IE cookie so it knows you've
already visited the site that day.
On Sat, Sep 8, 2012 at 9:07 AM, Rosendo Manuel <rosendo.jose@gmail.com >wrote:
> Well, it seems to be a problem of MSN (and also of Morningstar example
> number 877), because the references to Yahoo (example number 562) or Zacks
> (example number 848)work well.
>
> What'd be wrong?
>
> Rosendo José
>
>
> --- In smf_addin@yahoogroups.com , "Rosendo Manuel" <rosendo.jose@...>
> wrote:
> >
> > Despite being an old user of SMF add-in I'm having a strange problem
> > after doing an update with the latest version of 2 February (certainly
> > for my mistake).For your reference, firstly, I have the add-in files in
> > the folder C: \ SMF and have Excel configured in accordance Options \
> > Suiplementos.As you can see from the Excel image, the formulas
> > RCHGetElementNumber (and others) have all "Error".Can you help identify
> > the possible error? I do not know what more to try ...
>
have changed their web page structure since the last official release of
the add-in -- see:
http://finance.
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL
Element #877 works fine here, if I make sure to visit the Morningstar
website first with the EXCEL Web Query process or with IE (not with
FireFox). MorningStar does some advertising redirections upon the first
visit of the day, so you need to create an IE cookie so it knows you've
already visited the site that day.
On Sat, Sep 8, 2012 at 9:07 AM, Rosendo Manuel <rosendo.jose@
> Well, it seems to be a problem of MSN (and also of Morningstar example
> number 877), because the references to Yahoo (example number 562) or Zacks
> (example number 848)work well.
>
> What'd be wrong?
>
> Rosendo José
>
>
> --- In smf_addin@yahoogrou
> wrote:
> >
> > Despite being an old user of SMF add-in I'm having a strange problem
> > after doing an update with the latest version of 2 February (certainly
> > for my mistake).For your reference, firstly, I have the add-in files in
> > the folder C: \ SMF and have Excel configured in accordance Options \
> > Suiplementos.
> > RCHGetElementNumber (and others) have all "Error".Can you help identify
> > the possible error? I do not know what more to try ...
>
Sat Sep 8, 2012 9:50 am (PDT) . Posted by:
"charles" chasjohn02
Many Target Prices (t8) are yielding N/A for S&P 500 stocks.
Sat Sep 8, 2012 12:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's what Yahoo is sending on the CSV file...
On Sat, Sep 8, 2012 at 9:50 AM, charles <chasjohn02@yahoo.com > wrote:
> Many Target Prices (t8) are yielding N/A for S&P 500 stocks.
>
On Sat, Sep 8, 2012 at 9:50 AM, charles <chasjohn02@yahoo.
> Many Target Prices (t8) are yielding N/A for S&P 500 stocks.
>
Sat Sep 8, 2012 12:26 pm (PDT) . Posted by:
"Harry Gross" harry144g
Randy,
I'm having a problem retrieving values for the Dow:-(
The formula in question is as follows:
=RCHGetYahooHistory("^DJI",YEAR(N3),MONTH(N3),DAY(N3),YEAR(N3),MONTH(N3),DAY(N3),,"A",0)
Where cell N3 contains that date I need data for. The problem is, I don't get anything back. However, if I change the symbol to, say, 'IBM' or '^GSPC' (the S&P 500), it works just fine.
Did the symbol for Dow Industrial change? Is there something else going on?
Note - this is happening in a spreadsheet that I loaded off the net - I didn't create it, and am not familiar with the various macro calls, so . . .
Thanks for any assistance you can provide!
Harry
I'm having a problem retrieving values for the Dow:-(
The formula in question is as follows:
=RCHGetYahooHistory
Where cell N3 contains that date I need data for. The problem is, I don't get anything back. However, if I change the symbol to, say, 'IBM' or '^GSPC' (the S&P 500), it works just fine.
Did the symbol for Dow Industrial change? Is there something else going on?
Note - this is happening in a spreadsheet that I loaded off the net - I didn't create it, and am not familiar with the various macro calls, so . . .
Thanks for any assistance you can provide!
Harry
Sat Sep 8, 2012 12:33 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo is no longer licensed to provide a CSV file of the historical DJIA
quotes...
On Sat, Sep 8, 2012 at 8:35 AM, Harry Gross <harry@harry144.com > wrote:
>
> I'm having a problem retrieving values for the Dow:-(
>
> The formula in question is as follows:
>
>
> =RCHGetYahooHistory("^DJI",YEAR(N3),MONTH(N3),DAY(N3),YEAR(N3),MONTH(N3),DAY(N3),,"A",0)
>
> Where cell N3 contains that date I need data for. The problem is, I don't
> get anything back. However, if I change the symbol to, say, 'IBM' or
> '^GSPC' (the S&P 500), it works just fine.
>
> Did the symbol for Dow Industrial change? Is there something else going
> on?
>
> Note - this is happening in a spreadsheet that I loaded off the net - I
> didn't create it, and am not familiar with the various macro calls, so . . .
>
> Thanks for any assistance you can provide!
>
quotes...
On Sat, Sep 8, 2012 at 8:35 AM, Harry Gross <harry@harry144.
>
> I'm having a problem retrieving values for the Dow:-(
>
> The formula in question is as follows:
>
>
> =RCHGetYahooHistory
>
> Where cell N3 contains that date I need data for. The problem is, I don't
> get anything back. However, if I change the symbol to, say, 'IBM' or
> '^GSPC' (the S&P 500), it works just fine.
>
> Did the symbol for Dow Industrial change? Is there something else going
> on?
>
> Note - this is happening in a spreadsheet that I loaded off the net - I
> didn't create it, and am not familiar with the various macro calls, so . . .
>
> Thanks for any assistance you can provide!
>
Sat Sep 8, 2012 4:24 pm (PDT) . Posted by:
"c5vet@yahoo.com" c5vet
Hi Randy
Its interesting to find another quant
I have been using. Matlab for years
now to download and analyze stock, financial, and options data
I frequently have to go back and change my code because Yahoo changes stuff
I thought i was the only one experiencing this pain, but I think you do so also,
correct?
Rene (guy spelling)
----- Reply message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: <smf_addin@yahoogroups.com >
Subject: [smf_addin] Error retrieving ^DJI data
Date: Sat, Sep 8, 2012 3:33 pm
Yahoo is no longer licensed to provide a CSV file of the historical DJIA quotes...
On Sat, Sep 8, 2012 at 8:35 AM, Harry Gross <harry@harry144.com > wrote:
I'm having a problem retrieving values for the Dow:-(
The formula in question is as follows:
=RCHGetYahooHistory("^DJI",YEAR(N3),MONTH(N3),DAY(N3),YEAR(N3),MONTH(N3),DAY(N3),,"A",0)
Where cell N3 contains that date I need data for. The problem is, I don't get anything back. However, if I change the symbol to, say, 'IBM' or '^GSPC' (the S&P 500), it works just fine.
Did the symbol for Dow Industrial change? Is there something else going on?
Note - this is happening in a spreadsheet that I loaded off the net - I didn't create it, and am not familiar with the various macro calls, so . . .
Thanks for any assistance you can provide!
Its interesting to find another quant
I have been using. Matlab for years
now to download and analyze stock, financial, and options data
I frequently have to go back and change my code because Yahoo changes stuff
I thought i was the only one experiencing this pain, but I think you do so also,
correct?
Rene (guy spelling)
----- Reply message -----
From: "Randy Harmelink" <rharmelink@gmail.
To: <smf_addin@yahoogrou
Subject: [smf_addin] Error retrieving ^DJI data
Date: Sat, Sep 8, 2012 3:33 pm
Yahoo is no longer licensed to provide a CSV file of the historical DJIA quotes...
On Sat, Sep 8, 2012 at 8:35 AM, Harry Gross <harry@harry144.
I'm having a problem retrieving values for the Dow:-(
The formula in question is as follows:
=RCHGetYahooHistory
Where cell N3 contains that date I need data for. The problem is, I don't get anything back. However, if I change the symbol to, say, 'IBM' or '^GSPC' (the S&P 500), it works just fine.
Did the symbol for Dow Industrial change? Is there something else going on?
Note - this is happening in a spreadsheet that I loaded off the net - I didn't create it, and am not familiar with the various macro calls, so . . .
Thanks for any assistance you can provide!
Tidak ada komentar:
Posting Komentar