Kamis, 31 Mei 2012

[smf_addin] Digest Number 2231

Messages In This Digest (14 Messages)

1a.
Downloading a table from Barchart.com From: oryxius
1b.
Re: Downloading a table from Barchart.com From: Randy Harmelink
1c.
Re: Downloading a table from Barchart.com From: oryxius
1d.
Re: Downloading a table from Barchart.com From: Randy Harmelink
1e.
Re: Downloading a table from Barchart.com From: oryxius
2a.
templates From: lyle
2b.
Re: templates From: Randy Harmelink
2c.
Re: templates From: lyle burditt
2d.
Re: templates From: Randy Harmelink
3a.
MSN Elements not working From: oryxius
3b.
Re: MSN Elements not working From: Randy Harmelink
3c.
Re: MSN Elements not working From: investor952
3d.
Re: MSN Elements not working From: oryxius
3e.
Re: MSN Elements not working From: oryxius

Messages

1a.

Downloading a table from Barchart.com

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

Wed May 30, 2012 10:33 am (PDT)



I am trying to download a table of the bottom signal stocks from Barchart.com. I am using the formula:

=RCHGetHTMLTable("http://www.barchart.com/stocks/signals/bottom100","Custom View",1,"REGISTER FOR",-1)

With "Custom View" and "REGISTER FOR" being the two search boundaries before and after the table.

But it is not working, what am I doing wrong?

Thank you,

M.K.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1b.

Re: Downloading a table from Barchart.com

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

Wed May 30, 2012 10:42 am (PDT)



That formula works fine for me. What results are you getting?

On Wed, May 30, 2012 at 10:33 AM, oryxius <oryxius@yahoo.com> wrote:

