[smf_addin] Digest Number 2200

EXCEL Stock Market Functions Add-in

Messages In This Digest (25 Messages)

1a.

Re: Old spreadsheets dont work after re instalation From: Kermit W. Prather

1b.

Re: Old spreadsheets dont work after re instalation From: steven_rourk

1c.

Re: Old spreadsheets dont work after re instalation From: Mike McQuaid

1d.

Re: Old spreadsheets dont work after re instalation From: Randy Harmelink

1e.

Re: Old spreadsheets dont work after re instalation From: steven_rourk

1f.

Re: Old spreadsheets dont work after re instalation From: Mike McQuaid

1g.

Re: Old spreadsheets dont work after re instalation From: steven_rourk

2.1.

Re: Instructions for fixing the elements problem.... From: Kermit W. Prather

2.2.

Re: Instructions for fixing the elements problem.... From: steven_rourk

2.3.

Re: Instructions for fixing the elements problem.... From: Mike McQuaid

2.4.

Re: Instructions for fixing the elements problem.... From: Randy Harmelink

2.5.

Re: Instructions for fixing the elements problem.... From: steven_rourk

2.6.

Re: Instructions for fixing the elements problem.... From: steven_rourk

3a.

Re: Buttons ??? From: Ashish Mukerji

3b.

Re: Buttons ??? From: Randy Harmelink

3c.

Re: Buttons ??? From: Ashish Mukerji

4a.

Industry element number pulling from Yahoo From: futants46and2

4b.

Re: Industry element number pulling from Yahoo From: Mike McQuaid

4c.

Re: Industry element number pulling from Yahoo From: Sill. Micheal

4d.

Re: Industry element number pulling from Yahoo From: Randy Harmelink

4e.

Re: Industry element number pulling from Yahoo From: Sill. Micheal

5a.

Re: Extracting forexpro data From: Stefn Rai

5b.

Re: Extracting forexpro data From: Randy Harmelink

6a.

MSN Data Element (1) From: samuelmtaylor

6b.

Re: MSN Data Element (1) From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

Re: Old spreadsheets dont work after re instalation

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Fri May 4, 2012 6:41 am (PDT)

Randy, I was going to ask - where is the smfFixLinks macro located.

But I found it in the "modUtilities" in VBA

Is there an easier way to force its execution than going into VBA and running it? Is there a hot key?

By the way it worked great on a problem I previously reported on bad links.

Thanks,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, May 03, 2012 7:09 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Old spreadsheets dont work after re instalation


Try the smfFixLinks macro when you have a workbook with unresolved links.
On Thu, May 3, 2012 at 3:38 PM, steven_rourk <steven_rourk@hotmail.com> wrote:
Thanks Mike, it did the job.....Unfortunately I have 500 spreadsheets!... I´ll have to do it one by one....Oh well.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1b.

Re: Old spreadsheets dont work after re instalation

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 7:40 am (PDT)

Ok, I´ll just use de C:\SMF Add-in location, that way I won´t have to worry if the windows OS is in spanish or english...

Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can be located almost anywhere. The only issue is opening
> workbooks that were saved with the add-in in a different location. Then you
> have to manually resolve the links.
>
> But if you are constantly moving things between two computers, I would make
> sure they use a consistent location.
>
> My own location is:
>
> C:\SMF Add-in
>
> ...which is the location all new templates will use.
>
> When I open up a workbook that needs links resolved, I just press a button
> on my toolbar that runs the smfFixLinks macro that is part of the add-in.
>
> On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@...>wrote:
>
> >
> > Anyway, I was reading some old post and I read that you can save the SMF
> > Addin in any part of the computer, so I was thinking of saving it at a new
> > folder C:\SMF to avoid this problem with languages. Can it be done?. Could
> > there be a problem if I do that?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1c.

Re: Old spreadsheets dont work after re instalation

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri May 4, 2012 7:57 am (PDT)

Or, on your spanish machine just put them in "c:\program files\SMF Add-in"
or whereever the exact directory was in your other machine. If you don't
have those directories just make them.

That way you wouldn't have to worry about changing the links in any of your
500 spreadsheets.

But, if you do want to change your spreadsheets, following Randy's location
suggestion is a good idea.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of steven_rourk
Sent: Friday, May 04, 2012 10:41 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation

Ok, I´ll just use de C:\SMF Add-in location, that way I won´t have to worry
if the windows OS is in spanish or english...

Thanks.

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> The add-in can be located almost anywhere. The only issue is opening
> workbooks that were saved with the add-in in a different location. Then
you
> have to manually resolve the links.
>
> But if you are constantly moving things between two computers, I would
make
> sure they use a consistent location.
>
> My own location is:
>
> C:\SMF Add-in
>
> ...which is the location all new templates will use.
>
> When I open up a workbook that needs links resolved, I just press a button
> on my toolbar that runs the smfFixLinks macro that is part of the add-in.
>
> On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@...>wrote:
>
> >
> > Anyway, I was reading some old post and I read that you can save the SMF
> > Addin in any part of the computer, so I was thinking of saving it at a
new
> > folder C:\SMF to avoid this problem with languages. Can it be done?.
Could
> > there be a problem if I do that?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1d.

