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/ ","Custom View",1,"REGISTER FOR",-1)signals/bottom10 0
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.
- 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/ ","Customsignals/bottom10 0
> 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?
>
- 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/ ","Customsignals/bottom10 0
> > 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?
> >
>
- 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.
>
- 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.
> >
>
- 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
- 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?
>
- 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?
>
- 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.
>
- 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.
- 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.
>
- 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.
>
- 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.
> >
>
- 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.
> > >
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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
