[smf_addin] Digest Number 2103

EXCEL Stock Market Functions Add-in

Messages In This Digest (11 Messages)

1a.

Re: tmxmoney.com From: bushpilote@yahoo.ca

2a.

Re: IBD and RCHGetTableCell Error From: Roger Diaz

3a.

ADVFN again From: codyklein

3b.

Re: ADVFN again From: codyklein

3c.

Re: ADVFN again From: Randy Harmelink

3d.

Re: ADVFN again From: codyklein

3e.

Re: ADVFN again From: codyklein

3f.

Re: ADVFN again From: Randy Harmelink

3g.

Re: ADVFN again From: Randy Harmelink

3h.

Re: ADVFN again From: codyklein

3i.

Re: ADVFN again From: codyklein

View All Topics | Create New Topic

Messages

1a.

Re: tmxmoney.com

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Fri Feb 3, 2012 5:30 am (PST)

Randy, Mike amd Don thanks for the replies. Web Query works well at my end. I'll explore that as a possible solution.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. I can get it into the Web Query dialog now too. But when the XMLHTTP
> protocol tries to retrieve the web page for the add-in, it gets some
> cryptic error message numbers (large negative integers). So if it can't
> retrieve the source code of the web page, none of the add-in functions are
> going to work.
>
> I wonder if the PHP routine has some way to identify what is going after
> the data?
>
> On Thu, Feb 2, 2012 at 8:54 AM, Mike McQuaid <mikemcq802@...> wrote:
>
> > **
> >
> > Randy, I can see that site just fine in Excel Web Query (and IE). In
> > fact, I used W/Q to place that whole web page in my worksheet and I saw it
> > fine - including sector and industry.
> >
> > But, I can't get the TableCell or TagContent to work either - not sure why
> > - I don't usually have trouble with those.
> >
>

Back to top

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

2a.

Re: IBD and RCHGetTableCell Error

Posted by: "Roger Diaz" rogerdiazb@gmail.com   rogerdiazbernal

Fri Feb 3, 2012 6:20 am (PST)

Thank you very much, Randy.
Someone can help me give me VBA code to extract data ratings to Excel Web
IBD.
To apply the reading of the symbol, copy and paste the ratings and
and continue
to the next symbol and ends when you find blank cell symbol?

2012/2/2 Randy Harmelink <rharmelink@gmail.com>

> **
>
>
> The problem is that they have changed the URLs. It is no longer driven
> simply by ticker symbol, so it's going to be more difficult to grab data.
> For example, instead of:
>
> http://www.investors.com/StockResearch/StockCheckup.aspx?symbol=MMM
>
> ...the URL now needs to be:
>
> http://research.investors.com/StockCheckup/Nyse-Three-M-Company-MMM.aspx
>
>
> On Thu, Feb 2, 2012 at 7:56 PM, Roger Diaz <rogerdiazb@gmail.com> wrote:
>
>>
>> I am a subscriber of IBD but I try to apply the formula for ratings
>> information but always get Error.
>> =RCHGetTableCell("
>> http://www.investors.com/StockResearch/StockCheckup.aspx?symbol="&A$5,1,">RS
>> Rating")
>> I saw the post on this subject, but always fails. In Excel / Data / Web
>> enter my username and pswd and see the results but not the formula does
>> not extract the data.
>> I will appreciate your answer.
>>
>>
>
>

Back to top

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

3a.

ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 11:47 am (PST)

Stopped working again. Tried Apple. the prefix is still www. Used "AAPL", "NASDAQ:AAPL" no luck. Things worked this morning. Exited excel and restarted, no luck. Anyone else see a problem.

Back to top

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

3b.

Re: ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 12:15 pm (PST)

STJ ticker works but not AAPL???

--- In smf_addin@yahoogroups.com, "codyklein" <codyklein@...> wrote:
>
> Stopped working again. Tried Apple. the prefix is still www. Used "AAPL", "NASDAQ:AAPL" no luck. Things worked this morning. Exited excel and restarted, no luck. Anyone else see a problem.
>

Back to top

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

3c.

Re: ADVFN again

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

Fri Feb 3, 2012 12:18 pm (PST)

I just opened the template from the files area and tried AAPL -- everything
seems to be working fine here.

Might something have changed your cache settings in Internet Options, so
you're not getting a fresh copy of the web page each time?

On Fri, Feb 3, 2012 at 1:15 PM, codyklein <codyklein@alum.drexel.edu> wrote:

> STJ ticker works but not AAPL???
>
> --- In smf_addin@yahoogroups.com, "codyklein" <codyklein@...> wrote:
> >
> > Stopped working again. Tried Apple. the prefix is still www. Used
> "AAPL", "NASDAQ:AAPL" no luck.
>
> Things worked this morning. Exited excel and restarted, no luck. Anyone
> else see a problem.
>

Back to top

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

3d.

Re: ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 12:46 pm (PST)

I used the smfForcerecalculation, wouldn't that take care of this? I checked the setting and its set for everytime I visit the webpage.

I downloaded "smfGetAdvFNElement-Template-All-Line-Items.xls" Restarted the computer. Other tickers are working but not AAPL, INTC or MSFT

The version is: Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-in; 1)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just opened the template from the files area and tried AAPL -- everything
> seems to be working fine here.
>
> Might something have changed your cache settings in Internet Options, so
> you're not getting a fresh copy of the web page each time?
>
> On Fri, Feb 3, 2012 at 1:15 PM, codyklein <codyklein@...> wrote:
>
> > STJ ticker works but not AAPL???
> >
> > --- In smf_addin@yahoogroups.com, "codyklein" <codyklein@> wrote:
> > >
> > > Stopped working again. Tried Apple. the prefix is still www. Used
> > "AAPL", "NASDAQ:AAPL" no luck.
> >
> > Things worked this morning. Exited excel and restarted, no luck. Anyone
> > else see a problem.
> >
>