Re: Old spreadsheets dont work after re instalation

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

Fri May 4, 2012 8:32 am (PDT)

You can assign macros to toolbar buttons or give them keyboard shortcuts.
I've done both, but I use the button most often. Just do a Google search on
customizing the toolbar and you should find lot of examples.

I have about 6 custom buttons on my toolbar, as shortcuts to things I do
quite often that aren't part of the normal EXCEL. I also have a number of
custom buttons on my toolbar that are EXCEL tasks I do more often than
other people. For example, I do a lot "Group" and "Ungroup" operations,
which I don't think most people use at all.

On Fri, May 4, 2012 at 6:40 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Randy, I was going to ask - where is the smfFixLinks macro located.****
>
> ** **
>
> But I found it in the "modUtilities" in VBA****
>
> ** **
>
> Is there an easier way to force its execution than going into VBA and
> running it? Is there a hot key? ****
>
> ** **
>
> By the way it worked great on a problem I previously reported on bad
> links. ****
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1e.

Re: Old spreadsheets dont work after re instalation

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 8:32 am (PDT)

The problem is that at work Windows is in spanish, and at home windows is in english... Originally my 500 spreadsheets were created at work (Spanish), so the links are in Spanish. And when I moved them to my home (English) I "resolved" the problem creating a spanish directory "C:\Archivos de Programa" and I lived happy for a couple of years...

So what´s the problem you ask?.

The problem is that yesterday, after having some problems with my work laptop they returned it with Windows 7 (I had Windows XP).. The OS is still in spanish so there shouldn´t be a problem. I saved the Add in the same "C:\Archivos de Programa" but for some reason my old worksheets were not working (broken link). After some "research" I realized that when I right click the SMF Add-In folder (or any folder in Arhivos de Programma) the path is in english "C:\Program Files"... You know what I mean?. The OS (all menues, everything) is still in spanish, but windows internally translates it to english(?).... Don´t know, but i guess that didnt happended in XP...So, the bottom line is that my worksheets dont work...

I tried to resolve this as I did at home, just creating a new
"C:\Archivos de Programa" folder, but as it already exists I cannot creat another one. Its stupid because the name of the file is in spanish, but internally Windows "sees" it in english.

So..... i was thinking of creating a new C:\SMF and avoid all this language stuff.... It will be hard work at the begginging, changing all my worksheets, but at least I wont have to worry about that the next time I change laptops.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Or, on your spanish machine just put them in "c:\program files\SMF Add-in"
> or whereever the exact directory was in your other machine. If you don't
> have those directories just make them.
>
> That way you wouldn't have to worry about changing the links in any of your
> 500 spreadsheets.
>
> But, if you do want to change your spreadsheets, following Randy's location
> suggestion is a good idea.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of steven_rourk
> Sent: Friday, May 04, 2012 10:41 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation
>
>
>
>
> Ok, I´ll just use de C:\SMF Add-in location, that way I won´t have to worry
> if the windows OS is in spanish or english...
>
> Thanks.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > The add-in can be located almost anywhere. The only issue is opening
> > workbooks that were saved with the add-in in a different location. Then
> you
> > have to manually resolve the links.
> >
> > But if you are constantly moving things between two computers, I would
> make
> > sure they use a consistent location.
> >
> > My own location is:
> >
> > C:\SMF Add-in
> >
> > ...which is the location all new templates will use.
> >
> > When I open up a workbook that needs links resolved, I just press a button
> > on my toolbar that runs the smfFixLinks macro that is part of the add-in.
> >
> > On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@>wrote:
> >
> > >
> > > Anyway, I was reading some old post and I read that you can save the SMF
> > > Addin in any part of the computer, so I was thinking of saving it at a
> new
> > > folder C:\SMF to avoid this problem with languages. Can it be done?.
> Could
> > > there be a problem if I do that?
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1f.

Re: Old spreadsheets dont work after re instalation

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri May 4, 2012 9:00 am (PDT)

Ahhh. I understand.

Win7 has localization features that XP did not - as you realize.

I think what might have happened is your new Win7 machine, although Spanish,
has localization options for English. This is why your spanish name for
Program Files is getting changed to the English one. It's just a theory - I
don't have a lot of experience with that.

Getting to a neutral directory might be the path of least resistance -
sorting out all the Win7 options is confusing.

Here's some clues about localization for that directory in Win7 in case you
wish to pursue that - you are not the only one having issues.
http://answers.microsoft.com/en-us/windows/forum/windows_7-files/problem-wit
h-program-files-folder-localisation/152af8a0-3a5a-4c8d-a9d7-97c4e13198e2

Good luck.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of steven_rourk
Sent: Friday, May 04, 2012 11:32 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation

The problem is that at work Windows is in spanish, and at home windows is in
english... Originally my 500 spreadsheets were created at work (Spanish), so
the links are in Spanish. And when I moved them to my home (English) I
"resolved" the problem creating a spanish directory "C:\Archivos de
Programa" and I lived happy for a couple of years...

So what´s the problem you ask?.

