[smf_addin] Digest Number 1963

EXCEL Stock Market Functions Add-in

Messages In This Digest (15 Messages)

1a.

Re: Update problems today 9/21...Is it just me??? From: Bill Durrance

1b.

Re: Update problems today 9/21...Is it just me??? From: Randy Harmelink

1c.

Re: Update problems today 9/21...Is it just me??? From: Bill Durrance

1d.

Re: Update problems today 9/21...Is it just me??? From: Randy Harmelink

1e.

Re: Update problems today 9/21...Is it just me??? From: Bill Durrance

1f.

Re: Update problems today 9/21...Is it just me??? From: Randy Harmelink

1g.

Re: Update problems today 9/21...Is it just me??? From: Bill Durrance

2a.

S&P 500 price From: Bill Durrance

2b.

Re: S&P 500 price From: Martin Topper

2c.

Re: S&P 500 price From: Randy Harmelink

2d.

Re: S&P 500 price From: Bill Durrance

3a.

for us Canadians - any way to pull TSX/TSE specific data from Google From: r d

3b.

Re: for us Canadians - any way to pull TSX/TSE specific data from Go From: Randy Harmelink

4a.

question for Randy regarding Barron's Stock Grader From: investor952

4b.

Re: question for Randy regarding Barron's Stock Grader From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

Re: Update problems today 9/21...Is it just me???

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 12:23 pm (PDT)

I'm experiencing the same problem.  Any resolution yet?

From: Dr_KrwL <anml819@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, September 21, 2011 8:23 PM
>Subject: [smf_addin] Update problems today 9/21...Is it just me???
>
>
> 
>Quotes don't appear to be updating correctly today...just me???
>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1b.

Re: Update problems today 9/21...Is it just me???

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 1:28 pm (PDT)

I'll need a better description of the problem. At this point, all I can do
is guess about function, ticker symbols, data items, and other details.

On Thu, Sep 22, 2011 at 12:23 PM, Bill Durrance <high_winger@yahoo.com>wrote:

>
> I'm experiencing the same problem. Any resolution yet?
>
> *From:* Dr_KrwL <anml819@yahoo.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Wednesday, September 21, 2011 8:23 PM
> *Subject:* [smf_addin] Update problems today 9/21...Is it just me???
>
> Quotes don't appear to be updating correctly today...just me???
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1c.

Re: Update problems today 9/21...Is it just me???

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 1:57 pm (PDT)

I was pulling up option values and current pricing for UPRO using =RCHGetYahooQuotes( $A1,"l1",,NOW())  and =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A3,B$3, " ",A$2),"b") . which should trtanslate to:
UPRO Oct 2011 OTM1 Call
 
where A1:B$ =
 UPRO Oct
Call 5.00
OTM 1
Strike = 57
 
The strike is found using: =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A3,B$3, " ",A$2),"s")
 
The Concat() should =
UPRO Oct 2011 OTM1 Call
 
The call value appeared to be consitently incorrect or from a nother cell such as OTM3.  Puts were doing the same thing.  The price wasn't updating either.  I had the Yahoo pages open for comparison.  I tried to work around it by using get table cell from Yahoo, Google , and MSN.  MSN might (kind of fuzzy now after many iterations) have worked the best.
 
See anything obviously wrong?

From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, September 22, 2011 4:28 PM
>Subject: Re: [smf_addin] Update problems today 9/21...Is it just me???
>
>
> 
>I'll need a better description of the problem. At this point, all I can do is guess about function, ticker symbols, data items, and other details.
>
>
>On Thu, Sep 22, 2011 at 12:23 PM, Bill Durrance <high_winger@yahoo.com> wrote:
>
>
>>
>>I'm experiencing the same problem.  Any resolution yet?
>>
>>From: Dr_KrwL <anml819@yahoo.com>
>>>To: smf_addin@yahoogroups.com
>>>Sent: Wednesday, September 21, 2011 8:23 PM
>>>Subject: [smf_addin] Update problems today 9/21...Is it just me???
>>>
>>> 
>>>Quotes don't appear to be updating correctly today...just me???
>>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1d.

Re: Update problems today 9/21...Is it just me???

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 2:06 pm (PDT)

How are you forcing the update? I see you are using NOW() with the
RCHGetYahooQuotes() function. F9 will update it, but will not update the
smfGetOptionQuotes() results.

I just tried:

=smfGetOptionQuotes("UPRO Oct 2011 OTM1 Call","s")

...and it worked fine for me, returning $46. smfGetOptionQuotes() is just a
wrapper function that ends up using an RCHGetTableCell() function to
actually retrieve the data.