Back to top

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

3e.

Re: ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 12:52 pm (PST)

Found the problem. The ticker in the URL is NASDAQ%3AAAPL
http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ%3AAAPL

That worked. Not sure how to get around that unless its consistent

--- In smf_addin@yahoogroups.com, "codyklein" <codyklein@...> wrote:
>
> I used the smfForcerecalculation, wouldn't that take care of this? I checked the setting and its set for everytime I visit the webpage.
>
> I downloaded "smfGetAdvFNElement-Template-All-Line-Items.xls" Restarted the computer. Other tickers are working but not AAPL, INTC or MSFT
>
> The version is: Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-in; 1)
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > I just opened the template from the files area and tried AAPL -- everything
> > seems to be working fine here.
> >
> > Might something have changed your cache settings in Internet Options, so
> > you're not getting a fresh copy of the web page each time?
> >
> > On Fri, Feb 3, 2012 at 1:15 PM, codyklein <codyklein@> wrote:
> >
> > > STJ ticker works but not AAPL???
> > >
> > > --- In smf_addin@yahoogroups.com, "codyklein" <codyklein@> wrote:
> > > >
> > > > Stopped working again. Tried Apple. the prefix is still www. Used
> > > "AAPL", "NASDAQ:AAPL" no luck.
> > >
> > > Things worked this morning. Exited excel and restarted, no luck. Anyone
> > > else see a problem.
> > >
> >
>

Back to top

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

3f.

Re: ADVFN again

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

Fri Feb 3, 2012 12:54 pm (PST)

smfForceRecalculation would tell the add-in to get a new copy of the web
page, to replace the copy it had saved so that data can be extracted from
it. However, if the Internet Options aren't set to get a fresh copy of the
web page, XMLHTTP could just return the cached copy of the web page to the
add-in.

I just tried that same template with the same three ticker symbols -- all
worked fine for me.

On Fri, Feb 3, 2012 at 1:46 PM, codyklein <codyklein@alum.drexel.edu> wrote:

> I used the smfForcerecalculation, wouldn't that take care of this? I
> checked the setting and its set for everytime I visit the webpage.
>
> I downloaded "smfGetAdvFNElement-Template-All-Line-Items.xls" Restarted
> the computer. Other tickers are working but not AAPL, INTC or MSFT
>
> The version is: Stock Market Functions add-in, Version 2.1.2012.02.02
> (C:\Program Files\SMF Add-in; 1)
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Might something have changed your cache settings in Internet Options, so
> > you're not getting a fresh copy of the web page each time?
>

Back to top

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

3g.

Re: ADVFN again

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

Fri Feb 3, 2012 12:56 pm (PST)

Hmmm. I don't need the exchange on mine.

In your browser, were do you end up if you tell it to go to "advfn.com"?

Do you end up at "http;//www.advfn.com" or do you have a prefix other than
"www"?

On Fri, Feb 3, 2012 at 1:52 PM, codyklein <codyklein@alum.drexel.edu> wrote:

> Found the problem. The ticker in the URL is NASDAQ%3AAAPL
>
> http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ%3AAAPL
>
> That worked. Not sure how to get around that unless its consistent
>

Back to top

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

3h.

Re: ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 1:12 pm (PST)

I end up back at www. I also noticed that for some symbols just the symbol works like STJ but so does NYSE%3ASTJ.

For MSFT I get http://www.advfn.com/p.php?pid=financials&btn=s_ok&mode=annual_reports&symbol=MSFT&s_ok=OK&start_date=14 but when I switch to qtr reports then back to annual reports I get: http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=quarterly_reports&symbol=NASDAQ%3AMSFT&istart_date=67

Different URL, same data but the only ticker that works for MSFT is NASDAQ%3AMSFT

Looks like they ae still trying to make changes???

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. I don't need the exchange on mine.
>
> In your browser, were do you end up if you tell it to go to "advfn.com"?
>
> Do you end up at "http;//www.advfn.com" or do you have a prefix other than
> "www"?
>
> On Fri, Feb 3, 2012 at 1:52 PM, codyklein <codyklein@...> wrote:
>
> > Found the problem. The ticker in the URL is NASDAQ%3AAAPL
> >
> > http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ%3AAAPL
> >
> > That worked. Not sure how to get around that unless its consistent
> >
>

Back to top

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

3i.

Re: ADVFN again

Posted by: "codyklein" codyklein@alum.drexel.edu   codyklein

Fri Feb 3, 2012 2:23 pm (PST)

Turns out its not a big deal. I can handle it with a table.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. I don't need the exchange on mine.
>
> In your browser, were do you end up if you tell it to go to "advfn.com"?
>
> Do you end up at "http;//www.advfn.com" or do you have a prefix other than
> "www"?
>
> On Fri, Feb 3, 2012 at 1:52 PM, codyklein <codyklein@...> wrote:
>
> > Found the problem. The ticker in the URL is NASDAQ%3AAAPL
> >
> > http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NASDAQ%3AAAPL
> >
> > That worked. Not sure how to get around that unless its consistent
> >
>

Back to top

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

Recent Activity

•  125
  New Members
•  1
  New Links
•  6
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

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

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