The problem is that yesterday, after having some problems with my work
laptop they returned it with Windows 7 (I had Windows XP).. The OS is still
in spanish so there shouldn´t be a problem. I saved the Add in the same
"C:\Archivos de Programa" but for some reason my old worksheets were not
working (broken link). After some "research" I realized that when I right
click the SMF Add-In folder (or any folder in Arhivos de Programma) the path
is in english "C:\Program Files"... You know what I mean?. The OS (all
menues, everything) is still in spanish, but windows internally translates
it to english(?).... Don´t know, but i guess that didnt happended in
XP...So, the bottom line is that my worksheets dont work...

I tried to resolve this as I did at home, just creating a new
"C:\Archivos de Programa" folder, but as it already exists I cannot creat
another one. Its stupid because the name of the file is in spanish, but
internally Windows "sees" it in english.

So..... i was thinking of creating a new C:\SMF and avoid all this language
stuff.... It will be hard work at the begginging, changing all my
worksheets, but at least I wont have to worry about that the next time I
change laptops.

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> Or, on your spanish machine just put them in "c:\program files\SMF Add-in"
> or whereever the exact directory was in your other machine. If you don't
> have those directories just make them.
>
> That way you wouldn't have to worry about changing the links in any of
your
> 500 spreadsheets.
>
> But, if you do want to change your spreadsheets, following Randy's
location
> suggestion is a good idea.
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of steven_rourk
> Sent: Friday, May 04, 2012 10:41 AM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation
>
>
>
>
> Ok, I´ll just use de C:\SMF Add-in location, that way I won´t have to
worry
> if the windows OS is in spanish or english...
>
> Thanks.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > The add-in can be located almost anywhere. The only issue is opening
> > workbooks that were saved with the add-in in a different location. Then
> you
> > have to manually resolve the links.
> >
> > But if you are constantly moving things between two computers, I would
> make
> > sure they use a consistent location.
> >
> > My own location is:
> >
> > C:\SMF Add-in
> >
> > ...which is the location all new templates will use.
> >
> > When I open up a workbook that needs links resolved, I just press a
button
> > on my toolbar that runs the smfFixLinks macro that is part of the
add-in.
> >
> > On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@>wrote:
> >
> > >
> > > Anyway, I was reading some old post and I read that you can save the
SMF
> > > Addin in any part of the computer, so I was thinking of saving it at a
> new
> > > folder C:\SMF to avoid this problem with languages. Can it be done?.
> Could
> > > there be a problem if I do that?
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

1g.

Re: Old spreadsheets dont work after re instalation

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 9:10 am (PDT)

I think I´ll do it the old way... its more work, but its simpler. I dont want to mess around with the OS and get into trouble after... I´m not that good with computers....Thanks for all your help Mike and Randy.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Ahhh. I understand.
>
> Win7 has localization features that XP did not - as you realize.
>
> I think what might have happened is your new Win7 machine, although Spanish,
> has localization options for English. This is why your spanish name for
> Program Files is getting changed to the English one. It's just a theory - I
> don't have a lot of experience with that.
>
> Getting to a neutral directory might be the path of least resistance -
> sorting out all the Win7 options is confusing.
>
> Here's some clues about localization for that directory in Win7 in case you
> wish to pursue that - you are not the only one having issues.
> http://answers.microsoft.com/en-us/windows/forum/windows_7-files/problem-wit
> h-program-files-folder-localisation/152af8a0-3a5a-4c8d-a9d7-97c4e13198e2
>
> Good luck.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of steven_rourk
> Sent: Friday, May 04, 2012 11:32 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation
>
>
>
>
> The problem is that at work Windows is in spanish, and at home windows is in
> english... Originally my 500 spreadsheets were created at work (Spanish), so
> the links are in Spanish. And when I moved them to my home (English) I
> "resolved" the problem creating a spanish directory "C:\Archivos de
> Programa" and I lived happy for a couple of years...
>
> So what´s the problem you ask?.
>
> The problem is that yesterday, after having some problems with my work
> laptop they returned it with Windows 7 (I had Windows XP).. The OS is still
> in spanish so there shouldn´t be a problem. I saved the Add in the same
> "C:\Archivos de Programa" but for some reason my old worksheets were not
> working (broken link). After some "research" I realized that when I right
> click the SMF Add-In folder (or any folder in Arhivos de Programma) the path
> is in english "C:\Program Files"... You know what I mean?. The OS (all
> menues, everything) is still in spanish, but windows internally translates
> it to english(?).... Don´t know, but i guess that didnt happended in
> XP...So, the bottom line is that my worksheets dont work...
>
> I tried to resolve this as I did at home, just creating a new
> "C:\Archivos de Programa" folder, but as it already exists I cannot creat
> another one. Its stupid because the name of the file is in spanish, but
> internally Windows "sees" it in english.
>
> So..... i was thinking of creating a new C:\SMF and avoid all this language
> stuff.... It will be hard work at the begginging, changing all my
> worksheets, but at least I wont have to worry about that the next time I
> change laptops.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Or, on your spanish machine just put them in "c:\program files\SMF Add-in"
> > or whereever the exact directory was in your other machine. If you don't
> > have those directories just make them.
> >
> > That way you wouldn't have to worry about changing the links in any of
> your
> > 500 spreadsheets.
> >
> > But, if you do want to change your spreadsheets, following Randy's
> location
> > suggestion is a good idea.
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
> Behalf
> > Of steven_rourk
> > Sent: Friday, May 04, 2012 10:41 AM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > Subject: [smf_addin] Re: Old spreadsheets dont work after re instalation
> >
> >
> >
> >
> > Ok, I´ll just use de C:\SMF Add-in location, that way I won´t have to
> worry
> > if the windows OS is in spanish or english...
> >
> > Thanks.
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > Randy Harmelink <rharmelink@> wrote:
> > >
> > > The add-in can be located almost anywhere. The only issue is opening
> > > workbooks that were saved with the add-in in a different location. Then
> > you
> > > have to manually resolve the links.
> > >
> > > But if you are constantly moving things between two computers, I would
> > make
> > > sure they use a consistent location.
> > >
> > > My own location is:
> > >
> > > C:\SMF Add-in
> > >
> > > ...which is the location all new templates will use.
> > >
> > > When I open up a workbook that needs links resolved, I just press a
> button
> > > on my toolbar that runs the smfFixLinks macro that is part of the
> add-in.
> > >
> > > On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@>wrote:
> > >
> > > >
> > > > Anyway, I was reading some old post and I read that you can save the
> SMF
> > > > Addin in any part of the computer, so I was thinking of saving it at a
> > new
> > > > folder C:\SMF to avoid this problem with languages. Can it be done?.
> > Could
> > > > there be a problem if I do that?
> > > >
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