On Thu, Sep 22, 2011 at 1:57 PM, Bill Durrance <high_winger@yahoo.com>wrote:

>
> I was pulling up option values and current pricing for UPRO using
> =RCHGetYahooQuotes( $A1,"l1",,NOW()) and
> =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A3,B$3, "
> ",A$2),"b") . which should trtanslate to: UPRO Oct 2011 OTM1 Call
>
> where A1:B$ =
>
> UPRO Oct Call *5.00* OTM 1 Strike = 57
>
> The strike is found using: =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1,"
> 2011 ",A3,B$3, " ",A$2),"s")
>
> The Concat() should = UPRO Oct 2011 OTM1 Call
>
> The call value appeared to be consitently incorrect or from a nother cell
> such as OTM3. Puts were doing the same thing. The price wasn't updating
> either. I had the Yahoo pages open for comparison. I tried to work around
> it by using get table cell from Yahoo, Google , and MSN. MSN might (kind of
> fuzzy now after many iterations) have worked the best.
>
> See anything obviously wrong?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1e.

Re: Update problems today 9/21...Is it just me???

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 2:18 pm (PDT)

I F9'ed many times followed by many other F***s...lol. 
 
=smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2),"s")
where CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2) gives

From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, September 22, 2011 5:06 PM
>Subject: Re: [smf_addin] Update problems today 9/21...Is it just me???
>
> 
>How are you forcing the update? I see you are using NOW() with the RCHGetYahooQuotes() function. F9 will update it, but will not update the smfGetOptionQuotes() results.
>
>I just tried:
>
>=smfGetOptionQuotes("UPRO Oct 2011 OTM1 Call","s")
>
>...and it worked fine for me, returning $46. smfGetOptionQuotes() is just a wrapper function that ends up using an RCHGetTableCell() function to actually retrieve the data.
>
>
>On Thu, Sep 22, 2011 at 1:57 PM, Bill Durrance <high_winger@yahoo.com> wrote:
>
>>
>>I was pulling up option values and current pricing for UPRO using =RCHGetYahooQuotes( $A1,"l1",,NOW())  and =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A3,B$3, " ",A$2),"b") . which should trtanslate to:
>>UPRO Oct 2011 OTM1 Call
>> 
>>where A1:B$ =
>> UPRO Oct
>>Call 5.00
>>OTM 1
>>Strike = 57
>>
>>The strike is found using: =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A3,B$3, " ",A$2),"s")
>>
>>The Concat() should =
>>UPRO Oct 2011 OTM1 Call
>>
>>The call value appeared to be consitently incorrect or from a nother cell such as OTM3.  Puts were doing the same thing.  The price wasn't updating either.  I had the Yahoo pages open for comparison.  I tried to work around it by using get table cell from Yahoo, Google , and MSN.  MSN might (kind of fuzzy now after many iterations) have worked the best.
>>
>>See anything obviously wrong?
>
UPRO Oct 2011 OTM1 Call
 
returns 51 for me as did copy/paste of your functions below.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1f.

Re: Update problems today 9/21...Is it just me???

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 2:39 pm (PDT)

As I said, F9 will *not* update the smfGetOptionQuotes() function. You need
to run the smfForceRecalculation macro. You may also need to make sure your
Internet settings are set to always get a new web page. See the two items in
the "Links" area of the group related to the smfForceRecalculation macro for
more info.

The copy/paste of my function would give the same result, since the web page
it extracts data from is probably already saved. All extractions go against
the saved copy of the web page, which is why you need to run
smfForceRecalculation.

On Thu, Sep 22, 2011 at 2:18 PM, Bill Durrance <high_winger@yahoo.com>wrote:

>
> I F9'ed many times followed by many other F***s...lol.
>
> =smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2),"s")
> where CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2) gives
> UPRO Oct 2011 OTM1 Call
>
> returns 51 for me as did copy/paste of your functions below.
>
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Thursday, September 22, 2011 5:06 PM
> *Subject:* Re: [smf_addin] Update problems today 9/21...Is it just me???
> **
>
> How are you forcing the update? I see you are using NOW() with the
> RCHGetYahooQuotes() function. F9 will update it, but will not update the
> smfGetOptionQuotes() results.
>
> I just tried:
>
> =smfGetOptionQuotes("UPRO Oct 2011 OTM1 Call","s")
>
> ...and it worked fine for me, returning $46. smfGetOptionQuotes() is just a
> wrapper function that ends up using an RCHGetTableCell() function to
> actually retrieve the data.
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

