12 New Messages
Digest #2581
3a
[NEWBIE] Can NASDAQ Real-Time data be captured ? by "jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
Messages
Thu Apr 11, 2013 6:59 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
if i were to add another concatenation operator, that will be
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1"/''&A1''/financials/",4,"(EBITDA)")," ","")?
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You need another concatenation operator between A1 and "/financials/".
>
> If you're having difficulties like that, create the URL outside of the
> formula FIRST, so you know it's OK. Otherwise, you don't know if it is the
> add-in formula, or something else. This is an EXCEL issue, not an add-in
> one.
>
> On Wed, Apr 10, 2013 at 11:53 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > the code when input,
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "Â Â Â Â & Â Â
> > A1Â Â Â Â & Â Â "/financials/",4,"(EBITDA)")," ","")
> >
> > gives a formula error
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1"/financials/",4,"(EBITDA)"),"
> > ","")
> >
> > still gives a formula error ''VALUE''!
> >
> > what is wrong?
> >
>
if i were to add another concatenation operator, that will be
=0+SUBSTITUTE(
thanks
--- In smf_addin@yahoogrou
>
> You need another concatenation operator between A1 and "/financials/
>
> If you're having difficulties like that, create the URL outside of the
> formula FIRST, so you know it's OK. Otherwise, you don't know if it is the
> add-in formula, or something else. This is an EXCEL issue, not an add-in
> one.
>
> On Wed, Apr 10, 2013 at 11:53 PM, weekeewawa <weekeewawa@
>
> >
> > the code when input,
> >
> > =0+SUBSTITUTE(
> > A1Â Â Â Â & Â Â "/financials/
> >
> > gives a formula error
> >
> > =0+SUBSTITUTE(
> > ","
> >
> > still gives a formula error ''VALUE&#
> >
> > what is wrong?
> >
>
Thu Apr 11, 2013 2:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All you needed was the concatenation operator (i.e. the ampersand). I don't
know what you added another A1 cell reference. Or and additional slash.
On Thu, Apr 11, 2013 at 6:59 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> if i were to add another concatenation operator, that will be
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1"/''&A1''/financials/",4,"(EBITDA)"),"
> ","")?
>
know what you added another A1 cell reference. Or and additional slash.
On Thu, Apr 11, 2013 at 6:59 AM, weekeewawa <weekeewawa@yahoo.
>
> if i were to add another concatenation operator, that will be
>
> =0+SUBSTITUTE(
> ","
>
Thu Apr 11, 2013 5:26 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
the code which is then
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
still gives a #Value! error.
it could not have been
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ ''&A1''/financials/",4,"(EBITDA)")," ","")
or
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ ''&A1&''&/financials/",4,"(EBITDA)")," ","")
as it makes no sense...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> All you needed was the concatenation operator (i.e. the ampersand). I don't
> know what you added another A1 cell reference. Or and additional slash.
>
> On Thu, Apr 11, 2013 at 6:59 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > if i were to add another concatenation operator, that will be
> >
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1"/''&A1''/financials/",4,"(EBITDA)"),"
> > ","")?
> >
>
the code which is then
=0+SUBSTITUTE(
still gives a #Value! error.
it could not have been
=0+SUBSTITUTE(
or
=0+SUBSTITUTE(
as it makes no sense...
--- In smf_addin@yahoogrou
>
> All you needed was the concatenation operator (i.e. the ampersand). I don't
> know what you added another A1 cell reference. Or and additional slash.
>
> On Thu, Apr 11, 2013 at 6:59 AM, weekeewawa <weekeewawa@
>
> >
> > if i were to add another concatenation operator, that will be
> >
> > =0+SUBSTITUTE(
> > ","
> >
>
Thu Apr 11, 2013 6:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because you're using two apostrophes instead of a double-quote
delimiter when you create the URL.
On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> the code which is then
>
> =0+SUBSTITUTE(RCHGetTableCell("
> http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
>
> still gives a #Value! error.
>
delimiter when you create the URL.
On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@yahoo.
>
> the code which is then
>
> =0+SUBSTITUTE(
> http://www.4-
>
> still gives a #Value! error.
>
Thu Apr 11, 2013 9:57 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
i am sorry, but i still cannot get the code.
is it possible to give the example code?
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's because you're using two apostrophes instead of a double-quote
> delimiter when you create the URL.
>
> On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > the code which is then
> >
> > =0+SUBSTITUTE(RCHGetTableCell("
> > http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
> >
> > still gives a #Value! error.
> >
>
i am sorry, but i still cannot get the code.
is it possible to give the example code?
thanks
--- In smf_addin@yahoogrou
>
> That's because you're using two apostrophes instead of a double-quote
> delimiter when you create the URL.
>
> On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@
>
> >
> > the code which is then
> >
> > =0+SUBSTITUTE(
> > http://www.4-
> >
> > still gives a #Value! error.
> >
>
Thu Apr 11, 2013 10:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try this:
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1&"/financials/",4,"(EBITDA)"),"
","")
On Thu, Apr 11, 2013 at 9:57 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy,
>
> i am sorry, but i still cannot get the code.
>
> is it possible to give the example code?
>
> thanks
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > That's because you're using two apostrophes instead of a double-quote
> > delimiter when you create the URL.
> >
> > On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@...> wrote:
> >
> > >
> > > the code which is then
> > >
> > > =0+SUBSTITUTE(RCHGetTableCell("
> > > http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
> > >
> > > still gives a #Value! error.
>
=0+SUBSTITUTE(
","
On Thu, Apr 11, 2013 at 9:57 PM, weekeewawa <weekeewawa@yahoo.
> hello randy,
>
> i am sorry, but i still cannot get the code.
>
> is it possible to give the example code?
>
> thanks
>
> --- In smf_addin@yahoogrou
> >
> > That's because you're using two apostrophes instead of a double-quote
> > delimiter when you create the URL.
> >
> > On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@
> >
> > >
> > > the code which is then
> > >
> > > =0+SUBSTITUTE(
> > > http://www.4-
> > >
> > > still gives a #Value! error.
>
Thu Apr 11, 2013 10:58 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
oh my randy
it is incredibly strange
i typed in the exact same code
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
vs
yours
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1&"/financials/",4,"(EBITDA)")," ","")
but mine is value error and urs is correct!
how did u get the '' on the keyboard?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try this:
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1&"/financials/",4,"(EBITDA)"),"
> ","")
>
> On Thu, Apr 11, 2013 at 9:57 PM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy,
> >
> > i am sorry, but i still cannot get the code.
> >
> > is it possible to give the example code?
> >
> > thanks
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > That's because you're using two apostrophes instead of a double-quote
> > > delimiter when you create the URL.
> > >
> > > On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@> wrote:
> > >
> > > >
> > > > the code which is then
> > > >
> > > > =0+SUBSTITUTE(RCHGetTableCell("
> > > > http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
> > > >
> > > > still gives a #Value! error.
> >
>
it is incredibly strange
i typed in the exact same code
=0+SUBSTITUTE(
vs
yours
=0+SUBSTITUTE(
but mine is value error and urs is correct!
how did u get the '' on the keyboard?
--- In smf_addin@yahoogrou
>
> Try this:
>
> =0+SUBSTITUTE(
> ","
>
> On Thu, Apr 11, 2013 at 9:57 PM, weekeewawa <weekeewawa@
>
> > hello randy,
> >
> > i am sorry, but i still cannot get the code.
> >
> > is it possible to give the example code?
> >
> > thanks
> >
> > --- In smf_addin@yahoogrou
> > >
> > > That's because you're using two apostrophes instead of a double-quote
> > > delimiter when you create the URL.
> > >
> > > On Thu, Apr 11, 2013 at 5:26 PM, weekeewawa <weekeewawa@
> > >
> > > >
> > > > the code which is then
> > > >
> > > > =0+SUBSTITUTE(
> > > > http://www.4-
> > > >
> > > > still gives a #Value! error.
> >
>
Thu Apr 11, 2013 11:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I told you -- you're using TWO APOSTROPHES instead of a double quote, twice
(on either side of the &A1&).
You don't want two ' characters. You want one " character. They're the same
key on the keyboard, but the apostrophe is the unshifted version of the key.
On Thu, Apr 11, 2013 at 10:58 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> it is incredibly strange
>
> i typed in the exact same code
>
> =0+SUBSTITUTE(RCHGetTableCell("
> http://www.4-traders.com/ ''&A1&''/financials/",4,"(EBITDA)")," ","")
>
> vs
>
> yours
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&A1&"/financials/",4,"(EBITDA)"),"
> ","")
>
> but mine is value error and urs is correct!
>
> how did u get the '' on the keyboard?
>
(on either side of the &A1&
You don't want two ' characters. You want one " character. They're the same
key on the keyboard, but the apostrophe is the unshifted version of the key.
On Thu, Apr 11, 2013 at 10:58 PM, weekeewawa <weekeewawa@yahoo.
>
> it is incredibly strange
>
> i typed in the exact same code
>
> =0+SUBSTITUTE(
> http://www.4-
>
> vs
>
> yours
>
> =0+SUBSTITUTE(
> ","
>
> but mine is value error and urs is correct!
>
> how did u get the '' on the keyboard?
>
Thu Apr 11, 2013 9:25 am (PDT) . Posted by:
"Louis Benedict" lsbenedict
Hi there,
I've installed the add in Excel 2013, but am unable to see whether the calculation in the Test File works as my F9 on my computer dims the screen. How else can I calculate without pressing the F9 key?
Thank you!
I've installed the add in Excel 2013, but am unable to see whether the calculation in the Test File works as my F9 on my computer dims the screen. How else can I calculate without pressing the F9 key?
Thank you!
Thu Apr 11, 2013 2:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In EXCEL 2007, I can go to the "Formulas"; menu tab, and then click on the
"Calculate Now" button.
But I have no idea what "test file" you are talking about. Maybe you need
the smfForceRecalculation macro on a button. See the LINKS area for more
info on this macro.
On Thu, Apr 11, 2013 at 7:23 AM, Louis Benedict <lsbenedict@yahoo.com >wrote:
>
> I've installed the add in Excel 2013, but am unable to see whether the
> calculation in the Test File works as my F9 on my computer dims the screen.
> How else can I calculate without pressing the F9 key?
>
>
"Calculate Now" button.
But I have no idea what "test file" you are talking about. Maybe you need
the smfForceRecalculati
info on this macro.
On Thu, Apr 11, 2013 at 7:23 AM, Louis Benedict <lsbenedict@yahoo.
>
> I've installed the add in Excel 2013, but am unable to see whether the
> calculation in the Test File works as my F9 on my computer dims the screen.
> How else can I calculate without pressing the F9 key?
>
>
Thu Apr 11, 2013 6:21 pm (PDT) . Posted by:
"jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
Apologies if this has been addressed somewhere already
Have just found this forum and I am wondering if there is the ability to read the Amazon page of the NASDAQ real-time share price info - ideally the current price and the time of this price ?
Cheers in advance
Have just found this forum and I am wondering if there is the ability to read the Amazon page of the NASDAQ real-time share price info - ideally the current price and the time of this price ?
Cheers in advance
Thu Apr 11, 2013 6:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample URL please?
On Thu, Apr 11, 2013 at 5:25 PM, jshgfhjsgdfhjgsdfutef <
cybersurferuk@googlemail.com > wrote:
> Apologies if this has been addressed somewhere already
>
> Have just found this forum and I am wondering if there is the ability to
> read the Amazon page of the NASDAQ real-time share price info - ideally the
> current price and the time of this price ?
>
On Thu, Apr 11, 2013 at 5:25 PM, jshgfhjsgdfhjgsdfut
cybersurferuk@
> Apologies if this has been addressed somewhere already
>
> Have just found this forum and I am wondering if there is the ability to
> read the Amazon page of the NASDAQ real-time share price info - ideally the
> current price and the time of this price ?
>
Tidak ada komentar:
Posting Komentar