2.1.

Re: Instructions for fixing the elements problem....

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Fri May 4, 2012 6:53 am (PDT)

Pete, I just tried
=RCHGetElementNumber($E1, $A20)
Where $E1 was the symbol
And $A20 was the element

And it worked just fine.

What is GETDATA? It is not part of the add-in

Kermit

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Pete A
Sent: Thursday, May 03, 2012 6:27 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Instructions for fixing the elements problem....

Thanks Mike. I had been following that MSM thing, and had downloaded the
elements-1.txt file...still doesn't work. Most of the fixes do.

Appreciate the quick response! Save Randy a few minutes...

Pete A

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Pete, 13862 comes from MSN. See all the messages recently about the
> changes at MSN. In short, you need the new elements-1.txt file in the
> Works in Progress folder.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On
> Behalf Of Pete A
> Sent: Thursday, May 03, 2012 5:41 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Instructions for fixing the elements problem....
>
>
>
>
> 13862 (company name) doesn't work at all when using the utility "GetData"
> It's been down for several days now; I haven't delved into it because
> it isn't critical. Is there something differenct about how GetData does
it?
> Thanks Randy!
> Pete A
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> , Randy Harmelink <rharmelink@> wrote:
> >
> > All of those element numbers are working fine for me right now:
> >
> > Element #
> > MMM NFLX Element Description
> > 13862 3M Co Netflix Inc Company Name 55 15.1 23.8 % Growth Rate --
> <snip> 13862.... When do you think the errors of those elements are
>

------------------------------------

Yahoo! Groups Links

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

2.2.

Re: Instructions for fixing the elements problem....

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 8:01 am (PDT)

Ok, Im at work (Windows 7 Professional & Excell 2007). So here is what i´m getting with each of the 4 formulas below:

=smfGetAParms(13862) is returning something different than what I got at home MSN;Company Name;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0

=smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM"",""div"",-1,""class=""""cn"""">""),""|"",""<""))") is returning the correct answer 3M Co

=TRIM(smfStrExtr("|"&smfGetTagContent("http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM","div",-1,"class=""cn"">"),"|","<")) is returning #NAME?

