Senin, 15 Oktober 2012

[smf_addin] Digest Number 2374

8 New Messages

Digest #2374
1a
Some suggest who have problems ... by "José Azevedo" jma_resende
1b
1c
Re: Some suggest who have problems ... by "Randy Harmelink" rharmelink
1d
Re: Some suggest who have problems ... by "José Azevedo" jma_resende
2a
ADVFN Link Speeds by "Russell M" rerussellson
2b
Re: ADVFN Link Speeds by "Randy Harmelink" rharmelink

Messages

Sun Oct 14, 2012 7:35 am (PDT) . Posted by:

"José Azevedo" jma_resende

Hi!

Finally I have some success with Excel 2010.

Some suggest who start with Excel 2010.

1º I follow this doc: Step-by-Step SMF Add-In.doc Very good.

But... when I try... problems... and what are my problem???

2º Regional configuration.
In my country I have to change the "," by ";" and ... voilá... problem
solved!
Ufa!!
Example: In this file: SMF-Addin-Combined-Documentation-010212_N.pdf
If I put this:
=RCHGetElementNumber("IBM", 941) I have a error, but if I put:
=RCHGetElementNumber("IBM"; 941) solved.

In the document pdf there are many command that not work

Regards
Jose

Sun Oct 14, 2012 5:52 pm (PDT) . Posted by:

"Ron Spruell" hashky

Jose -

I wrote the Step-by-Step SMF Add-In.doc.  I am glad you found it useful.  I wrote it when I taught a small class of investors who thought they  were interested in learning how to use Excel for getting stock data.  I documented my experiences in my upgrade from Excel 2003 to Excel 2010.  It took me a couple of days to get Excel 2010 not "locked down" and working with the Add-In.  My target audience didn't have the regional problems.

Did you get the Step-by-Step from this group?  I don't think that I ever uploaded it here. 

Ron Spruell
 

>________________________________
> From: José Azevedo <jmazevedo@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, October 14, 2012 9:28 AM
>Subject: [smf_addin] Some suggest who have problems ...
>
>

>Hi!
>
>
>Finally I have some success with Excel 2010.
>
>
>Some suggest who start with Excel 2010.
>
>
>1º I follow this doc: Step-by-Step SMF Add-In.doc  Very good.
>
>
>But... when I try... problems... and what are my problem???
>
>
>2º Regional configuration.
>In my country I have to change the "," by ";" and ... voilá... problem solved!
>Ufa!!
>Example: In this file: SMF-Addin-Combined-Documentation-010212_N.pdf
>If I put this:
>=RCHGetElementNumber("IBM", 941)  I have a error, but if I put:
>=RCHGetElementNumber("IBM"; 941)  solved.
>
>
>In the document pdf there are many command that not work
>
>
>Regards
>Jose 
>
>
>

Sun Oct 14, 2012 7:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The LINKS area of the group points to the document.

One issue many have had is the doc format uses left double quotes and right
double quotes, so people copying and pasting a formula will have problems
-- EXCEL only uses the simple double quotes to identify strings.

On Sun, Oct 14, 2012 at 5:52 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful.
> I wrote it when I taught a small class of investors who thought they were
> interested in learning how to use Excel for getting stock data. I
> documented my experiences in my upgrade from Excel 2003 to Excel 2010. It
> took me a couple of days to get Excel 2010 not "locked down" and working
> with the Add-In. My target audience didn't have the regional problems.
>
> Did you get the Step-by-Step from this group? I don't think that I ever
> uploaded it here.
>
>

Mon Oct 15, 2012 2:11 am (PDT) . Posted by:

"José Azevedo" jma_resende

Hi!

I find this doc by google.
I think it is well construct for Excel 2010. This doc should be in file
group. But this is only a suggest.

In next 2 months I am going to try get some fundamental analysis. I hope
make some experiences with stock market. Only start very slowly.

Many thanks
Obrigado
Jose

On 15 October 2012 01:52, Ron Spruell <hashky@yahoo.com> wrote:

