3 New Messages
Digest #2580
Messages
Wed Apr 10, 2013 10:30 am (PDT) . Posted by:
"PeteA" option2z
RE:
<http://groups.
BF9TAzk3MzU5NzE1BGd
NQRzZWMDZG1zZwRzbGs
Tue Apr 9, 2013 3:34 am (PDT) . Posted by:
<mailto:kenneth.dooley@
"tenenbaum88&q
I don't know if the group has seen this or not or the feasibility with
integrating it into the SMF addon, but it has a stunning amount of free
historical financial data available.
edit - after looking at some more, there is apparently an Excel and Matlab
addin as well.
http://www.quandl.
I've installed the addin and it works. BUT, it does some odd things, making
me wonder about the implementation. I sent them a report of this behavior
and got a nice reply, but no fix, or instructions on how to fix.
Below is an image. Quandl installs itself in the middle of the normal Excel
2010 menu, rather than at the end as other add ins do. If you are "position
driven" (as I am), this moves standard menus to new location. None of the
other addins that I use do this.
Another thing is use of some strange Quandl Code
that is required to paste in when you use it. Just annoyances both. It
offers a HUGE amount of data.
Pete A
Wed Apr 10, 2013 11:53 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
lets see,
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?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You just concatenate, same as always. You have three strings:
>
> http://www.4-traders.com/
> 3M-CO-4836
> /financials/
>
> The second string is just replaced by a cell reference:
>
> "http://www.4-traders.com/ " & A1 & "/financials/"
>
> On Sun, Apr 7, 2013 at 7:11 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > another question on cell reference again
> >
> > as the code links to 3M-CO-4836,
> > can i refer it to a specific cell such as cell A1?
> >
> > however, this is quite unique as there is no string or concantrate what so
> > ever...
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Try:
> > >
> > > =0+SUBSTITUTE(RCHGetTableCell("
> > > http://www.4-traders.com/3M-CO-4836/financials/ ",4,"(EBITDA)")," ","")
> >
>
the code when input,
=0+SUBSTITUTE(
gives a formula error
=0+SUBSTITUTE(
still gives a formula error ''VALUE&#
what is wrong?
--- In smf_addin@yahoogrou
>
> You just concatenate, same as always. You have three strings:
>
> http://www.4-
> 3M-CO-4836
> /financials/
>
> The second string is just replaced by a cell reference:
>
> "http://www.4-
>
> On Sun, Apr 7, 2013 at 7:11 PM, weekeewawa <weekeewawa@
>
> >
> > another question on cell reference again
> >
> > as the code links to 3M-CO-4836,
> > can i refer it to a specific cell such as cell A1?
> >
> > however, this is quite unique as there is no string or concantrate what so
> > ever...
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Try:
> > >
> > > =0+SUBSTITUTE(
> > > http://www.4-
> >
>
Wed Apr 10, 2013 11:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@yahoo.com > 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 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@yahoo.
>
> the code when input,
>
> =0+SUBSTITUTE(
> A1Â Â Â Â & Â Â "/financials/
>
> gives a formula error
>
> =0+SUBSTITUTE(
> ","
>
> still gives a formula error ''VALUE&#
>
> what is wrong?
>
Tidak ada komentar:
Posting Komentar