=RCHGetElementNumber("MMM",13862) is returning ERROR

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You have the correct definition of element 13862.
>
> EXCEL 2007 shouldn't be the problem -- that's what I use.
>
> Basically, this is what the element definition is doing:
>
> =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM
> "",""div"",-1,""class=""""cn"""">""),""|"",""<""))")
>
> ...or the direct version:
>
> =TRIM(smfStrExtr("|"&smfGetTagContent("
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM
> ","div",-1,"class=""cn"">"),"|","<"))
>
> Do those work on your computer? Both of them give me the same result as:
>
> =RCHGetElementNumber("MMM",13862)
>
> On Thu, May 3, 2012 at 8:26 PM, steven_rourk <steven_rourk@...>wrote:
>
> > Ok, finally some progress. I work through two computers, one at the office
> > (Windows 7 Professional & Excel 2007) where Im still having the problem,
> > and one at home (Windows 7 Home Premium & Excel 2010) where I just updated
> > the smf-elements-1 file and it corrected most of the errors (Im still
> > getting error in element 13862) So it seems the problem has something to do
> > with Excel 2007 or with the "Professional" Windows.
> >
> > Answering your question Randy.... At home, were most works except element
> > 13862, the formula smfGetAParms(13862) gets me:
> >
> > MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~
> > ","div",-1,"class=""cn"">"),"|","<"))
> >
> > I'll write tomorrow from the office to let you know what i get in that
> > laptop, were I'm also having problems with the links of my spreadsheets
> > (I'll comment about that in another post, sorry about that)
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

2.3.

Re: Instructions for fixing the elements problem....

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri May 4, 2012 8:12 am (PDT)

Then your work machine still doesn't have the updated elements-1.txt file in
the correct place.

Note the url address in the smfGetAParms function - it is moneycentral. The
current -1.txt file will have investing.money.msn.com like Randy provided in
the direct functions. And, what you got at home.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of steven_rourk
Sent: Friday, May 04, 2012 11:02 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Instructions for fixing the elements problem....

Ok, Im at work (Windows 7 Professional & Excell 2007). So here is what i´m
getting with each of the 4 formulas below:

=smfGetAParms(13862) is returning something different than what I got at
home MSN;Company
Name;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1
<http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AI
E=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&
Type=Equity&Symbol=~~~~~;?;;;;;;;;0>
&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0

=smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""http://investing.money.ms
n.com/investments/stock-report?CR=1
<http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
pe=Equity&Symbol=MMM>
&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
&ITT=1&ITP=1&Type=Equity&Symbol=MMM"",""div"",-1,""class=""""cn"""">""),""|"
",""<""))") is returning the correct answer 3M Co

=TRIM(smfStrExtr("|"&smfGetTagContent("http://investing.money.msn.com/invest
ments/stock-report?CR=1
<http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
pe=Equity&Symbol=MMM>
&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
&ITT=1&ITP=1&Type=Equity&Symbol=MMM","div",-1,"class=""cn"">"),"|","<")) is
returning #NAME?

=RCHGetElementNumber("MMM",13862) is returning ERROR

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> You have the correct definition of element 13862.
>
> EXCEL 2007 shouldn't be the problem -- that's what I use.
>
> Basically, this is what the element definition is doing:
>
> =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""
> http://investing.money.msn.com/investments/stock-report?CR=1
<http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
pe=Equity&Symbol=MMM>
&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
&ITT=1&ITP=1&Type=Equity&Symbol=MMM
> "",""div"",-1,""class=""""cn"""">""),""|"",""<""))")
>
> ...or the direct version:
>
> =TRIM(smfStrExtr("|"&smfGetTagContent("
> http://investing.money.msn.com/investments/stock-report?CR=1
<http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
pe=Equity&Symbol=MMM>
&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
&ITT=1&ITP=1&Type=Equity&Symbol=MMM
> ","div",-1,"class=""cn"">"),"|","<"))
>
> Do those work on your computer? Both of them give me the same result as:
>
> =RCHGetElementNumber("MMM",13862)

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

2.4.

Re: Instructions for fixing the elements problem....

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

Fri May 4, 2012 8:37 am (PDT)

As Mike noted, you don't have the updated element definitions file. What
you're getting from the smfGetAParms() function is showing me the old
definition of the element.

However, I don't see how the third formula can possibly return a #NAME?
error if the second formula is working. It's the same formula wrapped into
the smfEval() function.

On Fri, May 4, 2012 at 8:01 AM, steven_rourk <steven_rourk@hotmail.com>wrote:

>
> Ok, Im at work (Windows 7 Professional & Excell 2007). So here is what i´m
> getting with each of the 4 formulas below:
>
> =smfGetAParms(13862) is returning something different than what I got at
> home MSN;Company Name;
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0
>
>
> =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM"",""div"",-1,""class=""""cn"""">""),""|"",""<""))")
> is returning the correct answer 3M Co
>
> =TRIM(smfStrExtr("|"&smfGetTagContent("
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM","div",-1,"class=""cn"">"),"|","<"))
> is returning #NAME?
>
> =RCHGetElementNumber("MMM",13862) is returning ERROR
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

2.5.

Re: Instructions for fixing the elements problem....

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 8:43 am (PDT)

hmmm... strange... I did the same thing at work, that I did at home. The only difference as I poited out is that at work I have Windows 7 Professional & Excel 2007..... and at home I have Windows 7 Home Edition & Excel 2010...

I´ll try doing it all over again.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Then your work machine still doesn't have the updated elements-1.txt file in
> the correct place.
>
> Note the url address in the smfGetAParms function - it is moneycentral. The
> current -1.txt file will have investing.money.msn.com like Randy provided in
> the direct functions. And, what you got at home.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of steven_rourk
> Sent: Friday, May 04, 2012 11:02 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: Instructions for fixing the elements problem....
>
>
>
>
>
> Ok, Im at work (Windows 7 Professional & Excell 2007). So here is what i´m
> getting with each of the 4 formulas below:
>
> =smfGetAParms(13862) is returning something different than what I got at
> home MSN;Company
> Name;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1
> <http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AI
> E=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&
> Type=Equity&Symbol=~~~~~;?;;;;;;;;0>
> &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> &ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0
>
> =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""http://investing.money.ms
> n.com/investments/stock-report?CR=1
> <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> pe=Equity&Symbol=MMM>
> &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> &ITT=1&ITP=1&Type=Equity&Symbol=MMM"",""div"",-1,""class=""""cn"""">""),""|"
> ",""<""))") is returning the correct answer 3M Co
>
> =TRIM(smfStrExtr("|"&smfGetTagContent("http://investing.money.msn.com/invest
> ments/stock-report?CR=1
> <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> pe=Equity&Symbol=MMM>
> &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> &ITT=1&ITP=1&Type=Equity&Symbol=MMM","div",-1,"class=""cn"">"),"|","<")) is
> returning #NAME?
>
> =RCHGetElementNumber("MMM",13862) is returning ERROR
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > You have the correct definition of element 13862.
> >
> > EXCEL 2007 shouldn't be the problem -- that's what I use.
> >
> > Basically, this is what the element definition is doing:
> >
> > =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""
> > http://investing.money.msn.com/investments/stock-report?CR=1
> <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> pe=Equity&Symbol=MMM>
> &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> &ITT=1&ITP=1&Type=Equity&Symbol=MMM
> > "",""div"",-1,""class=""""cn"""">""),""|"",""<""))")
> >
> > ...or the direct version:
> >
> > =TRIM(smfStrExtr("|"&smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-report?CR=1
> <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> pe=Equity&Symbol=MMM>
> &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> &ITT=1&ITP=1&Type=Equity&Symbol=MMM
> > ","div",-1,"class=""cn"">"),"|","<"))
> >
> > Do those work on your computer? Both of them give me the same result as:
> >
> > =RCHGetElementNumber("MMM",13862)
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

2.6.

Re: Instructions for fixing the elements problem....

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Fri May 4, 2012 9:42 am (PDT)

Good news. I deleted everything and installed again in the C:\SMF Add-In folder (as opposed to C:\Program Files\SMF Add-In) , as I said in another post, and it is all working fine. Maybe it had to do with the "language" issue I mendioned in the other post.

Anyway, thanks again.

--- In smf_addin@yahoogroups.com, "steven_rourk" <steven_rourk@...> wrote:
>
> hmmm... strange... I did the same thing at work, that I did at home. The only difference as I poited out is that at work I have Windows 7 Professional & Excel 2007..... and at home I have Windows 7 Home Edition & Excel 2010...
>
> I´ll try doing it all over again.
>
>
>
>
> --- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Then your work machine still doesn't have the updated elements-1.txt file in
> > the correct place.
> >
> > Note the url address in the smfGetAParms function - it is moneycentral. The
> > current -1.txt file will have investing.money.msn.com like Randy provided in
> > the direct functions. And, what you got at home.
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> > Of steven_rourk
> > Sent: Friday, May 04, 2012 11:02 AM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: Instructions for fixing the elements problem....
> >
> >
> >
> >
> >
> > Ok, Im at work (Windows 7 Professional & Excell 2007). So here is what i´m
> > getting with each of the 4 formulas below:
> >
> > =smfGetAParms(13862) is returning something different than what I got at
> > home MSN;Company
> > Name;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1
> > <http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AI
> > E=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&
> > Type=Equity&Symbol=~~~~~;?;;;;;;;;0>
> > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> > &ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;?;;;;;;;;0
> >
> > =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""http://investing.money.ms
> > n.com/investments/stock-report?CR=1
> > <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> > 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> > pe=Equity&Symbol=MMM>
> > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> > &ITT=1&ITP=1&Type=Equity&Symbol=MMM"",""div"",-1,""class=""""cn"""">""),""|"
> > ",""<""))") is returning the correct answer 3M Co
> >
> > =TRIM(smfStrExtr("|"&smfGetTagContent("http://investing.money.msn.com/invest
> > ments/stock-report?CR=1
> > <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> > 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> > pe=Equity&Symbol=MMM>
> > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> > &ITT=1&ITP=1&Type=Equity&Symbol=MMM","div",-1,"class=""cn"">"),"|","<")) is
> > returning #NAME?
> >
> > =RCHGetElementNumber("MMM",13862) is returning ERROR
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> > Randy Harmelink <rharmelink@> wrote:
> > >
> > > You have the correct definition of element 13862.
> > >
> > > EXCEL 2007 shouldn't be the problem -- that's what I use.
> > >
> > > Basically, this is what the element definition is doing:
> > >
> > > =smfEval("TRIM(smfStrExtr(""|""&smfGetTagContent(""
> > > http://investing.money.msn.com/investments/stock-report?CR=1
> > <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> > 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> > pe=Equity&Symbol=MMM>
> > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> > &ITT=1&ITP=1&Type=Equity&Symbol=MMM
> > > "",""div"",-1,""class=""""cn"""">""),""|"",""<""))")
> > >
> > > ...or the direct version:
> > >
> > > =TRIM(smfStrExtr("|"&smfGetTagContent("
> > > http://investing.money.msn.com/investments/stock-report?CR=1
> > <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=
> > 1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Ty
> > pe=Equity&Symbol=MMM>
> > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1
> > &ITT=1&ITP=1&Type=Equity&Symbol=MMM
> > > ","div",-1,"class=""cn"">"),"|","<"))
> > >
> > > Do those work on your computer? Both of them give me the same result as:
> > >
> > > =RCHGetElementNumber("MMM",13862)
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)

3a.

Re: Buttons ???

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri May 4, 2012 7:46 am (PDT)

Randy .... not being savvy with excel, I am lost when you say "you just press a button on your toolbar that runs the smfFixLinks macro that is part of the add-in" .... I don't see it on my excel tool bar or may be I am missing something??? .... do I need to create this button and if so, how? .... same is apparently true about smfForceRecalculation "button" .... is that something automatic or do I have to create it? .... Thanks in advance ....

 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, May 4, 2012 12:10 AM
>Subject: Re: [smf_addin] Re: Old spreadsheets dont work after re instalation
>
>
> 
>The add-in can be located almost anywhere. The only issue is opening workbooks that were saved with the add-in in a different location. Then you have to manually resolve the links.
>
>But if you are constantly moving things between two computers, I would make sure they use a consistent location.
>
>My own location is:
>
>C:\SMF Add-in
>
>...which is the location all new templates will use.
>
>When I open up a workbook that needs links resolved, I just press a button on my toolbar that runs the smfFixLinks macro that is part of the add-in.
>
>
>On Thu, May 3, 2012 at 8:41 PM, steven_rourk <steven_rourk@hotmail.com> wrote:
>
>
>>Anyway, I was reading some old post and I read that you can save the SMF Addin in any part of the computer, so I was thinking of saving it at a new folder C:\SMF to avoid this problem with languages. Can it be done?. Could there be a problem if I do that?
>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

3b.

Re: Buttons ???

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

Fri May 4, 2012 8:28 am (PDT)

They are something you have to create. You need to customize the toolbar.
Just do a Google search and you'll find lots of examples.

On Fri, May 4, 2012 at 7:46 AM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Randy .... not being savvy with excel, I am lost when you say "you just
> press a button on your toolbar that runs the smfFixLinks macro that is part
> of the add-in" .... I don't see it on my excel tool bar or may be I am
> missing something??? .... do I need to create this button and if so, how?
> .... same is apparently true about smfForceRecalculation "button" .... is
> that something automatic or do I have to create it? .... Thanks in advance
> ....
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

3c.

Re: Buttons ???

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Fri May 4, 2012 12:35 pm (PDT)

thx. Randy ... did check some of them out ... hopefully, I will be able to follow them ...

 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, May 4, 2012 11:28 AM
>Subject: Re: [smf_addin] Re: Buttons ???
>
>
> 
>They are something you have to create. You need to customize the toolbar. Just do a Google search and you'll find lots of examples.
>
>
>On Fri, May 4, 2012 at 7:46 AM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>Randy .... not being savvy with excel, I am lost when you say "you just press a button on your toolbar that runs the smfFixLinks macro that is part of the add-in" .... I don't see it on my excel tool bar or may be I am missing something??? .... do I need to create this button and if so, how? .... same is apparently true about smfForceRecalculation "button" .... is that something automatic or do I have to create it? .... Thanks in advance ....
>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)

4a.

Industry element number pulling from Yahoo

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

Fri May 4, 2012 8:57 am (PDT)

Hey Randy,

Is there an element number for industry from Yahoo? I looked through the elements list and couldn't find it. I also checked through the RCHGetYahooQuotes() function list and didn't find a code for Industry either.

I was using Zack's for industry, but it really slowed down my data pull, and I couldn't even startup my spreadsheet, with the Zack's link.Once I removed the Zack's links my data pull was flying. I already use elements pulled all from Yahoo, so I figure to keep the pulls homogeneous may be better instead of using another pull from MSN.

Thanks,
Elliot.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4b.

Re: Industry element number pulling from Yahoo

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri May 4, 2012 9:03 am (PDT)

13867?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of futants46and2
Sent: Friday, May 04, 2012 11:57 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Industry element number pulling from Yahoo

Hey Randy,

Is there an element number for industry from Yahoo? I looked through the
elements list and couldn't find it. I also checked through the
RCHGetYahooQuotes() function list and didn't find a code for Industry
either.

I was using Zack's for industry, but it really slowed down my data pull, and
I couldn't even startup my spreadsheet, with the Zack's link.Once I removed
the Zack's links my data pull was flying. I already use elements pulled all
from Yahoo, so I figure to keep the pulls homogeneous may be better instead
of using another pull from MSN.

Thanks,
Elliot.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4c.

Re: Industry element number pulling from Yahoo

Posted by: "Sill. Micheal" futants46and2@yahoo.com   futants46and2

Fri May 4, 2012 9:15 am (PDT)

Yes, Thanks. I didn't scroll that far down the list.

Elliot.

________________________________
From: Mike McQuaid <mikemcq802@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 4, 2012 12:03 PM
Subject: RE: [smf_addin] Industry element number pulling from Yahoo


 
13867?

________________________________
From: smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com] On Behalf Of futants46and2
Sent: Friday, May 04, 2012 11:57 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Industry element number
pulling from Yahoo

 
Hey Randy,

Is there an element number for industry from Yahoo? I
looked through the elements list and couldn't find it. I also checked through
the RCHGetYahooQuotes() function list and didn't find a code for Industry
either.

I was using Zack's for industry, but it really slowed down my
data pull, and I couldn't even startup my spreadsheet, with the Zack's link.Once
I removed the Zack's links my data pull was flying. I already use elements
pulled all from Yahoo, so I figure to keep the pulls homogeneous may be better
instead of using another pull from MSN.

Thanks,
Elliot.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4d.

Re: Industry element number pulling from Yahoo

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

Fri May 4, 2012 9:19 am (PDT)

I see Mike already gave you the Yahoo element number.

You're correct that RCHGetYahooQuotes() doesn't have it. Yahoo chose not to
include it there.

The toughest thing about industry groups is just whose you want to use.
They can be very different.

For Zack's, you can speed it up significantly if you use their screener,
screen on stocks with a price greater than zero, and then just export the
results with the industry groups. Then use a VLOOKUP() on that exported
data.

You could do something similar with FinViz.

On Fri, May 4, 2012 at 8:57 AM, futants46and2 <futants46and2@yahoo.com>wrote:

>
> Is there an element number for industry from Yahoo? I looked through the
> elements list and couldn't find it. I also checked through the
> RCHGetYahooQuotes() function list and didn't find a code for Industry
> either.
>
> I was using Zack's for industry, but it really slowed down my data pull,
> and I couldn't even startup my spreadsheet, with the Zack's link.Once I
> removed the Zack's links my data pull was flying. I already use elements
> pulled all from Yahoo, so I figure to keep the pulls homogeneous may be
> better instead of using another pull from MSN.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4e.

Re: Industry element number pulling from Yahoo

Posted by: "Sill. Micheal" futants46and2@yahoo.com   futants46and2

Fri May 4, 2012 9:31 am (PDT)

Great. As always thanks for the help!

Elliot.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, May 4, 2012 12:19 PM
Subject: Re: [smf_addin] Industry element number pulling from Yahoo


 
I see Mike already gave you the Yahoo element number.

You're correct that RCHGetYahooQuotes() doesn't have it. Yahoo chose not to include it there.

The toughest thing about industry groups is just whose you want to use. They can be very different.

For Zack's, you can speed it up significantly if you use their screener, screen on stocks with a price greater than zero, and then just export the results with the industry groups. Then use a VLOOKUP() on that exported data.

You could do something similar with FinViz.

On Fri, May 4, 2012 at 8:57 AM, futants46and2 <futants46and2@yahoo.com> wrote:

>Is there an element number for industry from Yahoo? I looked through the elements list and couldn't find it. I also checked through the RCHGetYahooQuotes() function list and didn't find a code for Industry either.
>
>I was using Zack's for industry, but it really slowed down my data pull, and I couldn't even startup my spreadsheet, with the Zack's link.Once I removed the Zack's links my data pull was flying. I already use elements  pulled all from Yahoo, so I figure to keep the pulls homogeneous may be better instead of using another pull from MSN.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5a.

Re: Extracting forexpro data

Posted by: "Stefn Rai" rainerglobal@ymail.com   rainerglobal@ymail.com

Fri May 4, 2012 12:21 pm (PDT)

Randy, thanks for the help, that works! However, the live prices does not update unless I press the smfForceREcalculation button. Any idea as to how to get the prices to update live, or at least more frequently, maybe every 10 seconds or so.
Kind Regards,
Steve
 


________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 2, 2012 3:36 PM
Subject: Re: [smf_addin] Extracting forexpro data


 

Try:

=RCHGetTableCell("http://www.forexpros.com/indices/indices-futures",5,"us-30-futures")

On Wed, May 2, 2012 at 1:19 PM, Stefn Rai <rainerglobal@ymail.com> wrote:

>
>...under the first table, "Real time Streaming Futures Quotes". Is it possible to just exctract for example "low", US 30.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

5b.

Re: Extracting forexpro data

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

Fri May 4, 2012 1:16 pm (PDT)

You'd need to write your VBA timing routine for that.

On Fri, May 4, 2012 at 12:21 PM, Stefn Rai <rainerglobal@ymail.com> wrote:

>
> Randy, thanks for the help, that works! However, the live prices does not
> update unless I press the smfForceREcalculation button. Any idea as to how
> to get the prices to update live, or at least more frequently, maybe every
> 10 seconds or so.
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

6a.

MSN Data Element (1)

Posted by: "samuelmtaylor" samuelmtaylor@earthlink.net   samuelmtaylor

Fri May 4, 2012 1:45 pm (PDT)

The company description pulled by =RCHGetElementNumber (XX,1)does not seem to be working properly. Have I missed an update?

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

6b.

Re: MSN Data Element (1)

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

Fri May 4, 2012 1:46 pm (PDT)

You need the new element definitions in smf-elements-1.txt from the "Works
in Progress" folder of the group's Files area. Exit EXCEL before updating
the file in your add-in folder.

On Fri, May 4, 2012 at 1:39 PM, samuelmtaylor
<samuelmtaylor@earthlink.net>wrote:

> The company description pulled by =RCHGetElementNumber (XX,1)does not seem
> to be working properly. Have I missed an update?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  91
  New Members
•  4
  New Files

Visit Your Group

Yahoo! News

Get it all here

Breaking news to

entertainment news

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

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

Messages | Files | Photos | Polls

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