1g.

Re: Update problems today 9/21...Is it just me???

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 3:16 pm (PDT)

Sorry, I missed the NOT.  I will try later.  Thanks.
 
Awesome tool by thw way.  I really appreciate all you've put into the tool and the support! 

From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, September 22, 2011 5:39 PM
>Subject: Re: [smf_addin] Update problems today 9/21...Is it just me???
>
> 
>As I said, F9 will not update the smfGetOptionQuotes() function. You need to run the smfForceRecalculation macro. You may also need to make sure your Internet settings are set to always get a new web page. See the two items in the "Links" area of the group related to the smfForceRecalculation macro for more info.
>
>The copy/paste of my function would give the same result, since the web page it extracts data from is probably already saved. All extractions go against the saved copy of the web page, which is why you need to run smfForceRecalculation.
>
>
>On Thu, Sep 22, 2011 at 2:18 PM, Bill Durrance <high_winger@yahoo.com> wrote:
>
>>
>>I F9'ed many times followed by many other F***s...lol. 
>> 
>>=smfGetOptionQuotes(CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2),"s")
>>where CONCATENATE($A$1," ",$B$1," 2011 ",A$3, B3," ",A2) gives
>>UPRO Oct 2011 OTM1 Call
>>
>>returns 51 for me as did copy/paste of your functions below.
>>From: Randy Harmelink <rharmelink@gmail.com>
>>>To: smf_addin@yahoogroups.com
>>>Sent: Thursday, September 22, 2011 5:06 PM
>>>Subject: Re: [smf_addin] Update problems today 9/21...Is it just me???
>>>
>>> 
>>>How are you forcing the update? I see you are using NOW() with the RCHGetYahooQuotes() function. F9 will update it, but will not update the smfGetOptionQuotes() results.I just tried:=smfGetOptionQuotes("UPRO Oct 2011 OTM1 Call","s")...and it worked fine for me, returning $46. smfGetOptionQuotes() is just a wrapper function that ends up using an RCHGetTableCell() function to actually retrieve the data.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

2a.

S&P 500 price

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 12:27 pm (PDT)

Is there a "normal" way to get the current S&P value?  I can't locate it in the Element Numbers.  I've tried get table cell from a few sites.  Its hard to tell if its working correctly with Yahoo not updating as expected.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2b.

Re: S&P 500 price

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Thu Sep 22, 2011 1:22 pm (PDT)

try the RCHGetYahooQuotes formula

with SPY as ticker

http://f1.grp.yahoofs.com/v1/wJN7ToxeaEPoEjZy_26WKZlYqU401cRZipwDvt4PHAWohJrhenUl6irAASlytXXfJKYeZtaz_I2vkXzdZXtY1NLu9bxZsg/Documentation/3.0%20-%20RCHGetYahooQuotes.html

Marty

________________________________
From: Bill Durrance <high_winger@yahoo.com>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Thursday, September 22, 2011 3:27 PM
Subject: [smf_addin] S&P 500 price

 
Is there a "normal" way to get the current S&P value?  I can't locate it in the Element Numbers.  I've tried get table cell from a few sites.  Its hard to tell if its working correctly with Yahoo not updating as expected.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2c.

Re: S&P 500 price

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 1:31 pm (PDT)

I'd either use SPY or ^GSPC with RCHGetYahooQuotes().

On Thu, Sep 22, 2011 at 12:27 PM, Bill Durrance <high_winger@yahoo.com>wrote:

>
> Is there a "normal" way to get the current S&P value? I can't locate it in
> the Element Numbers. I've tried get table cell from a few sites. Its hard
> to tell if its working correctly with Yahoo not updating as expected.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2d.

Re: S&P 500 price

Posted by: "Bill Durrance" high_winger@yahoo.com   high_winger

Thu Sep 22, 2011 1:41 pm (PDT)

Thanks.  I prefer ^GSPC since SPY isn't the same price as the S&P.

From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, September 22, 2011 4:31 PM
>Subject: Re: [smf_addin] S&P 500 price
>
>
> 
>I'd either use SPY or ^GSPC with RCHGetYahooQuotes().
>
>
>On Thu, Sep 22, 2011 at 12:27 PM, Bill Durrance <high_winger@yahoo.com> wrote:
>
>
>>
>>Is there a "normal" way to get the current S&P value?  I can't locate it in the Element Numbers.  I've tried get table cell from a few sites.  Its hard to tell if its working correctly with Yahoo not updating as expected.
>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3a.

for us Canadians - any way to pull TSX/TSE specific data from Google