> I am trying to download a table of the bottom signal stocks from
> Barchart.com. I am using the formula:
>
> =RCHGetHTMLTable("http://www.barchart.com/stocks/signals/bottom100","Custom
> View",1,"REGISTER FOR",-1)
>
> With "Custom View" and "REGISTER FOR" being the two search boundaries
> before and after the table.
>
> But it is not working, what am I doing wrong?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1c.

Re: Downloading a table from Barchart.com

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

Wed May 30, 2012 11:20 am (PDT)



When I press CTRL+SHFT+ENTER for the array, excel just displays the formula in the highlighted cells. No results.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That formula works fine for me. What results are you getting?
>
> On Wed, May 30, 2012 at 10:33 AM, oryxius <oryxius@...> wrote:
>
> > I am trying to download a table of the bottom signal stocks from
> > Barchart.com. I am using the formula:
> >
> > =RCHGetHTMLTable("http://www.barchart.com/stocks/signals/bottom100","Custom
> > View",1,"REGISTER FOR",-1)
> >
> > With "Custom View" and "REGISTER FOR" being the two search boundaries
> > before and after the table.
> >
> > But it is not working, what am I doing wrong?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1d.

Re: Downloading a table from Barchart.com

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

Wed May 30, 2012 12:31 pm (PDT)



Try it in a brand new workbook and see if you get the same results.

There are reasons a formula will show up instead of the calculated results
of a formula.

http://www.mrexcel.com/archive/Formatting/2921.html
http://www.mrexcel.com/articles/show-formulas-in-cells.php

On Wed, May 30, 2012 at 11:20 AM, oryxius <oryxius@yahoo.com> wrote:

> When I press CTRL+SHFT+ENTER for the array, excel just displays the
> formula in the highlighted cells. No results.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1e.

Re: Downloading a table from Barchart.com

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

Wed May 30, 2012 8:49 pm (PDT)



Thank you Randy. One of the discussion threads you pointed me to mentioned that it is a formatting issue. So I copied the formula into a text pad and noticed that there are two spaces before the equal sign. I removed these and then re-copied the formula back into Excel, and voila! it worked.

Thank you.

m.k.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try it in a brand new workbook and see if you get the same results.
>
> There are reasons a formula will show up instead of the calculated results
> of a formula.
>
> http://www.mrexcel.com/archive/Formatting/2921.html
> http://www.mrexcel.com/articles/show-formulas-in-cells.php
>
> On Wed, May 30, 2012 at 11:20 AM, oryxius <oryxius@...> wrote:
>
> > When I press CTRL+SHFT+ENTER for the array, excel just displays the
> > formula in the highlighted cells. No results.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

templates

Posted by: "lyle" ljb7011@yahoo.com   ljb7011

Wed May 30, 2012 2:14 pm (PDT)



I am running excel 2007 and have confirmed my installation with the =RCHGetYahooHistory("MSFT") test. My problem now is I cannot get any of the templates to work. I have looked though all the files and used the examples and documentation and such but no luck. Any suggestion?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2b.

Re: templates

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

Wed May 30, 2012 2:17 pm (PDT)



You may need to fix unresolved links (see the "Location errors" item in the
LINKS area of the group).

Otherwise, "it doesn't work" isn't enough of a description of a problem to
give me a way to help.

On Wed, May 30, 2012 at 2:04 PM, lyle <ljb7011@yahoo.com> wrote:

> I am running excel 2007 and have confirmed my installation with the
> =RCHGetYahooHistory("MSFT") test. My problem now is I cannot get any of the
> templates to work. I have looked though all the files and used the examples
> and documentation and such but no luck. Any suggestion?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2c.

Re: templates

Posted by: "lyle burditt" ljb7011@yahoo.com   ljb7011

Wed May 30, 2012 2:48 pm (PDT)



Basically when I type a ticker symbol into a template nothing happens. Usually just #NAME comes up in every box.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 30, 2012 4:17 PM
Subject: Re: [smf_addin] templates


 
You may need to fix unresolved links (see the "Location errors" item in the LINKS area of the group).

Otherwise, "it doesn't work" isn't enough of a description of a problem to give me a way to help.

On Wed, May 30, 2012 at 2:04 PM, lyle <ljb7011@yahoo.com> wrote:

I am running excel 2007 and have confirmed my installation with the =RCHGetYahooHistory("MSFT") test. My problem now is I cannot get any of the templates to work. I have looked though all the files and used the examples and documentation and such but no luck. Any suggestion?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2d.

Re: templates

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

Wed May 30, 2012 3:53 pm (PDT)



Those are the unresolved links I mentioned. They have to be manually fixed.

On Wed, May 30, 2012 at 2:48 PM, lyle burditt <ljb7011@yahoo.com> wrote:

>
> Usually just #NAME comes up in every box.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3a.

MSN Elements not working

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

Wed May 30, 2012 9:31 pm (PDT)



Am I missing some update? All the MSN elements I tried are not working. I've just replaced my addin files with the addin file package in Works in Progress (including the msf-elements-1 file), but still no luck.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.

Re: MSN Elements not working

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

Wed May 30, 2012 10:10 pm (PDT)



Did you replace the file after exiting EXCEL? The add-in loads the element
definitions once, so if you replace the definitions file after that loading
process, you won't pick up the new definitions until you exit and restart
EXCEL, or run the smfForceRecalculation macro (see LINKS area of the Yahoo
group).

On Wed, May 30, 2012 at 9:31 PM, oryxius <oryxius@yahoo.com> wrote:

> Am I missing some update? All the MSN elements I tried are not working.
> I've just replaced my addin files with the addin file package in Works in
> Progress (including the msf-elements-1 file), but still no luck.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3c.

Re: MSN Elements not working

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

Wed May 30, 2012 10:10 pm (PDT)



mine seem to be working fine now

--- In smf_addin@yahoogroups.com, "oryxius" <oryxius@...> wrote:
>
> Am I missing some update? All the MSN elements I tried are not working. I've just replaced my addin files with the addin file package in Works in Progress (including the msf-elements-1 file), but still no luck.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.

Re: MSN Elements not working

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

Thu May 31, 2012 12:37 am (PDT)



I did. I also ran the smfForceRecalculation macro. I also changed IE's Temp. Internet files setting to open new sites on every visit. Purged the temp. files several times and restarted excel several times (forcing it to calculate every time). but nothing is working. I noticed that the SMF-Elements-1 file I downloaded from the worksinprogress folder displays Jan. 27 as the last modification date. Isn't it supposed to show a May modification date?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Did you replace the file after exiting EXCEL? The add-in loads the element
> definitions once, so if you replace the definitions file after that loading
> process, you won't pick up the new definitions until you exit and restart
> EXCEL, or run the smfForceRecalculation macro (see LINKS area of the Yahoo
> group).
>
> On Wed, May 30, 2012 at 9:31 PM, oryxius <oryxius@...> wrote:
>
> > Am I missing some update? All the MSN elements I tried are not working.
> > I've just replaced my addin files with the addin file package in Works in
> > Progress (including the msf-elements-1 file), but still no luck.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3e.

Re: MSN Elements not working

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

Thu May 31, 2012 12:54 am (PDT)



OK, it's now working. I have found out that, for some quirky reason, if you choose to replace the old file when downloading, it somehow either windows does not replace the old file or it keeps its time stamps. But things changed when I downloaded the new file into a different folder, deleted the old one and then moved the updated one there!

--- In smf_addin@yahoogroups.com, "oryxius" <oryxius@...> wrote:
>
> I did. I also ran the smfForceRecalculation macro. I also changed IE's Temp. Internet files setting to open new sites on every visit. Purged the temp. files several times and restarted excel several times (forcing it to calculate every time). but nothing is working. I noticed that the SMF-Elements-1 file I downloaded from the worksinprogress folder displays Jan. 27 as the last modification date. Isn't it supposed to show a May modification date?
>
>
>
>
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Did you replace the file after exiting EXCEL? The add-in loads the element
> > definitions once, so if you replace the definitions file after that loading
> > process, you won't pick up the new definitions until you exit and restart
> > EXCEL, or run the smfForceRecalculation macro (see LINKS area of the Yahoo
> > group).
> >
> > On Wed, May 30, 2012 at 9:31 PM, oryxius <oryxius@> wrote:
> >
> > > Am I missing some update? All the MSN elements I tried are not working.
> > > I've just replaced my addin files with the addin file package in Works in
> > > Progress (including the msf-elements-1 file), but still no luck.
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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
Diposting oleh EXCEL FEED LEARNING di 01.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)