> Jose -
>
> I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful.
> I wrote it when I taught a small class of investors who thought they were
> interested in learning how to use Excel for getting stock data. I
> documented my experiences in my upgrade from Excel 2003 to Excel 2010. It
> took me a couple of days to get Excel 2010 not "locked down" and working
> with the Add-In. My target audience didn't have the regional problems.
>
> Did you get the Step-by-Step from this group? I don't think that I ever
> uploaded it here.
>
> Ron Spruell
>
>
> ------------------------------
> *From:* José Azevedo <jmazevedo@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Sunday, October 14, 2012 9:28 AM
> *Subject:* [smf_addin] Some suggest who have problems ...
>
>
> Hi!
>
> Finally I have some success with Excel 2010.
>
> Some suggest who start with Excel 2010.
>
> 1º I follow this doc: Step-by-Step SMF Add-In.doc Very good.
>
> But... when I try... problems... and what are my problem???
>
> 2º Regional configuration.
> In my country I have to change the "," by ";" and ... voilá... problem
> solved!
> Ufa!!
> Example: In this file: SMF-Addin-Combined-Documentation-010212_N.pdf
> If I put this:
> =RCHGetElementNumber("IBM", 941) I have a error, but if I put:
> =RCHGetElementNumber("IBM"; 941) solved.
>
> In the document pdf there are many command that not work
>
> Regards
> Jose
>
>
>
>

Sun Oct 14, 2012 12:09 pm (PDT) . Posted by:

"Russell M" rerussellson

What is the download speed difference between using something like:

=smfGetADVFNElement(A1,"Q",1,"Total Common Shares Out")

vs.

=RCHGetElementNumber(A1,10966)

Are there any other relevant differences I should be aware of?

Thanks!

Sun Oct 14, 2012 2:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The RCHGetElementNumber() is executing the smfGetADVFNElement() functions,
so it will be a hair slower. But it should be nothing noticeable -- even if
doing a large number of elements.

On Sun, Oct 14, 2012 at 12:09 PM, Russell M <ru88ell@gmail.com> wrote:

> What is the download speed difference between using something like:
>
> =smfGetADVFNElement(A1,"Q",1,"Total Common Shares Out")
>
> vs.
>
> =RCHGetElementNumber(A1,10966)
>
> Are there any other relevant differences I should be aware of?
>

Sun Oct 14, 2012 9:09 pm (PDT) . Posted by:

"mff2805" mff2805

i can open a few other files that use the add-in without getting the same messages/behavior that i get with when i open my favorite file.

so, there must bee something about that file. i has about 20-30 sheets, most of which were copied from templates. i tried to be careful about changing formulas as needed to keep my own file self-contained. i've run the macro described in the links section regarding search/replacce and even did a manual seach on each sheet looking for "smf" and "rch" strings - to no avail.

if you have some thoughts on what i can do or look for in my file such that i no longer have this problem, i'd appreciate it. i'd send you the file itself if you wanted to see if you get the same msgs i do.
thanks much,
mike

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't think your links problem is with the add-in.
>
> If I open a functioning worksheet that uses the add-in, and flags no link
> errors, I can also open "Edit Links" and see the add-in there with an
> "Unknown" status.
>
> Does this happen with any other workbook that uses the add-in?
>
> On Thu, Oct 11, 2012 at 7:59 PM, mff2805 <mff3429@...> wrote:
>
> > i get
> > Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> > Files\SMF Add-In; 1)
> >
> > i'm still stumped
> >
>

Sun Oct 14, 2012 9:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

To tell the truth, I have no interest in opening a workbook that uses that
many sheets.

You may want to check links on each sheet. I'm not sure if it varies by
sheet or not? You probably copied some type of link on one of the copy and
paste processes when you created one of the sheets.

On Sun, Oct 14, 2012 at 9:09 PM, mff2805 <mff3429@comcast.net> wrote:

> i can open a few other files that use the add-in without getting the same
> messages/behavior that i get with when i open my favorite file.
>
> so, there must bee something about that file. i has about 20-30 sheets,
> most of which were copied from templates. i tried to be careful about
> changing formulas as needed to keep my own file self-contained. i've run
> the macro described in the links section regarding search/replacce and even
> did a manual seach on each sheet looking for "smf" and "rch" strings - to
> no avail.
>
> if you have some thoughts on what i can do or look for in my file such
> that i no longer have this problem, i'd appreciate it. i'd send you the
> file itself if you wanted to see if you get the same msgs i do.
>

Tidak ada komentar:

Posting Komentar