Posted by: "r d" freddy@email.com   stupid21bull

Thu Sep 22, 2011 9:30 pm (PDT)

Hi
Awesome plugin....but

Is there a way import "current" and "descriptive" data for TSX/TSE stocks like:
Name of Stock
Description
Current Price

???

Seems I can import historical Statement data....but current/descriptive data? Apparently MSN doesn't like Canada...

help :(

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

3b.

Re: for us Canadians - any way to pull TSX/TSE specific data from Go

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 10:04 pm (PDT)

Sample URLs, please. I don't do anything with TSX/TSE stocks.

On Thu, Sep 22, 2011 at 9:04 PM, r d <freddy@email.com> wrote:

> Hi
> Awesome plugin....but
>
> Is there a way import "current" and "descriptive" data for TSX/TSE stocks
> like:
> Name of Stock
> Description
> Current Price
>
> ???
>
> Seems I can import historical Statement data....but current/descriptive
> data? Apparently MSN doesn't like Canada...
>
> help :(
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4a.

question for Randy regarding Barron's Stock Grader

Posted by: "investor952" investor952@yahoo.com   investor952

Thu Sep 22, 2011 10:29 pm (PDT)

Hello Randy,

I have an online subscription to the WSJ and Barron's. The Barron's website has a link to their Stock Grader, which provides a numeric grade for a stock on a 0-100 scale. Below is an example of the link and output for the stock IBM. They grade this stock as a 74.3 which is a BUY.

Can you suggest a formula I can use to retrieve this in Excel? I don't see any headings or word to key off of. Thanks.

http://online.barrons.com/quotes/stock_grader.html?symbol=IBM

**********************************************

Search StockGrader:
---------------------------
International Business Machines Corp. (IBM)
INFORMATION TECHNOLOGY SERVICES 74.3

Company Scores Very Good Fundamental Grades -
MarketGrader currently has a BUY rating on International Business Machines Corp. (IBM), based on a final overall grade of 74.3 scored by the company's fundamental analysis. International Business Machines Corp. scores at the 96th percentile among all 6137 North American equities currently followed by MarketGrader. Our present rating dates to January 20, 2010, when it was upgraded from a HOLD. Relative to the Information Technology Services sub-industry, which is comprised of 134 companies, International Business Machines Corp.'s grade of 74.3 ranks fourth. The industry grade leader is Cognizant Technology Solutions Corp. (CTSH) with an overall grade of 80.6. The stock, up 4.19% in the last six months, has outperformed both the Information Technology Services group, down 12.88% and the S&P 500 Index, which has returned -9.14% in the same period.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4b.

Re: question for Randy regarding Barron's Stock Grader

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Sep 22, 2011 11:46 pm (PDT)

Sorry, but based on what you've shown, I can't tell if it can be extracted.

On Thu, Sep 22, 2011 at 10:28 PM, investor952 <investor952@yahoo.com> wrote:

>
> I have an online subscription to the WSJ and Barron's. The Barron's website
> has a link to their Stock Grader, which provides a numeric grade for a stock
> on a 0-100 scale. Below is an example of the link and output for the stock
> IBM. They grade this stock as a 74.3 which is a BUY.
>
> Can you suggest a formula I can use to retrieve this in Excel? I don't see
> any headings or word to key off of. Thanks.
>
>
> http://online.barrons.com/quotes/stock_grader.html?symbol=IBM
>
> **********************************************
>
> Search StockGrader:
> ---------------------------
> International Business Machines Corp. (IBM)
> INFORMATION TECHNOLOGY SERVICES 74.3
>
> Company Scores Very Good Fundamental Grades -
> MarketGrader currently has a BUY rating on International Business Machines
> Corp. (IBM), based on a final overall grade of 74.3 scored by the company's
> fundamental analysis. International Business Machines Corp. scores at the
> 96th percentile among all 6137 North American equities currently followed by
> MarketGrader. Our present rating dates to January 20, 2010, when it was
> upgraded from a HOLD. Relative to the Information Technology Services
> sub-industry, which is comprised of 134 companies, International Business
> Machines Corp.'s grade of 74.3 ranks fourth. The industry grade leader is
> Cognizant Technology Solutions Corp. (CTSH) with an overall grade of 80.6.
> The stock, up 4.19% in the last six months, has outperformed both the
> Information Technology Services group, down 12.88% and the S&P 500 Index,
> which has returned -9.14% in the same period.
>
>
>
> ------------------------------------
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  101
  New Members

Visit Your Group

Yahoo! News

Get it all here

Breaking news to

entertainment news

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe